Skip to Content
author's profile photo Former Member
Former Member

DB Connect BW on DB2, external system Oracle

Hi all,

I'm trying to set up a connection between my BW system which is running on DB2 on AIX, and an external system running Oracle 9.x also on AIX.

When I try to create the connection I can choose ORA - Oracle in the DBMS field, but according to other threads I have seen, we also need to have a tnsnames.ora file on the following location on the server /oracle/SID/920_64/network/admin, but this directory does not exist, and according to my basis guy this is created once we install an Oracle client on the server.

Does anybody know if this is necessary, or can we just create the folders and add a tnsnames.ora file with the connection info?

If anybody has any other useful ideas, please let me know. I have read some how-to guides, and as far as I can see, the shared database library is installed, since I can select ORA in the DBMS field when setting up the connection.

Thanks for any reply

Regards,

Øystein

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 19, 2010 at 02:04 PM

    Hi,

    You must install a oracle client

    Sven

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Sven Mader

      Hi,

      testing the connection with "tnsping" in not available, this is not part of the installation of our oracle client... Perhaps we have installed the incorrect file?

      But trying to run a telnet to the source system shows that the connection is established.

      The oracle client was downloaded by a our database admin from oracle's website, if this also can be found on service.sap.com please guide me in the correct direction, as I have not been able to find any myself...

      Any advice is appreciated.

      Regards,

      Øystein

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2010 at 12:08 PM

    Hi,

    As far as i know, it is mandatory to have tnsnames.ora file. with that there is no possible way to get the connectivity.

    U have to maintain the tnsentry in that file and need to check with tnsping. once the readability is available, then u will be able to create source system..

    Incase of any issue please get back to me.

    Regards,

    varaprasad

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      A default tnsname.ora is created, at the above location, when you install the Oracle instance, now if you want to add more servers/instances to it you have to create entries in this parameter file (entries have to be made in a way similar to that of default server). After the entries are added, sometimes it might not be able to pick it up correctly & hence does not provide you a link to connect to the new server. So, in that case mostly restart of the instance corrects it.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.