Oracle Opatch failed with error code 73

Beim Patchen einer Datenbank kam unerwartet die Fehlermeldung:

opatch failed with error code 73

Vorarbeiten waren:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Loading login.sql file…
SYS@DBASQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@DBASQL>exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
oracle_DBA@dbe16:~$> srvctl stop listener -l LISTENER_DBA

Der folgende Check auf die Prerequisites war erfolgreich:

oracle_DBA@dbe16:/stage/Oracle/SOLARIS/SPARC/12.1.0.2/patches/DBSW-12.1.0.2.170418/25171037$> $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/DBA/12.1.0.2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/DBA/12.1.0.2/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/DBA/12.1.0.2/cfgtoollogs/opatch/opatch2017-11-03_08-17-18AM_1.log

Invoking prereq „checkconflictagainstohwithdetail“

Prereq „checkConflictAgainstOHWithDetail“ passed.

OPatch succeeded.

Trotzdem gab es einen Fehler beim Anwenden des Patches:

oracle_DBA@dbe16:/stage/Oracle/SOLARIS/SPARC/12.1.0.2/patches/DBSW-12.1.0.2.170418/25171037$> $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/DBA/12.1.0.2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/DBA/12.1.0.2/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/DBA/12.1.0.2/cfgtoollogs/opatch/opatch2017-11-03_08-20-27AM_1.log

Verifying environment and performing prerequisite checks…
Prerequisite check „CheckActiveFilesAndExecutables“ failed.
The details are:

Following executables are active :
/u01/app/oracle/product/DBA/12.1.0.2/lib/libclntsh.so.12.1
UtilSession failed: Prerequisite check „CheckActiveFilesAndExecutables“ failed.
Log file location: /u01/app/oracle/product/DBA/12.1.0.2/cfgtoollogs/opatch/opatch2017-11-03_08-20-27AM_1.log

OPatch failed with error code 73

Ermitteln des Prozesses:

$> fuser    /u01/app/oracle/product/DBA/12.1.0.2/lib/libclntsh.so.12.1
/u01/app/oracle/product/DBA/12.1.0.2/lib/libclntsh.so.12.1:   26298m

$> ps 26298
PID TT S TIME COMMAND
26298 ? S 0:00 /u01/app/oracle/product/DBA/12.1.0.2/bin/tnslsnr LISTEN

Es war der Listener. Obwohl dieser gestoppt war.

Nochmaliges Stoppen des Listeners und der „Opatch apply“ läuft ohne Probleme! Notfalls killen des Prozesses.

Im Alert fand sich übrigens auch eine Fehlermeldung:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor