Oracle 11g transparent gateway connected to sybase Database

Oracle 11g transparent gateway connected to sybase Database

I have already compiled two documents about connecting the Oracle transparent gateway to the mysql database and the SQL Server database. I thought that I would not connect to other databases through the transparent gateway, But I encountered it again, oracle connects to the sybase Database through a transparent gateway, and once again enters the document;

Note: This section describes how to set up a transparent gateway, connect to the sqlserver database, and mysql database. Please search for it in your blog due to time constraints;

Body: The method for configuring transparent gateway to connect to the sybase Database is almost the same as that for connecting to sqlserver. (Some netizens suggested that the sybase client driver should be installed, but it is not required after verification)

Ii. Detailed operations are as follows:

Follow these steps;

3. transparent gateway Configuration

3.1 configure the transparent gateway parameter file

Go to the directory: $ ORACLE_HOME/dg4sybs/admin/

Create a parameter file named initecc. ora Based on the parameter file initdg4sybs. ora)

# This is a customized agent init file that contains the HS parameters

# That are needed for the Database Gateway for Sybase

#

# HS init parameters

#

HS_FDS_CONNECT_INFO = 192.168.0.124: 4901/ECC (modify this column)

HS_FDS_TRACE_LEVEL = OFF

HS_FDS_RECOVERY_ACCOUNT = RECOVER

HS_FDS_RECOVERY_PWD = RECOVER
 

3.2 modify the database listening Configuration

Note: Add SID_DESC only under SID_LIST:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ECC)

(ORACLE_HOME = d: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1)

(PROGRAM = dg4sybs)

)

)

Note:

SID_NAME must match the name of the above parameter file

The ORACLE_HOME directory is consistent with the actual installation directory.

The PROGRAM is dg4sybs.
 

After the listener file is configured, restart lisnrctl.

 

3.3 add or remove the configuration of the tnsnames File

ECC = (Note: Any name can be set)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = tcp) (HOST = localhost) (PORT = 1521 ))

(CONNECT_DATA = (SID = ECC ))

(HS = OK)

)

Note:

The SID Name is the name of the listener file configuration;

The configuration is complete. You can run tnsping ECC.

4. Configure dblink

SQL> CREATE PUBLIC DATABASE LINK ECC_LINK CONNECT TO "username" IDENTIFIED BY "password" USING 'ecc ';

You can set the ECC_LINK name as required;

'Ecc 'is the name configured in the tnsnames file;

Run the configuration: select * from dual @ ECC_LINK. If a return value is returned, the configuration is successful;

Tip: the sybase Database is case-sensitive. Therefore, if many table names and fields contain lower-case content, they must be expanded using double quotation marks.
In fact, oracle can be case-sensitive, but oracle will automatically convert to uppercase without double quotation marks.

Summary: the settings of the transparent gateway to connect to sybase are almost the same as those of sqlserver. This operation is generally normal, but an internal specification is recommended for the name of the whole process design, the management benefits of this specification will be discovered in the subsequent use process;