ORA-12541：ORA-12541:TNS:没有监听器解决方法-优快云博客

本文详细介绍了如何配置Oracle数据库的监听器listener.ora文件，并提供了具体的步骤和示例。包括修改配置文件、重启监听器和服务的具体命令，确保数据库能够正常启动。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Step1，在监听器中添加

# listener.ora Network Configuration File: D:\oracle\product\10.2.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.2.0\db_1)
      (PROGRAM = extproc)
    )
(SID_DESC =
      (GLOBAL_DBNAME= test)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME = test)
   )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
     (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jiahuan)(PORT = 1521))
    )
)

Step2，进入LSNRCTL

>LSNRCTL
LSNRCTL> stop;
LSNRCTL> start;

Step3，进入SQLPLUS

>SQLPLUS
请输入用户名: system/test@test
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

Step4，一切OK，END.

BY IT HELEN
2008.8.1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7905232/viewspace-417434/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7905232/viewspace-417434/