Myeclipse开发:ORA-12505,TNS:listener does not currently know o
来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/06/30 23:18:47
Myeclipse开发:ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.
开发环境:Myeclipse 6.5,Tomcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为:username.密码是:password,数据库实例为:test.
启动Tomcat时报错,错误信息如下:
[main] ERROR:org.hibernate.util.JDBCExceptionReporter#logExceptions :Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:mydb
)
(16 ms) [main] WARN :org.hibernate.cfg.SettingsFactory#buildSettings :Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException:Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:mydb
)
我在content.xml中的配置如下:
name="orcl"
type="javax.sql.DataSource"
maxActive="20"
maxIdle="2"
username="username"
maxWait="500000"
validationQuery="select 1 from dual"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="password"
url="jdbc:oracle:thin:@192.168.10.10:1521:test"/>
而且本机上也没有mydb的用户
请问是什么原因引起的?应该怎么解决?
而在另外一台机子上一样的项目文件,却没有报出这个错误……
开发环境:Myeclipse 6.5,Tomcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为:username.密码是:password,数据库实例为:test.
启动Tomcat时报错,错误信息如下:
[main] ERROR:org.hibernate.util.JDBCExceptionReporter#logExceptions :Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:mydb
)
(16 ms) [main] WARN :org.hibernate.cfg.SettingsFactory#buildSettings :Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException:Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:mydb
)
我在content.xml中的配置如下:
name="orcl"
type="javax.sql.DataSource"
maxActive="20"
maxIdle="2"
username="username"
maxWait="500000"
validationQuery="select 1 from dual"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="password"
url="jdbc:oracle:thin:@192.168.10.10:1521:test"/>
而且本机上也没有mydb的用户
请问是什么原因引起的?应该怎么解决?
而在另外一台机子上一样的项目文件,却没有报出这个错误……
![Myeclipse开发:ORA-12505,TNS:listener does not currently know o](/uploads/image/z/15501898-10-8.jpg?t=Myeclipse%E5%BC%80%E5%8F%91%EF%BC%9AORA-12505%2CTNS%3Alistener+does+not+currently+know+o)
碰到过这种问题,改listener.ora 试试是否能解决.
解决方法:
打开Oracle的 listener.ora 文件:
(我的目录 oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora)
可参照参考资料:
解决方法:
打开Oracle的 listener.ora 文件:
(我的目录 oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora)
可参照参考资料:
ORA-12505,TNS:listener does not currently know of SID given
借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listen
Myeclipse 中使用Ant 提示下面错误 “target xx does not exist in this pr
Your device does not currently have any browser configuratio
She does not know .
ORA-01034:ORACLE not available ORA-27101:shared memory realm
He does not know much Chinese.[同义]
know girls not Linda two does those
She does not know London very well.
she does not know London very well
___he does not know the answer
she does not know ____for the party.