Could somebody post a better solution?
What if you get a db that did not tell you the version number? What are you gonna do?
I never get that because I apply the scripts after patching
THE BEST SOLUTION :
SELECT * FROM product_component_version;
product_component_version does not tell you all the patches that have been installed.
I have installed a patch 220.127.116.11.5 but this only displays the first patch - 18.104.22.168.
I'm afraid Oracle does not always update the version numbers.
From Sanjay's mail:
"If these is difference between major version of datafile and software installed e.g. If the datafiles are 8.1.6 version and suppose you use oracle 9i software to mount oracle 8i database, I am sure , you will get error."
Oracle does not give any error. This is a method which you will use for Oracle9i migration.
Say No To Plastics
If you are on unix:
Originally posted by DBA_Lisa
So, if you are not sure whether the db has been updated or not, how do you know the correct version number of the db?
$ strings system01.dbf | grep "NLS_RDBMS_VERSION"
NLS_RDBMS_VERSION 22.214.171.124.0 RDBMS version for NLS parameters,
Put the correct name of your system tablespace data file in place of "system01.dbf".
I am sure in NT also you can check for the same string "NLS_RDBMS_VERSION" using an utility (no idea what though!).
Click Here to Expand Forum to Full Width