郁闷啊,前天还可以,刚才在连接就出现这个错误,上网搜索一堆,还没有解决,感觉不是驱动问题,因为前几天都可以。
在另外一台机子就可以运行
error: Error while performing database login with the oracle driver:
Listener refused the connection with the following error:
ora-12514 tns listener does not currently know of service requested in connect descriptor
The connection descriptor used by the client was:
localhost:1521这是这么回事啊?Connection URL:jdbc:oracle:thin:@127.0.0.1:1521:orclDriver JARS:jdbcforOracleUser name:yujie
Password:yujie
在另外一台机子就可以运行
error: Error while performing database login with the oracle driver:
Listener refused the connection with the following error:
ora-12514 tns listener does not currently know of service requested in connect descriptor
The connection descriptor used by the client was:
localhost:1521这是这么回事啊?Connection URL:jdbc:oracle:thin:@127.0.0.1:1521:orclDriver JARS:jdbcforOracleUser name:yujie
Password:yujie
tnsnames.ora:
我的配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)这个文件在我的是在这个目录下:E:\oracle\Administrator\product\11.1.0\db_1\NETWORK\ADMIN
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)