Oracle Implementation of Heterogeneous Database Connection Services is called transparent gateway. Current Oracle uses transparent gateways to implement interconnection of multiple mainstream databases such as SQL Server, Sybase, DB2.
Now use Oracle to access the Sybase database, write the steps of configuring Oracle9i Transparent Gateway for Sybase to document, for webmouth reference! Configuring Transparent Gateway for Sybase Steps
1. The Sybase Client is installed on the server where you are located (or installing Oracle, Sybase Server) on the same server, ensures access to the Sybase database
2. Install the Transparent Gateway for Sybase Option, install it with a custom installation. Correctly select Sybase installation directory
3. Select a SID string ready to assign it to the Sybase database. Such as: TG4SYBS sets Sybase's DLL path to environment variable PATH (this is very important)
4. Modify the initialization file, the default is: ORACLE_HOME / tg4sybs / admin / inittg4sybs.ora setting 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: The following $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$ # 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 $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$ SERVER_NAME is MIGRATION_SERVDATABASE_NAME is TAX
5. Configuring the Listener of the Oracle Network Services, the configuration file is: listner.ora default path: Oracle_Home / Network / Admin Added
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = GATEWAY_SID) (Program = TG4SYBS)))
Gateway_sid is 3 selected SID strings Oracle_home_directory is Oracle_hometg4sybs If Sybase is specific. If it is another database, it will be different. The following example: $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$ (SID_DESC = (SID_NAME = TG4SYBS ) (ORACLE_HOME = D: / Oracle / ORA92) (Program = tg4sybs) $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$ 6. Stop listening
LSNRCTL Stop
Restart the listener
Lsnrctl Start
7. oracle server configuration makes it possible to access the tnsnames.ora sybaseconnect_descriptor = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = host_name) (PORT = port_number)) (CONNECT_DATA = (SID = gateway_sid)) (HS = OK ))
Connect_Descriptor is a connection string, a nameport_number: Oracle listening port Gateway_SID is 3 selected SID strings
The following example: $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$ (description = (Address_List = (Address = (protocol = TCP) (port = DW-Server1)))))) (Connect_Data = (SID = TG4SYBS)) (HS = OK))
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
8. Establish Database Link
Such as: CREATE DATABASE LINK SYBS Connect To Sa Identified by Prient Use 'SBYS'; you can access the Sybase database.
It should be noted that the name of the Sybase database, the field name, if it is lower-written, then add a double quotation number when accessing in Oracle
Such as: SQL> SELECT "a" from "b" @sybs;
