Step 8: Be proficient in accessing the Sybase Database from Oracle

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.taxHS_FDS_TRACE_LEVEL=  
  
  
        OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_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)) 
 
 

6. Stop listening

Lsnrctl stop

Restart the listener

Lsnrctl start

7. Configure tnsnames. ora of the oracle server to enable it to access sybase

 
 

  
  
connect_descriptor=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)  
  
  
(HOST= host_name)(PORT= port_number))  
  
  
(CONNECT_DATA=(SID= gateway_sid))(HS=OK)) 
 
 

Connect_descriptor is a connection string. It can be used as any parameter. It is generally sybs.

Host_name: name of the oracle server

Port_number: oracle listening port

Gateway_sid is the sid string selected by 3.

Example:

 
 

  
  
sybs=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)  
  
  
(HOST= dw-server1)(PORT= 1521)))  
  
  
(CONNECT_DATA=(SID= tg4sybs))(HS=OK)) 
 
 

8. Create a database link

For example:

Create database link sybs connect to sa identified by prient USING 'sbys ';

You can access the sybase Database.

Note that the table name and field name of the sybase database should be added with double quotation marks when accessing the oracle database in lower case ""

For example:

SQL> select "a" from "B" @ sybs;

1. Analysis of Oracle index reconstruction by user name
2. Connection Methods and common usage of Oracle database tables
3. Application Analysis of Oracle recovery Manager
4. Oracle Server parameter file maintenance skills
5. Detailed description of Oracle DataGuard data backup solution