5 Replies Latest reply: Feb 7, 2014 8:09 AM by Srini Chavali-Oracle RSS

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

    Habib Eslami

      HI,

      I installed Oracle Database 11g Express Edition.

      Previously I could connect to XE in jdeveloper 11.1.1.7.0 without any problem but now when I want to connect to XE the Exception below occurs:

      Test failed: Listener refused the connection with the following error:

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

       

      the content of listener.ora :

      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)

          )

        )

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

            (ADDRESS = (PROTOCOL = TCP)(HOST = Habib-PC)(PORT = 1521))

          )

        )

       

       

      DEFAULT_SERVICE_LISTENER = (XE)

       

      and when I want to change and save this file, it says : the file is opened in another program

       

      Habib