Oracle 11g Express错误：ORA-12505，TNS：listener当前不知道在连接描述符中给出的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开发人员从客户端连接，我们收到错误状态：失败 - 测试失败：Listener拒绝连接，出现以下错误：ORA-12505，TNS：侦听器当前不知道连接描述符中给出的SID 。
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".
我们多次重新启动了这个服务器和数据库（通过在Oracle菜单下启动和停止数据库选项），但是我们仍然得到相同的错误。
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.
请求您帮助解决此问题。
Request you to please help to resolve this issue.
推荐答案
我们解决了这个问题，实际上我们在一些文件中丢失了服务器地址，它仍然引用了旧地址。
we resolved this issue, actually we were missing server address in some files it was still referring old address.
initXE.ora缺少本地侦听器参数，它和它开始工作。
initXE.ora missing local listener parameter, then we added this parameter to it and it start working.
可能这不是泛化的解决方案，但它的工作原理。
May be this is not the generalise solution but it work in our case.
这篇关于Oracle 11g Express错误：ORA-12505，TNS：listener当前不知道在连接描述符中给出的SID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
