First step is download the Patch "p9114072_111070_Linux-x86.zip" from Metalink as shown below and unzip the file into some temp directory on the server.
Lets see how to do this:vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >ls -ltr
total 868
drwxrwxr-x 20 oracle dba 4096 Jan 6 09:14 9114072
-rw-r--r-- 1 oracle dba 877256 Feb 21 11:47 p9114072_111070_Linux-x86.zip
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >rm p9114072_111070_Linux-x86.zip
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >lt
total 4
drwxrwxr-x 20 oracle dba 4096 Jan 6 09:14 9114072
Use the opatch to apply the patch as the following example:
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >cd 9114072/
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch/9114072 >opatch napply -skip_subset -skip_duplicate
Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /oracle/app/oracle/product/11.1.0.7
Central Inventory : /oracle/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.1
OUI version : 11.1.0.7.0
OUI location : /oracle/app/oracle/product/11.1.0.7/oui
Log file location : /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatc
Patch history file: /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatc
Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking skip_duplicate
Checking skip_subset
Checking conflicts against Oracle Home...
OPatch continues with these patches: 8306934 8342506 8563941 8563942 8563943 8563944 8563946 8563947 8563948 8855553 8855559 8855565 8855570 8855575 8855577 9114072 9118620 9118622
Do you want to proceed? [y|n]
y
User Responded with: Y
Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/product/11.1.0.7')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...
Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/8342506/custom/scripts/pre -apply 8342506 ':
Return Code = 0
Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/9114072/custom/scripts/pre -apply 9114072 ':
Return Code = 0
Applying patch 8306934...
ApplySession applying interim patch '8306934' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8306934' for rollback. This might take a while...
Patching component oracle.network.listener, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglgr.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglro.o"
ApplySession adding interim patch '8306934' to inventory
Verifying the update...
Inventory check OK: Patch ID 8306934 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8306934 are present in Oracle Home.
Applying patch 8342506...
ApplySession applying interim patch '8342506' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8342506' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile/recompile_precheck_jan2008cpu.sql"
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile/view_recompile_jan2008cpu.sql"
ApplySession adding interim patch '8342506' to inventory
Verifying the update...
Inventory check OK: Patch ID 8342506 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8342506 are present in Oracle Home.
Applying patch 8563941...
ApplySession applying interim patch '8563941' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563941' for rollback. This might take a while...
Patching component oracle.network.listener, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsgcs.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglsn.o"
ApplySession adding interim patch '8563941' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563941 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563941 are present in Oracle Home.
Applying patch 8563942...
ApplySession applying interim patch '8563942' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563942' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/catmetx.sql"
ApplySession adding interim patch '8563942' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563942 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563942 are present in Oracle Home.
Applying patch 8563943...
ApplySession applying interim patch '8563943' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563943' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/krvg.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/knld.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prsc.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prsg.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prssz.o"
ApplySession adding interim patch '8563943' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563943 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563943 are present in Oracle Home.
Applying patch 8563944...
ApplySession applying interim patch '8563944' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563944' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzrt.o"
ApplySession adding interim patch '8563944' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563944 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563944 are present in Oracle Home.
Applying patch 8563946...
ApplySession applying interim patch '8563946' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563946' for rollback. This might take a while...
Patching component oracle.rdbms.rsf, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libcommon11.a" with "lib/libcommon11.a/ttcpip.o"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '8563946' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563946 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563946 are present in Oracle Home.
Applying patch 8563947...
ApplySession applying interim patch '8563947' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563947' for rollback. This might take a while...
Patching component oracle.sysman.console.db, 11.1.0.7.0...
Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/config/compare/CompareWizSecondConfigBean.class"
ApplySession adding interim patch '8563947' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563947 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563947 are present in Oracle Home.
Applying patch 8563948...
ApplySession applying interim patch '8563948' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8563948' for rollback. This might take a while...
Patching component oracle.sysman.console.db, 11.1.0.7.0...
Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistoryBean.class"
Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistoryController.class"
Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistorySearch.class"
ApplySession adding interim patch '8563948' to inventory
Verifying the update...
Inventory check OK: Patch ID 8563948 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8563948 are present in Oracle Home.
Applying patch 8855553...
ApplySession applying interim patch '8855553' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855553' for rollback. This might take a while...
Patching component oracle.sdo.locator, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/md/admin/sdomigrt.sql"
ApplySession adding interim patch '8855553' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855553 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855553 are present in Oracle Home.
Applying patch 8855559...
ApplySession applying interim patch '8855559' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855559' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzia.o"
ApplySession adding interim patch '8855559' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855559 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855559 are present in Oracle Home.
Applying patch 8855565...
ApplySession applying interim patch '8855565' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855565' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating jar file "/oracle/app/oracle/product/11.1.0.7/rdbms/jlib/CDC.jar" with "/rdbms/jlib/CDC.jar/oracle/CDC/Purge.class"
Updating jar file "/oracle/app/oracle/product/11.1.0.7/rdbms/jlib/CDC.jar" with "/rdbms/jlib/CDC.jar/oracle/CDC/PublishApi.class"
ApplySession adding interim patch '8855565' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855565 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855565 are present in Oracle Home.
Applying patch 8855570...
ApplySession applying interim patch '8855570' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855570' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/prvtaqds.plb"
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/dbmsaqds.plb"
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/prvtaqiu.plb"
ApplySession adding interim patch '8855570' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855570 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855570 are present in Oracle Home.
Applying patch 8855575...
ApplySession applying interim patch '8855575' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855575' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kkxs.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kza.o"
ApplySession adding interim patch '8855575' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855575 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855575 are present in Oracle Home.
Applying patch 8855577...
ApplySession applying interim patch '8855577' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '8855577' for rollback. This might take a while...
Patching component oracle.rdbms.rsf, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libpls11.a" with "lib/libpls11.a/pkwrap.o"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '8855577' to inventory
Verifying the update...
Inventory check OK: Patch ID 8855577 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8855577 are present in Oracle Home.
Applying patch 9114072...
ApplySession applying interim patch '9114072' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '9114072' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/catcpu.sql"
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/catcpu_rollback.sql"
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/bundledata_CPU.xml"
Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/catbundle.sql"
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/scripts/sdo_oct2009.sql"
Patching component oracle.rdbms.rsf, 11.1.0.7.0...
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/rollback_all.lst"
Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/rollback_new.lst"
ApplySession adding interim patch '9114072' to inventory
Verifying the update...
Inventory check OK: Patch ID 9114072 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9114072 are present in Oracle Home.
Applying patch 9118620...
ApplySession applying interim patch '9118620' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '9118620' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzld.o"
ApplySession adding interim patch '9118620' to inventory
Verifying the update...
Inventory check OK: Patch ID 9118620 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9118620 are present in Oracle Home.
Applying patch 9118622...
ApplySession applying interim patch '9118622' to OH '/oracle/app/oracle/product/11.1.0.7'
Backing up files affected by the patch '9118622' for rollback. This might take a while...
Patching component oracle.network.rsf, 11.1.0.7.0...
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libnro11.a" with "lib/libnro11.a/ncrfgp.o"
Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libnro11.a" with "lib/libnro11.a/ncrfidsa.o"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '9118622' to inventory
Verifying the update...
Inventory check OK: Patch ID 9118622 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9118622 are present in Oracle Home.
Running make for target itnslsnr
Running make for target ioracle
Running make for target client_sharedlib
Running make for target client_sharedlib
Running make for target iwrap
--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************
Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/9114072/custom/scripts/post -apply 9114072 ':
Return Code = 0
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch/9114072 >
Please refer to the "3.3.2 Post Installation Instructions" section in order to check if any more steps are requered.
Checking the installation:
vmlinux3-oracle-ATLASDEV-/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile >opatch lsinventory
Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/oracle/product/11.1.0.7
Central Inventory : /oracle/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.1
OUI version : 11.1.0.7.0
OUI location : /oracle/app/oracle/product/11.1.0.7/oui
Log file location : /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatch2010-02-21_14-21-51PM.log
Patch history file: /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/lsinv/lsinventory2010-02-21_14-21-51PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (3):
Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Examples 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0
There are 3 products installed in this Oracle Home.
Interim patches (18) :
Patch 9118622 : applied on Sun Feb 21 14:00:43 BRST 2010
Unique Patch ID: 12054869
Created on 23 Dec 2009, 08:14:47 hrs PST8PDT
Bugs fixed:
9118622
Patch 9118620 : applied on Sun Feb 21 14:00:39 BRST 2010
Unique Patch ID: 12054869
Created on 23 Dec 2009, 08:18:01 hrs PST8PDT
Bugs fixed:
9118620
Patch 9114072 : applied on Sun Feb 21 14:00:34 BRST 2010
Unique Patch ID: 12054869
Created on 23 Dec 2009, 12:13:30 hrs PST8PDT
Bugs fixed:
9114072, 8836375, 8290478, 8534338
Patch 8855577 : applied on Sun Feb 21 14:00:29 BRST 2010
Unique Patch ID: 12054869
Created on 9 Sep 2009, 04:46:33 hrs PST8PDT
Bugs fixed:
8855577
Patch 8855575 : applied on Sun Feb 21 14:00:24 BRST 2010
Unique Patch ID: 12054869
Created on 9 Sep 2009, 04:50:05 hrs PST8PDT
Bugs fixed:
8855575
Patch 8855570 : applied on Sun Feb 21 14:00:11 BRST 2010
Unique Patch ID: 12054869
Created on 2 Sep 2009, 08:23:21 hrs PST8PDT
Bugs fixed:
8306933, 8855570
Patch 8855565 : applied on Sun Feb 21 14:00:07 BRST 2010
Unique Patch ID: 12054869
Created on 2 Sep 2009, 08:16:23 hrs PST8PDT
Bugs fixed:
8855565
Patch 8855559 : applied on Sun Feb 21 14:00:01 BRST 2010
Unique Patch ID: 12054869
Created on 9 Sep 2009, 04:48:57 hrs PST8PDT
Bugs fixed:
8855559, 8563945
Patch 8855553 : applied on Sun Feb 21 13:59:55 BRST 2010
Unique Patch ID: 12054869
Created on 9 Sep 2009, 04:30:24 hrs PST8PDT
Bugs fixed:
8855553
Patch 8563948 : applied on Sun Feb 21 13:59:52 BRST 2010
Unique Patch ID: 12054869
Created on 4 Jun 2009, 01:51:05 hrs PST8PDT
Bugs fixed:
8563948
Patch 8563947 : applied on Sun Feb 21 13:59:31 BRST 2010
Unique Patch ID: 12054869
Created on 4 Jun 2009, 01:52:36 hrs PST8PDT
Bugs fixed:
8563947
Patch 8563946 : applied on Sun Feb 21 13:58:46 BRST 2010
Unique Patch ID: 12054869
Created on 3 Jun 2009, 23:09:22 hrs PST8PDT
Bugs fixed:
8563946
Patch 8563944 : applied on Sun Feb 21 13:58:40 BRST 2010
Unique Patch ID: 12054869
Created on 10 Jun 2009, 06:20:58 hrs PST8PDT
Bugs fixed:
6870937, 8563944
Patch 8563943 : applied on Sun Feb 21 13:58:30 BRST 2010
Unique Patch ID: 12054869
Created on 3 Jun 2009, 08:31:45 hrs PST8PDT
Bugs fixed:
8563943
Patch 8563942 : applied on Sun Feb 21 13:57:56 BRST 2010
Unique Patch ID: 12054869
Created on 3 Jun 2009, 23:33:55 hrs PST8PDT
Bugs fixed:
8563942
Patch 8563941 : applied on Sun Feb 21 13:57:52 BRST 2010
Unique Patch ID: 12054869
Created on 3 Jun 2009, 06:48:40 hrs PST8PDT
Bugs fixed:
8563941
Patch 8342506 : applied on Sun Feb 21 13:57:48 BRST 2010
Unique Patch ID: 12054869
Created on 18 Mar 2009, 04:38:31 hrs PST8PDT
Bugs fixed:
8342506
Patch 8306934 : applied on Sun Feb 21 13:57:43 BRST 2010
Unique Patch ID: 12054869
Created on 13 Mar 2009, 04:56:47 hrs PST8PDT
Bugs fixed:
8306934
--------------------------------------------------------------------------------
OPatch succeeded.
vmlinux3-oracle-ATLASDEV-/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile >
Lets check my installation results using SQLPlus.
SQL>
SQL>
SQL>
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
SQL>
SQL> select * from registry$history;
ACTION_TIME ACTION NAMESPAC VERSION ID COMMENTS BUNDLE_SERIES
------------------------------ ---------- -------- -------- ---------- ---------------------------------------- -------------
21-FEB-10 01.09.04.839873 PM APPLY SERVER 11.1.0.7 4 CPUJan2010 CPU
21-FEB-10 01.14.26.308370 PM CPU 6452863 view recompilation
SQL>
And we are done!!
No comments:
Post a Comment