Prerequisite check "CheckSystemCommandAvailable" failed. || 12.2C

By -

Pre-requisite: Completed successfully.

[oracle@testing 30593149]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /testing/app/oracle/product/12.2.0/testing_1
Central Inventory : /testing/app/oraInventory
   from           : /testing/app/oracle/product/12.2.0/testing_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.1.4
Log file location : /testing/app/oracle/product/12.2.0/testing_1/cfgtoollogs/opatch/opatch2020-05-15_15-38-45PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.


But Opatch apply fails:

[oracle@testing 30593149]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /testing/app/oracle/product/12.2.0/testing_1
Central Inventory : /testing/app/oraInventory
   from           : /testing/app/oracle/product/12.2.0/testing_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.1.4
Log file location : /testing/app/oracle/product/12.2.0/testing_1/cfgtoollogs/opatch/opatch2020-05-15_15-39-10PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemCommandAvailable" failed.
The details are:
Missing command :fuser
UtilSession failed:
Prerequisite check "CheckSystemCommandAvailable" failed.
Log file location: /testing/app/oracle/product/12.2.0/testing_1/cfgtoollogs/opatch/opatch2020-05-15_15-39-10PM_1.log

 OPatch failed with error code 73





Solution:

Create empty file fuser at $ORACLE_HOME/bin location.

[oracle@testing 30593149]$ cd $ORACLE_HOME/bin/
[oracle@testing bin]$ touch fuser
[oracle@testing bin]$ chmod 755 fuser

Now apply the patch:

[oracle@testing 30593149]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /testing/app/oracle/product/12.2.0/testing_1
Central Inventory : /testing/app/oraInventory
   from           : /testing/app/oracle/product/12.2.0/testing_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.1.4
Log file location : /testing/app/oracle/product/12.2.0/testing_1/cfgtoollogs/opatch/opatch2020-05-15_15-47-05PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30593149
Do you want to proceed? [y|n]
Y

Comments

Post a Comment

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

By -
How to set the root password after creating instance on oracle cloud? since you have created instance on oracle cloud, it requires you private .ppk key file to login from putty you can login on your instance by directly providing that private key. and on Linux/Unix defult user is "opc". since during creation of instance it  will not ask you for  root password. You dont need any password to connect to root. to connect to root type below command as opc user. [opc@sts ~]$ sudo su [root@sts opc]# by this you will login as root. Now change your password [root@sts opc]# passwd Changing password for user root. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@sts opc]# All done. Thanks & Regards Nikhil Kumar.
Read more

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

By -
Oracle Listener does not start with errors:  TNS-12541: TNS:no listener TNS-12560, TNS-00511, Linux Error: 2: No such file or directory, The listener supports no services euls25002.sgp.st.com:oraSID 51> ps -ef | grep -i tns root       330     2  0 Jul19 ?        00:00:00 [netns] oraSID   17512     1  0 Jul20 ?        00:01:25 /oracleSID/SID/121/bin/tnslsnr LISTENER_SID -inherit oraSID   56223 56131  0 08:02 pts/1    00:00:00 grep --color=auto -i tns euls25002.sgp.st.com:oraSID 52> lsnrctl status LISTENER_SID LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:02:19 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD)) TNS-12541: TNS:no listener  TNS-12560: TNS:protocol adapter error   TNS-00511: No listener    Linux Error: 2: No such file or directory Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID)) TNS-12541: TNS:no listener  TNS-12560: TNS:protocol adapter error   TNS-00511: No listen
Read more

Queryable inventory could not determine the current opatch status.

By -
[oracle@Testing02 OPatch]$ ./datapatch -verbose SQL Patching tool version 12.2.0.1.0 Production on Fri May 15 15:54:19 2020 Copyright (c) 2012, 2019, Oracle.  All rights reserved. Log file for this invocation: /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log Connecting to database...OK Bootstrapping registry and package to current versions...done Queryable inventory could not determine the current opatch status. Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for the complete error. Prereq check failed, exiting without installing any patches. Please refer to MOS Note 1609718.1 and/or the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for information on how to resolve the above errors. SQL
Read more