oracle连接“监听程序当前无法识别连接描述符中请求的服务”

显示全部楼层 · 2009-7-22 16:49:43

装上去是简单~但是就是登陆不了~~为什么啊。。

大家救命啊。！！！
我是在没有联网的状态下安装的。。
这是我的配置F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# listener.ora Network Configuration File: F:\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 = F:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = oracle10)

(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)

(SID_NAME = oracle10)

)

)
LISTENER =
(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)
)
另一个文件里代码
F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)
)
速度帮帮~~~在线等。。
换ip，计算机名~我试了~没效果！！我的是Oracle10G的

千问 · 2009-7-22 16:49:43

好象没错啊...

千问 · 2009-7-22 16:49:43

1. 点要问一下，你的数据库SID到底是什么？oracle10 ？还是 orcl嗯，查好了再告诉我把。...

千问 · 2009-7-22 16:49:43

localhost改成你的ip试下...