ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的SID等错误解决方法【连接本机】

最新推荐文章于 2024-07-08 17:59:54 发布

wfxx_

最新推荐文章于 2024-07-08 17:59:54 发布

阅读量1.3w

点赞数 3

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/wfxx_/article/details/126556178

版权

遇到这个问题首先考虑检查配置文件listener.ora和tnsnames.ora。

1 listener.ora文件

获取电脑主机名称：可通过dba登录sqlplus利用

select HOST_NAME from v$instance;

语句查询主机名

模板如下：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
	  (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Lenovo\product\11.2.0\dbhome_1\BIN\OraClr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-W)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = D:\app\Lenovo

2 tnsnames.ora文件

①这里的SID要和示例名一致

②这里的SERVICE_NAME要和服务端的名称一致

模板如下：

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
	  (SID = orcl)
      (SERVICE_NAME = orcl)
    )
  )