Thursday, 4 June 2015

Oracle Critical Patch Update On 12.1.0.1

April 2015 Oracle Critical Patch Update On 12.1.0.1

1st Check the conflict against OH and among patches and check for applicable with point 1,2,3. 
1)opatch prereq CheckConflictAgainstOHWithDetail -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101
2)opatch prereq CheckConflictAmongPatches -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101
3)opatch prereq CheckApplicable -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101

Apply the patch on RDBMS home.

opatch napply -local -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -id 20558101 -phBaseDir c:\20558101
=========================================================
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\app\sqladmin\product\121~1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : C:\app\sqladmin\product\121~1.0\dbhome_1\cfgtoollogs\opatch\
opatch2015-06-04_14-45-02PM_1.log

Lsinventory Output file location : C:\app\sqladmin\product\121~1.0\dbhome_1\cfgt
oollogs\opatch\lsinv\lsinventory2015-06-04_14-45-02PM.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.

C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>
=====================================================
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>opatch prereq CheckConflictAgainstOHWithDetail -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : C:\app\sqladmin\product\12.1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : C:\app\sqladmin\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-06-04_14-48-39PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
=============================================
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>opatch prereq CheckConflictAmongPatches -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : C:\app\sqladmin\product\12.1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : C:\app\sqladmin\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-06-04_14-48-55PM_1.log

Invoking prereq "checkconflictamongpatches"

Prereq "checkConflictAmongPatches" passed.

OPatch succeeded.

C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>opatch prereq CheckApplicable -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -phBaseDir c:\20558101

Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : C:\app\sqladmin\product\12.1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : C:\app\sqladmin\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-06-04_14-49-07PM_1.log

Invoking prereq "checkapplicable"
Patch 20558101: Optional component(s) missing : [ oracle.rdbms.ic, 12.1.0.1.0 ]
, [ oracle.has.cfs, 12.1.0.1.0 ] , [ oracle.has.crs, 12.1.0.1.0 ] , [ oracle.has
.cvu, 12.1.0.1.0 ] , [ oracle.usm, 12.1.0.1.0 ]

Prereq "checkApplicable" for patch 20558101 passed.

OPatch succeeded.

C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>opatch napply -local -oh C:\app\sqladmin\product\12.1.0\dbhome_1 -id 20558101 -phBaseDir c:\20558101

Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : C:\app\sqladmin\product\12.1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : C:\app\sqladmin\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-06-04_15-35-51PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   20558101

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'C:\app\sqladmin\product\12.1.0\dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '20558101' to OH 'C:\app\sqladmin\product\12.1.0\dbhome_1'
ApplySession: Optional component(s) [ oracle.rdbms.ic, 12.1.0.1.0 ] , [ oracle.h
as.cfs, 12.1.0.1.0 ] , [ oracle.has.crs, 12.1.0.1.0 ] , [ oracle.has.cvu, 12.1.0
.1.0 ] , [ oracle.usm, 12.1.0.1.0 ]  not present in the Oracle Home or a higher
version is found.

Patching component oracle.rdbms, 12.1.0.1.0...

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

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

Patching component oracle.ordim.client, 12.1.0.1.0...

Patching component oracle.ordim.server, 12.1.0.1.0...

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

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

Patching component oracle.xdk.rsf, 12.1.0.1.0...

Patching component oracle.xdk, 12.1.0.1.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.1.0...

Patching component oracle.sdo.locator.jrf, 12.1.0.1.0...

Patching component oracle.sdo.locator, 12.1.0.1.0...

Patching component oracle.odbc.ic, 12.1.0.1.0...

Patching component oracle.precomp.common, 12.1.0.1.0...

Patching component oracle.rdbms.plsql, 12.1.0.1.0...

Patching component oracle.network.client, 12.1.0.1.0...

Patching component oracle.oraolap, 12.1.0.1.0...

Patching component oracle.rdbms.install.common, 12.1.0.1.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.1.0...

Patching component oracle.swd.oui.core.min, 12.1.0.1.0...

Patching component oracle.precomp.common.core, 12.1.0.1.0...

Patching component oracle.precomp.lang, 12.1.0.1.0...

Patching component oracle.precomp.rsf, 12.1.0.1.0...

Patching component oracle.ctx, 12.1.0.1.0...

Patching component oracle.xdk.parser.java, 12.1.0.1.0...

Patching component oracle.ordim.jai, 12.1.0.1.0...

Patching component oracle.ovm, 12.1.0.1.0...

Patching component oracle.ntoledb.odp_net_2, 12.1.0.1.0...

Patching component oracle.clrintg.ode_net_2, 12.1.0.1.0...

Patching component oracle.aspnet_2, 12.1.0.1.0...

Patching component oracle.has.common, 12.1.0.1.0...

Patching component oracle.has.common.cvu, 12.1.0.1.0...

Patching component oracle.has.db, 12.1.0.1.0...

Patching component oracle.has.deconfig, 12.1.0.1.0...

Patching component oracle.has.rsf, 12.1.0.1.0...

Verifying the update...
Patch 20558101 successfully applied.
Log file location: C:\app\sqladmin\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-06-04_15-35-51PM_1.log

OPatch succeeded.

C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>
====================================================
Go with readme for Patch Post-Installation Instructions below steps is for non-CDB/PDB.

  1. Start the OracleService<SID> and Oracle Listener Services if already not started. Ensure that all database instances running out of the ORACLE_HOME that you just patched are started.
  2. Go with below step
With Oracle 11g the latest patch is applied within the database using:
SQL> @catbundle.sql psu apply

Oracle 12c introduces a new utility called “datapatch” which replaces the need to run the 11g command shown above.
As with Oracle 11g you first install the patch into the Oracle Home with all services & databases down. But with Oracle Database 12c after restarting the database simply run datapatch from the OPatch directory:

cd $ORACLE_HOME/OPatch
./datapatch -verbose

C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Thu Jun  4 15:47:51 2015
Copyright (c) 2014, Oracle.  All rights reserved.

Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
Currently installed C Patches: 20558101
Adding patches to installation queue and performing prereq checks...
Installation queue:
  Nothing to roll back
  The following patches will be applied: 20558101
Installing patches...
Patch installation complete.  Total patches installed: 1
Validating logfiles...
Patch 20558101 apply: SUCCESS
  logfile: C:\app\sqladmin\product\12.1.0\dbhome_1\sqlpatch\20558101/20315702_apply_ORCL_orcl_2015Jun04_15_58_30.log (no errors)
  catbundle generate logfile: C:\app\sqladmin\cfgtoollogs\catbundle\catbundle_PSU_ORCL_orcl_GENERATE_2015Jun04_15_58_36.log (no errors)
  catbundle apply logfile: C:\app\sqladmin\cfgtoollogs\catbundle\catbundle_PSU_ORCL_orcl_APPLY_2015Jun04_15_58_42.log (no errors)
SQL Patching tool complete on Thu Jun  4 16:07:30 2015
C:\app\sqladmin\product\12.1.0\dbhome_1\OPatch>

Please take the backup for db and home before execution of Patching activity.

Posted by at No comments:
Subscribe to: Comments (Atom)