All,
First, I am not an Oracle DBA by choice, but by accident. My employer needs to find someone with certain certifications before they will hire them to support the Oracle environment at the customer site. I am by profession a Microsoft SQL DBA, so I can at least hum the tune to keep the Oracle instances running...
That being said, here's my question:
In prepping for the upcoming January CPU I checked the versions of the Oracle databases I'm currently supporting. The Oracle Home is 11gR2 (11.2.0.2.0,) which is what I expect, but when I connect with SQLPlus to the two databases in this home, one gives me a rather unexpected result for the version.
The first DB reports back 11.2.0.2.0 when I run "select version from v$version"
The second DB, however, reports back 10.2.0.5.0
The exact commands I am running (in the %oracle_home%\bin\ directory) are:
set oracle_sid=dbname
sqlplus /nolog
connect / as sysdba
select * from v$version;
The Oracle Home directory is \11.2.0\grid\
The two databases in question are in a RAC / Clusterware environment.
The OS of the servers is Windows 2008 R2 SP2
Obviously, things are working as-is, but I am curious to know why the one database reports version 10.
Thank you,
Jason A.
(Thankfully, my employer has several candidates in the pipeline to take over the Oracle DBA duties, but I've got no idea when they might start...)