★★“ORA:12541:TNS 没有监听器” 的问题★★
我的机器名称: mobile
Oracle服务器: mobile
问题:Oracle(9i)安装后监听器都可以启动,机器重启后就无法启动监听器了。
我没有改动过机器的名称,看了以前的帖子好像都无法解决,请各位大侠帮帮忙!!
========listener.ora========
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mobile)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = mobile)
)
)
=========tnsnames.ora=========
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
MOBILE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mobile)
)
)
Oracle服务器: mobile
问题:Oracle(9i)安装后监听器都可以启动,机器重启后就无法启动监听器了。
我没有改动过机器的名称,看了以前的帖子好像都无法解决,请各位大侠帮帮忙!!
========listener.ora========
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mobile)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = mobile)
)
)
=========tnsnames.ora=========
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
MOBILE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mobile)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mobile)
)
)
...全文
相关推荐
连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程
当连接Oracle数据库时遇到ORA-12541:TNS:无监听程序错误,通常意味着客户端试图与Oracle服务器通信时,监听器未能识别或找到相应的服务名。监听器是Oracle数据库系统中的一个重要组
TNS-12541: TNS: 无监听程序 TNS-12560
"Oracle数据库监听器问题-TNS-12541与TNS-12560错误解决"在IT领域,特别是Oracle数据库管理中,遇到"TNS-12541: TNS: 无监听程序"和"TNS-12560
基于ORA-12170 TNS 连接超时解决办法详解
本文主要针对Oracle数据库环境中的ORA-12170 TNS连接超时问题进行深入解析,并提供了解决步骤。当遇到"ORA-12170: TNS: 连接超时"错误时,这通常意味着客户端无法与数据库服务
ORACLE数据库逐步解决ORA-12541、ORA-01034和ORA-27101、ORA-00119和ORA00132的过程
"TNS:无监听程序",表示数据库的监听服务没有运行或者配置错误。
ora-12514的错误的原因
下面我们将从根本上探究 ORA-12514 错误的原因,并提供相应的解决方法。原因 1:监听器没有启动ORA-12514 错误的一个常见原因是监听器没有启动。在服务器端,监听器是数据库连接的入口点。


基础和管理
