오라클 19c opatch debug 방법

OS 환경 : Oracle Linux 8.7 (64bit)

 

DB 환경 : Oracle Database 19.27.0.0

 

방법 : 오라클 19c opatch debug 방법

opatch 시 원인모를 에러가 발생했을 때 sr에 opatch 전체 로그 또는 더 상세 정보를 요청할때가 있음
이때 본문의 debug 옵션을 사용해 opatch 상세 로그를 수집할 수 있음

 

 

아래 사항 적용 후 opatch 실행

1 2 3

$ export OPATCH_DEBUG=true $ export PERL_DL_DEBUG=1 $ export OPATCH_LOG_LEVEL=ALL

 

 

opatch 수행

1 2	$ cd /app/oracle/media/37952382/37957391/37960098/ $ opatch apply >> opatch_debug.log

 

 

tail로 확인

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

$ tail -300f opatch_debug.log OPatch was not able to set FMW_COMPONENT_HOME by itself.   CAS jars exist ? 0  [/app/oracle/product/19c/OPatch/jlib/*content-store-interfaces*.jar] - Detect the option -jre/-jdk ? 0 - Detect the bundled jre (/app/oracle/product/19c/OPatch/jre) ? 1   CAS jars exist ? 0  [/app/oracle/product/19c/OPatch/jlib/*content-store-interfaces*.jar]   JAVA version : 8  [/app/oracle/product/19c/OPatch/jre] Can Use JAVA ? 1 Machine Info: Linux ora19fs 5.15.0-3.60.5.1.el8uek.x86_64 #2 SMP Wed Oct 19 20:04:48 PDT 2022 x86_64 x86_64 x86_64 GNU/Linux _osArch is amd64 _javaVMSpecVersion is 1.8 _javaVMSpecVendor is Oracle Corporation _javaVMSpecName is Java Virtual Machine Specification _javaVMVendor is Oracle Corporation _javaJRESpecVersion is 1.8 _javaJRESpecVendor is Oracle Corporation _javaJRESpecName is Java Platform API Specification _javaSupportedClassVersion is 52.0 OPatch compiled with , JRE_MEMORY_OPTIONS are  -d64 -Xmx3072m -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/app/oracle/product/19c/cfgtoollogs/opatch _osArch (from OCM API) is   CAS jars exist ? 0  [/app/oracle/product/19c/OPatch/jlib/*content-store-interfaces*.jar] CAS_BASED_HOME is true(1) or false(0) : 0 /app/oracle/product/19c/OPatch/jre/bin/java      -d64 -Xmx3072m -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/app/oracle/product/19c/cfgtoollogs/opatch -cp /app/oracle/product/19c/oui/jlib/OraInstaller.jar:/app/oracle/product/19c/oui/jlib/OraInstallerNet.jar:/app/oracle/product/19c/oui/jlib/OraPrereq.jar:/app/oracle/product/19c/oui/jlib/share.jar:/app/oracle/product/19c/oui/jlib/orai18n-mapping.jar:/app/oracle/product/19c/oui/jlib/xmlparserv2.jar:/app/oracle/product/19c/oui/jlib/emCfg.jar:/app/oracle/product/19c/oui/jlib/ojmisc.jar:/app/oracle/product/19c/OPatch/ocm/lib/emocmclnt.jar:/app/oracle/product/19c/OPatch/jlib/opatch.jar:/app/oracle/product/19c/OPatch/jlib/opatchsdk.jar:/app/oracle/product/19c/OPatch/oplan/jlib/automation.jar:/app/oracle/product/19c/OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar:/app/oracle/product/19c/OPatch/jlib/oracle.opatch.classpath.jar:/app/oracle/product/19c/OPatch/oplan/jlib/jaxb/activation.jar:/app/oracle/product/19c/OPatch/oplan/jlib/jaxb/jaxb-api.jar:/app/oracle/product/19c/OPatch/oplan/jlib/jaxb/jaxb-impl.jar:/app/oracle/product/19c/OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar:/app/oracle/product/19c/OPatch/oplan/jlib/OsysModel.jar:/app/oracle/product/19c/OPatch/oplan/jlib/osysmodel-utils.jar:/app/oracle/product/19c/OPatch/oplan/jlib/CRSProductDriver.jar:/app/oracle/product/19c/OPatch/oplan/jlib/oracle.oplan.classpath.jar -DOPatch.ORACLE_HOME=/app/oracle/product/19c -DOPatch.DEBUG=true -DOPatch.MAKE=false -DOPatch.RUNNING_DIR=/app/oracle/product/19c/OPatch -DOPatch.MW_HOME= -DOPatch.WL_HOME= -DOPatch.COMMON_COMPONENTS_HOME= -DOPatch.OUI_LOCATION=/app/oracle/product/19c/oui -DOPatch.FMW_COMPONENT_HOME= -DOPatch.OPATCH_CLASSPATH=/app/oracle/product/19c/jlib:/app/oracle/product/19c/rdbms/jlib -DOPatch.WEBLOGIC_CLASSPATH=  -DOPatch.SKIP_OUI_VERSION_CHECK= -DOPatch.PARALLEL_ON_FMW_OH=   oracle/opatch/OPatch rollback -id 37642901  -invPtrLoc /app/oracle/product/19c/oraInst.loc Oracle Interim Patch Installer version 12.2.0.1.46 Copyright (c) 2025, Oracle Corporation.  All rights reserved.   OUIReplacer::runEnvScript() called SystemCall:RuntimeExec(cmds, runDir): GOING to start thread to read Input Stream SystemCall:RuntimeExec(cmds, runDir): Started thread to read Input Stream SystemCall:RuntimeExec(cmds, runDir): GOING to start thread to read Error Stream ReaderThread::run(): Stream InputStream about to be read ReaderThread::run(): Stream InputStream reading completed SystemCall:RuntimeExec(cmds, runDir): Started thread to read Error Stream SystemCall:RuntimeExec(cmds, runDir): GOING into process.waitFor() SystemCall:RuntimeExec(cmds, runDir): process.waitFor() is OVER ReaderThread::run(): Stream ErrorStream about to be read ReaderThread::run(): Stream ErrorStream reading completed SystemCall:RuntimeExec(cmds, runDir): Error stream thread joined successfully SystemCall:RuntimeExec(cmds, runDir): Input stream thread joined successfully OUIReplacer::setKeyValue() called OPatchSession::process() Environment:    OPatch.ORACLE_HOME=/app/oracle/product/19c    oracle.installer.invPtrLoc=/app/oracle/product/19c/oraInst.loc    oracle.installer.oui_loc=/app/oracle/product/19c/oui    oracle.installer.library_loc=/app/oracle/product/19c/oui/lib/linux64    oracle.installer.startup_location=/app/oracle/product/19c/oui    OPatch.PLATFORM_ID=    os.name=Linux    OPatch.NO_FUSER=    OPatch.SKIP_VERIFY=null    OPatch.SKIP_VERIFY_SPACE=null    oracle.installer.clusterEnabled=false    TRACING.ENABLED=TRUE    TRACING.LEVEL=2    OPatch.DEBUG=true    OPATCH_VERSION=12.2.0.1.46    Bundled OPatch Property File=properties    Minimum OUI version: 10.2    OPatch.PATH=/app/oracle/product/19c/bin:/app/oracle/product/19c/OPatch:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin    OPatch.MW_HOME=    OPatch.WL_HOME=    OPatch.COMMON_COMPONENTS_HOME=

엄청나게 많은 양의 로그가 쌓이므로 꼭 > 구문으로 파일에 담아 전달해줘야함

 

 

참조 :