[ORACLE] SE to EE 버전업 테스트

1.version 확인

C:\Users\Administrator>sqlplus / as sysdba   SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 10 18:12:02 2020 Version 19.3.0.0.0   Copyright (c) 1982, 2019, Oracle.  All rights reserved.   Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0   SQL>

2.oracle service 중지

 

3.backup

$ORACLE_HOME/database/

$ORACLE_HOME/network/admin/

data파일

archive파일

 

4.deinstall

5.version upgrand engine 설치

6.service 재등록

oradim -delete -sid ORCL oradim -NEW -SID ORCL -INTPWD oracle -STARTMODE auto -PFILE 'C:\u01\base\product\19c\database\SPFILEORCL.ora'

 

7.$ORACLE_HOME 환경변수 변경

SQL> startup upgrade; ORACLE instance started.   Total System Global Area 2516582224 bytes Fixed Size                  9031504 bytes Variable Size             536870912 bytes Database Buffers         1962934272 bytes Redo Buffers                7745536 bytes Database mounted. Database opened.   C:\u01\base\product\19c\rdbms\admin>sqlplus / as sysdba   SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 10 20:50:34 2020 Version 19.3.0.0.0   Copyright (c) 1982, 2019, Oracle.  All rights reserved.   Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0   SQL> @catalog.sql SQL> @catproc.sql   SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started.   Total System Global Area 2516582224 bytes Fixed Size                  9031504 bytes Variable Size             536870912 bytes Database Buffers         1962934272 bytes Redo Buffers                7745536 bytes Database mounted. Database opened.   SQL> @utlrp.sql