After applying 11.2.0.2.2 PSU patch,I want to check to see the version number as 11.2.0.2.2 but, it was not shown in places:
1st the statement while connecting to database or ASM via sqlplus like:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
2nd v$instance
3rd v$version
4th impdp
So what?
In MOS I bumped into a note regarding with the PSU versions after then.
Patch Set Updates for Oracle Products [ID 854428.1] [ID 854428.1]
Patch Set Updates are referenced by their 5-place version number.
The following OPatch commands are a simple way to determine the latest PSU installed in the Oracle Home.
For Database PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i "DATABASE PSU"
For CRS (Cluster Ready Services) PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i "TRACKING BUG" | grep -i PSU
For GI (Grid Infrastructure) PSUs, enter the following command:
opatch lsinventory -bugs_fixed | grep -i "gi psu"
At last I also checked this information from below link, while looking for keyword "5-place version number".
http://forums.oracle.com/forums/thread.jspa?messageID=4250078&tstart=0
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
-
Simple but very handy way of taking exports without knowing database password. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFIL...
-
It seems an easy topic, I prefer being careful with the easy ones... so it is handy to have all you need, in one place and which will lead i...
-
This directory is created in the home directory of the oracle user, after making a local connection. I had tested it as follows: [oracle@geo...
No comments:
Post a Comment