ORA-12541:TNS:no listener 排查方法

随笔3天前发布 鸽子
2 0 0

步骤1:检查客户端的tnsnames.ora

/usr/app/oracle/product/11.2.0/network/admin/tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = **数据库服务器IP** )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = **orcl**)
    )
  )

步骤2:检查服务器listener.ora

/usr/app/oracle/product/11.2.0/network/admin/listener.ora

SID_LIST_LISTENER=(
    (SID_LIST=
        (SID_DESC=
            。。。省略。。。
        )
        (SID_DESC=
            (SID_NAME= **orcl** )
            (ORACLE_HOME= **dbhome_1的目录地址**)
        )
    )
)
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = **数据库服务器IP** )(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /usr/app/oracle

步骤3:重启监听

lsnrctl stop

lsnrctl start

© 版权声明

相关文章

暂无评论

您必须登录才能参与评论!
立即登录
暂无评论...