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?




Oracle LazyDBA home page