环境: windows enterpirse 2003 32 bit + oracle 9i 9.2.0.8 IP:10.190.16.100
windows enterpirse 2003 R2 x64 + SQL server 2005 IP:10.132.36.86
配置: 1. ODBC里system DSN 配置 对SQL server AA数据库 的连接,name : AA
2. initAA.ora 配置
HS_FDS_CONNECT_INFO = AA
HS_FDS_TRACE_LEVEL = OFF
3. listener.ora 配置
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.190.16.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1527))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d