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
완료
'ORACLE > ADMIN' 카테고리의 다른 글
oracle 리두로그(redo log) 관리(member,group 추가 삭제 변경) (0) | 2023.09.21 |
---|---|
ORACLE datafile 이동 방법 2 가지 (0) | 2023.09.21 |
oracle COMBO OF OJVM RU COMPONENT 12.2.0.1.220118 + 12.2.0.1.220118DBJAN2022RU (패치) (0) | 2023.09.20 |
오라클 manual 11G GIPSU 절차 (0) | 2023.09.15 |
오라클 ASM diskgroup 생성 및 disk 추가 방법 (0) | 2023.06.09 |