Monday, December 2, 2013

Oracle database 12c–Installing PSU in multitenant envrionment

1. Preparation work

[oracle@gc12c db]$ unzip p17027533_121010_Linux-x86-64.zip
[oracle@gc12c db]$ cd 17027533
[oracle@gc12c 17027533]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.1.0.1.0

OPatch succeeded.

[oracle@gc12c 17027533]$ $ORACLE_HOME/OPatch/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-12-02_18-05-50PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.




2. Shutdown database listener



[oracle@gc12c 17027533]$ lsnrctl stop
[oracle@gc12c 17027533]$ sqlplus / as sysdba <<EOD
> shutdown immediate
> EOD


[oracle@gc12c 17027533]$ ps -fu oracle


3. Apply binary patch



[oracle@gc12c 17027533]$ $ORACLE_HOME/OPatch/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_Dec_02_2013_18_25_52/apply2013-12-02_18-25-52PM_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_Dec_02_2013_18_25_52/apply2013-12-02_18-25-52PM_1.log

OPatch succeeded.
[oracle@gc12c 17027533]$


[oracle@gc12c 17027533]$ $ORACLE_HOME/OPatch/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-12-02_18-33-02PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-12-02_18-33-02PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch 17027533 : applied on Mon Dec 02 18:28:17 SGT 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



--------------------------------------------------------------------------------

OPatch succeeded.



4. Startup database and listener



[oracle@gc12c 17027533]$ lsnrctl start

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 02-DEC-2013 18:37:07

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/gc12c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gc12c)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gc12c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 02-DEC-2013 18:37:07
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/gc12c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gc12c)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@gc12c 17027533]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Dec 2 18:37:17 2013

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1636814848 bytes
Fixed Size 2288968 bytes
Variable Size 1056965304 bytes
Database Buffers 570425344 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;

Pluggable database altered.

SQL> exit



5. Post-patch: loading modified SQL Files into the database



[oracle@gc12c 17027533]$ cd $ORACLE_HOME/OPatch
[oracle@gc12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Mon Dec 2 19:59:16 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 DEMO:
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: DEMO
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_CDBORCL_CDBROOT_2013Dec02_19_59_22.log (no errors)
catbundle generate logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_GENERATE_2013Dec02_19_59_50.log (no errors)
catbundle apply logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_APPLY_2013Dec02_19_59_52.log (no errors)
Patch 17027533 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_CDBORCL_PDBSEED_2013Dec02_19_59_35.log (no errors)
catbundle generate logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_GENERATE_2013Dec02_19_59_50.log (no errors)
catbundle apply logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_APPLY_2013Dec02_19_59_52.log (no errors)
Patch 17027533 apply (pdb DEMO): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_CDBORCL_DEMO_2013Dec02_19_59_45.log (no errors)
catbundle generate logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_GENERATE_2013Dec02_19_59_50.log (no errors)
catbundle apply logfile: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_CDBORCL_DEMO_APPLY_2013Dec02_19_59_52.log (no errors)
SQL Patching tool complete on Mon Dec 2 20:00:02 2013