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?
Printable View
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;
Harry
product_component_version does not tell you all the patches that have been installed.
I have installed a patch 8.1.7.1.5 but this only displays the first patch - 8.1.7.1.
I'm afraid Oracle does not always update the version numbers.
Hi,
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.
Vijay.
If you are on unix:Quote:
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 8.1.7.2.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!).
-amar