Oracle 11g Express Error ORA-12505，TNS：监听器当前不知道连接描述符中给出的SID [英] Oracle 11g Express Error ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

问题描述

我在Linux Centos 6.4上托管Oracle 11g Express时遇到问题。此服务器从一个地方重新定位到另一个地方，此重定位更改了服务器的IP。

我们更改了tnsname.ora和listerner.ora文件中的IP。在我们尝试从服务器连接到数据库实例的这些更改之后，我们收到错误已连接到空闲实例。如果我们尝试使用SQL开发人员从客户端连接，我们会收到错误状态：失败 - 测试失败：监听器拒绝连接时出现以下错误：ORA-12505，TNS：监听器当前不知道连接描述符中给出的SID 。



我们多次重启这个服务器和数据库（通过Oracle菜单下的选项Start和Stop数据库）多次，但我们仍然得到同样的错误。



帮助解决此问题

I am facing problem with Oracle 11g Express hosted on Linux Centos 6.4. This server is relocated from one place to another, this relocation changes the IP of server.
We have changed the IP in tnsname.ora and listerner.ora files. After these changes when we are trying to connect to database instance from server we are getting error "Connected to idle instance". If we are trying it to connect from client using SQL developer we are getting error "Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor".

We have restarted this server and database multiple time (through option Start and Stop database under Oracle menu) multiple time, but still we are getting the same error.

Help to resolve this issue

推荐答案

Google发送此错误消息。

http://ora-12505.ora-code.com/ [ ^ ]

Google for this error message.
http://ora-12505.ora-code.com/[^]

此错误通常用于连接字符串和名称你添加到最后。



SERVER =（DESCRIPTION =（ADDRESS =（PROTOCOL = TCP）（HOST = MyHost）（PORT = MyPort））（CONNECT_DATA =（ SERVICE_NAME = MyOracleSID ）））;



因此，请先查看SID名称，然后查看其他内容。

This error is usualy about Connection String and name u add on the end.

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));

So check SID name 1st then other things.

这篇关于Oracle 11g Express Error ORA-12505，TNS：监听器当前不知道连接描述符中给出的SID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！