oracle10G 的ORA-12505问题解决方法
来源:互联网 发布:长篇网络禁书百度云 编辑:程序博客网 时间:2024/04/30 10:53
连接 jdbc Oracle10g 错误 ,JDBC代码无问题,服务也启动,连接字符串也是对的,但是在eclipse 下报错,错误信息如下:
java.sql.SQLException: 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:orcl
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:279)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at cn.com.db.DBAccess.getConnection(DBAccess.java:33)
at cn.com.db.DBAccess.main(DBAccess.java:95)
Null
在CMD下snrctl status ,tnsping orcl 显示都正常。
在pl/SQL下用
select open_mode from v$database;
show parameter instance;
select INSTANCE_NAME from v$instance;
sqlplus sys/oracle@orcl
查询都显示正常,就是用pl/sql 登录时 填“数据库名” orcl 就无法登陆,报ora -12514
l最后有效的解决方法:
修改listener.ora文件
原listener.ora文件:
# listener.ora Network Configuration File: D:/oracle/product/10.1.0/Db_4/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/oracle/product/10.1.0/Db_4)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
修改后的文件:
---------------------------------------------------------------------------------------
# listener.ora Network Configuration File: D:/oracle/product/10.1.0/Db_4/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/oracle/product/10.1.0/Db_4)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:/oracle/product/10.1.0/Db_4)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
-----------------------------------------------------------------
如果错误还存在,也可以那试一下:
set oracle_sid=<sid_name>
sqlplus /nolog
connect sys/pwd as sysdba
start
原贴:http://www.blogjava.net/joan/archive/2008/10/28/237141.html
- oracle10G 的ORA-12505问题解决方法
- 原创:oracle10G 的ORA-12505问题解决方法
- Oracle10g ORA-32004 问题解决方案
- Oracle10g的ORA-3136
- AIX+ORACLE10g RAC ORA-04030 问题解决过程
- 关于oracle中oracle 的ORA-12505问题解决方法
- 【Vegas原创】ORA-12505问题解决方法
- 【Vegas原创】ORA-12505问题解决方法
- Oracle10g的ORA-3136错误
- Oracle10g的ORA-3136错误
- ORA-30649: 缺少DIRECTORY关键字的问题解决方法
- ORACLE10G imp error: ORA-12899的解决方案
- Oracle10g的ORA-3136错误(INBOUND_CONNECT_TIMEOUT参数)
- Oracle10g的ORA-3136错误(INBOUND_CONNECT_TIMEOUT参数)
- oracle10g下ora-12505_错误解决方案
- myeclipse6.0 连接oracle10g的问题 ORA-00604,ORA-12705
- myeclipse6.0 连接oracle10g的问题 ORA-00604,ORA-12705
- myeclipse6.0 连接oracle10g的问题 ORA-00604,ORA-12705
- Linux-2.6.20的cs8900驱动分析(三)
- tomcat6.0The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.
- ORA-28000报错解决
- YUV格式的解析zz
- hdu1170--Balloon Comes!
- oracle10G 的ORA-12505问题解决方法
- 纯CSS制作的IE6兼容型table hover
- MySQL 当记录不存在时插入(insert if not exists)
- 北大ACM题目分类3
- 话说高清电视
- java远程调用之spring和hessian
- 从osCommerce到Zen Cart,再到CubeCart
- hibernate二级缓存使用
- 开始研究Twitter。。。