This discussion is archived
2 Replies Latest reply: Oct 24, 2012 7:47 AM by gonzroman RSS

Need client sybase before/after install oracle gateway?

JoeSSI Newbie
Currently Being Moderated
Dear All,

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 11.1.0.6.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?

please help

Regards

JOE
  • 1. Re: Need client sybase before/after install oracle gateway?
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi Joe,
    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 11.1.0.6 but it would be better to install and use the latest 11.2.0.3 version as suggested by Klaus in your other thread -

    The latest software release is currently 11.2.0.3 and it can be downloaded (and installed from scratch) from "My Oracle Support". Just open the Patches & Updates section, look for Patch 10404530: 11.2.0.3.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.

    Regards,
    Mike

    Edited by: mkirtley on Oct 22, 2012 8:12 AM
  • 2. Re: Need client sybase before/after install oracle gateway?
    gonzroman Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points