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.
2. Exract patch files from p17552800_121010_Linux-x86-64.zip file.
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.
4. Apply patch to Oracle Database 12c (12.1.0.1.0)
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
The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.
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
Regards
Mahir M. Quluzade
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
Comments
Post a Comment