myeclipse连接oracle处错误
郁闷啊,前天还可以,刚才在连接就出现这个错误,上网搜索一堆,还没有解决,感觉不是驱动问题,因为前几天都可以。
在另外一台机子就可以运行
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:orcl
Driver JARS:jdbcforOracle
User 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:orcl
Driver JARS:jdbcforOracle
User name:yujie
Password:yujie
作者: crazyyujie 发布时间: 2011-06-09
连接到别的机器上把localhost改为别的机器的IP吧
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
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
作者: dreamhunter_lan 发布时间: 2011-06-10
我的是这样:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
引用 1 楼 dreamhunter_lan 的回复:
连接到别的机器上把localhost改为别的机器的IP吧
tnsnames.ora:
我的配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
……
连接到别的机器上把localhost改为别的机器的IP吧
tnsnames.ora:
我的配置如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.81)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
……
作者: crazyyujie 发布时间: 2011-06-10