ORA-12541:TNS:无监听程序”错误解决

最新推荐文章于 2024-01-12 16:43:40 发布

shdyn126

最新推荐文章于 2024-01-12 16:43:40 发布

阅读量729

点赞数

分类专栏：数据库文章标签： list tcp oracle network service dos

本文链接：https://blog.youkuaiyun.com/jiyidianranyikeyan/article/details/5992037

版权

数据库专栏收录该内容

8 篇文章

订阅专栏

1:首先利用cmd中输入netstat -a -n查看相关的端口（默认为1521）启用没有，若没有，则可以参考本人的另一篇文章

2：Oracle的listener已经启动

3. 查看oracle/product/10.1.0/db_1/NETWORK/ADMIN/listener.ora

# listener.ora Network Configuration File: D:/oracle/product/10.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = D:/oracle/product/10.1.0/db_1)

      (PROGRAM = extproc)

    )

)

LISTENER =

(DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

      )

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

      )

    )

)

把(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

pc-xxx.mail.yyy.cn是计算机名

127.0.0.1也就是目前数据库正在用的ip地址。

4.       查看oracle/product/10.1.0/db_1/NETWORK/ADMIN/tnsnames.ora

找到下列语句：

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

)

将(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

5.       关闭后再启动listener

运行->cmd启动dos窗口，执行lsnrctl stop关闭，lsnrctl start启动。