About DATABASE

GI PSU 작업

[root@pradg1 ~]# export LANG=C
[root@pradg1 ~]# opatch auto /patch/31718723/
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /patch -patchn 31718723 -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_13-03-03.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_13-03-03.report.log

2023-09-20 13:03:03: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
                                                                                                     
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /patch/31718723/29938455/custom/server/29938455  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch /patch/31718723/31537677  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 

Stopping CRS...
Stopped CRS successfully

patch /patch/31718723/29938455  apply successful for home  /u01/app/11.2.0/grid 
patch /patch/31718723/31537677  apply successful for home  /u01/app/11.2.0/grid 
patch /patch/31718723/29509309  apply successful for home  /u01/app/11.2.0/grid 

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

================================================================================================================================================================================================
[grid@+ASM1 ~]$ tail -f /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2023-09-20_13-03-03.report.log
***********  Configuration Data  ***********
* It shows only those targets that will be patched in this session *


crs_home=/u01/app/11.2.0/grid      owner=grid      opatch_ver=11.2.0.3.33
rac_home=/u01/app/oracle/product/11.2.0/db_1      owner=oracle      opatch_ver=11.2.0.3.33

*********** Steps to be executed as owner unless specified as root ***********


1: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29938455/custom/server/29938455 -oh /u01/app/oracle/product/11.2.0/db_1

2: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckComponents -ph /patch/31718723/31537677 -oh /u01/app/oracle/product/11.2.0/db_1

3: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /patch/31718723/29938455/custom/server/29938455 -oh /u01/app/oracle/product/11.2.0/db_1

4: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOH -ph /patch/31718723/31537677 -oh /u01/app/oracle/product/11.2.0/db_1

5: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29938455 -oh /u01/app/11.2.0/grid

6: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/31537677 -oh /u01/app/11.2.0/grid

7: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckComponents -ph /patch/31718723/29509309 -oh /u01/app/11.2.0/grid

8: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /patch/31718723/29938455 -oh /u01/app/11.2.0/grid

9: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /patch/31718723/31537677 -oh /u01/app/11.2.0/grid

10: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOH -ph /patch/31718723/29509309 -oh /u01/app/11.2.0/grid

11: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop dbconsole

12: /u01/app/oracle/product/11.2.0/db_1/bin/emctl stop agent

13: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29938455/custom/server/29938455 -oh /u01/app/oracle/product/11.2.0/db_1

14: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/31537677 -oh /u01/app/oracle/product/11.2.0/db_1

15: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n pradg1 -f

16: /patch/31718723/29938455/custom/server/29938455/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1

17: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply /patch/31718723/29938455/custom/server/29938455 -local -silent -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

18: /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply /patch/31718723/31537677 -local -silent -oh /u01/app/oracle/product/11.2.0/db_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

19: /patch/31718723/29938455/custom/server/29938455/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1

20: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock : run as root

21: /u01/app/11.2.0/grid/tfa/bin/tfactl stop : run as root

22: /sbin/fuser -k /u01/app/11.2.0/grid/bin/crsctl.bin : run as root

23: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29938455 -oh /u01/app/11.2.0/grid

24: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/31537677 -oh /u01/app/11.2.0/grid

25: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /patch/31718723/29509309 -oh /u01/app/11.2.0/grid

26: /u01/app/11.2.0/grid/OPatch/opatch napply /patch/31718723/29938455 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

27: /u01/app/11.2.0/grid/OPatch/opatch napply /patch/31718723/31537677 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

28: /u01/app/11.2.0/grid/OPatch/opatch napply /patch/31718723/29509309 -local -silent -oh /u01/app/11.2.0/grid -invPtrLoc /u01/app/11.2.0/grid/oraInst.loc

29: /u01/app/11.2.0/grid/bin/emctl start dbconsole

30: /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh : run as root

31: /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch : run as root

32: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole

33: /u01/app/oracle/product/11.2.0/db_1/bin/emctl start agent

34: /u01/app/oracle/product/11.2.0/db_1/bin/srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s /u01/app/oracle/product/11.2.0/db_1/srvm/admin/stophome.txt -n pradg1

패치 후 추가 작업

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 as follows:

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.

For information about the catbundle.sql script, see My Oracle Support Document 605795.1 Introduction to Oracle Database catbundle.sql.

If the OJVM PSU was applied for a previous GI PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

완료