Oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 解决

已于 2024-01-16 08:40:58 修改
阅读量196 收藏
点赞数
分类专栏： 数据库常见汇总 Oracle 文章标签： oracle 数据库
于 2023-10-13 10:34:53 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_48291304/article/details/133805460
版权
本文介绍了如何在Oracle的listener.ora文件中添加新的SID_DESC，以便连接到不同的数据库（PLSExtProc和ORCL），并随后重启监听器。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

打开Oracle的 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))
    )
  )

修改它的 SID_LIST_LISTENER 中的内容，修改后的内容如下

# 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)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521))
    )
  )

重启Oracle的监听器

Oracle连接失败，ORA-12514, TNS:listener does not currently know of service requested in connect descripto
十三月的博客
01-22 5919
在Window上搭建Oracle数据库，安装后启动，使用Dbeaver连接时无法连接，报错：Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor Listener refused the connection with the following error: O
解决连接oracle服务器故障：TNS:listener does not currently know of SID given in connect descriptor
hustcqb的专栏
04-09 2651
解决方法： 打开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/adm
ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的SID等错误解决方法
dixu7849的博客
04-16 2572
程序连接orarle报ORA-12505错误 一、异常{ ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 10.190.121.95:1521:sxzhdb } ...
Oracle数据库连接出现：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
weixin_40587144的博客
02-19 1万+
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
最新发布
m0_46178745的博客
03-23 132
把OracleServiceORCL这个服务启动一下。win+R输入services.msc打开“服务”
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
qq_29061315的博客
07-20 1万+
ORA-12505,SID数据连接问题！
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
qq_32565519的博客
09-16 338
JDBC连接Oracle报错：ORA-12505,TNS:监听器当前不知道连接描述符中给出的SID ORA-12505,TNS:listener does not currently know of SID given in connect descriptor 1、首先区分下SID和服务名 SID：一个数据库可以有多个Oracle实例（Oracle Instance），SID用以标识每个Ora...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor解决方法
m0_59061013的博客
09-06 9933
报错原因：通过报错内容 “TNS:listener does not currently know of SID given in connect descriptor”，可以分析出，SID 不正确；jdbc连接数据库的时候，使用数据库的 sid_name，而不是数据库的 services_name（服务名）原文链接：https://blog.csdn.net/weixin_45894220/article/details/129839666。//监听sid服务，表示sid为orcl。
部署容器数据库连接失败：TNS:listener does not currently know of SID given in connect descriptor
kang1011的博客
11-21 2万+
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 之前用PL/SQL DEVELOPER和SQLPLUS 登录数据库都没有问题，就是应用程序通过JDBC连接Oracle时无法成功连接，出现ORA-12505错误listener does not currently know of SID given in connect descriptor…。 经过查找， 发现Oracle的serv
【bug】 “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor“
热门推荐
Mia惠枫的博客
04-23 4万+
2. 确保您的 `tnsnames.ora` 文件中的服务名（SERVICE_NAME）与 `listener.ora` 文件中的服务名匹配。2. 确保您的 `tnsnames.ora` 文件中的服务名（SERVICE_NAME）与 `listener.ora` 文件中的服务名匹配。如果监听器已配置为动态服务注册，请确保数据库实例中的服务名与 `listener.ora` 文件中的服务名匹配。如果 TNS 监听器已成功启动，并识别到您请求的服务名，那么您应该可以看到关于已注册服务和正在监听的端口的信息。
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
09-20
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor 是一个Oracle数据库连接错误。它的原因是监听器不知道给定的SID在连接描述符中。这通常是由于配置问题或者网络问题导致的。 ...
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
03-30
"Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" 是Oracle数据库连接时可能遇到的错误之一。这个错误通常是...
java操作报错误信息：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
weixin_39098944的博客
04-03 3142
今天在通过代码连接oracel数库库时，一直报ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的错误信息。。经过多方查找问题原因，原来oracle版本比较新，需要升级驱动包或者更改url样式。。如下 报错信息： 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异常
添柴程序猿的专栏
09-29 951
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: 127.0.
连接linux下的oracle数据库报错：ORA-12505: TNS:listener does not currently know of SID given in connect descrip
qq_36703810的博客
04-12 1328
一种可能的解决方案是检查您的JDBC字符串并确保它是正确的。输入 show parameter instance_name 并按回车键。输入 connect sys as sysdba 并按回车键。输入 connect sys as sysdba 并按回车键。输入 sqlplus /nolog 并按回车键。输入 sqlplus /nolog 并按回车键。输入 lsnrctl start 并按回车键。输入 startup 并按回车键。输入您的系统密码并按回车键。输入您的系统密码并按回车键。
ORA-12505：TNS:listener does not currently know of SID given in connect descriptor
linuxghs的专栏
08-23 6045
修改localhost为IP地址，然后重启listener，通过ip:1521:orcl，还是报错。类似如上，如果还报错，把tnsnames.ora的localhost也修改成IP地址。复制绿色方框内的内容，修改成红色方框的内容。22号处的地方已经修改成当前电脑的IP。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值