Connect Oracle11g transparent gateway to sybase Database

Source: Internet
Author: User
Tags sybase sybase client sybase database
I have already compiled two documents about oracle transparent gateway connecting mysql database and sqlserver database. I thought it would not connect to other databases through transparent gateway.

I have already compiled two documents about oracle transparent gateway connecting mysql database and sqlserver database. I thought it would not connect to other databases through transparent gateway.

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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.