TNS-03505 Failed to resolve nameCause: The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service.Action: Verify that you entered the service name correctly. You may need to ensure that the name was entered correctly into the network configuration.
To:zgh2003(世纪飞扬)我的jsp代码是通过连接池来连接的,应该不会有什么问题吧?? 这是我Conn.jsp的内容: <%@ page import="javax.sql.*,javax.naming.*" %> <% Context env = (Context) new InitialContext().lookup("java:comp/env"); DataSource PoolConn = (DataSource) env.lookup("szbd"); %> 下面是Resin1.4.2的配置文件内容(部分): <resource-ref> <res-ref-name>szbd</res-ref-name> <res-type>javax.sql.DataSource</res-type> <init-param driver-name="oracle.jdbc.driver.OracleDriver"/> <init-param url="jdbc:oracle:thin:@10.0.0.12:1521:pxzx"/> <init-param user="szbd"/> <init-param password="szbd911"/> <init-param max-connections="200"/> <init-param max-idle-time="30"/> </resource-ref> ========================================To:beckhambobo(beckham)麻烦你讲得具体些,我英文不好。========================================To:zzhtd(华子)我按你的方法去实验了一下,还是不行。 问题依旧:java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection========================================To:wuenming(真永远)我可以确定服务器已经启动了。另外,在此谢谢你们的参与..........
check listener.ora and tnsnames.ora 注意你的host一定要统一,要么是IP,要么是计算机名。
oracle 服务器 没插网线时我遇到过同样得问题
我试了一个命令:tnsping,出现的信息如下,这些是否正常呢?? =======================================C:\>tnsping zmxTNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-5月 -2 004 14:48:31Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件: e:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名 Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=zmx))(ADDR ESS=(PROTOCOL=TCP)(HOST=zmx)(PORT=1521))) TNS-12541: TNS:无监听器
C:\>lsnrctlLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-5月 -2004 18:44 :41Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.欢迎来到LSNRCTL,请键入"help"以获得信息。LSNRCTL> status 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) TNS-12541: TNS:无监听器 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听器 32-bit Windows Error: 2: No such file or directory 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmx)(PORT=1521))) TNS-12541: TNS:无监听器 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听器 32-bit Windows Error: 61: Unknown error
LSNRCTL> start 你的还没有启动吧
Sorry! ========================================= C:\>lsnrctlLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-5月 -2004 09:37 :46Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.欢迎来到LSNRCTL,请键入"help"以获得信息。LSNRCTL> start 启动tnslsnr:请稍候...TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production 系统参数文件为e:\oracle\ora92\network\admin\listener.ora 写入e:\oracle\ora92\network\log\listener.log的日志信息 监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) 监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=1521)))正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) LISTENER 的 STATUS ------------------------ 别名 LISTENER 版本 TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc tion 启动日期 12-5月 -2004 09:37:52 正常运行时间 0 天 0 小时 0 分 2 秒 跟踪级别 off 安全性 OFF SNMP OFF 监听器参数文件 e:\oracle\ora92\network\admin\listener.ora 监听器日志文件 e:\oracle\ora92\network\log\listener.log 监听端点概要... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=1521))) 服务摘要.. 服务 "PLSExtProc" 包含 1 个例程。 例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序... 服务 "Pxzx" 包含 1 个例程。 例程 "Pxzx", 状态 UNKNOWN, 包含此服务的 1 个处理程序... 命令执行成功 LSNRCTL>
但不知道:
LSNRCTL
LSNRCTL>STATUS
是什么意思,在哪里进行这样的操作呢???救我呀..............
status --查看状态.
如果没有开启则
stop
start --重启来
=====================================LSNRCTL> status
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
启动日期 27-4月 -2004 08:39:58
正常运行时间 0 天 9 小时 3 分 0 秒
跟踪级别 off
安全性 OFF
SNMP OFF
监听器参数文件 e:\oracle\ora92\network\admin\listener.ora
监听器日志文件 e:\oracle\ora92\network\log\listener.log
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=8080))(Presentation=HTTP)(
Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=2100))(Presentation=FTP)(S
ession=RAW))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "Pxzx" 包含 2 个例程。
例程 "Pxzx", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
例程 "Pxzx", 状态 READY, 包含此服务的 1 个处理程序...
服务 "PxzxXDB" 包含 1 个例程。
例程 "Pxzx", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功
LSNRCTL>
SQL*Plus也能登录进去。查看你的代码与Oracle建立的连接是否有问题?
把ora9i数据存储目录安全属性中的读写属性先取消,在选中,保存实验一下反正在ora9i与.net2003中连接就有此问题,是ora9i的bug
这是我Conn.jsp的内容:
<%@ page import="javax.sql.*,javax.naming.*" %>
<%
Context env = (Context) new InitialContext().lookup("java:comp/env");
DataSource PoolConn = (DataSource) env.lookup("szbd");
%>
下面是Resin1.4.2的配置文件内容(部分):
<resource-ref>
<res-ref-name>szbd</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<init-param driver-name="oracle.jdbc.driver.OracleDriver"/>
<init-param url="jdbc:oracle:thin:@10.0.0.12:1521:pxzx"/>
<init-param user="szbd"/>
<init-param password="szbd911"/>
<init-param max-connections="200"/>
<init-param max-idle-time="30"/>
</resource-ref>
========================================To:beckhambobo(beckham)麻烦你讲得具体些,我英文不好。========================================To:zzhtd(华子)我按你的方法去实验了一下,还是不行。
问题依旧:java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection========================================To:wuenming(真永远)我可以确定服务器已经启动了。另外,在此谢谢你们的参与..........
注意你的host一定要统一,要么是IP,要么是计算机名。
=======================================C:\>tnsping zmxTNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-5月 -2
004 14:48:31Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
e:\oracle\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=zmx))(ADDR
ESS=(PROTOCOL=TCP)(HOST=zmx)(PORT=1521)))
TNS-12541: TNS:无监听器
:41Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.欢迎来到LSNRCTL,请键入"help"以获得信息。LSNRCTL> status
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 2: No such file or directory
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmx)(PORT=1521)))
TNS-12541: TNS:无监听器
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error
你的还没有启动吧
=========================================
C:\>lsnrctlLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-5月 -2004 09:37
:46Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.欢迎来到LSNRCTL,请键入"help"以获得信息。LSNRCTL> start
启动tnslsnr:请稍候...TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
系统参数文件为e:\oracle\ora92\network\admin\listener.ora
写入e:\oracle\ora92\network\log\listener.log的日志信息
监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
监听:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=1521)))正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
启动日期 12-5月 -2004 09:37:52
正常运行时间 0 天 0 小时 0 分 2 秒
跟踪级别 off
安全性 OFF
SNMP OFF
监听器参数文件 e:\oracle\ora92\network\admin\listener.ora
监听器日志文件 e:\oracle\ora92\network\log\listener.log
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zmx)(PORT=1521)))
服务摘要..
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "Pxzx" 包含 1 个例程。
例程 "Pxzx", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
LSNRCTL>
监听现在应该已经启动了。
贴出你的sqlnet.ora,tnsnames.ora,listener.ora以方便分析问题
============================
# SQLNET.ORA Network Configuration File: e:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)tnsnames.ora内容:
============================
# TNSNAMES.ORA Network Configuration File: e:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.YLGC_ZZG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zzg)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ylgc)
(SERVER = DEDICATED)
)
)PXZX_CJH_CJH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cjh)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pxzx_cjh)
(SERVER = DEDICATED)
)
)ORA9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cjh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ora9i)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zmx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)PXZX_CJH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cjh)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)PXZX_ZMX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zmx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pxzx)
(SERVER = DEDICATED)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)ZZG_YLGC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ylgc)(PORT = 1521))
)
(CONNECT_DATA =
(SID = zzg)
(SERVER = DEDICATED)
)
)PXZX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zmx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = pxzx)
(SERVER = DEDICATED)
)
)listener.ora内容:
==========================
# LISTENER.ORA Network Configuration File: e:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zmx)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Pxzx)
(ORACLE_HOME = e:\oracle\ora92)
(SID_NAME = Pxzx)
)
)
感谢,各位"星级"大哥们的帮忙和关注!!!!!!!!!!
问题的解决:
是resin和jdk的问题,重装一下就OK了.