1 2 Previous Next 16 Replies Latest reply: Feb 7, 2014 11:16 AM by Habib.Eslami Go to original post RSS
      • 15. Re: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
        Deepak Kumar K

        Start the database service and try again. The service name will be like

        OracleserviceXE

        • 16. Re: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
          Habib.Eslami

          I did these settings in jdeveloper declaratively

          username : hr

          pass : hr

          Host Name : localhost

          Service name : XE

          port : 1521


          but this time the below Exception occurs:

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

          ORA-12514, TNS:listener does not currently know of service requested in connect descriptor


          and when I set SID : XE the below Exception 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  tnsnames.ora :

          XE =

            (DESCRIPTION =

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

              (CONNECT_DATA =

                (SERVER = DEDICATED)

                (SERVICE_NAME = XE)

              )

            )

           

           

          EXTPROC_CONNECTION_DATA =

            (DESCRIPTION =

              (ADDRESS_LIST =

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

              )

              (CONNECT_DATA =

                (SID = PLSExtProc)

                (PRESENTATION = RO)

              )

            )

           

           

          ORACLR_CONNECTION_DATA =

            (DESCRIPTION =

              (ADDRESS_LIST =

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

              )

              (CONNECT_DATA =

                (SID = CLRExtProc)

                (PRESENTATION = RO)

              )

            )

           

          Regards

          1 2 Previous Next