This discussion is archived
2 Replies Latest reply: Dec 11, 2012 3:40 AM by 979067 RSS

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

979067 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points