试试这个
String url = "jdbc:oracle:thin:@john:1521:orcl";
String url = "jdbc:oracle:thin:@john:1521:orcl";
解决方案 »
- update 返回值
- 高级应用话题(请资深专家一起探讨探讨)
- 菜鸟求助SQL语句(ORACLE)一种写法,请各位达人帮忙,在线等
- oracle提取方案中的表名的查询语句
- 请教高手组织一条SQL语句
- 第一次运行SQLPLUS时,提示ORACLE initialization or shutdown in progress 是什么意思,应该怎么办??在线等
- 散分,imp问题,急!
- 创建表空间错误,求救!!!
- 请问在oracle中如何导出某张表中的数据呢?又该如何导入呢?
- 祝各位在新的一年里,事事顺利,取得更大的成绩!
- 简单的操作
- 深入浅出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....