ORA-06512: at "SYS.DBMS_QOPATCH", line 777

OS환경 : Oracle Linux 7.5 (64bit)

DB 환경 : Oracle Database 19.3.0.0

에러 : ORA-06512: at "SYS.DBMS_QOPATCH", line 777

db 설치 후 alert log 에 발생한 메세지

db가 정상 기동 정상종료는 되지만 기동시 alert log에 아래 메세지 발생

Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 777
ORA-06512: at "SYS.DBMS_QOPATCH", line 864
ORA-06512: at "SYS.DBMS_QOPATCH", line 2222
ORA-06512: at "SYS.DBMS_QOPATCH", line 740
ORA-06512: at "SYS.DBMS_QOPATCH", line 2247
 
===========================================================
Dumping current patch information
===========================================================
Unable to obtain current patch information due to error: 20001

해결 방법 : 권한 부여 및 opatch 명령 수행

권한 부여

$ chmod 775 $ORACLE_HOME/rdbms/log

opatch datapatch -prereq 명령 수행

$ $ORACLE_HOME/OPatch/datapatch -prereq
SQL Patching tool version 19.3.0.0.0 Production on Wed May  6 01:18:43 2020
Copyright (c) 2012, 2019, Oracle.  All rights reserved.
 
Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_13266_2020_05_06_01_18_43/sqlpatch_invocation.log
 
Connecting to database...OK
Gathering database info...done
Determining current state...done
 
Current state of interim SQL patches:
  No interim patches found
 
Current state of release update SQL patches:
  Binary registry:
    19.3.0.0.0 Release_Update 190410122720: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 24-OCT-19 02.43.28.408630 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 Wed May  6 01:19:02 2020

db 재기동 및 alert log 확인(선택사항)

원인 : $ORACLE_HOME/rdbms/log 디렉토리의 권한 문제

$ORACLE_HOME/rdbms/log 디렉토리의 권한 문제

참조 : 2323937.1