1 Reply Latest reply: Jul 18, 2013 9:49 AM by clcarter RSS

    tnsnames reconfig for sid connection

    1025831

      Hi,

      I need to change tnnames for my application.

       

      My application can't connect with such coonection:

      mydb/mydb@192.168.100.100/xe

       

      I get information that it will connect using:

      mydb/mydb@xe

       

      Where xe is my SID.

       

      SO tell me haw reconfigurate tnsnames for such connetcion (aplication use tnsnames)

       

      My current tnsnames

       

      XE =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-KO31DMFLCH0)(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)

          )

        )

       

      How it schould be corect?