[oracle@strong ~]$ /u01/app/oracle/product/19.3.0/db_1/OPatch/opatch apply -local /setup/30783543/30805684
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-06-45PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3.0/db_1/bin/oracle
Following active executables are used by opatch process :
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-06-45PM_1.log
OPatch failed with error code 73
查看opatch日志:
[oracle@strong lib]$ cat /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-06-45PM_1.log
[Aug 5, 2020 5:06:46 PM] [INFO] CUP_LOG: Trying to load HomeOperations object
[Aug 5, 2020 5:06:46 PM] [INFO] CUP_LOG: HomeOperations object created. CUP1.0 is enabled
[Aug 5, 2020 5:06:46 PM] [INFO] OPatch invoked as follows: 'apply -local /setup/30783543/30805684 -invPtrLoc /u01/app/oracle/product/19.3.0/db_1/oraInst.loc '
[Aug 5, 2020 5:06:46 PM] [INFO] Runtime args: [-Xmx3072m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=apply, -DOPatch.ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/u01/app/oracle/product/19.3.0/db_1/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DOPatch.OUI_LOCATION=/u01/app/oracle/product/19.3.0/db_1/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatch.PARALLEL_ON_FMW_OH=]
[Aug 5, 2020 5:06:46 PM] [INFO] Heap in use : 7 MB
Total memory: 30 MB
Free memory : 23 MB
Max memory : 2969 MB
[Aug 5, 2020 5:06:46 PM] [INFO] Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.2.0.7.0
OUI location : /u01/app/oracle/product/19.3.0/db_1/oui
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-06-45PM_1.log
[Aug 5, 2020 5:06:46 PM] [INFO] Patch history file: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch_history.txt
[Aug 5, 2020 5:06:48 PM] [INFO] [OPSR-TIME] Loading raw inventory
[Aug 5, 2020 5:06:49 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 15 (MB)
[Aug 5, 2020 5:06:49 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 8 (MB)
[Aug 5, 2020 5:06:49 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully
[Aug 5, 2020 5:06:49 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.
[Aug 5, 2020 5:06:49 PM] [INFO] Verifying environment and performing prerequisite checks...
[Aug 5, 2020 5:06:49 PM] [INFO] [OPSR-TIME] Running prerequisite checks
[Aug 5, 2020 5:06:49 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.3.0/db_1/OPatch/jlib/opatch-external.jar
[Aug 5, 2020 5:06:50 PM] [INFO] [OPSR-TIME] Loading cooked inventory
[Aug 5, 2020 5:06:50 PM] [INFO] [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 18 (MB)
[Aug 5, 2020 5:06:50 PM] [INFO] [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 14 (MB)
[Aug 5, 2020 5:06:50 PM] [INFO] [OPSR-TIME] Cooked inventory loaded successfully
[Aug 5, 2020 5:06:50 PM] [INFO] Checking if Oracle Home has components required by patches...
[Aug 5, 2020 5:06:50 PM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[Aug 5, 2020 5:06:50 PM] [INFO] Checking conflict among patches...
[Aug 5, 2020 5:06:50 PM] [INFO] Running prereq checkConflictAmongPatchesWithDetail
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches can be applied: 30805684
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches are not required:
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches are auto rollbackable:
[Aug 5, 2020 5:06:50 PM] [INFO] Finished checking prereq checkConflictAmongPatchesWithDetail
[Aug 5, 2020 5:06:50 PM] [INFO] Conflict checking amongst patches PASSED
[Aug 5, 2020 5:06:50 PM] [INFO] Checking conflicts against Oracle Home...
[Aug 5, 2020 5:06:50 PM] [INFO] Running prereq checkConflictAgainstOHWithDetail
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches can be applied: 30805684
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches are not required:
[Aug 5, 2020 5:06:50 PM] [INFO] Following patches are auto rollbackable:
[Aug 5, 2020 5:06:50 PM] [INFO] Finished checking prereq checkConflictAgainstOHWithDetail
[Aug 5, 2020 5:06:51 PM] [INFO] Running prerequisite checks...
[Aug 5, 2020 5:06:51 PM] [INFO] Space Needed : 851.205MB
[Aug 5, 2020 5:06:51 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 30805684
[Aug 5, 2020 5:06:51 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0/db_1/bin/oracle at Wed Aug 05 17:06:51 CST 2020
[Aug 5, 2020 5:06:51 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0/db_1/bin/oracle at Wed Aug 05 17:06:51 CST 2020
[Aug 5, 2020 5:06:51 PM] [INFO] Files in use by a process: /u01/app/oracle/product/19.3.0/db_1/bin/oracle PID( 2487 2489 2491 2493 2497 2499 2503 2506 2509 2512 2514 2516 2518 2520 2522 2524 2526 2528 2530 2532 2536 2540 2544 2546 2549 2551 2553 2568 2570 2572 2577 2582 2589 2594 2598 2602 2615 2621 3411 11307 11309 11311 11360 11416 11475 11760 11764 11771 23305 23892 )
[Aug 5, 2020 5:06:51 PM] [INFO] Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3.0/db_1/bin/oracle
Following active executables are used by opatch process :
[Aug 5, 2020 5:06:51 PM] [INFO] Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3.0/db_1/bin/oracle
Following active executables are used by opatch process :
[Aug 5, 2020 5:06:52 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Aug 5, 2020 5:06:52 PM] [INFO] Finishing UtilSession at Wed Aug 05 17:06:52 CST 2020
[Aug 5, 2020 5:06:52 PM] [INFO] Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-06-45PM_1.log
[Aug 5, 2020 5:06:52 PM] [INFO] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
at oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6752)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1002)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:372)
at oracle.opatch.opatchutil.NApply.process(NApply.java:352)
at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1123)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.opatch.UtilSession.process(UtilSession.java:355)
at oracle.opatch.OPatchSession.process(OPatchSession.java:2660)
at oracle.opatch.OPatch.process(OPatch.java:840)
at oracle.opatch.OPatch.main(OPatch.java:897)
Caused by: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
... 13 more
Caused by: oracle.opatch.PrereqFailedException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
... 13 more
[oracle@strong lib]$
2、 停止数据库再检查进程
[oracle@strong ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 5 17:08:36 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
再次执行成功:
[oracle@strong lib]$ /u01/app/oracle/product/19.3.0/db_1/OPatch/opatch apply -local /setup/30783543/30805684
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-09-13PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.21
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2020-08-05_17-09-36PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30805684
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30805684' to OH '/u01/app/oracle/product/19.3.0/db_1'