[ORACLE] 18c -> 19c RAC AutoUpgrade.jar 를 사용한 업그레이드

	대상 장비	DB_NAME	VERSION	STORAGE	ORACLE_HOME	GRID_HOME
SOURCE	racup1, racup2	racup	18.8.0.0.0	ASM	/u01/app/oracle/product/18c/db_1	/u01/app/19c/grid
TARGET	racup1, racup2	racup	19.16.0.0.0	ASM	/u01/app/oracle/product/19c/db_1	/u01/app/19c/grid

 

AutoUpgrade Utility : 업그레이드 프로세스를 자동화하도록 설계된 유틸리티

다운로드 : docs 2485457.1 // autoupgrade.jar

 

1. autoupgrade.jar file 준비 

다운받은 jar file을 server로 전송시켜둔 상태 

chown oracle:oinstall /media/autoupgrade.jar

# 기존 file 경로로 이동
cd $ORACLE_HOME/rdbms/admin

# 새 file로 교체
mv autoupgrade.jar autoupgrade.jar_old
cp /media/autoupgrade.jar .
ls -alrt | grep autoup 

-------------------------------------------------------------------------------------
[racup1|oracle:/u01/app/oracle/product/18c/db_1/rdbms/admin]> ls -alrt | grep autoup 
-rw-r--r--.  1 oracle oinstall    6189  2월  8  2018 autoupgrade.jar_old
-rw-r--r--.  1 oracle oinstall 6473720  4월 17 18:44 autoupgrade.jar

2. config file 생성 및 작성 

19c 환경으로 변경하여 진행해야 함.

# config file 생성
java -jar autoupgrade.jar -create_sample_file config


[racup1|oracle:/u01/app/oracle/product/19c/db_1/rdbms/admin]> java -jar autoupgrade.jar -create_sample_file config
샘플 구성 파일 /u01/app/oracle/product/19c/db_1/rdbms/admin/sample_config.cfg을(를) 생성했습니다.

vi sample_config.cfg

-------------------------------------------------------------------------------
#
# Global logging directory pertains to all jobs
#
global.autoupg_log_dir=/u01/app/oracle/cfgtoollogs/autoupgrade

#
# Database 1
#
upg1.source_home=/u01/app/oracle/product/18c/db_1	 # Path of the source ORACLE_HOME
upg1.target_home=/u01/app/oracle/product/19c/db_1 	 # Path of the target ORACLE_HOME
upg1.sid=RACUP1										 # ORACLE_SID of the source DB/CDB                                                 
upg1.log_dir=/u01/app/oracle/cfgtoollogs/autoupgrade # Path of the log directory for the upgrade job              
upg1.upgrade_node=racup1                  			 # Optional. To find out the name of your node, run the hostname utility. Default is ''localhost''
upg1.run_utlrp=yes  								 # Optional. Whether or not to run utlrp after upgrade (Invalid Object Recompile)
upg1.timezone_upg=yes								 # Optional. Whether or not to run the timezone upgrade (oracle version up에 의한 시간대 데이터 변경으로, 새로운 시간대 데이터로 맞춰주는 작업)
upg1.target_version=19								 # Oracle version of the target ORACLE_HOME. (target 버전 12.2 때만 반드시 명시하면 됨)

 

3.  분석

java -jar autoupgrade.jar -config sample_config.cfg -mode analyze

로그 확인 >> /u01/app/oracle/cfgtoollogs/autoupgrade/cfgtoollogs/upgrade/auto

 

==========================================
          Autoupgrade Summary Report
==========================================
[Date]           Wed Apr 19 12:38:07 KST 2023
[Number of Jobs] 1
==========================================
[Job ID] 105
==========================================
[DB Name]                RACUP
[Version Before Upgrade] 18.8.0.0.0
[Version After Upgrade]  19.16.0.0.0
------------------------------------------
[Stage Name]    PRECHECKS
[Status]        SUCCESS
[Start Time]    2023-04-19 12:37:32
[Duration]      0:00:30
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/105/prechecks
[Detail]        /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/105/prechecks/lgctms_preupgrade.log
                Check passed and no manual intervention needed
------------------------------------------

 

Report generated by AutoUpgrade 23.1.230224 (#a1e2990e) on 2023-04-19 12:38:04

Upgrade-To version: 19.0.0.0.0

=======================================
Status of the database prior to upgrade
=======================================
      Database Name:  RACUP1
     Container Name:  RACUP1
       Container ID:  0
            Version:  18.8.0.0.0
     DB Patch Level:  UNKNOWN
         Compatible:  18.0.0
          Blocksize:  8192
           Platform:  Linux x86 64-bit
      Timezone File:  31
  Database log mode:  ARCHIVELOG
           Readonly:  false
            Edition:  EE

  Oracle Component                       Upgrade Action    Current Status
  ----------------                       --------------    --------------
  OLAP Analytic Workspace                [to be upgraded]  VALID         
  Oracle Server                          [to be upgraded]  VALID         
  Oracle Java Packages                   [to be upgraded]  VALID         
  Oracle Text                            [to be upgraded]  VALID         
  JServer JAVA Virtual Machine           [to be upgraded]  VALID         
  Oracle Multimedia                      [to be upgraded]  VALID         
  Oracle Workspace Manager               [to be upgraded]  VALID         
  Real Application Clusters              [to be upgraded]  VALID         
  Oracle Spatial                         [to be upgraded]  VALID         
  Oracle XML Database                    [to be upgraded]  VALID         
  Oracle XDK for Java                    [to be upgraded]  VALID         
  Oracle OLAP API                        [to be upgraded]  VALID         

  *
  * ALL Components in This Database Registry:
  *
  Component   Current      Current      Original     Previous     Component   
  CID         Version      Status       Version      Version      Schema      
  ----------  -----------  -----------  -----------  -----------  ------------
  APS         18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  CATALOG     18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  CATJAVA     18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  CATPROC     18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  CONTEXT     18.8.0.0.0   VALID        18.8.0.0.0                CTXSYS      
  JAVAVM      18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  ORDIM       18.8.0.0.0   VALID        18.8.0.0.0                ORDSYS      
  OWM         18.8.0.0.0   VALID        18.8.0.0.0                WMSYS       
  RAC         18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  SDO         18.8.0.0.0   VALID        18.8.0.0.0                MDSYS       
  XDB         18.8.0.0.0   VALID        18.8.0.0.0                XDB         
  XML         18.8.0.0.0   VALID        18.8.0.0.0                SYS         
  XOQ         18.8.0.0.0   VALID        18.8.0.0.0                OLAPSYS     

==============
BEFORE UPGRADE ////////// UPGRADE 전 NOTICE 
==============

  REQUIRED ACTIONS
  ================
  None

>>>>>>>>>>>>>> 여기서 나오는 요청 액션을 전부 수행하면 precheck Success 한다.

 

  RECOMMENDED ACTIONS
  ===================

 

>>>>>>>>>>>>>> 여기 이하 내용은 추천사항임. 안해도 업데이트는 되나, 진행하는 것을 권고

 

  INFORMATION ONLY
  ================

 

>>>>>>>>>>>>>> 여기 이하 내용은 그냥 알려주는 내용

파라미터 파일에 매개변수가 바뀌거나, tablespace의 크기가 증가하는 등의 여러 notice 사항을 알려줌

 

=============
AFTER UPGRADE ////////// UPGRADE 후 NOTICE
=============

  REQUIRED ACTIONS
  ================
  None

  RECOMMENDED ACTIONS
  ===================

 

4. fixups

java -jar autoupgrade.jar -config sample_config.cfg -mode fixups

analyze와 동일한 log 결과

5. 업그레이드 수행

java -jar autoupgrade.jar -config sample_config.cfg -mode deploy

status 모니터링

status
status -job 111

Details

Job No           111
Oracle SID       RACUP1
Start Time       23/04/19 13:38:15
Elapsed (min):   0
End time:        N/A

작업 로그 위치
-----------------------------------
로그 기본 위치:    /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1
작업 로그:     /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111
단계 로그:   /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/prechecks
시간대:     /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/temp

Stages
SETUP            <1 min
GRP              <1 min
PREUPGRADE       <1 min
PRECHECKS        ~0 min (RUNNING)
PREFIXUPS       
DRAIN           
DBUPGRADE       
POSTCHECKS      
POSTFIXUPS      
POSTUPGRADE     
SYSUPDATES      

Stage-Progress Per Container

+--------+---------+
|Database|PRECHECKS|
+--------+---------+
| RACUP1|    0  % |
+--------+---------+

 

업그레이드 로그

cat /u01/app/oracle/cfgtoollogs/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log

==========================================
          Autoupgrade Summary Report
==========================================
[Date]           Wed Apr 19 14:22:36 KST 2023
[Number of Jobs] 3
==========================================
[Job ID] 111
==========================================
[DB Name]                RACUP
[Version Before Upgrade] 18.8.0.0.0
[Version After Upgrade]  19.16.0.0.0
------------------------------------------
[Stage Name]    GRP
[Status]        SUCCESS
[Start Time]    2023-04-19 13:38:15
[Duration]      0:00:08
[Detail]        Please drop the following GRPs after Autoupgrade completes:
                 AUTOUPGRADE_9212_RACUP188000
------------------------------------------
[Stage Name]    PREUPGRADE
[Status]        SUCCESS
[Start Time]    2023-04-19 13:38:24
[Duration]      0:00:00
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/preupgrade
------------------------------------------
[Stage Name]    PRECHECKS
[Status]        SUCCESS
[Start Time]    2023-04-19 13:38:24
[Duration]      0:00:24
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/prechecks
[Detail]        /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/prechecks/RACUP_preupgrade.log
                Check passed and no manual intervention needed
------------------------------------------
[Stage Name]    PREFIXUPS
[Status]        SUCCESS
[Start Time]    2023-04-19 13:38:48
[Duration]      0:00:14
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/prefixups
[Detail]        /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/prefixups/prefixups.xml
------------------------------------------
[Stage Name]    DRAIN
[Status]        SUCCESS
[Start Time]    2023-04-19 13:39:03
[Duration]      0:02:06
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/drain
------------------------------------------
[Stage Name]    DBUPGRADE
[Status]        SUCCESS
[Start Time]    2023-04-19 13:41:09
[Duration]      0:26:26
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/dbupgrade
------------------------------------------
[Stage Name]    POSTCHECKS
[Status]        SUCCESS
[Start Time]    2023-04-19 14:07:53
[Duration]      0:00:01
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/postchecks
[Detail]        /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/postchecks/RACUP_postupgrade.log
                Check passed and no manual intervention needed
------------------------------------------
[Stage Name]    POSTFIXUPS
[Status]        SUCCESS
[Start Time]    2023-04-19 14:07:55
[Duration]      0:08:50
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/postfixups
[Detail]        /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/postfixups/postfixups.xml
------------------------------------------
[Stage Name]    POSTUPGRADE
[Status]        SUCCESS
[Start Time]    2023-04-19 14:16:45
[Duration]      0:01:39
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/postupgrade
------------------------------------------
[Stage Name]    SYSUPDATES
[Status]        SUCCESS
[Start Time]    2023-04-19 14:18:25
[Duration]      0:01:28
[Log Directory] /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/sysupdates
------------------------------------------
Summary: /u01/app/oracle/cfgtoollogs/autoupgrade/RACUP/RACUP1/111/dbupgrade/upg_summary.log

 

6. UPDATE 완료 및 확인

crsctl stat res -t ## 2번 노드도 upgrade 되었는지 확인

select INSTANCE_NAME,HOST_NAME,VERSION_FULL,STATUS from v$instance ;

select comp_id,comp_name,status,version from dba_registry; ## 컴포넌트 19c로 변경 확인