ORACLE 9i连接SYBASE的透明网关的配置

核心提示：5.配置oracle网络服务的listener,配置文件是：listener.ora默认路径：ORACLE_HOME etworkadmin加入如下SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME= gateway_sid)(ORACLE_HOME= oracle_home

5.配置oracle网络服务的listener,配置文件是：listener.ora

默认路径：ORACLE_HOME etworkadmin

加入如下

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME= gateway_sid)
(ORACLE_HOME= oracle_home_directory)
(PROGRAM=tg4sybs)
)
)

gateway_sid就是3选择的sid字符串

oracle_home_directory是ORACLE_HOME

tg4sybs若是SYBASE是特定的。如果是其他数据库，会不同。

例子如下：

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

(SID_DESC=
(SID_NAME=tg4sybs)
(ORACLE_HOME = D:oracleora92)
(PROGRAM=tg4sybs)
)

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

6.停止监听

lsnrctl stop

重新启动监听程序

lsnrctl start