오라클 19c 홈경로(엔진경로) 변경 후 기동시 alert log

OS환경 : Oracle Linux 7.5 (64bit)

DB 환경 : Oracle Database 19.7.0.0

방법 : 오라클 19c 홈경로(엔진경로) 변경 후 기동시 alert log

기존 엔진경로 : /app/oracle/product/19/db_1

변경 엔진경로 : /app/oracle/product/19c

https://positivemh.tistory.com/574 이후 DB 기동시 alert log

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

2020-05-31T12:05:03.163983+09:00 QPI : Found directory objects and ORACLE_HOME out of sync QPI : Trying to patch with the current ORACLE_HOME QPI: ------QPI Old Directories ------- QPI: OPATCH_SCRIPT_DIR:/app/oracle/product/19/db_1/QOpatch QPI: OPATCH_LOG_DIR:/app/oracle/product/19/db_1/rdbms/log QPI: OPATCH_INST_DIR:/app/oracle/product/19/db_1/OPatch QPI: op_scpt_path /app/oracle/product/19c/QOpatch QPI: Found QPI install at :/app/oracle/product/19c/QOpatch QPI: Self adjusting the directories QPI: ------QPI New Directories------- QPI: OPATCH_SCRIPT_DIR:/app/oracle/product/19c/QOpatch QPI: OPATCH_LOG_DIR:/app/oracle/product/19c/rdbms/log QPI: OPATCH_INST_DIR:/app/oracle/product/19c/OPatch QPI: opatch file present, opatch QPI: qopiprep.bat file present

OPatch 19.7 패치파일을 읽어들이기 위해 오라클이 디렉토리를 자체적으로 조정함

sqlplus 접속 후 해당 디렉토리 조회

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

SQL>  set lines 200 set pages 1000 col directory_name for a30 col directory_path for a40 select directory_name, directory_path  from dba_directories where directory_name in ('OPATCH_SCRIPT_DIR','OPATCH_LOG_DIR','OPATCH_INST_DIR') /   DIRECTORY_NAME               DIRECTORY_PATH ------------------------------ ---------------------------------------- OPATCH_INST_DIR            /app/oracle/product/19c/OPatch OPATCH_SCRIPT_DIR           /app/oracle/product/19c/QOpatch OPATCH_LOG_DIR               /app/oracle/product/19c/rdbms/log   3 rows selected.

정상적으로 변경된 엔진경로의 하위 경로로 표시됨

datapatch -prereq 명령도 정상적으로 실행됨

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -prereq
SQL Patching tool version 19.7.0.0.0 Production on Tue Jun  2 13:30:53 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.
 
Log file for this invocation: /app/oracle/cfgtoollogs/sqlpatch/sqlpatch_36058_2020_06_02_13_30_53/sqlpatch_invocation.log
 
Connecting to database...OK
Gathering database info...done
Determining current state...done
 
Current state of interim SQL patches:
Interim patch 30805684 (OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)):
  Binary registry: Installed
  SQL registry: Applied successfully on 31-MAY-20 02.43.03.638505 PM
 
Current state of release update SQL patches:
  Binary registry:
    19.7.0.0.0 Release_Update 200404035018: Installed
  SQL registry:
    Applied 19.7.0.0.0 Release_Update 200404035018 successfully on 31-MAY-20 02.43.03.629765 PM
 
Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  No release update patches need to be installed
  No interim patches need to be applied
 
SQL Patching tool complete on Tue Jun  2 13:31:12 2020

참조 :