Encountering the following error in the Oracle database agent logs:
Failed to execute the [echo QUEST_OUTPUT_START; export ORACLE_HOME=/u50/oradata/tsdb03d/db/10.2.0.5; expo...=/u50/oradata/network/admin/; export LD_LIBRARY_PATH=$ORACLE_HOME/lib; export SHL...CLE_HOME/lib; /u50/oradata/tsdb03d/db/10.2.0.5/bin/lsnrctl status LISTENER_TSDB03D] script of DBO_Usability on myserver.example.com-testdb.
Reason : [/u50/oradata/tsdb03d/db/10.2.0.5/bin/lsnrctl: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory].Unix Error code : [127].
Some causes for this can include:
A). SELINUX being enabled (https://forums.oracle.com/forums/thread.jspa?threadID=598820)
B). The listener name does not match the listener.ora file
C). Missing libclntsh.so.11.1
1) Set the TNS names variable in the database global administration dashboard
2) Set permissions at the Unix level to allow the non-dba account read only access to the following
$ORACLE_HOME/lib
$ORACLE_HOME/mesg
$ORACLE_HOME/network/mesg
read and execute on
$ORACLE_HOME/bin/lsnrctl
Note for those with security concerns: even with the permissions, the non-dba user cannot shutdown the listener.
lsnrctl stop LISTENER
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-OCT-2012
TNS-01190: The user is not authorized to execute the requested listener command
The listener status is controlled by the Usability collection. This collection can be disabled through the Global Administration panel. Usability is the last collection frequency in the list.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center