eclipse连接数据库时出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的解决
来源:互联网 发布:ppduck for mac破解版 编辑:程序博客网 时间:2024/06/02 06:54
关于用eclipse连接数据库时出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的解决方法
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:
解决方法:
打开Oracle的 listener.ora 文件:
(oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora)
修改前:
# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))
)
)
------------------------------------------------------------------------------------------------------------------------------
修改后:
# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/Administrator/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME =/app/Administrator/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))
)
)
上面的红色文字是增加的内容。 (ORCL -- 是你的SID 数据库名)
ORACLE_HOME(不同的Oracle版本不同的写法,可以自己找安装目录去复制)
重启Oracle的监听器。
- eclipse连接数据库时出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的解决
- oraclejdbc连接数据库的问题ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- 解决‘ORA-12505, TNS:listener does not currently know of SID given in connect descriptor’
- Oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 解决
- Oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 解决
- navicat 连接 oracle 的时出现:ORA-12505, TNS:listener does not currently know of SID given in connect descr
- ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
- Oracle ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- 力所能及之ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
- ubuntu 修改当前文件夹中所有 文件时间为特定时间
- 【Windows7系统值得推荐的四大特色】
- php+nginx
- 多线程--基础篇3--内部类
- 关闭win7/8 80端口
- eclipse连接数据库时出现ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的解决
- 自定义的带tab的可左右滑动的viewpager之一 简单实现
- 看过的一篇较好的解释PID的文章,分享只为新手~
- APACHE 无法启动 setup_inherited_listeners(), WSASocket failed to open the inherited socket
- 小议IT公司的组织架构
- AC 经典多模式匹配算法
- 秀秀我的爱站
- 不得不说的Java环境变量配置
- 又开始出发