오라클 데이터베이스 업그레이드2

• 

  [오라클] 업그레이드 #4 - Oracle database upgrade (11.2.x to 19.x) 4. 업그레이드 4.1 preupgrade_fixup 실행 preupgrade_fixups 수행 및 데이터베이스 중지 1 2 3 4 SET ECHO ON; SET SERVEROUTPUT ON; @/u01/app/oracle/cfgtoollogs/orcl/preupgrade/preupgrade_fixups.sql shutdown immediate; 더보기 [oracle@orcl ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 5 11:19:11 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterp.. DATABASE/ORACLE 2022. 10. 10.

• 

  [오라클] 업그레이드 #3 - Oracle database upgrade (11.2.x to 19.x) 3.4 Oracle Application Express 업그레이드 19c의 APEX 경로로 이동 1 cd /apex 더보기 [oracle@orcl ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1 [oracle@orcl ~]$ cd /u01/app/oracle/product/19c/db_1/apex APEX 신버전 설치 1 2 select COMP_NAME, STATUS, VERSION from DBA_REGISTRY where COMP_NAME='Oracle Application Express'; @apexins SYSAUX SYSAUX TEMP /i/ [oracle@orcl apex]$ sqlplus / as sysdba SQL*Plus: Rele.. DATABASE/ORACLE 2022. 10. 10.