Today, I got email about 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
Anyway, I wanted to patch for Database only. So, I downloaded "Patch 17027533: DATABASE PATCH SET UPDATE 12.1.0.1.1" and tested for patching.
Note: 17272829 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.1.1 (INCLUDES DB PSU 12.1.0.1.1)If Users use Oracle GI 12c and Database 12c, User can use PSU 17272829 to patch GI and DB.
After downloaded, It was time for test on my Database.
- Check Opatch version and some command-lines.
[oracle@test12c ~]$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch version- Uncompress PSU file, Check conflict with the PSU.
OPatch Version: 12.1.0.1.0
OPatch succeeded.
[oracle@test12c ~]$ type make
make is /usr/bin/make
[oracle@test12c ~]$ type ar
ar is /usr/bin/ar
[oracle@test12c ~]$ type ld
ld is /usr/bin/ld
[oracle@test12c ~]$ type nm
nm is /usr/bin/nm
[oracle@test12c ~]$
[oracle@test12c ~]$ unzip p17027533_121010_Linux-x86-64.zipNo Conflict with the PSU.
[oracle@test12c ~]$ cd 17027533
[oracle@test12c 17027533]$ export PATH=$PATH:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch
[oracle@test12c 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-16_09-22-53AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@test12c 17027533]$ cat /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-22-53AM_1.log
[Oct 16, 2013 9:22:54 AM] PREREQ session
[Oct 16, 2013 9:22:54 AM] OPatch invoked as follows: 'prereq CheckConflictAgainstOHWithDetail -ph ./ -invPtrLoc /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc '
[Oct 16, 2013 9:22:54 AM] OUI-67077:
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
OUI location : /u01/app/oracle/product/12.1.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-22-53AM_1.log
[Oct 16, 2013 9:22:54 AM] Patch history file: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Oct 16, 2013 9:22:54 AM] Invoking prereq "checkconflictagainstohwithdetail"
[Oct 16, 2013 9:22:56 AM] Patch 17027533 is not subset of any other patch processed till now
[Oct 16, 2013 9:22:56 AM] Patch ID 17027533
[Oct 16, 2013 9:22:56 AM] Patches that conflict: [ ]
[Oct 16, 2013 9:22:56 AM] Checking conflicts for patch: 17027533
[Oct 16, 2013 9:22:56 AM] Checking conflicts/supersets for patch: 17027533 with patch:17027533
[Oct 16, 2013 9:22:56 AM] Prereq "checkConflictAgainstOHWithDetail" passed.
[Oct 16, 2013 9:22:56 AM] Finishing PrereqSession at Wed Oct 16 09:22:56 ICT 2013
[oracle@test12c 17027533]$
- Shutdown Database and Stop Listener. (I tested with Multitenant Database)
[oracle@test12c 17027533]$ sqlplus / as sysdba- Patch Database software and Check.
SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 16 09:24:00 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 name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
APEX READ WRITE
TESTPDB READ WRITE
OPUNPDB READ WRITE
SQL> shutdown 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@test12c 17027533]$ lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 16-OCT-2013 09:26:08
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test12c)(PORT=1521)))
The command completed successfully
[oracle@test12c 17027533]$ pwd- Load Modified SQL Files into the Database and Check.
/home/oracle/17027533
[oracle@test12c 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_16_2013_09_27_59/apply2013-10-16_09-27-59AM_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_16_2013_09_27_59/apply2013-10-16_09-27-59AM_1.log
OPatch succeeded.
[oracle@test12c 17027533]$ less /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_16_2013_09_27_59/apply2013-10-16_09-27-59AM_1.log
[oracle@test12c 17027533]$
[oracle@test12c 17027533]$
[oracle@test12c 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-16_09-32-36AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-16_09-32-36AM.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 Wed Oct 16 09:29:44 ICT 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@test12c 17027533]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 16 09:34:07 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1636814848 bytes
Fixed Size 2288968 bytes
Variable Size 973079224 bytes
Database Buffers 654311424 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> SQL>
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@test12c 17027533]$ cd $ORACLE_HOME/OPatch
[oracle@test12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Wed Oct 16 09:36:28 2013
Copyright (c) 2013, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
PDB CDB$ROOT:
PDB PDB$SEED:
PDB APEX:
PDB TESTPDB:
PDB OPUNPDB:
Currently installed C Patches: 17027533
For the following PDBs: CDB$ROOT
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: PDB$SEED
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: APEX
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: TESTPDB
Nothing to roll back
The following patches will be applied: 17027533
For the following PDBs: OPUNPDB
Nothing to roll back
The following patches will be applied: 17027533
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17027533 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_CDBROOT_2013Oct16_09_36_40.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_PDBSEED_2013Oct16_09_37_17.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb APEX): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_APEX_2013Oct16_09_38_35.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb TESTPDB): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_TESTPDB_2013Oct16_09_39_22.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb OPUNPDB): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_OPUNPDB_2013Oct16_09_40_12.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
SQL Patching tool complete on Wed Oct 16 09:41:10 2013
[oracle@test12c OPatch]$
SQL> select * from cdb_registry_sqlpatch order by CON_ID;
PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION
---------- --------------- --------------- --------------------------------------------------------------------------- ---------------
LOGFILE CON_ID
------------------------------------------------------------------------------------------------------------------------ ----------
17027533 APPLY SUCCESS 16-OCT-13 09.41.00.582789 AM bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_CDBROOT_2013Oct16_09_36_40.log 1
17027533 APPLY SUCCESS 16-OCT-13 09.41.06.930702 AM bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_PDBSEED_2013Oct16_09_37_17.log 2
17027533 APPLY SUCCESS 16-OCT-13 09.41.09.974677 AM bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_APEX_2013Oct16_09_38_35.log 3
17027533 APPLY SUCCESS 16-OCT-13 09.41.10.276728 AM bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_TESTPDB_2013Oct16_09_39_22.log 4
17027533 APPLY SUCCESS 16-OCT-13 09.41.10.362787 AM bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_OPUNPDB_2013Oct16_09_40_12.log 5
There was all right for patching on my Database. For Users, they might have to "Upgrade Oracle Recovery Manager Catalog".
BTW, Good Luck - "Patch 17027533 - 12.1.0.1.1 Patch Set Update".
Posts
1 comment:
Thank you for sharing this information.
Post a Comment