-
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.
Say No To Plastics
-
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?
If you are on unix:
$ 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|