Heterogeneous Connectivity
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Heterogeneous Connectivity

  1. #1
    Join Date
    Mar 2010
    Posts
    3

    Heterogeneous Connectivity

    Hello

    I have a need to connect Oracle RDBMS 10g r2 (10.0.2.5.0) to SQL Server 2008 on WIN 64 bit machine.

    To achieve this, I have downloaded and Installed Oracle Gateway for ODBC 11G and followed steps outlined below.

    However when I create the database link and run a SELECT statement I get following error:

    Code:
    ORA-12154: TNS:could not resolve the connect identifier specified
    Below are details of all files. Not sure what is causing this. I have checked TNSNAMES.ora multiple times and no luck :(

    No matter what I do I am getting ORA 12154.

    Code:
    Below is my TNSNAME.ora entry from Oracle Database server
    
    SSLTMS=(DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=TCP)(HOST=SQLSERVER-DB)(PORT=1521)))
    (CONNECT_DATA=(SID=SSLTMS))
    (HS=OK)
    )
    Below is my Listener.ora entry from Gateway server

    Code:
    LISTENER =
     (ADDRESS_LIST=
          (ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521))
     )
     
    SID_LIST_LISTENER=
      (SID_LIST=
          (SID_DESC=
             (SID_NAME=SSLTMS)
             (ORACLE_HOME=C:\product\11.2.0\tg_1)
             (PROGRAM=dg4odbc)
          )
      )
    And below is the entry of intiSSLTMS.ini file

    Code:
    # This is a sample agent init file that contains the HS parameters that are
    # needed for the Database Gateway for ODBC
     
    #
    # HS init parameters
    #
    HS_FDS_CONNECT_INFO = SSLTMS
    HS_FDS_TRACE_LEVEL = off
     
     
    #
    # Environment variables required for the non-Oracle system
    #
    #set =
    My sqlnet.ora on Oracle DB supports all names as shown below

    Code:
    NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
    SQLNET.EXPIRE_TIME= 10

    AND, for some weird reasons Listener does not show any services running is this normal?

    Code:
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
    ction
    Start Date                02-DEC-2011 23:25:34
    Uptime                    0 days 0 hr. 7 min. 46 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   C:\product\11.2.0\tg_1\network\admin\listener.ora
    Listener Log File         C:\product\11.2.0\tg_1\diag\tnslsnr\SQLSERVER-DB\listene
    r\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521
    )))
    The listener supports no services
    The command completed successfully
    Please help :(

  2. #2
    Join Date
    May 2002
    Posts
    2,645

  3. #3
    Join Date
    Mar 2010
    Posts
    3
    Unfortunatley, Gateway for SQL Server is a paid product and we dont have it.

    I am using Oracle Database Gateway for ODBC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width