QPI: qopiprep.bat file present

OS환경 : Oracle Linux 7.5 (64bit)

DB 환경 : Oracle Database 19.7.0.0

에러 : QPI: qopiprep.bat file present

alert log 에 발생하는 아래 메세지

1 2 3

2020-05-31T12:07:58.527771+09:00 QPI: opatch file present, opatch QPI: qopiprep.bat file present

해결 방법 : 에러 메세지가 아님

에러 메세지가 아닌 OPatch 파일이 존재하고 해당 bat 파일을 실행했을때 나오는 메세지임

원인 : $ORACLE_HOME/OPatch에서 datapatch 명령 사용시 발생

datapatch -verbose 또는 datapatch -prereq 명령실행

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
SQL Patching tool version 19.7.0.0.0 Production on Sun May 31 13:52:44 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.
 
Log file for this invocation: /app/oracle/cfgtoollogs/sqlpatch/sqlpatch_25425_2020_05_31_13_52_44/sqlpatch_invocation.log
 
Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...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 26-APR-20 02.41.37.290285 AM
 
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 26-APR-20 02.41.37.281705 AM
 
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 Sun May 31 13:53:02 2020

alert log 확인

2020-05-31T13:52:52.664554+09:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present

datapatch -prereq 명령 실행

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -prereq
SQL Patching tool version 19.7.0.0.0 Production on Sun May 31 13:55:37 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.
 
Log file for this invocation: /app/oracle/cfgtoollogs/sqlpatch/sqlpatch_26008_2020_05_31_13_55_37/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 26-APR-20 02.41.37.290285 AM
 
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 26-APR-20 02.41.37.281705 AM
 
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 Sun May 31 13:55:55 2020

alert log 확인

2020-05-31T13:55:45.878617+09:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present

참조 : Doc. 1602089.1