跳出的提示是：
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
