TNS-01201: Listener cannot find executable /bee/app/oracle/product/11g/bin/oracle for SID srvdb1
Oracle Error :: TNS-01201
Listener cannot find executable string for SID string
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.
Comments (Add Comment)
Wiki Page: TNS-01201
原因配置静态监听时,拷贝来的listener信息中ORACLE_HOME与本地不一样:
cat listener.ora
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.205.0.30)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test1)
(ORACLE_HOME = /bee/app/oracle/product/11.2.0/db_1)
(SID_NAME = test11)
)
)