Critical Patch Update - October 2013 - Install Patch 17027533 on Multitenant (CDB/PDB)
Install Patch 17027533 on Multitenant (CDB/PDB)
Critical Patch Update - October 2013. I found Oracle Patch for 12c Database. I checked some requirements.
OPatch requirement for October 2013:
- OPatch 12.1.0.1.1 for Database PSU 12.1.0.1.1
- OPatch 12.1.0.1.2 for GI PSU 12.1.0.1.1
login as: root
root@192.168.236.128's password:
Last login: Thu Oct 31 19:46:27 2013 from 192.168.236.1
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ dba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 31 19:50:48 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
0
PL/SQL Release 12.1.0.1.0 - Production
0
CORE 12.1.0.1.0 Production
0
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
TNS for Linux: Version 12.1.0.1.0 - Production
0
NLSRTL Version 12.1.0.1.0 - Production
0
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@localhost ~]$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch version
OPatch Version: 12.1.0.1.0
OPatch succeeded.
[oracle@localhost ~]$ type make
make is /usr/bin/make
[oracle@localhost ~]$ type ar
ar is /usr/bin/ar
[oracle@localhost ~]$ type ld
ld is /usr/bin/ld
[oracle@localhost ~]$ type nm
nm is /usr/bin/nm
[oracle@localhost ~]$ exit
logout
After downloaded, It was time for test on my Database.
- Check Opatch version and some command-lines.
[root@localhost ~]# cd /u01
[root@localhost u01]# unzip p17027533_121010_Linux-x86-64.zip
Archive: p17027533_121010_Linux-x86-64.zip
creating: 17027533/
inflating: 17027533/README.html
extracting: 17027533/README.txt
creating: 17027533/etc/
creating: 17027533/etc/config/
inflating: 17027533/etc/config/actions.xml
inflating: 17027533/etc/config/inventory.xml
creating: 17027533/files/
creating: 17027533/files/lib/
inflating: 17027533/files/lib/asmcmdexceptions.pm
inflating: 17027533/files/lib/librs12.so
creating: 17027533/files/lib/libgeneric12.a/
inflating: 17027533/files/lib/libgeneric12.a/kgh.o
inflating: 17027533/files/lib/libgeneric12.a/kgl4.o
inflating: 17027533/files/lib/libgeneric12.a/kxdcap.o
inflating: 17027533/files/lib/libgeneric12.a/kgl.o
inflating: 17027533/files/lib/libgeneric12.a/kgl2.o
creating: 17027533/files/lib/libserver12.a/
inflating: 17027533/files/lib/libserver12.a/ksp.o
inflating: 17027533/files/lib/libserver12.a/kpdbd.o
inflating: 17027533/files/lib/libserver12.a/kmm.o
inflating: 17027533/files/lib/libserver12.a/kjbm.o
inflating: 17027533/files/lib/libserver12.a/ksb.o
inflating: 17027533/files/lib/libserver12.a/kkm.o
inflating: 17027533/files/lib/libserver12.a/kqr.o
inflating: 17027533/files/lib/libserver12.a/kjcts.o
inflating: 17027533/files/lib/libserver12.a/ktsj.o
inflating: 17027533/files/lib/libserver12.a/opilof.o
inflating: 17027533/files/lib/libserver12.a/kkzl.o
inflating: 17027533/files/lib/libserver12.a/kcvfdb.o
inflating: 17027533/files/lib/libserver12.a/kql.o
inflating: 17027533/files/lib/libserver12.a/kjm.o
inflating: 17027533/files/lib/libserver12.a/fbadrv.o
inflating: 17027533/files/lib/libserver12.a/kpdba.o
inflating: 17027533/files/lib/libserver12.a/ktm.o
inflating: 17027533/files/lib/libserver12.a/ksl.o
inflating: 17027533/files/lib/libserver12.a/kpolon.o
inflating: 17027533/files/lib/libserver12.a/qesrc.o
inflating: 17027533/files/lib/libserver12.a/kpdbe.o
inflating: 17027533/files/lib/libserver12.a/kpdb.o
inflating: 17027533/files/lib/libserver12.a/kzap.o
inflating: 17027533/files/lib/libserver12.a/kzr.o
inflating: 17027533/files/lib/libserver12.a/kjbl.o
inflating: 17027533/files/lib/libserver12.a/qerfx.o
inflating: 17027533/files/lib/libserver12.a/ksfd.o
inflating: 17027533/files/lib/libserver12.a/ksfdaf.o
inflating: 17027533/files/lib/libserver12.a/kdu.o
inflating: 17027533/files/lib/libserver12.a/krvrd.o
inflating: 17027533/files/lib/libserver12.a/kff.o
inflating: 17027533/files/lib/libserver12.a/kpon.o
inflating: 17027533/files/lib/libserver12.a/kpdbutl.o
inflating: 17027533/files/lib/libserver12.a/knalf.o
inflating: 17027533/files/lib/libserver12.a/jscr.o
inflating: 17027533/files/lib/libserver12.a/kxdam.o
inflating: 17027533/files/lib/libserver12.a/knas.o
inflating: 17027533/files/lib/libserver12.a/kcfis.o
inflating: 17027533/files/lib/libserver12.a/krt.o
inflating: 17027533/files/lib/libserver12.a/ctc.o
inflating: 17027533/files/lib/libserver12.a/ksws.o
inflating: 17027533/files/lib/libserver12.a/aud.o
inflating: 17027533/files/lib/libserver12.a/krvt.o
inflating: 17027533/files/lib/libserver12.a/kwqr.o
inflating: 17027533/files/lib/libserver12.a/kjb.o
inflating: 17027533/files/lib/libserver12.a/kzvdve.o
inflating: 17027533/files/lib/libserver12.a/kxes.o
inflating: 17027533/files/lib/libserver12.a/cvw.o
inflating: 17027533/files/lib/libserver12.a/kqlb.o
inflating: 17027533/files/lib/libserver12.a/ktsi.o
inflating: 17027533/files/lib/libserver12.a/kfi.o
inflating: 17027533/files/lib/libserver12.a/knipg.o
inflating: 17027533/files/lib/libserver12.a/jskq.o
inflating: 17027533/files/lib/libserver12.a/kjzd.o
inflating: 17027533/files/lib/libserver12.a/kdo.o
inflating: 17027533/files/lib/libserver12.a/kjbr.o
inflating: 17027533/files/lib/libserver12.a/kwqic.o
inflating: 17027533/files/lib/libserver12.a/ksk.o
inflating: 17027533/files/lib/libserver12.a/knl.o
inflating: 17027533/files/lib/libserver12.a/ktfa.o
inflating: 17027533/files/lib/libserver12.a/knahs.o
inflating: 17027533/files/lib/libserver12.a/qol.o
inflating: 17027533/files/lib/libserver12.a/ksu.o
inflating: 17027533/files/lib/libserver12.a/kcl.o
inflating: 17027533/files/lib/libserver12.a/knanr.o
inflating: 17027533/files/lib/libserver12.a/kxdofl.o
inflating: 17027533/files/lib/libserver12.a/k2v.o
inflating: 17027533/files/lib/libserver12.a/kjfc.o
inflating: 17027533/files/lib/libserver12.a/knalse.o
inflating: 17027533/files/lib/libserver12.a/kkt.o
inflating: 17027533/files/lib/libserver12.a/kzekm.o
inflating: 17027533/files/lib/libserver12.a/kdn.o
inflating: 17027533/files/lib/libserver12.a/kcf.o
inflating: 17027533/files/lib/libserver12.a/kwqmn.o
inflating: 17027533/files/lib/libserver12.a/ktt.o
inflating: 17027533/files/lib/libserver12.a/kzp.o
inflating: 17027533/files/lib/libserver12.a/kokl2.o
inflating: 17027533/files/lib/libserver12.a/kzckmr.o
inflating: 17027533/files/lib/libserver12.a/knasp.o
inflating: 17027533/files/lib/libserver12.a/kokt.o
inflating: 17027533/files/lib/libserver12.a/kfda.o
inflating: 17027533/files/lib/libserver12.a/kfpkg.o
inflating: 17027533/files/lib/libserver12.a/kpdbicd.o
inflating: 17027533/files/lib/libserver12.a/opiprs.o
inflating: 17027533/files/lib/libserver12.a/knahf.o
inflating: 17027533/files/lib/libserver12.a/qksrc.o
inflating: 17027533/files/lib/libserver12.a/dgls.o
inflating: 17027533/files/lib/libserver12.a/kzmkr.o
inflating: 17027533/files/lib/libserver12.a/kewf.o
inflating: 17027533/files/lib/libserver12.a/kcc.o
inflating: 17027533/files/lib/libserver12.a/qkagby.o
inflating: 17027533/files/lib/libserver12.a/ksfq.o
inflating: 17027533/files/lib/libserver12.a/kewm.o
inflating: 17027533/files/lib/libserver12.a/kpdbcv.o
inflating: 17027533/files/lib/libserver12.a/kfd.o
inflating: 17027533/files/lib/libserver12.a/kcbo.o
inflating: 17027533/files/lib/libserver12.a/knlogc.o
inflating: 17027533/files/lib/libserver12.a/kpdbc.o
inflating: 17027533/files/lib/libserver12.a/qmps.o
inflating: 17027533/files/lib/libserver12.a/sol.o
inflating: 17027533/files/lib/libserver12.a/dgl.o
inflating: 17027533/files/lib/libserver12.a/krvxr.o
inflating: 17027533/files/lib/libserver12.a/kwslb.o
inflating: 17027533/files/lib/libserver12.a/jskm.o
inflating: 17027533/files/lib/libserver12.a/krvxb.o
inflating: 17027533/files/lib/libserver12.a/kcb.o
inflating: 17027533/files/lib/libserver12.a/kfgb.o
inflating: 17027533/files/lib/libserver12.a/knals.o
inflating: 17027533/files/lib/libserver12.a/ktrv.o
inflating: 17027533/files/lib/libserver12.a/kkp.o
inflating: 17027533/files/lib/libserver12.a/knasx.o
inflating: 17027533/files/lib/libserver12.a/knasda.o
inflating: 17027533/files/lib/libserver12.a/kfvsu.o
inflating: 17027533/files/lib/libserver12.a/knam.o
inflating: 17027533/files/lib/libserver12.a/kkeaf.o
inflating: 17027533/files/lib/libserver12.a/kwqv.o
inflating: 17027533/files/lib/libserver12.a/kzckm.o
inflating: 17027533/files/lib/libserver12.a/kjzn.o
inflating: 17027533/files/lib/libserver12.a/knac.o
inflating: 17027533/files/lib/libserver12.a/kffm.o
inflating: 17027533/files/lib/libserver12.a/zllc.o
inflating: 17027533/files/lib/libnnz12.so
inflating: 17027533/files/lib/libnnzst12.a
inflating: 17027533/files/lib/asmcmdshare.pm
inflating: 17027533/files/lib/libzt12.a
inflating: 17027533/files/lib/asmcmddisk.pm
inflating: 17027533/files/lib/libosbws12.so
creating: 17027533/files/sqlpatch/
inflating: 17027533/files/sqlpatch/sqlpatch.pm
inflating: 17027533/files/sqlpatch/sqlpatch.pl
creating: 17027533/files/sqlpatch/17027533/
inflating: 17027533/files/sqlpatch/17027533/17027533_apply.sql
inflating: 17027533/files/sqlpatch/17027533/17027533_rollback.sql
creating: 17027533/files/rdbms/
creating: 17027533/files/rdbms/lib/
inflating: 17027533/files/rdbms/lib/jox.o
creating: 17027533/files/rdbms/lib/libknlopt.a/
inflating: 17027533/files/rdbms/lib/libknlopt.a/jox.o
creating: 17027533/files/rdbms/mesg/
inflating: 17027533/files/rdbms/mesg/oraus.msg
inflating: 17027533/files/rdbms/mesg/oraus.msb
creating: 17027533/files/rdbms/admin/
inflating: 17027533/files/rdbms/admin/prvtbstr.plb
inflating: 17027533/files/rdbms/admin/prvtlmd.plb
inflating: 17027533/files/rdbms/admin/bundledata_PSU.xml
inflating: 17027533/files/rdbms/admin/catbundleapply.sql
inflating: 17027533/files/rdbms/admin/prvtbxstr.plb
inflating: 17027533/files/rdbms/admin/catuppst.sql
inflating: 17027533/files/rdbms/admin/catbundle.sql
inflating: 17027533/files/rdbms/admin/cdenv.sql
inflating: 17027533/files/rdbms/admin/catbundlerollback.sql
creating: 17027533/files/bin/
inflating: 17027533/files/bin/asmcmdcore
creating: 17027533/files/patch/
creating: 17027533/files/patch/scripts/
inflating: 17027533/files/patch/scripts/bug16825779.sql
inflating: 17027533/files/patch/scripts/bug16286774.sql
[root@localhost u01]# cd 17027533
[root@localhost 17027533]# export PATH=$PATH:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch
[root@localhost 17027533]# chown -R oracle:oinstall /u01/17027533/
[root@localhost 17027533]# chmod -R 755 /u01/17027533/
[root@localhost 17027533]# su - oracle
[oracle@localhost 17027533]$ export PATH=$PATH:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch
[oracle@localhost 17027533]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-31_20-11-12PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
16901482, 17027533
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
16901482
Conflicts/Supersets for each patch are:
Patch : 17027533
Conflict with 16901482
Conflict details:
/u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a:/kpolon.o
OPatch failed with error code 1
[oracle@localhost 17027533]$ dba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 31 20:20:01 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$ lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-OCT-2013 20:21:21
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.236.128)(PORT=1521)))
The command completed successfully
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$ cd
[oracle@localhost ~]$ opatch rollback -id 16901482
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16901482_Oct_31_2013_20_21_28/rollback2013-10-31_20-21-28PM_1.log
RollbackSession rolling back interim patch '16901482' from OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
java.util.logging.ErrorManager: 2
java.io.IOException: No space left on device
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java:282)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at java.util.logging.FileHandler$MeteredStream.flush(FileHandler.java:141)
at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:278)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:122)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212)
at java.util.logging.StreamHandler.flush(StreamHandler.java:223)
at java.util.logging.FileHandler.publish(FileHandler.java:554)
at java.util.logging.Logger.log(Logger.java:478)
at java.util.logging.Logger.doLog(Logger.java:500)
at java.util.logging.Logger.log(Logger.java:523)
at oracle.opatch.opatchlogger.OLoggerImpl.justlog(OLoggerImpl.java:790)
at oracle.opatch.opatchlogger.OLogger.justlog(OLogger.java:1299)
at oracle.opatch.opatchlogger.OLogger.printStackTrace(OLogger.java:993)
at oracle.opatch.PatchObject.backupForRestore(PatchObject.java:4491)
at oracle.opatch.RollbackSession.backupPatchActionsAndCreateRestoreFile(RollbackSession.java:704)
at oracle.opatch.RollbackSession.backupPatchActionsAndCreateRestoreFile(RollbackSession.java:260)
at oracle.opatch.RollbackSession.processLocal(RollbackSession.java:1568)
at oracle.opatch.RollbackSession.process(RollbackSession.java:3128)
at oracle.opatch.OPatchSession.main(OPatchSession.java:2529)
at oracle.opatch.OPatch.main(OPatch.java:674)
RollbackSession for patch ID '16901482': Could not back up following actions for system restore:
'1) /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a
'
Do you want to proceed? [y|n]
y
User Responded with: Y
[ Error during Back up for restore Phase]. Detail: RollbackSession failed: RollbackSession failed to prepare the system. Backup for restore failed. No Actions
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67159:RollbackSession for patch ID '16901482': Could not back up following actions for system restore:
'1) /u01/app/oracle/product/12.1.0/dbhome_1/lib/libserver12.a
'
--------------------------------------------------------------------------------
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16901482_Oct_31_2013_20_21_28/rollback2013-10-31_20-21-28PM_1.log
Recommended actions: OPatch failed to back up existing patches in the Oracle Home inventory -- patches that are impacted by new patch installation. Please check if you have priviledge to access and modify those files.
OPatch failed with error code 49
[oracle@localhost ~]$ cd/u01/
-bash: cd/u01/: No such file or directory
[oracle@localhost ~]$ cd /u01
[oracle@localhost u01]$ ls
17027533 app install jdk libskgxn lost+found oms p17027533_121010_Linux-x86-64.zip plugins Release_Notes.pdf response runInstaller stage wls WT.zip
[oracle@localhost u01]$ rm -rf install jdk libskgxn oms p17027533_121010_Linux-x86-64.zip plugins Release_Notes.pdf response runInstaller stage wls WT.zip
[oracle@localhost u01]$ ls
17027533 app lost+found
[oracle@localhost u01]$ ls
17027533 app lost+found
[oracle@localhost u01]$ ls
17027533 app lost+found p16901482_121010_Linux-x86-64.zip
[oracle@localhost u01]$ su -
Password:
[root@localhost ~]# unzip /u01/p16901482_121010_Linux-x86-64.zip
Archive: /u01/p16901482_121010_Linux-x86-64.zip
creating: 16901482/
creating: 16901482/files/
creating: 16901482/files/lib/
creating: 16901482/files/lib/libserver12.a/
inflating: 16901482/files/lib/libserver12.a/kpolon.o
creating: 16901482/etc/
creating: 16901482/etc/config/
inflating: 16901482/etc/config/inventory.xml
inflating: 16901482/etc/config/actions.xml
creating: 16901482/online/
creating: 16901482/online/etc/
creating: 16901482/online/etc/config/
inflating: 16901482/online/etc/config/deploy.xml
inflating: 16901482/online/etc/config/actions.xml
inflating: 16901482/online/etc/config/inventory.xml
creating: 16901482/online/etc/xml/
inflating: 16901482/online/etc/xml/GenericActions.xml
inflating: 16901482/online/etc/xml/ShiphomeDirectoryStructure.xml
creating: 16901482/online/files/
creating: 16901482/online/files/hpatch/
inflating: 16901482/online/files/hpatch/bug16901482.pch
inflating: 16901482/README.txt
[root@localhost ~]#
[root@localhost ~]# chown -R oracle:oinstall /u01/
[root@localhost ~]# chmod -R 755 /u01/
[root@localhost ~]# exit
logout
[oracle@localhost u01]$ ls
17027533 app lost+found p16901482_121010_Linux-x86-64.zip
[oracle@localhost u01]$ ls -lrt
total 212
drwxr-xr-x 4 oracle oinstall 4096 Sep 27 20:30 17027533
drwxr-xr-x 2 oracle oinstall 16384 Oct 27 22:54 lost+found
drwxr-xr-x 4 oracle oinstall 4096 Oct 27 23:18 app
-rwxr-xr-x 1 oracle oinstall 174868 Oct 28 14:27 p16901482_121010_Linux-x86-64.zip
[oracle@localhost u01]$ unzip p16901482_121010_Linux-x86-64.zip
Archive: p16901482_121010_Linux-x86-64.zip
creating: 16901482/
creating: 16901482/files/
creating: 16901482/files/lib/
creating: 16901482/files/lib/libserver12.a/
inflating: 16901482/files/lib/libserver12.a/kpolon.o
creating: 16901482/etc/
creating: 16901482/etc/config/
inflating: 16901482/etc/config/inventory.xml
inflating: 16901482/etc/config/actions.xml
creating: 16901482/online/
creating: 16901482/online/etc/
creating: 16901482/online/etc/config/
inflating: 16901482/online/etc/config/deploy.xml
inflating: 16901482/online/etc/config/actions.xml
inflating: 16901482/online/etc/config/inventory.xml
creating: 16901482/online/etc/xml/
inflating: 16901482/online/etc/xml/GenericActions.xml
inflating: 16901482/online/etc/xml/ShiphomeDirectoryStructure.xml
creating: 16901482/online/files/
creating: 16901482/online/files/hpatch/
inflating: 16901482/online/files/hpatch/bug16901482.pch
inflating: 16901482/README.txt
[oracle@localhost u01]$ ls -lrt
total 220
drwxrwxr-x 5 oracle oinstall 4096 Sep 5 03:02 16901482
drwxr-xr-x 4 oracle oinstall 4096 Sep 27 20:30 17027533
drwxr-xr-x 2 oracle oinstall 16384 Oct 27 22:54 lost+found
drwxr-xr-x 4 oracle oinstall 4096 Oct 27 23:18 app
-rwxr-xr-x 1 oracle oinstall 174868 Oct 28 14:27 p16901482_121010_Linux-x86-64.zip
[oracle@localhost u01]$ cd 16901482
[oracle@localhost 16901482]$ opatch rollback -id 16901482
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16901482_Oct_31_2013_20_32_39/rollback2013-10-31_20-32-39PM_1.log
RollbackSession rolling back interim patch '16901482' from OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Patching component oracle.rdbms, 12.1.0.1.0...
RollbackSession removing interim patch '16901482' from inventory
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16901482_Oct_31_2013_20_32_39/rollback2013-10-31_20-32-39PM_1.log
OPatch succeeded.
[oracle@localhost 16901482]$ cd ..
[oracle@localhost u01]$ cd 17027533/
[oracle@localhost 17027533]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-31_20-41-36PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-31_20-41-36PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost 17027533]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-31_20-44-50PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@localhost 17027533]$ opatch lsinventory -detail
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-31_21-44-55PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-31_21-44-55PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
Installed Products (131):
Assistant Common Files 12.1.0.1.0
Buildtools Common Files 12.1.0.1.0
Cluster Verification Utility Common Files 12.1.0.1.0
Database Configuration and Upgrade Assistants 12.1.0.1.0
Database Migration Assistant for Unicode 12.1.0.1.0
Database SQL Scripts 12.1.0.1.0
Database Workspace Manager 12.1.0.1.0
Deinstallation Tool 12.1.0.1.0
Enterprise Edition Options 12.1.0.1.0
Expat libraries 2.0.1.0.2
Generic Connectivity Common Files 12.1.0.1.0
HAS Common Files 12.1.0.1.0
HAS Files for DB 12.1.0.1.0
Installation Common Files 12.1.0.1.0
Installation Plugin Files 12.1.0.1.0
Installer SDK Component 12.1.0.1.0
JAccelerator (COMPANION) 12.1.0.1.0
LDAP Required Support Files 12.1.0.1.0
OLAP SQL Scripts 12.1.0.1.0
Oracle Advanced Security 12.1.0.1.0
Oracle Application Express 12.1.0.1.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 12.1.0.1.0
Oracle Clusterware RDBMS Files 12.1.0.1.0
Oracle Configuration Manager 10.3.7.0.3
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.1.0
Oracle Core Required Support Files 12.1.0.1.0
Oracle Core Required Support Files for Core DB 12.1.0.1.0
Oracle Core XML Development Kit 12.1.0.1.0
Oracle Data Mining RDBMS Files 12.1.0.1.0
Oracle Database 12c 12.1.0.1.0
Oracle Database 12c 12.1.0.1.0
Oracle Database 12c Multimedia Files 12.1.0.1.0
Oracle Database Deconfiguration 12.1.0.1.0
Oracle Database Gateway for ODBC 12.1.0.1.0
Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.1.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.1.0
Oracle Database Vault option 12.1.0.1.0
Oracle DBCA Deconfiguration 12.1.0.1.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.1.0
Oracle Globalization Support 12.1.0.1.0
Oracle Globalization Support For Core 12.1.0.1.0
Oracle Help for Java 11.1.1.6.0
Oracle Help Share Library 11.1.1.6.0
Oracle Ice Browser 11.1.1.6.0
Oracle Internet Directory Client 12.1.0.1.0
Oracle Java Client 12.1.0.1.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC Server Support Package 12.1.0.1.0
Oracle JDBC/OCI Instant Client 12.1.0.1.0
Oracle JDBC/THIN Interfaces 12.1.0.1.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.1.0
Oracle JVM For Core 12.1.0.1.0
Oracle Label Security 12.1.0.1.0
Oracle LDAP administration 12.1.0.1.0
Oracle Locale Builder 12.1.0.1.0
Oracle Message Gateway Common Files 12.1.0.1.0
Oracle Multimedia 12.1.0.1.0
Oracle Multimedia Client Option 12.1.0.1.0
Oracle Multimedia Java Advanced Imaging 12.1.0.1.0
Oracle Multimedia Locator 12.1.0.1.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.1.0
Oracle Multimedia Locator RDBMS Files 12.1.0.1.0
Oracle Net 12.1.0.1.0
Oracle Net Java Required Support Files 12.1.0.1.0
Oracle Net Listener 12.1.0.1.0
Oracle Net Required Support Files 12.1.0.1.0
Oracle Net Services 12.1.0.1.0
Oracle Netca Client 12.1.0.1.0
Oracle Notification Service 12.1.0.1.0
Oracle Notification Service (eONS) 12.1.0.1.0
Oracle Notification Service for Instant Client 12.1.0.1.0
Oracle ODBC Driver 12.1.0.1.0
Oracle ODBC Driverfor Instant Client 12.1.0.1.0
Oracle OLAP 12.1.0.1.0
Oracle OLAP API 12.1.0.1.0
Oracle OLAP RDBMS Files 12.1.0.1.0
Oracle One-Off Patch Installer 12.1.0.1.0
Oracle Partitioning 12.1.0.1.0
Oracle Programmer 12.1.0.1.0
Oracle Quality of Service Management (Client) 12.1.0.1.0
Oracle R Enterprise Server Files 12.1.0.1.0
Oracle RAC Deconfiguration 12.1.0.1.0
Oracle RAC Required Support Files-HAS 12.1.0.1.0
Oracle Real Application Testing 12.1.0.1.0
Oracle Recovery Manager 12.1.0.1.0
Oracle Security Developer Tools 12.1.0.1.0
Oracle Spatial and Graph 12.1.0.1.0
Oracle SQL Developer 12.1.0.1.0
Oracle Starter Database 12.1.0.1.0
Oracle Text 12.1.0.1.0
Oracle Text ATG Language Support Files 12.1.0.1.0
Oracle Text for Core 12.1.0.1.0
Oracle Text Required Support Files 12.1.0.1.0
Oracle Universal Connection Pool 12.1.0.1.0
Oracle Universal Installer 12.1.0.1.0
Oracle USM Deconfiguration 12.1.0.1.0
Oracle Wallet Manager 12.1.0.1.0
Oracle XML Development Kit 12.1.0.1.0
Oracle XML Query 12.1.0.1.0
oracle.swd.oui.core.min 12.1.0.1.0
Parser Generator Required Support Files 12.1.0.1.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.1.0
PL/SQL Embedded Gateway 12.1.0.1.0
Platform Required Support Files 12.1.0.1.0
Precompiler Common Files 12.1.0.1.0
Precompiler Common Files for Core 12.1.0.1.0
Precompiler Required Support Files 12.1.0.1.0
Precompilers 12.1.0.1.0
RDBMS Required Support Files 12.1.0.1.0
RDBMS Required Support Files for Instant Client 12.1.0.1.0
RDBMS Required Support Files Runtime 12.1.0.1.0
Required Support Files 12.1.0.1.0
Sample Schema Data 12.1.0.1.0
Secure Socket Layer 12.1.0.1.0
SQL*Plus 12.1.0.1.0
SQL*Plus Files for Instant Client 12.1.0.1.0
SQL*Plus Required Support Files 12.1.0.1.0
SQLJ Runtime 12.1.0.1.0
SSL Required Support Files for InstantClient 12.1.0.1.0
Sun JDK 1.6.0.37.0
XDK Required Support Files 12.1.0.1.0
XML Parser for Java 12.1.0.1.0
XML Parser for Oracle JVM 12.1.0.1.0
There are 131 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost 17027533]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_31_2013_21_45_08/apply2013-10-31_21-45-07PM_1.log
Applying interim patch '17027533' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 12.1.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...
Patching component oracle.rdbms.rsf, 12.1.0.1.0...
Patching component oracle.ldap.rsf, 12.1.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.1.0...
Verifying the update...
Patch 17027533 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_31_2013_21_45_08/apply2013-10-31_21-45-07PM_1.log
OPatch succeeded.
[oracle@localhost 17027533]$ opatch lsinventory -detail
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-31_21-58-19PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-31_21-58-19PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
Installed Products (131):
Assistant Common Files 12.1.0.1.0
Buildtools Common Files 12.1.0.1.0
Cluster Verification Utility Common Files 12.1.0.1.0
Database Configuration and Upgrade Assistants 12.1.0.1.0
Database Migration Assistant for Unicode 12.1.0.1.0
Database SQL Scripts 12.1.0.1.0
Database Workspace Manager 12.1.0.1.0
Deinstallation Tool 12.1.0.1.0
Enterprise Edition Options 12.1.0.1.0
Expat libraries 2.0.1.0.2
Generic Connectivity Common Files 12.1.0.1.0
HAS Common Files 12.1.0.1.0
HAS Files for DB 12.1.0.1.0
Installation Common Files 12.1.0.1.0
Installation Plugin Files 12.1.0.1.0
Installer SDK Component 12.1.0.1.0
JAccelerator (COMPANION) 12.1.0.1.0
LDAP Required Support Files 12.1.0.1.0
OLAP SQL Scripts 12.1.0.1.0
Oracle Advanced Security 12.1.0.1.0
Oracle Application Express 12.1.0.1.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 12.1.0.1.0
Oracle Clusterware RDBMS Files 12.1.0.1.0
Oracle Configuration Manager 10.3.7.0.3
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.1.0
Oracle Core Required Support Files 12.1.0.1.0
Oracle Core Required Support Files for Core DB 12.1.0.1.0
Oracle Core XML Development Kit 12.1.0.1.0
Oracle Data Mining RDBMS Files 12.1.0.1.0
Oracle Database 12c 12.1.0.1.0
Oracle Database 12c 12.1.0.1.0
Oracle Database 12c Multimedia Files 12.1.0.1.0
Oracle Database Deconfiguration 12.1.0.1.0
Oracle Database Gateway for ODBC 12.1.0.1.0
Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.1.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.1.0
Oracle Database Vault option 12.1.0.1.0
Oracle DBCA Deconfiguration 12.1.0.1.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.1.0
Oracle Globalization Support 12.1.0.1.0
Oracle Globalization Support For Core 12.1.0.1.0
Oracle Help for Java 11.1.1.6.0
Oracle Help Share Library 11.1.1.6.0
Oracle Ice Browser 11.1.1.6.0
Oracle Internet Directory Client 12.1.0.1.0
Oracle Java Client 12.1.0.1.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC Server Support Package 12.1.0.1.0
Oracle JDBC/OCI Instant Client 12.1.0.1.0
Oracle JDBC/THIN Interfaces 12.1.0.1.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.1.0
Oracle JVM For Core 12.1.0.1.0
Oracle Label Security 12.1.0.1.0
Oracle LDAP administration 12.1.0.1.0
Oracle Locale Builder 12.1.0.1.0
Oracle Message Gateway Common Files 12.1.0.1.0
Oracle Multimedia 12.1.0.1.0
Oracle Multimedia Client Option 12.1.0.1.0
Oracle Multimedia Java Advanced Imaging 12.1.0.1.0
Oracle Multimedia Locator 12.1.0.1.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.1.0
Oracle Multimedia Locator RDBMS Files 12.1.0.1.0
Oracle Net 12.1.0.1.0
Oracle Net Java Required Support Files 12.1.0.1.0
Oracle Net Listener 12.1.0.1.0
Oracle Net Required Support Files 12.1.0.1.0
Oracle Net Services 12.1.0.1.0
Oracle Netca Client 12.1.0.1.0
Oracle Notification Service 12.1.0.1.0
Oracle Notification Service (eONS) 12.1.0.1.0
Oracle Notification Service for Instant Client 12.1.0.1.0
Oracle ODBC Driver 12.1.0.1.0
Oracle ODBC Driverfor Instant Client 12.1.0.1.0
Oracle OLAP 12.1.0.1.0
Oracle OLAP API 12.1.0.1.0
Oracle OLAP RDBMS Files 12.1.0.1.0
Oracle One-Off Patch Installer 12.1.0.1.0
Oracle Partitioning 12.1.0.1.0
Oracle Programmer 12.1.0.1.0
Oracle Quality of Service Management (Client) 12.1.0.1.0
Oracle R Enterprise Server Files 12.1.0.1.0
Oracle RAC Deconfiguration 12.1.0.1.0
Oracle RAC Required Support Files-HAS 12.1.0.1.0
Oracle Real Application Testing 12.1.0.1.0
Oracle Recovery Manager 12.1.0.1.0
Oracle Security Developer Tools 12.1.0.1.0
Oracle Spatial and Graph 12.1.0.1.0
Oracle SQL Developer 12.1.0.1.0
Oracle Starter Database 12.1.0.1.0
Oracle Text 12.1.0.1.0
Oracle Text ATG Language Support Files 12.1.0.1.0
Oracle Text for Core 12.1.0.1.0
Oracle Text Required Support Files 12.1.0.1.0
Oracle Universal Connection Pool 12.1.0.1.0
Oracle Universal Installer 12.1.0.1.0
Oracle USM Deconfiguration 12.1.0.1.0
Oracle Wallet Manager 12.1.0.1.0
Oracle XML Development Kit 12.1.0.1.0
Oracle XML Query 12.1.0.1.0
oracle.swd.oui.core.min 12.1.0.1.0
Parser Generator Required Support Files 12.1.0.1.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.1.0
PL/SQL Embedded Gateway 12.1.0.1.0
Platform Required Support Files 12.1.0.1.0
Precompiler Common Files 12.1.0.1.0
Precompiler Common Files for Core 12.1.0.1.0
Precompiler Required Support Files 12.1.0.1.0
Precompilers 12.1.0.1.0
RDBMS Required Support Files 12.1.0.1.0
RDBMS Required Support Files for Instant Client 12.1.0.1.0
RDBMS Required Support Files Runtime 12.1.0.1.0
Required Support Files 12.1.0.1.0
Sample Schema Data 12.1.0.1.0
Secure Socket Layer 12.1.0.1.0
SQL*Plus 12.1.0.1.0
SQL*Plus Files for Instant Client 12.1.0.1.0
SQL*Plus Required Support Files 12.1.0.1.0
SQLJ Runtime 12.1.0.1.0
SSL Required Support Files for InstantClient 12.1.0.1.0
Sun JDK 1.6.0.37.0
XDK Required Support Files 12.1.0.1.0
XML Parser for Java 12.1.0.1.0
XML Parser for Oracle JVM 12.1.0.1.0
There are 131 products installed in this Oracle Home.
Interim patches (1) :
Patch 17027533 : applied on Thu Oct 31 21:53:36 MYT 2013
Unique Patch ID: 16677152
Patch description: "Database Patch Set Update : 12.1.0.1.1 (17027533)"
Created on 27 Sep 2013, 05:30:33 hrs PST8PDT
Bugs fixed:
17034172, 16694728, 16448848, 16863422, 16634384, 16465158, 16320173
16313881, 16910734, 16816103, 16911800, 16715647, 16825779, 16707927
16392068, 14197853, 16712618, 17273253, 16902138, 16524071, 16856570
16465149, 16705020, 16689109, 16372203, 16864864, 16849982, 16946613
16837842, 16964279, 16459685, 16978185, 16845022, 16195633, 14536110
16964686, 16787973, 16850996, 16674842, 16838328, 16178562, 15996344
16503473, 16842274, 16935643, 17000176, 14355775, 16362358, 16994576
16485876, 16919176, 16928832, 16864359, 16617325, 16921340, 16679874
16788832, 16483559, 16733884, 16784167, 16286774, 15986012, 16660558
16674666, 16191248, 16697600, 16993424, 16946990, 16589507, 16173738
16784143, 16772060, 16991789, 17346196, 16495802, 16859937, 16590848
16910001, 16603924, 16427054, 16730813, 16227068, 16663303, 16784901
16836849, 16186165, 16457621, 16007562, 16170787, 16663465, 16524968
16543323, 17027533, 16675710, 17005047, 16795944, 16668226, 16070351
16212405, 16523150, 16698577, 16621274, 16930325, 17330580, 16443657
Files Touched:
/kcb.o --> ORACLE_HOME/lib/libserver12.a
/kcbo.o --> ORACLE_HOME/lib/libserver12.a
/kcl.o --> ORACLE_HOME/lib/libserver12.a
/kjzd.o --> ORACLE_HOME/lib/libserver12.a
/kjzn.o --> ORACLE_HOME/lib/libserver12.a
/kjb.o --> ORACLE_HOME/lib/libserver12.a
/kjbl.o --> ORACLE_HOME/lib/libserver12.a
/kjbm.o --> ORACLE_HOME/lib/libserver12.a
/kjbr.o --> ORACLE_HOME/lib/libserver12.a
/kjcts.o --> ORACLE_HOME/lib/libserver12.a
/kjfc.o --> ORACLE_HOME/lib/libserver12.a
/kjm.o --> ORACLE_HOME/lib/libserver12.a
/dgl.o --> ORACLE_HOME/lib/libserver12.a
/dgls.o --> ORACLE_HOME/lib/libserver12.a
/kxes.o --> ORACLE_HOME/lib/libserver12.a
/kkm.o --> ORACLE_HOME/lib/libserver12.a
/kql.o --> ORACLE_HOME/lib/libserver12.a
/kqlb.o --> ORACLE_HOME/lib/libserver12.a
/qol.o --> ORACLE_HOME/lib/libserver12.a
/kqr.o --> ORACLE_HOME/lib/libserver12.a
/ctc.o --> ORACLE_HOME/lib/libserver12.a
/cvw.o --> ORACLE_HOME/lib/libserver12.a
/kkeaf.o --> ORACLE_HOME/lib/libserver12.a
/kkp.o --> ORACLE_HOME/lib/libserver12.a
/kkt.o --> ORACLE_HOME/lib/libserver12.a
/sol.o --> ORACLE_HOME/lib/libserver12.a
/jskm.o --> ORACLE_HOME/lib/libserver12.a
/jskq.o --> ORACLE_HOME/lib/libserver12.a
/jscr.o --> ORACLE_HOME/lib/libserver12.a
/krvrd.o --> ORACLE_HOME/lib/libserver12.a
/krvt.o --> ORACLE_HOME/lib/libserver12.a
/krvxb.o --> ORACLE_HOME/lib/libserver12.a
/krvxr.o --> ORACLE_HOME/lib/libserver12.a
/kmm.o --> ORACLE_HOME/lib/libserver12.a
/kokl2.o --> ORACLE_HOME/lib/libserver12.a
/kokt.o --> ORACLE_HOME/lib/libserver12.a
/kwqic.o --> ORACLE_HOME/lib/libserver12.a
/kwqr.o --> ORACLE_HOME/lib/libserver12.a
/kwqv.o --> ORACLE_HOME/lib/libserver12.a
/kwqmn.o --> ORACLE_HOME/lib/libserver12.a
/kwslb.o --> ORACLE_HOME/lib/libserver12.a
/kpdb.o --> ORACLE_HOME/lib/libserver12.a
/kpdba.o --> ORACLE_HOME/lib/libserver12.a
/kpdbc.o --> ORACLE_HOME/lib/libserver12.a
/kpdbcv.o --> ORACLE_HOME/lib/libserver12.a
/kpdbd.o --> ORACLE_HOME/lib/libserver12.a
/kpdbe.o --> ORACLE_HOME/lib/libserver12.a
/kpdbicd.o --> ORACLE_HOME/lib/libserver12.a
/kpdbutl.o --> ORACLE_HOME/lib/libserver12.a
/kpolon.o --> ORACLE_HOME/lib/libserver12.a
/kpon.o --> ORACLE_HOME/lib/libserver12.a
/opilof.o --> ORACLE_HOME/lib/libserver12.a
/opiprs.o --> ORACLE_HOME/lib/libserver12.a
/kfd.o --> ORACLE_HOME/lib/libserver12.a
/kfda.o --> ORACLE_HOME/lib/libserver12.a
/kff.o --> ORACLE_HOME/lib/libserver12.a
/kffm.o --> ORACLE_HOME/lib/libserver12.a
/kfgb.o --> ORACLE_HOME/lib/libserver12.a
/kfi.o --> ORACLE_HOME/lib/libserver12.a
/kfpkg.o --> ORACLE_HOME/lib/libserver12.a
/kfvsu.o --> ORACLE_HOME/lib/libserver12.a
/kdo.o --> ORACLE_HOME/lib/libserver12.a
/kdu.o --> ORACLE_HOME/lib/libserver12.a
/kdn.o --> ORACLE_HOME/lib/libserver12.a
/kcc.o --> ORACLE_HOME/lib/libserver12.a
/kcf.o --> ORACLE_HOME/lib/libserver12.a
/kcfis.o --> ORACLE_HOME/lib/libserver12.a
/kcvfdb.o --> ORACLE_HOME/lib/libserver12.a
/krt.o --> ORACLE_HOME/lib/libserver12.a
/knac.o --> ORACLE_HOME/lib/libserver12.a
/knahf.o --> ORACLE_HOME/lib/libserver12.a
/knahs.o --> ORACLE_HOME/lib/libserver12.a
/knalf.o --> ORACLE_HOME/lib/libserver12.a
/knals.o --> ORACLE_HOME/lib/libserver12.a
/knalse.o --> ORACLE_HOME/lib/libserver12.a
/knam.o --> ORACLE_HOME/lib/libserver12.a
/knanr.o --> ORACLE_HOME/lib/libserver12.a
/knas.o --> ORACLE_HOME/lib/libserver12.a
/knasda.o --> ORACLE_HOME/lib/libserver12.a
/knasp.o --> ORACLE_HOME/lib/libserver12.a
/knasx.o --> ORACLE_HOME/lib/libserver12.a
/knipg.o --> ORACLE_HOME/lib/libserver12.a
/knl.o --> ORACLE_HOME/lib/libserver12.a
/knlogc.o --> ORACLE_HOME/lib/libserver12.a
/kkzl.o --> ORACLE_HOME/lib/libserver12.a
/kxdam.o --> ORACLE_HOME/lib/libserver12.a
/kxdofl.o --> ORACLE_HOME/lib/libserver12.a
/aud.o --> ORACLE_HOME/lib/libserver12.a
/kzap.o --> ORACLE_HOME/lib/libserver12.a
/kzp.o --> ORACLE_HOME/lib/libserver12.a
/kzr.o --> ORACLE_HOME/lib/libserver12.a
/kzckm.o --> ORACLE_HOME/lib/libserver12.a
/kzckmr.o --> ORACLE_HOME/lib/libserver12.a
/kzekm.o --> ORACLE_HOME/lib/libserver12.a
/kzmkr.o --> ORACLE_HOME/lib/libserver12.a
/kzvdve.o --> ORACLE_HOME/lib/libserver12.a
/zllc.o --> ORACLE_HOME/lib/libserver12.a
/ktm.o --> ORACLE_HOME/lib/libserver12.a
/ktsi.o --> ORACLE_HOME/lib/libserver12.a
/ktsj.o --> ORACLE_HOME/lib/libserver12.a
/ktt.o --> ORACLE_HOME/lib/libserver12.a
/qesrc.o --> ORACLE_HOME/lib/libserver12.a
/qerfx.o --> ORACLE_HOME/lib/libserver12.a
/qkagby.o --> ORACLE_HOME/lib/libserver12.a
/qksrc.o --> ORACLE_HOME/lib/libserver12.a
/kewf.o --> ORACLE_HOME/lib/libserver12.a
/kewm.o --> ORACLE_HOME/lib/libserver12.a
/k2v.o --> ORACLE_HOME/lib/libserver12.a
/fbadrv.o --> ORACLE_HOME/lib/libserver12.a
/ktfa.o --> ORACLE_HOME/lib/libserver12.a
/ktrv.o --> ORACLE_HOME/lib/libserver12.a
/ksb.o --> ORACLE_HOME/lib/libserver12.a
/ksfd.o --> ORACLE_HOME/lib/libserver12.a
/ksfdaf.o --> ORACLE_HOME/lib/libserver12.a
/ksfq.o --> ORACLE_HOME/lib/libserver12.a
/ksk.o --> ORACLE_HOME/lib/libserver12.a
/ksl.o --> ORACLE_HOME/lib/libserver12.a
/ksp.o --> ORACLE_HOME/lib/libserver12.a
/ksu.o --> ORACLE_HOME/lib/libserver12.a
/ksws.o --> ORACLE_HOME/lib/libserver12.a
/qmps.o --> ORACLE_HOME/lib/libserver12.a
/jox.o --> ORACLE_HOME/rdbms/lib/libknlopt.a
sqlpatch.pl --> ORACLE_HOME/sqlpatch/sqlpatch.pl
sqlpatch.pm --> ORACLE_HOME/sqlpatch/sqlpatch.pm
asmcmdcore --> ORACLE_HOME/bin/asmcmdcore
asmcmdshare.pm --> ORACLE_HOME/lib/asmcmdshare.pm
asmcmdexceptions.pm --> ORACLE_HOME/lib/asmcmdexceptions.pm
asmcmddisk.pm --> ORACLE_HOME/lib/asmcmddisk.pm
jox.o --> ORACLE_HOME/rdbms/lib/jox.o
libosbws12.so --> ORACLE_HOME/lib/libosbws12.so
librs12.so --> ORACLE_HOME/lib/librs12.so
bundledata_PSU.xml --> ORACLE_HOME/rdbms/admin/bundledata_PSU.xml
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ikfod
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/irenamedg
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ioracle
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/client_sharedlib
17027533_apply.sql --> ORACLE_HOME/sqlpatch/17027533/17027533_apply.sql
17027533_rollback.sql --> ORACLE_HOME/sqlpatch/17027533/17027533_rollback.sql
bug16286774.sql --> ORACLE_HOME/patch/scripts/bug16286774.sql
bug16825779.sql --> ORACLE_HOME/patch/scripts/bug16825779.sql
catbundle.sql --> ORACLE_HOME/rdbms/admin/catbundle.sql
catbundleapply.sql --> ORACLE_HOME/rdbms/admin/catbundleapply.sql
catbundlerollback.sql --> ORACLE_HOME/rdbms/admin/catbundlerollback.sql
catuppst.sql --> ORACLE_HOME/rdbms/admin/catuppst.sql
cdenv.sql --> ORACLE_HOME/rdbms/admin/cdenv.sql
prvtlmd.plb --> ORACLE_HOME/rdbms/admin/prvtlmd.plb
prvtbstr.plb --> ORACLE_HOME/rdbms/admin/prvtbstr.plb
prvtbxstr.plb --> ORACLE_HOME/rdbms/admin/prvtbxstr.plb
/kgl.o --> ORACLE_HOME/lib/libgeneric12.a
/kgl2.o --> ORACLE_HOME/lib/libgeneric12.a
/kgl4.o --> ORACLE_HOME/lib/libgeneric12.a
/kxdcap.o --> ORACLE_HOME/lib/libgeneric12.a
/kgh.o --> ORACLE_HOME/lib/libgeneric12.a
oraus.msb --> ORACLE_HOME/rdbms/mesg/oraus.msb
oraus.msg --> ORACLE_HOME/rdbms/mesg/oraus.msg
libzt12.a --> ORACLE_HOME/lib/libzt12.a
ins_net_client.mk --> ORACLE_HOME/network/lib/client_sharedlib
libzt12.a --> ORACLE_HOME/lib/libzt12.a
libnnzst12.a --> ORACLE_HOME/lib/libnnzst12.a
libnnz12.so --> ORACLE_HOME/lib/libnnz12.so
Patch Location in Inventory:
/u01/app/oracle/product/12.1.0/dbhome_1/inventory/oneoffs/17027533
Patch Location in Storage area:
/u01/app/oracle/product/12.1.0/dbhome_1/.patch_storage/17027533_Sep_27_2013_05_30_33
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost 17027533]$
[oracle@localhost 17027533]$ dba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 31 22:09:26 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 417546240 bytes
Fixed Size 2289064 bytes
Variable Size 339739224 bytes
Database Buffers 71303168 bytes
Redo Buffers 4214784 bytes
Database mounted.
Database opened.
SQL> !lsnrctl start
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-OCT-2013 22:12:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.236.128)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.236.128)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 31-OCT-2013 22:12:17
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.236.128)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@localhost 17027533]$ cd $ORACLE_HOME/OPatch
[oracle@localhost OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Thu Oct 31 22:13:00 2013
Copyright (c) 2013, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
Currently installed C Patches: 17027533
Nothing to roll back
The following patches will be applied: 17027533
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17027533 apply: SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_MYDB_mydb_2013Oct31_22_13_14.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_MYDB_mydb_GENERATE_2013Oct31_22_13_35.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_MYDB_mydb_APPLY_2013Oct31_22_13_43.log (no errors)
SQL Patching tool complete on Thu Oct 31 22:13:58 2013
[oracle@localhost OPatch]$
[oracle@localhost OPatch]$
[oracle@localhost OPatch]$ dba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Oct 31 22:14:21 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from cdb_registry_sqlpatch order by CON_ID;
PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION LOGFILE CON_ID
---------- --------------- --------------- ------------------------------ -------------------- -------------------------------------------------- ----------
17027533 APPLY SUCCESS 31-OCT-13 10.13.58.625963 PM bundle:PSU /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/1 0
7027533/17027533_apply_MYDB_mydb_2013Oct31_22_13_1
4.log
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production
SQL>
Comments
Post a Comment