透明网关配置修改后服务器要重启吗,配置透明网关的步骤 - 第8页 - Oracle数据库管理

多谢！我也刚刚搞定。

原来是一个低级错误——tnsnames.ora文件配置错误(直接拷贝后修改，结果没改主机地址！指到别的地方了：)：))。另外注意：lsnrctl中显示status=unknow不必惊讶，正常。

今天阅读了Oracle 9i附带的Oracle Transparent Gateways文档，整理了一下，供参考！

搜索关键字：

Oracle Transparent Gateways

透明网关

Oracle database applications can be executed against non-Oracle database servers using SQL*Connect or the Oracle Open Gateway.

Oracle Transparent Gateways

The capabilities, SQL mappings, data type conversions, and interface to the remote non-Oracle system are contained in the gateway. The gateway interacts with Heterogeneous Services to provide the transparent connectivity between Oracle and non-Oracle systems.

The gateway can be installed on any machine. It can be on the same machine as the Oracle database or on the same machine as the non-Oracle system or on a third machine as a standalone. Each configuration has its advantages and disadvantages. The issues to consider when determining where to install the gateway are network traffic, operating system platform availability, hardware resources and storage.

Configuring the Gateway

After installing the gateway(supplied with Oracle 9i setup package), perform the following tasks to configure the gateway for Microsoft SQL Server:

1.Configuring the Gateway(ORACLE_HOME\tg4msql\admin\init.ora on gateway side)

2.Configuring Oracle Net Services Listener for the Gateway(listener.ora on gateway side)

3.Configuring the Oracle Database Server for Gateway Access(tnsnames.ora on oracle side)

4.Creating Database Links(on oracle side)

1.Configuring the Gateway

Task 1: Choose a System Identifier for the Gateway

The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance.The SID is used as part of the file name for the initialization parameter file.

Task 2: Customize the Initialization Parameter File

The initialization parameter file must be available when the gateway is started.

如：ORACLE_HOME\tg4msql\admin\initmytg4msql.ora

注意：HS_FDS_CONNECT_INFO= server_name.database_name

HS_FDS_DEFAULT_OWNER = 缺省用户

2.Configuring Oracle Net Services Listener for the Gateway

The gateway requires Oracle Net Services to provide transparent data access. After configuring the gateway, configure Oracle Net Services to work with the gateway.

Configure Oracle Net Services TNS Listener for the Gateway

If you are already running a TNS listener that listens on multiple database SIDs, add only the following syntax to SID_LIST in the existing listener.ora file:

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=.

)

(SID_DESC=.

)

(SID_DESC=

(SID_NAME=mytg4msql)

(ORACLE_HOME=oracle_home_directory)

(PROGRAM=tg4msql)

)

3.Configuring the Oracle Database Server for Gateway Access

Before you use the gateway to access Microsoft SQL Server data you must configure the Oracle database server to enable communication with the gateway over Oracle Net Services.

Configuring Oracle Net Services for the Oracle Database Server

The tnsnames.ora file is required by the Oracle database server accessing the gateway, but not by the gateway. Edit the tnsnames.ora file to add a connect descriptor for the gateway.:

connect_descriptor=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST= host_name)

(PORT= port_number)

)

(CONNECT_DATA=

(SID= mytg4msql))

(HS=OK))--(HS=OK) specifies that this connect descriptor uses the Oracle Heterogeneous Services option.

4.Creating Database Links

接下来：Configuring the Gateway for Multiple Microsoft SQL Server Databases