ORA-12541:TNS:无监听

来源：互联网发布：ubuntu连打印机编辑：程序博客网时间：2024/05/16 17:20

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">新安装oracle 11g, 重启机器后使用pl sql 连接提示ORA-12541:TNS:无监听, 而使用spl plus可以正常连接(说明服务运行正常...)</span>

百度, google 搜索解决方法都是重新配置监听程序, 结果重启还是ORA-12541:TNS:无监听
经过努力问题最终得到解决, 找到安装目录以下文件,将下面代码标红的换为机器名即可

\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = <strong><span style="color:#ff6666;">机器名</span></strong>)(PORT = 1521))    )  )ADR_BASE_LISTENER = C:\app\Administrator

\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = <span style="font-family: Arial, Helvetica, sans-serif; "><strong><span style="color:#ff6666;">机器名</span></strong></span><span style="font-family: Arial, Helvetica, sans-serif;">)(PORT = 1521))</span>    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

1 0