当你得到这个错误“ORA-12505, TNS:监听器目前不知道在连接描述符中给定的SID”

解决方案:打开服务，启动OracleServiceXE，然后尝试连接…

通过在主机上执行tnsping和实例名来检查。它会给你tns描述，大多数时候主机名是不同的，不匹配。

我同样解决我的问题

在Unix机器中 $ tnspring(输入)

它给了我完整的tns描述，我发现主机名是不同的..：）

面对类似的错误，上述任何解决方案都不起作用。 监听器有问题。ora文件。我错误地添加了SID的SID_LIST见下面(部分之间的星星*)。

 SID_LIST_LISTENER =
      (SID_LIST =

        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
        )
        )

 *(SID_DESC =
           (SID_NAME = XE)
           (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
         )*
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        )
      )


    DEFAULT_SERVICE_LISTENER = (XE)

更正此错误如下:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
       (SID_NAME = XE)
       (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
     )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )


DEFAULT_SERVICE_LISTENER = (XE)

停止，数据库

手动停止监听器OracleServiceXE和OracleXETNSListener，因为它没有通过进入控制面板\所有控制面板项\管理工具\服务自动停止。重新启动数据库，它工作得很好。

I too faced the same issue. I had installed Oracle Express edition 10g in Windows XP OS using VMware and it was working fine. Since it was very awkward typing SQL queries in the SQL utility provided by 10g and since I was used to working with SQL developer, I installed 32 bit SQL developer in XP and tried connecting to my DB SID "XE". But the connection failed with error-ORA-12505 TNS listener doesn't currently know of SID given in connect descriptor. I was at sea as to how this problem occurred since it was working fine with the SQL utility and I had also created few Informatica mappings using the same. I did browse a lot on this stuff hither thither and applied the suggestions offered to me after pinging the status of "lsnrctl" on public forums but to no avail. However, this morning I tried creating a new connection again, and Voila, it worked with no issues. I am guessing after reading in few posts that sometimes listener listens before the DB connects or something(pardon me for my crude reference as I am a newbie here) but I suggest to just restart the machine and check again.

当你得到这个错误“ORA-12505, TNS:监听器目前不知道在连接描述符中给定的SID”

解决方案:打开服务，启动OracleServiceXE，然后尝试连接…

我刚来的时候也有同样的问题。我刚刚在Windows 8(64位)上安装了Oracle 12c，但我已经在命令行上通过'TNSPING xe'解决了它…如果连接未建立或名称未找到，请尝试数据库名称，在我的情况下，它是'orcl'…再次使用' tnspring orcl'，如果它ping成功，那么你需要在这种情况下将SID更改为'orcl'(或任何你使用的数据库名称)…