How does the Oracle database correctly access SYBASE data?

The following article describes how to access SYBASE-related data in an Oracle database and how to configure the transparent gateway for Sybase, I hope this will help you in your future studies.

1. Install Sybase client on the server where Oracle is located (or install Oracle and Sybase servers on the same server) to ensure that Oracle can access the Sybase database;

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 = parameters = OFFHS_FDS_RECOVERY_ACCOUNT = records = 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 Oracle server tnsnames. ora to enable Oracle 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; 
 
 

The above content is an introduction to Oracle's access to SYBASE data. I hope you will have some gains.