I am very new on this oracle gateway for sybase, I try to create dblink from oracle EBS to sybase,
Is there any step before or after this installation step:
Oracle Universal Installer: Available Product Components
a. Select Oracle Database Gateway for Sybase 188.8.131.52.0.
b. Click Next.
Oracle Database Gateway for Sybase
Sybase Database Server Host Name - Specify the host name of the machine hosting the Sybase database server.
Sybase Database Server Port number - Specify the port number of the Sybase database server
Sybase Database Name - Specify the Sybase database name
Click Next to continue.
Must we install some sybase client or maybe configure some file before and after install?
If you have installed the DG4Sybase then you do not need to install any Sybase software.
The information requested during the install is used to created a init<sid>.ora file which is thne used by the gateway to connect to the Syabse database.
You can put in dummy information and then manually change it when the install is completed.
You also say you have installed Dg4Syabse 184.108.40.206 but it would be better to install and use the latest 220.127.116.11 version as suggested by Klaus in your other thread -
The latest software release is currently 18.104.22.168 and it can be downloaded (and installed from scratch) from "My Oracle Support". Just open the Patches & Updates section, look for Patch 10404530: 22.214.171.124.0 PATCH SET FOR ORACLE DATABASE SERVER and make sure to choose the platform you want to use. Then check out the readme as it lists which of these download CD's contains the gateway software.
BTW, the CD contains DG4ODBC and DG4SYBS and it is up to you to decide during the installation which product you want to use.
Edited by: mkirtley on Oct 22, 2012 8:12 AM
I had an experience configuring database gateway for Sybase. After the installation, you need to configure 4 thinks.
1. listener on the gateway side
2. create init.ora parameter on the gateway
3. create database link on the db that will connect to sybase
4. add an entry in tnsnames.ora on the database side
Hope this helps.