解决数据库连接报错Listener refused the connection with the following error: ORA-12505
来源:互联网 发布:阿里云服务器购买 编辑:程序博客网 时间:2024/06/06 04:18
今天遇到的数据库连接时报错:
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
解决:进入数据库安装目录下,找到tnsnames.ora文件,把其中的service_name改成数据库正确的sid值,如我的是orcl
\network\admin\tnsnames.ora:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.62)(PORT = 1521))
(CONNECT_DATA =
(SERVER = ORCL)
(SERVICE_NAME = ORCL)
)
重启监听即可
若是碰到继续报错:17410 提示无法从套接字获取更多数据如何解决,则进入数据库安装目录下,找到listener.ora文件,将(PROGRAM = extproc)这行前面加#注释掉,如下:
#(PROGRAM = extproc)
并且,检查配置文件中HOST是否为主机名
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))
)
重启监听,数据库即可连接
阅读全文
1 0
- 解决数据库连接报错Listener refused the connection with the following error: ORA-12505
- 解决数据库连接报错Listener refused the connection with the following error: ORA-12505
- Listener refused the connection with the following error 错误解决
- Listener refused the connection with the following error 错误解决
- Listener refused the connection with the following error 错误解决
- Listener refused the connection with the following error 错误解决
- Listener refused the connection with the following error 错误解决
- 数据库报ORA-12519;java.sql.SQLException: Listener refused the connection with the following error解决办法
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently
- java.sql.SQLException: Listener refused the connection with the following error:ORA-12505
- java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:list
- java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:lis
- java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:list
- ORA-12514错误:Listener refused the connection with the following&
- 状态: 失败 -测试失败: Listener refused the connection with the following error: ORA-12505, TNS:listener does
- 状态: 失败 -测试失败: Listener refused the connection with the following error: ORA-12505, TNS:listener does
- Java 循环结构
- html简介
- 单链表<一>初始化链表和头插法
- go get 命令被墙问题
- mac下使用jenv切换jdk版本
- 解决数据库连接报错Listener refused the connection with the following error: ORA-12505
- Hydra使用
- sql
- 【51单片机学习笔记】彩色呼吸灯
- Zookeeper集群及单机安装
- 死锁
- java for的几种循环方式
- C#DES文件加解密工具类
- [模板]treap小结