2 Replies Latest reply: Feb 11, 2014 8:02 AM by GMoney RSS

    11g Enterprise Edition Release 11.2.0.1.0 to Microsoft SQL Server 2008 R2 (RTM)

    GMoney


      Good day all,

       

      I believe I have followed all of the correct steps to establish connectivity, yet to no avail. Before initiating the "bang-head-against_wall" sequence, I am reaching for assistance.

      I appreciate any and all guidance.

       

      Here are the particulars:

       

      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

      PL/SQL Release 11.2.0.1.0 - Production

      CORE    11.2.0.1.0      Production

      TNS for 32-bit Windows: Version 11.2.0.1.0 - Production

      NLSRTL Version 11.2.0.1.0 - Production

       

      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
      Apr  2 2010 15:48:46
      Copyright (c) Microsoft Corporation

      Standard Edition (64-bit) on Windows NT 6.1 <X64>
      (Build 7601: Service Pack 1)
      (Hypervisor)

       

      Microsoft SQL Server ODBC Driver Version 06.01.7601

      Data Source Name: GMEXCH
      Data Source Description: GMEXCH
      Server: INFWDCSWNSERD01v
      Database: mars
      Language: (Default)
      Translate Character Data: Yes
      Log Long Running Queries: No
      Log Driver Statistics: No
      Use Regional Settings: No
      Prepared Statements Option: Drop temporary procedures on disconnect
      Use Failover Server: No
      Use ANSI Quoted Identifiers: Yes
      Use ANSI Null, Paddings and Warnings: Yes
      Data Encryption: No

      Microsoft SQL Server ODBC Driver Version 06.01.7601

      Running connectivity tests...

      Attempting connection
      Connection established
      Verifying option settings
      Disconnecting from server

      TESTS COMPLETED SUCCESSFULLY!

       

      initGMEXCH.ora
      HS_FDS_CONNECT_INFO = GMEXCH
      HS_FDS_TRACE_LEVEL = 0
      HS_AUTOREGISTER = TRUE


      Listener.ora
      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME=GMSERV)
      (ORACLE_HOME=C:\app\LOGIX\product\11.2.0\dbhome_1)
      (PROGRAM = hsodbc)
      )
      )

      tnsnames.ora
      GMOTD=
      (DESCRIPTION=
      (ADDRESS_LIST=
      (Address=(PROTOCOL=TCP)
      (HOST = 10.94.34.124)
      (PORT=1521)))
      (CONNECT_DATA=(SID=GMSERV))
      (HS=OK)
      )

       

      sqlnet.ora
      SQLNET.AUTHENTICATION_SERVICES = (NONE)

       

       

      LSNRCTL> status
      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
      ction
      Start Date                10-FEB-2014 15:40:01
      Uptime                    0 days 0 hr. 18 min. 39 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   C:\app\LOGIX\product\11.2.0\dbhome_1\network\admin\lis
      tener.ora
      Listener Log File         c:\app\logix\diag\tnslsnr\WVHUNTID0017\listener\alert\
      log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WVHUNTID0017)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WVHUNTID0017)(PORT=8080))(Presentati
      on=HTTP)(Session=RAW))
      Services Summary...
      Service "GMSERV" has 1 instance(s).
        Instance "GMSERV", status UNKNOWN, has 1 handler(s) for this service...
      Service "LOGIXFTRXDB" has 1 instance(s).
        Instance "logixftr", status READY, has 1 handler(s) for this service...
      Service "logixftr" has 1 instance(s).
        Instance "logixftr", status READY, has 1 handler(s) for this service...
      The command completed successfully

       

      C:\Windows\System32>tnsping GMOTD

      TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-FEB-2
      014 15:48:25

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

      Used parameter files:
      C:\app\LOGIX\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (Address=(PROTOCOL=TCP) (HOST
      = 10.94.34.124) (PORT=1521))) (CONNECT_DATA=(SID=GMSERV)) (HS=OK))
      OK (20 msec)

       

      SQL> show parameter global_names;

      NAME                                 TYPE        VALUE
      ------------------------------------ ----------- -------
      global_names                         boolean     FALSE


      SQL> create database link GM connect to "agaf_dhdhd" identified by
        2  "xhxhxhxh!" using 'GMOTD';

      Database link created.


      SQL> select * from wirecenters_web@GM;
      select * from wirecenters_web@GM
                                    *
      ERROR at line 1:
      ORA-28545: error diagnosed by Net8 when connecting to an agent
      Unable to retrieve text of NETWORK/NCR message 65535
      ORA-02063: preceding 2 lines from GM