Run a SQLPLUS session from each node on the cluster. Connect to the database
on one node and then the other. SQLPLUS should give you the client and
server version in use. Example:
sqlplus user/[Email Address Removed] Release 9.2.0.6.0 - Production on Wed Jul 5 07:13:59 2006
^--- CLIENT version
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: |-- server version
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.6.0 - Production
Also check DBA_REGISTRY (select COMP_ID,VERSION from dba_registry) and look
for differences in the version (this exists in 9i/10g.. cant remember if it
was there in 8i).
HTH
John.
-----Original Message-----
From: benbart
[mailto:oracledba-ezmlmshield-x59023797.[Email address protected]
Sent: 04 July 2006 22:28
To: LazyDBA Discussion
Subject: Conflicting Oracle Version on different servers in the cluster
Hi all,
I have SERVER1 and SERVER2 as part of one SUN CLUSTER. When SERVER1 is the
main
server in the cluster, SELECT VERSION FROM V$INSTANCE shows 8.1.7.1.0. When
SERVER2 is the main server in the cluster, SELECT VERSION FROM V$INSTANCE
shows
8.1.7.4.0.
I do not see a VERSION field, although there is a VERSION_TIME from
V$DATABASE,
that is why am checking the version from V$INSTANCE instead.
Now, my concern is, is my database really 8.1.7.1.0 or 8.1.7.4.0? Or does
the
difference in the version just really means that the binaries are different
and
so I should be able to get away with it by overwriting the binaries of
SERVER1
with whatever I have on SERVER2.
Is there any views at all in the database, besides V$VERSION and V$INSTANCE
where I can check the version of my database? With this discrepancies, am
really getting confused now what does a database upgrade means, as in my
current situation, it seems that an upgrade means a binaries upgrade instead
of
database upgrade or does my current situation only means, no database
upgrade
had occurred, only a "missed" patching as the first 3 major numbers on each
server are the same.
Since there seems to be a discrepancies in my binaries, where then can I
find
the "real" version of my database, i.e., is it 8.1.7.1.0 or 8.1.7.4.0?
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page