急问Ora12560错误!!!
ern 2003-11-16 02:45:40 系统:Win XP Pro 所有最新的补丁都装过
Oracle 9iR2 是从官方网站下载的Personal Edition
主机名是ern
昨天安装以后是可以正常使用的。后来可能是用了注册表优化程序,今天进系统不能打开监听器了。后来看了网上的文章,自己在监听器服务注册表里添加了imagepath,从而至少在“服务”里可以看到监听器服务已经正常启动。但是又发现原来自动的OracleServiceYaoyp(yaoyp是我的数据库服务名)服务不能启动——提示路径不对,后来仿照前面添加了imagepath,指引到安装目录下的bin\oracle.exe,服务也能启动了。可是当我连接数据库的时候,仍然提示ORA12560 TNS 协议适配器错误。修改下面的配置文件,host改为127.0.0.1也不行。万望各位大哥帮忙,快疯了!
自己分数不多,先定这么多,哪位帮我解决了,可以另外给分
tnsname.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 = ern)(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)
YAOYP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ern)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = yaoyp)
listener.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ern)(PORT = 1521))