oracle 11g ͸Ã÷Íø¹ØÁ¬½Ómssql 2005±¨´í£¿£¿£¿

ͨ¹ýoracle 11g Á¬½Ómssql 2005 ±¨ÏÂÃæµÄ´íÎó
select * from maintanance@mssql
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-28545: Á¬½Ó´úÀíʱ Net8 Õï¶Ïµ½´íÎó
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: ½ô½Ó×Å 2 lines (Æð×Ô MSSQL)
oracle 11g listener.oraÅäÖÃÈçÏ£º
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=UniteAlarm)
(ORACLE_HOME=D:\app\Administrator\product\11.1.0\db_1)
(ENVS=LD_LIBRARY_PATH=D:\app\Administrator\OraGtw11g_home1\dg4msql\driver\lib;D:\app\Administrator\product\11.1.0\db_1\LIB)
(PROGRAM=dg4msql)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aRong)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
oracle 11g tnsnames.oraÅäÖÃÈçÏ£º
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
UniteAlarm =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST= aRong)(PORT=1521))  
     )
     (CONNECT_DATA =
       (SID = UniteAlarm)
     )
     (HS=OK)
   )
ÆäÖУ¬UniteAlarmÊÇÒªÁ¬½ÓµÄmssqlµÄÊý¾Ý¿â£¬Í¸Ã÷Íø¹ØD:\app\Administrator\OraGtw11g_home1\dg4msql\adminÏÂÃæµÄÅäÖÃÎļþinitUniteAlarm.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="SERVER=10.147.51.156;DATABASE=UniteAlarm"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
Çë¸ßÊÖ°ïæ½â¾öÏ£¬¶àл£¡£¡£¡