读书人

Uable to connect SQLState =S1000 [O

发布时间: 2014-01-28 21:29:37 作者: rapoo

跳出的提示是:
Uable to connect
SQLState =S1000
[Oracle][ODBC][Ora]ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务

我以后把Oracle OracleOraDb10g_home1TNSListener 这个服务器打开了
为什么还报这样的错误
我本来都配件号的JDBC 可以连接关机之后开机又 不行了
又报这样的错误 我反复的开了 上面那个 监听服务了 但还是无法连接 导致我编写JAVA 连接Orale的程序都运行不了请高手指点
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

# tnsnames.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

MLDN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mldn)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)



------解决方法--------------------------------------------------------
在客户端系统环境变量里的Path 里面增加
d:\oracle\product\10.1.0\db_1\bin;
然后在
环境变量里面新增一个
tns_admin
赋值:
d:\oracle\product\10.1.0\db_1\network\admin
------解决方法--------------------------------------------------------
检查一下你的实例的状况。

[Oracle][ODBC][Ora]ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务

应该是实例注册的问题。

你可以参考一下

http://www.inthirties.com/thread-107-2-1.html

        

读书人网 >oracle

热点推荐