2 Replies Latest reply: Dec 11, 2012 5:40 AM by 979067 RSS

    Error with dblink 'HS'  ORA-12154 Could not resolve the connect identifier

    979067
      I'm trying to make a connection heterogeneous DBLINK between Oracle and SQLSever, however me the following error is returned: ORA-12154.

      I am setting up as follows:


      TNSNAMES.ora:
      dg4msql =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM)(PORT = 1522))
      (CONNECT_DATA =
      (SID = dg4msql)
      )
      (HS = OK)     
      )
      
      XE =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM)(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) 
          ) 
        ) 
      LISTENER.ora:
      # listener.ora Network Configuration File: /u01/gateways/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      
      MSSQL = 
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      )
      )
      
      SID_LIST_LISTENER11G =
      (SID_LIST = 
      (SID_DESC =
      (SID_NAME=dg4msql)
      (ORACLE_HOME=/u01/gateways)
      (ENVS=LD_LIBRARY_PATH=/u01/gateways/dg4msql/driver/lib:/u01/gateways/lib)
      (PROGRAM=dg4msql)
      )
      )
      
      ADR_BASE_MSSQL = C:\product\11.2.0\tg_1
      INITDG4MSQL.ora :
       This is a customized agent init file that contains the HS parameters
      # that are needed for the Database Gateway for Microsoft SQL Server
      
      #
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO=S015145.SETAPE.COM//Teste
      # alternate connect format is hostname/serverinstance/databasename
      HS_FDS_TRACE_LEVEL=DEBUG
      HS_FDS_RECOVERY_ACCOUNT=RECOVER
      HS_FDS_RECOVERY_PWD=RECOVER
      Thx

      Edited by: 976064 on 10/12/2012 11:30