Wednesday, September 17, 2014

Applying PSU 11.2.0.3.11 to RDBMS home

Applying PSU 11.2.0.3.11 to RDBMS home


Environment:

Single instance running on Red Hat Enterprise Linux Server release 5.8 (Tikanga)
Oracle rdbms 11.2.0.3

I will be using ‘11.2.0.3.11 (Jul 2014) Grid Infrastructure Patch Set Update (GI PSU) - Patch: 18706488’ to patch a Single Instance Database Server/home.

PSU - What/ When ??

Patch Set Updates (PSUs) are proactive cumulative patches containing recommended bug fixes that are released every quarter on the Tuesday closest to the 17th of January, April, July, and October.

Identifying the right PSU for your environment

-- I will be patching 11.2.0.3 patch set binaries.

-- Find the current recommended PSU for your version of software ?

Use support note, Oracle Recommended Patches -- Oracle Database [ID 756671.1]

As of Sep 2014, the recommended patch for 11.2.0.3 is patch 11.2.0.3.11 (Jul 2014)

Database
Document
Description
Rolling RAC
Patch Download
11.2.0.3.11 (Jul 2014) Database Patch Set Update (PSU)
Yes


Grid Infrastructure
Document
Description
Rolling RAC
Patch Download
11.2.0.3.11 (Jul 2014) Grid Infrastructure Patch Set Update (GI PSU)
Yes

We can use any of the above downloads to patch an 11.2.0.3 RDBMS/DB single instance home.  Grid Infrastructure PSU includes DB PSU as well.


Patch Installation Prerequisites

To take a backup of the binaries, do the following tar of the binaries home.  Oracle also automatically takes a backup during opatch apply and stores it in “.patch_storage” under the $ORACLE_HOME where you apply the patch. This will be used during rollback, if the apply fails

As Oracle software owner

. oraenv
DB11203

env |grep -i oracle_

cd $ORACLE_HOME

tar -cvpf /patch_stage_dir/patchset/july2014/oh_bkp/oh_bkp.tar ./


where
c - compress
v - verbose
p - preserve permissions
f - tar file
/patch_stage_dir/patchset/july2014/oh_bkp/oh_bkp.tar is the backup tar file


Note: Always use the readme.html from the patch source. It contains complete details required for applying the patch successfully.

Latest OPatch
               
OPatch is the utility used to apply the patch. Download the latest OPatch utility from My Oracle Support patch 6880880.


Check the current OPatch version

> . oraenv
ORACLE_SID = [oracle] ? DB11203

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH


> which opatch
/u01/app/oracle/product/11.2.0.3/OPatch/opatch


> opatch version
OPatch Version: 11.2.0.3.5

OPatch succeeded.


As software home owner, unzip the downloaded OPatch to the $ORACLE_HOME

cd /patch_stage_dir/patchset/july2014/opatch        (Location where my downloaded patch is staged)

unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME


Check the new OPatch version

> opatch version
OPatch Version: 11.2.0.3.6

OPatch succeeded.


Validation of Oracle Inventory

Before patch application, let check the consistency of the oracle inventory. If the below command succeeds, we are good.

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME


Download and Unzip the Patch

This directory must be empty and not be /tmp

cd /patch_stage_dir/patchset/july2014/18706488    (Location where my downloaded patch is staged)

> unzip p18706488_112030_Linux-x86-64.zip

> ls -ltr
total 595076
-rw-r--r--  1 oracle dba        21 Jan  9  2014 README.txt
-rw-r--r--  1 oracle dba         0 Jan  9  2014 atp_lfp
drwxr-xr-x  5 oracle dba      4096 Jan  9  2014 17592127
-rw-r--r--  1 oracle dba       450 May 29 08:26 bundle.xml
drwxrwxr-x 13 oracle dba      4096 Jun 11 12:51 18522512              à DB PSU
-rw-rw-r--  1 oracle dba     59977 Jul 14 17:10 README.html
-rw-rw-r--  1 oracle dba      2367 Jul 15 12:02 PatchSearch.xml
-rw-r--r--  1 oracle dba 606878754 Sep 15 20:02 p18706488_112030_Linux-x86-64.zip


Note: Use below support note to find the correct DB PSU for your version.

Readme - Patch Installation and Deinstallation For 11.2.0.3.x GI PSU (Doc ID 1494646.1)
In this example, the <GI_PSU_number> is 18706488; the <GI_Components_number> is 17592127; and the <DB_PSU_number> is 18522512.


One-off Patch Conflict Detection and Resolution

Check for conflicting patches by doing the following for the RDBMS home you are planning to patch.

Use My Oracle Support Note 1061295.1 Patch Set Updates - One-off Patch Conflict Resolution to determine, for each conflicting patch, whether a conflict resolution patch is already available, and if you need to request a new conflict resolution patch or if the conflict may be ignored.

> opatch prereq CheckConflictAgainstOHWithDetail -oh $ORACLE_HOME -phBaseDir /patch_stage_dir/patchset/july2014/18706488/18522512
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0.3
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-30-19PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


Patch Installation

Note:

-- Stop EM agent if it is running on your server before you apply the patch. Our grid control agent is 12.2

> emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.


-- Make sure there is enough free space available in your RDBMS home volume
-- If the available free space is less, try to use ‘opatch util cleanup’ to clean old backup files from previous patching. It is usually a hidden directory in ORACLE_HOME called .patch_storage


Apply OPatch auto as Oracle user on 11.2.0.3 rdbms home

Shutdown all database and listener services running from the Oracle home that we are patching.


> cd /patch_stage_dir/patchset/july2014/18706488/18522512

> ls -ltr
total 48
drwxrwxr-x 5 oracle dba 4096 Jun 11 12:50 17540582
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 13696216
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 16619892
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 14275605
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 18522512
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 16902043
drwxrwxr-x 5 oracle dba 4096 Jun 11 12:50 14727310
drwxr-xr-x 4 oracle dba 4096 Jun 11 12:50 13343438
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 13923374
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 18031683
drwxrwxr-x 4 oracle dba 4096 Jun 11 12:50 16056266
-rw-r--r-- 1 oracle dba   21 Jun 11 12:50 README.txt
-rw-r--r-- 1 oracle dba   29 Jun 11 12:50 README.html
-rw-r--r-- 1 oracle dba 2872 Jun 11 12:51 patchmd.xml


> opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-32-22PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-32-22PM_1.log

OPatch failed with error code 73


logs at /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-32-22PM_1.log

[Sep 16, 2014 9:33:16 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/oracle at Tue Sep 16 21:33:16 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/oracle at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/renamedg at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/renamedg at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1 at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:17 PM]    Following executables are active :
                             /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
[Sep 16, 2014 9:33:17 PM]    Prerequisite check "CheckActiveFilesAndExecutables" failed.
                             The details are:


                             Following executables are active :
                             /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
[Sep 16, 2014 9:33:17 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/proc at Tue Sep 16 21:33:17 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/proc at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/rman at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/rman at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/wrap at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/wrap at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/plshprof at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/plshprof at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:18 PM]    Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/nid at Tue Sep 16 21:33:18 GMT-00:00 2014
[Sep 16, 2014 9:33:19 PM]    Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0.3/bin/nid at Tue Sep 16 21:33:19 GMT-00:00 2014
[Sep 16, 2014 9:33:19 PM]    OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Sep 16, 2014 9:33:19 PM]    Finishing UtilSession at Tue Sep 16 21:33:19 GMT-00:00 2014
[Sep 16, 2014 9:33:19 PM]    Log file location: /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-32-22PM_1.log
[Sep 16, 2014 9:33:19 PM]    Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1614)
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[Sep 16, 2014 9:33:19 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Sep 16, 2014 9:33:19 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Sep 16, 2014 9:33:19 PM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[Sep 16, 2014 9:33:19 PM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2343)
[Sep 16, 2014 9:33:19 PM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:614)


Some process is active on file /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1

Find the process


> /sbin/fuser /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1:  5848m

> ps -ef|grep -i 5848
oracle    5848  5738  0 Jul23 pts/4    00:00:00 sqlplus
oracle   22898 18209  0 21:37 pts/1    00:00:00 grep -i 5848

It is some sqlplus session.

> kill -9 5848

> /sbin/fuser /u01/app/oracle/product/11.2.0.3/lib/libclntsh.so.11.1
> 


Looks ok now. Proceeding to patch again

>  opatch apply
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-38-48PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   16902043  17540582  18031683  18522512

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: xxxxxx

..
..
..

Password (optional):                     
                                                                                          
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.                                                                                         
(Oracle Home = '/u01/app/oracle/product/11.2.0.3')                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
Is the local system ready for patching? [y|n]                                                                                                                                 
y                                                                                                                                                                              
User Responded with: Y                                                                                                                                                         
Backing up files...                                                                                                                                                           
Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0.3'                                                                                                        
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.                                                                                                                                                                                  
Patching component oracle.ldap.rsf, 11.2.0.3.0...                                                                                                                         
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...                                                                                                                      
Patching component oracle.owb.rsf, 11.2.0.3.0...                                                                                                                                                                                                        
Patching component oracle.rdbms, 11.2.0.3.0...                                                                                                                            
Patching component oracle.rdbms.rsf, 11.2.0.3.0...                                                                                                                                                                                                                                
Patching component oracle.sysman.console.db, 11.2.0.3.0...                                                                                                                                                                                                                                                                                                    
Verifying the update...                                                                                                                                                        
Applying sub-patch '17540582' to OH '/u01/app/oracle/product/11.2.0.3'                                                                                                        
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.                                                                                                                                                                                                                         
Patching component oracle.rdbms, 11.2.0.3.0...                                                                                                                                                                                                                     
Patching component oracle.rdbms.rsf, 11.2.0.3.0...                                                                                                                                                                                                                 
Patching component oracle.sdo, 11.2.0.3.0...                                                                                                                                                                                                
Patching component oracle.ldap.rsf, 11.2.0.3.0...                                                                                                                                                                                                                  
Patching component oracle.precomp.common, 11.2.0.3.0...                                                                                                                                                                                                                                                                                                       
Patching component oracle.ordim.client, 11.2.0.3.0...                                                                                                                                                                                                                                                                                                        
Patching component oracle.rdbms.util, 11.2.0.3.0...                                                                                                                                                                                                                                                                                                           
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...                                                                                                                                                                                                                                                                                                      
Patching component oracle.sdo.locator, 11.2.0.3.0...                                                                                                                          
Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.ordim.jai, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '18031683' to OH '/u01/app/oracle/product/11.2.0.3'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.ldap.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '18522512' to OH '/u01/app/oracle/product/11.2.0.3'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'                                                    
/u01/app/oracle/product/11.2.0.3/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'


Composite patch 18522512 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3/cfgtoollogs/opatch/opatch2014-09-16_21-38-48PM_1.log

OPatch completed with warnings.



Refer note Opatch warning: overriding commands for target xxxx (Doc ID 1448337.1)

If you check the $OH/install/make.log you will see that these warnings existed before patching i.e. after the original installation.  This is not an issue which the patch you are applying has introduced, simply a warning which opatch has correctly captured and is reporting back to the user.

> cat /u01/app/oracle/product/11.2.0.3/install/make.log |grep -i pcscfg.cfg
/usr/bin/make -f ins_precomp.mk links proc gen_pcscfg ORACLE_HOME=/u01/app/oracle/product/11.2.0.3//u01/app/oracle/product/11.2.0.3/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

So, it is ignorable


Check Applied Patch

> $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'DATABASE P'
18522512   18522512  Tue Sep 16 21:46:52 GMT-00:00 2014DATABASE PATCH SET UPDATE 11.2.0.3.11 (INCLUDES CP
18031683   18031683  Tue Sep 16 21:46:23 GMT-00:00 2014DATABASE PATCH SET UPDATE 11.2.0.3.10 (INCLUDES CP
17540582   17540582  Tue Sep 16 21:45:40 GMT-00:00 2014DATABASE PATCH SET UPDATE 11.2.0.3.9 (INCLUDES CPU
16902043   16902043  Tue Sep 16 21:44:27 GMT-00:00 2014DATABASE PATCH SET UPDATE 11.2.0.3.8 (INCLUDES CPU
16619892   16619892  Fri Oct 25 00:44:33 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.7 (INCLUDES CPU
16056266   16056266  Fri Oct 25 00:43:44 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.6 (INCLUDES CPU
14727310   14727310  Fri Oct 25 00:43:21 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.5 (INCLUDES CPU
14275605   14275605  Fri Oct 25 00:42:25 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPU
13923374   13923374  Fri Oct 25 00:42:09 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES
13696216   13696216  Fri Oct 25 00:41:32 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES
13343438   13343438  Fri Oct 25 00:40:14 GMT-00:00 2013DATABASE PATCH SET UPDATE 11.2.0.3.1


Patch Post Installation Steps


Start databases, listeners and Enterprise Manager Agent.

For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

Check the log files in $ORACLE_HOME/cfgtoollogs/catbundle for any errors


Upgrade Oracle Recovery Manager Catalog

If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it:

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;




No comments:

Post a Comment