安装oracle gateways

安装gate ways   遇到 ora-28545 错误，处理了好几天，今天终于搞定了

处理方法，删除监听，重新配置监听，删除tnsnames配置，netca重新配置监听。

# listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
(SID_DESC =
    (SID_NAME = dg4msql)     
    (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)    
    (PROGRAM = dg4msql)     
  )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = L9K1QZN648N2CPB)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


ADR_BASE_LISTENER = E:\app\Administrator

重新配置tnsnames

dg4msql =
(DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = L9K1QZN648N2CPB)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = dg4msql) 
  )
  (HS = OK)                    
)

重新配置dg4msql

# 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 [127.0.0.1]/MSSQLSERVER/test 
#
HS_FDS_CONNECT_INFO=192.168.1.1,1433//test
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

连接成功！