TNS-01201: Listener cannot find executablen 錯誤解決

TNS-01201: Listener cannot find executablen 錯誤解決

最近在啟動監聽器的時候收到了TNS-01201: Listener cannot find executable...的錯誤提示。這個錯誤還真是一個一直沒有碰到過的錯誤。咋一看還真不明白是怎麼一回事呢。下面是錯誤的具體描述與解決方案。

1、故障描述
#在啟動監聽器時收到了TNS-01201錯誤，監聽器無法找到可執行檔
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, 2006, 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) above...

 

2、故障分析
#Meatlink上給出了關於這個問題的描述(Doc ID 22060.1)
#需要檢查ORACLE_HOME環境變數是否指向了一個有效位置
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、故障解決
#原來監聽器中配置的oracle_home不同於當前的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

#由於直接從另外一台機器複製了listener配置內容，新機器與舊機器使用了不同的ORACLE_HOME
#於是收到了上面的錯誤提示，下面是更正後的內容，再次重啟正常
oracle@DevDB02:~> grep home $ORACLE_HOME/network/admin/listener.ora
        (oracle_home = /home/oracle/OraHome10g)