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

Popular posts from this blog

AWR Reports

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

My Fav Song in Telugu: Aa challani samudra garbham