oracle 18c patch 절차

RAC 18.8.0.0 패치시 아래 절차로 진행 ( 다른 버전도 동일 )

 

1. 패치전 정보 저장 (oragrid, oracle)
opatch lsinventory -detail -oh $ORACLE_HOME > patch_prior_30116785.lst

 

2. 패치 가능 여부 (oragrid => cluster)
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30112122
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30113775
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30116128
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 28655963
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30093398

 

3. 패치 가능 여부 (oracle => database)
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30112122
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 30113775

 

4. 설치 공간 체크
opatch prereq CheckSystemSpace -phBaseFile /tmp/30116795_oragrid.txt 

 

5. conflit 체크 (root)
/ORACLE/grid/18.0.0/OPatch/opatchauto apply  /home/oragrid/pkg/30116795 -analyze

 

6. cluster, db 엔진 백업

cp ~~~

 

6. patch (root, node별 각각)

1) RAC
/ORACLE/grid/18.0.0/OPatch/opatchauto apply /home/oragrid/pkg/30116795
2) Single
cd /30116795/30112122
opatch apply

 

7. Post 작업
datapatch -verbose
select * from dba_registry_sqlpatch;

 

8. invalid object 조치 
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@utlrp.sql