5 Replies Latest reply on Aug 24, 2013 3:18 PM by sb92075

    dblink is giving error at tns creation.

    947771

      hi,

      I am trying to make dblink, in 11g express.winodws 2003, to sqlserver 2005 on same machine.

      i have made odbc connection to sqlserver and the name is dg4odbc.

      my home is

      F:\oraclexe\app\oracle\product\11.2.0\server

       

      i have initdg4odbc.ora in

      F:\oraclexe\app\oracle\product\11.2.0\server\hs\admin

      content of the file is

      HS_FDS_CONNECT_INFO = dg4odbc

      HS_FDS_TRACE_LEVEL = OFF

       

       

      listener.ora file ha

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (SID_NAME = PLSExtProc)

            (ORACLE_HOME = F:\oraclexe\app\oracle\product\11.2.0\server)

            (PROGRAM = extproc)

          )

          (SID_DESC =

            (SID_NAME = CLRExtProc)

            (ORACLE_HOME = F:\oraclexe\app\oracle\product\11.2.0\server)

            (PROGRAM = extproc)

          )

      (SID_DESC =

                (SID_NAME = dg4odbc)

                (ORACLE_HOME = F:\oraclexe\app\oracle\product\11.2.0\server)

                (program = dg4odbc)

            )

       

        )

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

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

            (ADDRESS = (PROTOCOL = TCP)(HOST = wlt-vr7lj49kz0h)(PORT = 1521))

          )

        )

       

      DEFAULT_SERVICE_LISTENER = (XE)

       

      tnslistener.ora

      has

       

       

      dg4odbc =

                (DESCRIPTION =

                        (ADDRESS = (protocol=tcp)(host=wlt-vr7lj49kz0h)(port=1521))

                                (connect_data = (sid=dg4odbc))

                                (hs=ok)

                )

      XE =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = wlt-vr7lj49kz0h)(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)

          )

        )

       

      i am getting following error

       

      F:\Documents and Settings\Administrator>Lsnrctl reload

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 18-AUG-2013 08:00

      :02

       

      Copyright (c) 1991, 2010, Oracle.  All rights reserved.

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

        TNS-00511: No listener

         32-bit Windows Error: 2: No such file or directory

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wlt-vr7lj49kz0h)(PORT=15

      21)))

      TNS-12541: TNS:no listener

      TNS-12560: TNS:protocol adapter error

        TNS-00511: No listener

         32-bit Windows Error: 61: Unknown error

       

       

      yours sincerely