I recently received an error message for TNS-01201: Listenercannotfindexecutable... when I started the listener. This is really a mistake that has never been encountered.
The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This is really a mistake that has never been encountered.
The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is. The following is a detailed description of the error and the solution.
1. fault description
# An TNS-01201 error was received when the listener was started, and the listener could not find the executable file
Oracle @ DevDB02: ~> Lsnrctl start LISTENER_USBO2
LSNRCTL for Linux: Version 10.2.0.3.0-Production on 06-JUN-2014 17:06:37
Copyright (c) 1991,200 6, Oracle. All rights reserved.
Starting/home/oracle/OraHome10g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0-Production
System parameter file is/home/oracle/OraHome10g/network/admin/listener. ora
Log messages written to/home/oracle/OraHome10g/network/log/listener_usbo2.log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.202) (PORT = 1403 )))
TNS-01201: Listener cannot find executable/users/oracle/OraHome10g/bin/oracle for SID USBO2
Listener failed to start. See the error message (s) abve...
2. Fault Analysis
# Meatlink provides a description of this problem (Doc ID 22060.1)
# Check whether the ORACLE_HOME environment variable points to a valid location
Error: TNS 1201
Text: Listener cannot find executable % s for SID % s
-------------------------------------------------------------------------------
Cause: The executable for the Oracle dedicated server process cannot be
Found.
Action: Check the appropriate SID_DESC in LISTENER. ORA to make sure that
The ORACLE_HOME component is pointing to a valid location.
If this component is not set, then check the value of the ORACLE_HOME
Environment variable.
Comment: This error is reported only on UNIX platforms.
3. troubleshooting
# The oracle_home configured in the listener is different from the current ORACLE_HOME
Oracle @ DevDB02: ~> More $ ORACLE_HOME/network/admin/listener. ora
LISTENER_USBO2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.202) (PORT = 1403 ))
)
)
)
SID_LIST_LISTENER_USBO2 =
(SID_LIST =
(SID_DESC =
(Sid_name = USBO2)
(Oracle_home =/users/oracle/OraHome10g)
)
)
Oracle @ DevDB02: ~> Echo $ ORACLE_HOME
/Home/oracle/OraHome10g
# Because the listener Configuration content is directly copied from another machine, the new machine and the old machine use different ORACLE_HOME
# So I received the error message above. The following is the correct content. restart the system again.
Oracle @ DevDB02: ~> Grep home $ ORACLE_HOME/network/admin/listener. ora
(Oracle_home =/home/oracle/OraHome10g)