ORACLE Access to SYBASE Data
Posted on | February 7, 2010 | No Comments
TRANSPARENT GATEWAY FOR Sybase configuration steps
1.Oracle installed on the server where the Sybase client (or on the same server to install Oracle, Sybase Server) to ensure that access to Sybase databases;
2. TRANSPARENT GATEWAY FOR Sybase installation option, to use a custom installation. Correct choice of Sybase installation directory;
3. Select a sid string ready to assign the Sybase database. Such as: tg4sybs set the dll path to the Sybase environment variable PATH (This step 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 above example
server_name is the migration_serv
database_name is the tax
5. Configure the oracle network services listener, the configuration file is: listener.ora
Default Path: ORACLE_HOME \ network \ admin
Add the following:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = gateway_sid) (ORACLE_HOME = oracle_home_directory) (PROGRAM = tg4sybs))) gateway_sid are three options sid string
oracle_home_directory is the ORACLE_HOME
If the SYBASE is tg4sybs specific. If the other databases, will be different. Source: big-Microsoft certification exams test
Examples are as follows:
(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’s tnsnames.ora to be able to access sybase
connect_descriptor = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = host_name) (PORT = port_number)) (CONNECT_DATA = (SID = gateway_sid)) (HS = OK)) connect_descriptor the connection string, he was taken, usually sybs
host_name: oracle server’s name
port_number: oracle listen port
gateway_sid are three options sid string
Examples are as follows:
sybs = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dw-server1) (PORT = 1521))) (CONNECT_DATA = (SID = tg4sybs)) (HS = OK)) 8. to establish database link
Such as:
CREATE DATABASE LINK sybs CONNECT TO sa IDENTIFIED BY prient USING ‘SBYS’;
Can access sybase database.
Note that, sybase database table name, field names, if it is lowercase, then the time of the visit in the oracle where to add double quotation marks “”
Such as:
SQL> select “a” from “b” @ sybs;
Related Posts
- Pass4dumps Oracle 1z0-030 exam answers question
- Oracle announced a new line of specialty certifications
- Solve OracleDBConsoleorcl not start, Baocuo error