连接数据库的时候出现 ORA-12518, TNS错误 试试这个String url = "jdbc:oracle:thin:@john:1521:orcl"; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是这个吗 tns:# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLETE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = john)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracletest) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )用String url = "jdbc:oracle:thin:@john:1521:orcl";会出现错误:指定了无效的 Oracle URL 用String url = "jdbc:oracle:thin:@john:1521:orcl";错误是:Listener refused the connection with the following error:ORA-12518, TNS:listener could not hand off client connectionThe Connection descriptor used by the client was:john:1521:orcl 确认sqlplus连接的正确性。把主机名换成ip地址44看 用Net configuration assistant测试本地net 服务配置成功net服务名为oraclete换ip地址也出现一样的错误 你在 sqlplus 里可以正确连接吗?不行就重启你的oracle 服务 String url = "jdbc:oracle:thin:@john:1521:oraclete"; jdbc:oracle:thin:@10.25.10.175:1526:stg sqlplus不写主机字符串可以登入,可以连接写主机字符串的话会error:ora-12514:tns:监听程序当前无法识别连接描述符中请求的服务 Error remains...Searching for help.... String url = "jdbc:oracle:thin:@localhost:1521:orcl"; 方法2:String url = "jdbc:oracle:thin:sysman/123@localhost:orcl";conn = DriverManager.getConnection(url);注意:检查 TNS listener服务是否启动,或者重新配置一下 sqlplus exp csv問題請教 批量Insert到Oracle DB,性能如何才能最快?请高手建议方案! 请问如何察看或监视oracle高级复制所消耗的时间 关于树的查询,高手帮忙一下! 关于SQL*LOADER在导入数据时候包含回车和换行如何处理!在线等~ 剧情是这样的.............. oracle储存过程如果返回一个结果集?? oracle莫名其妙出问题。请看 有人能给提供一份比较全的Oracle异常代码吗? ora-01410 简单的操作 深入浅出SQL系列教程 第四节 SELECT命令中的GROUP BY 和 HAVING 子句
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORACLETE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = john)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracletest)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)用String url = "jdbc:oracle:thin:@john:1521:orcl";会出现错误:指定了无效的 Oracle URL
错误是:
Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
The Connection descriptor used by the client was:
john:1521:orcl
net服务名为oraclete换ip地址也出现一样的错误
不写主机字符串可以登入,可以连接
写主机字符串的话会error:ora-12514:tns:监听程序当前无法识别连接描述符中请求的服务
Searching for help....