无法创建监听程序?
在配置监听程序时,想删除了重新建一个,删除后建不了啦。提示“无法创建监听程序”配置文件信息:
tnsnames.ora
SERVICORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ServicOrcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fuqiang)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = fuqiang)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
到底是怎么回事呀,哪位高人给看看。
------解决方案--------------------为什么要删除了重新创建一个呢?
------解决方案--------------------重新安装oracle数据库吧
------解决方案--------------------从别的机器上,拷贝一个配置文件,然后比对者填写,就可以了
------解决方案--------------------看看服务里监听服务是否有,添加个
REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener /v ImagePath /t REG_EXPAND_SZ /d d:\oracle\ora92\BIN\TNSLSNR /f
net start OracleOraHome92TNSListener
我的oracle9i,10g的改改路径
------解决方案--------------------
------解决方案--------------------可以使用oracle的客户端程序创建
------解决方案--------------------对,同意楼上,用netmgr试试
------解决方案--------------------我觉得有这个时间在这里等答案不如赶快重新安装一下oracle.