Transparent gateway configuration for connecting Oracle9i to Sybase (1)

To configure TRANSPARENT GATEWAY FOR SYBASE

1. Install sybase client on the server where oracle is located (or install oracle and sybase servers on the same server) to ensure that the sybase database can be accessed;

2. Install the transparent gateway for sybase option, which must be customized. Correctly select the sybase installation directory;

3. Select a sid string to be assigned to the sybase Database. For example, tg4sybs sets the dll PATH of SYBASE to the environment variable PATH (this step is very important );

4. Modify the initialization file. The default value is:

ORACLE_HOME\tg4sybs\admin\inittg4sybs.ora

Set parameters

HS_FDS_CONNECT_INFO

Format:

HS_FDS_CONNECT_INFO= server_name. database_name[,INTERFACE= interface_file]

Server_name. database_name is case sensitive.

INTERFACE (optional)

Example:

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ # This is a sample agent init file that contains the HS parameters that are # needed for the Transparent Gateway for Sybase # # HS init parameters # HS_FDS_CONNECT_INFO=migration_serv.tax HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER # # Environment variables required for Sybase # set SYBASE=d:\sybase $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

In the above example

Server_name is migration_serv

Database_name is tax

5. Configure the listener of the oracle network service. The configuration file is listener. ora.

Default path: ORACLE_HOME \ network \ admin

Add as follows:

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

Gateway_sid is the sid string selected by 3.

Oracle_home_directory is ORACLE_HOME

If tg4sybs is SYBASE specific. If it is another database, it will be different.

Example:

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ (SID_DESC= (SID_NAME=tg4sybs) (ORACLE_HOME = D:\oracle\ora92) (PROGRAM=tg4sybs) ) $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$