2014/02/13

Installation and configuration Patch 17552800 - 12.1.0.1.2 Patch Set Update

Hi,

Patch 17552800 - 12.1.0.1.2 Database Patch Set Update released: January 14, 2014. You can download this PSU  from Oracle My Support. I will show short steps installation and configuration this PSU.

Note: To install the PSU 12.1.0.1.2 patch, the Oracle home must have the 12.1.0.1.0 Database installed. Subsequent PSU patches can be installed on Oracle Database 12.1.0.1.0 or any PSU with a lower 5th numeral version than the one being installed.

1. Download this patch set zip file from support web site and copy to database server.

My Oracle Support

[oracle@oel62-ora12c PSU1]$ pwd
/tmp/oracle/PSU1
[oracle@oel62-ora12c PSU1]$ ls -l
total 67952
-rw-r--r-- 1 oracle oinstall 69580299 Feb 12 09:17 p17552800_121010_Linux-x86-64.zip
[oracle@oel62-ora12c PSU1]$ 

2. Exract patch files from p17552800_121010_Linux-x86-64.zip file.

[oracle@oel62-ora12c PSU1]$ unzip p17552800_121010_Linux-x86-64.zip
Archive:  p17552800_121010_Linux-x86-64.zip
   creating: 17552800/
  inflating: 17552800/README.html   
   creating: 17552800/files/
   creating: 17552800/files/lib/
..........
 inflating: 17552800/etc/config/actions.xml 
  inflating: PatchSearch.xml 

[oracle@oel62-ora12c PSU1]$ cd 17552800
[oracle@oel62-ora12c 17552800]$ ls -l
total 84
drwxr-xr-x 3 oracle oinstall  4096 Jan  3 15:21 etc
drwxr-xr-x 7 oracle oinstall  4096 Jan  3 15:21 files
-rw-rw-r-- 1 oracle oinstall 70222 Jan 14 13:32 README.html
-rw-r--r-- 1 oracle oinstall    21 Jan  3 15:21 README.txt

You  can read all  steps of installation and configuration of PSU from README.html carefully. Read this file carefully. It is very important.

3. Pre-Installation Patch need check environment and Patch-Conflict detection and resolution.

[oracle@oel62-ora12c 17552800]$ echo $PATH
/u01/app/oracle/product/12.1.0/dbhome/bin:/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
[oracle@oel62-ora12c 17552800]$ export PATH=$PATH:/usr/ccs/bin
[oracle@oel62-ora12c 17552800]$ echo $PATH
/u01/app/oracle/product/12.1.0/dbhome/bin:/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/usr/ccs/bin
[oracle@oel62-ora12c 17552800]$

[oracle@oel62-ora12c 17552800]$ /u01/app/oracle/product/12.1.0/dbhome/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
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome/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/cfgtoollogs/opatch/opatch2014-02-12_09-42-16AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@oel62-ora12c 17552800]$

4. Apply  patch to  Oracle Database 12c (12.1.0.1.0)

[oracle@oel62-ora12c 17552800]$ $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
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome/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/cfgtoollogs/opatch/17552800_Feb_12_2014_09_42_56/apply2014-02-12_09-42-56AM_1.log

Applying interim patch '17552800' to OH '/u01/app/oracle/product/12.1.0/dbhome'
Verifying environment and performing prerequisite checks...
Patch 17552800: Optional component(s) missing : [ oracle.network.cman, 12.1.0.1.0 ]
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')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...


Patching component oracle.network.rsf, 12.1.0.1.0...

Patching component oracle.rdbms, 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...

Patching component oracle.rdbms.util, 12.1.0.1.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...

Patching component oracle.rdbms.rman, 12.1.0.1.0...

Verifying the update...
Patch 17552800 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome/cfgtoollogs/opatch/17552800_Feb_12_2014_09_42_56/apply2014-02-12_09-42-56AM_1.log

OPatch succeeded.
[oracle@oel62-ora12c 17552800]$

Patch applied successfully.

5. Loading modified SQL Files into the Database

My database is Multitenant Container Database (prmcdb). If your dataabse is Multitenant Container Database, then all PDBs (pluggable databaseses) must be opened READ WRITE mode

[oracle@oel62-ora12c 17552800]$ export ORACLE_SID=prmcdb
[oracle@oel62-ora12c 17552800]$ sqlplus "/ as sysdba"

SQL*Plus: Release 12.1.0.1.0 Production on Wed Feb 12 09:46:21 2014

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
PRMPDB01         READ WRITE
PRMPDB02         READ WRITE

SQL> exit

The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.

[oracle@oel62-ora12c 17552800]$ cd $ORACLE_HOME/OPatch
[oracle@oel62-ora12c OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome/OPatch
[oracle@oel62-ora12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Wed Feb 12 09:47:36 2014
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 PRMPDB01: 
PDB PRMPDB02: 
Currently installed C Patches: 17552800
For the following PDBs: CDB$ROOT
Nothing to roll back
The following patches will be applied: 17552800
For the following PDBs: PDB$SEED
Nothing to roll back
The following patches will be applied: 17552800
For the following PDBs: PRMPDB01
Nothing to roll back
The following patches will be applied: 17552800
For the following PDBs: PRMPDB02
Nothing to roll back
The following patches will be applied: 17552800
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17552800 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/17552800/17552800_apply_PRMCDB_CDBROOT_2014Feb12_09_47_49.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_CDBROOT_GENERATE_2014Feb12_09_47_50.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_CDBROOT_APPLY_2014Feb12_09_47_53.log (no errors)
Patch 17552800 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/17552800/17552800_apply_PRMCDB_PDBSEED_2014Feb12_09_48_09.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PDBSEED_GENERATE_2014Feb12_09_48_11.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PDBSEED_APPLY_2014Feb12_09_48_14.log (no errors)
Patch 17552800 apply (pdb PRMPDB01): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/17552800/17552800_apply_PRMCDB_PRMPDB01_2014Feb12_09_48_22.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PRMPDB01_GENERATE_2014Feb12_09_48_24.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PRMPDB01_APPLY_2014Feb12_09_48_27.log (no errors)
Patch 17552800 apply (pdb PRMPDB02): SUCCESS
logfile: /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/17552800/17552800_apply_PRMCDB_PRMPDB02_2014Feb12_09_48_35.log (no errors)
catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PRMPDB02_GENERATE_2014Feb12_09_48_38.log (no errors)
catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PRMCDB_PRMPDB02_APPLY_2014Feb12_09_48_40.log (no errors)
SQL Patching tool complete on Wed Feb 12 09:49:06 2014
[oracle@oel62-ora12c OPatch]$ 

SQL Patching tool completed with no errors. You can check log files in $ORACLE_HOME/sqlpatch/17552800/ for errors.

Note: If you are using the Oracle Recovery Manager catalog, then catalog needs to be upgraded.

6. Check changes in database

SQL> select *  from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
24-MAY-13 01.20.05.485655000 PM APPLY SERVER 12.1.0.1 0 PSU Patchset 12.1.0.0.0
10-FEB-14 06.29.37.412212000 PM APPLY SERVER 12.1.0.1 0 PSU Patchset 12.1.0.0.0
12-FEB-14 09.48.05.383369000 AM APPLY SERVER 12.1.0.1 2 PSU PSU 12.1.0.1.2


SQL> select *  from dba_registry_sqlpatch;

PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION LOGFILE
17552800 APPLY SUCCESS 12-FEB-14 09.49.00.559171000 AM bundle:PSU /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/17552800/17552800_apply_PRMCDB_CDBROOT_2014Feb12_09_47_49.log


Regards
Mahir M. Quluzade