TNS-01201: Listener cannot find executablen 错误

阳光穿透心脏的1/2处 2022-08-23 12:55 105阅读 0赞

最近在启动监听器的时候收到了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

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][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][oracle_DevDB02]:~> echo $ORACLE\_HOME  
/home/oracle/OraHome10g

\#由于直接从另外一台机器复制了listener配置内容，新机器与旧机器使用了不同的ORACLE\_HOME  
\#于是收到了上面的错误提示，下面是更正后的内容，再次重启正常  
[oracle@DevDB02][oracle_DevDB02]:~> grep home $ORACLE\_HOME/network/admin/listener.ora  
        (oracle\_home = /home/oracle/OraHome10g)

[![Oracle&nbsp;牛鹏社][Oracle_nbsp]][Oracle_nbsp_Oracle_nbsp]

相关参考  
    [RMAN 配置保留策略][RMAN]

[Oracle 闪回区(Oracle Flash recovery area)][Oracle _Oracle Flash recovery area]

[Oracle 快照控制文件(snapshot control file)][Oracle _snapshot control file]

[中小型数据库 RMAN CATALOG 备份恢复方案(一)][RMAN CATALOG]

[中小型数据库 RMAN CATALOG 备份恢复方案(二)][RMAN CATALOG 1]

[中小型数据库 RMAN CATALOG 备份恢复方案(三)][RMAN CATALOG 2]

[基于RMAN实现坏块介质恢复(blockrecover)][RMAN_blockrecover]

[用 DBMS\_REPAIR 修复坏块][DBMS_REPAIR]

[RMAN 数据库克隆文件位置转换方法][RMAN 1]

[基于RMAN的异机数据库克隆(rman duplicate)][RMAN_rman duplicate]

[基于 RMAN 的同机数据库克隆][RMAN 2]

[基于用户管理的同机数据库克隆][Link 1]

[基于RMAN从活动数据库异机克隆(rman duplicate from active DB)][RMAN_rman duplicate from active DB]

[RMAN duplicate from active 时遭遇 ORA-17627 ORA-12154][RMAN duplicate from active _ ORA-17627 ORA-12154]

[Oracle 冷备份][Oracle]

[Oracle 热备份][Oracle 1]

[Oracle 备份恢复概念][Oracle 2]

[Oracle 实例恢复][Oracle 3]

[Oracle 基于用户管理恢复的处理][Oracle 4]

[SYSTEM 表空间管理及备份恢复][SYSTEM]

[SYSAUX表空间管理及恢复][SYSAUX]

[Oracle 基于备份控制文件的恢复(unsing backup controlfile)][Oracle _unsing backup controlfile]

[RMAN 概述及其体系结构][RMAN 3]

[RMAN 配置、监控与管理][RMAN 4]

[RMAN 备份详解][RMAN 5]

[RMAN 还原与恢复][RMAN 6]

[RMAN catalog 的创建和使用][RMAN catalog]

[基于catalog 创建RMAN存储脚本][catalog _RMAN]

[基于catalog 的RMAN 备份与恢复][catalog _RMAN 1]

[RMAN 备份路径困惑][RMAN 7]

[自定义 RMAN 显示的日期时间格式][RMAN 8]

[只读表空间的备份与恢复][Link 2]

[Oracle 基于用户管理的不完全恢复][Oracle 5]

[理解 using backup controlfile][using backup controlfile]

[使用RMAN实现异机备份恢复(WIN平台)][RMAN_WIN]

[使用RMAN迁移文件系统数据库到ASM][RMAN_ASM]

[基于Linux下 Oracle 备份策略(RMAN)][Linux_ Oracle _RMAN]

[Linux 下RMAN备份shell脚本][Linux _RMAN_shell]

[使用RMAN迁移数据库到异机][RMAN 9]

[RMAN 提示符下执行SQL语句][RMAN _SQL]

[Oracle 基于 RMAN 的不完全恢复(incomplete recovery by RMAN)][Oracle _ RMAN _incomplete recovery by RMAN]

[rman 还原归档日志(restore archivelog)][rman _restore archivelog]

[oracle_DevDB02]: mailto:oracle@DevDB02
[Oracle_nbsp]: http://pub.idqqimg.com/wpa/images/group.png
[Oracle_nbsp_Oracle_nbsp]: /images/20220823/c8a2179a030e4e45b3391a0686e0a6ee.png
[RMAN]: http://blog.csdn.net/leshami/article/details/15498809
[Oracle _Oracle Flash recovery area]: http://blog.csdn.net/leshami/article/details/14230679
[Oracle _snapshot control file]: http://blog.csdn.net/leshami/article/details/12754339
[RMAN CATALOG]: http://blog.csdn.net/robinson_0612/article/details/9815271
[RMAN CATALOG 1]: http://blog.csdn.net/robinson_0612/article/details/9850665
[RMAN CATALOG 2]: http://blog.csdn.net/robinson_0612/article/details/9943407
[RMAN_blockrecover]: http://blog.csdn.net/robinson_0612/article/details/10500997
[DBMS_REPAIR]: http://blog.csdn.net/leshami/article/details/10616687
[RMAN 1]: http://blog.csdn.net/robinson_0612/article/details/9495975
[RMAN_rman duplicate]: http://blog.csdn.net/robinson_0612/article/details/9667847
[RMAN 2]: http://blog.csdn.net/robinson_0612/article/details/9497321
[Link 1]: http://blog.csdn.net/robinson_0612/article/details/9453553
[RMAN_rman duplicate from active DB]: http://blog.csdn.net/robinson_0612/article/details/9718153
[RMAN duplicate from active _ ORA-17627 ORA-12154]: http://blog.csdn.net/robinson_0612/article/details/9715347
[Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[SYSTEM]: http://blog.csdn.net/robinson_0612/article/details/6041207
[SYSAUX]: http://blog.csdn.net/robinson_0612/archive/2010/08/13/5810732.aspx
[Oracle _unsing backup controlfile]: http://blog.csdn.net/robinson_0612/article/details/7962187
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 4]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 5]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 6]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[RMAN catalog]: http://blog.csdn.net/robinson_0612/archive/2010/11/29/6043649.aspx
[catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073020.aspx
[catalog _RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073069.aspx
[RMAN 7]: http://blog.csdn.net/robinson_0612/article/details/6414338
[RMAN 8]: http://blog.csdn.net/robinson_0612/article/details/9011789
[Link 2]: http://blog.csdn.net/robinson_0612/article/details/6646492
[Oracle 5]: http://blog.csdn.net/robinson_0612/article/details/7909887
[using backup controlfile]: http://blog.csdn.net/robinson_0612/article/details/7963264
[RMAN_WIN]: http://blog.csdn.net/robinson_0612/article/details/6639064
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/article/details/6453954
[Linux_ Oracle _RMAN]: http://blog.csdn.net/robinson_0612/article/details/6454509
[Linux _RMAN_shell]: http://blog.csdn.net/robinson_0612/article/details/8029245
[RMAN 9]: http://blog.csdn.net/robinson_0612/article/details/8076841
[RMAN _SQL]: http://blog.csdn.net/robinson_0612/article/details/9020727
[Oracle _ RMAN _incomplete recovery by RMAN]: http://blog.csdn.net/robinson_0612/article/details/9253867
[rman _restore archivelog]: http://blog.csdn.net/robinson_0612/article/details/9614253