DB Connect BW on DB2, external system Oracle

[Former Member]

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

[sven_mader2 · Accepted solution]

Hi,

You must install a oracle client

Sven

[Former Member · Accepted solution]

Hi,

as our basis team is swamped at the moment, I have not yet had the client installed, and not been able to try the connection. I'll post back and close the thread or post more questions once I get the Oracle client installed.

Thanks for the feedback, all of you.

Regards,

Øystein

[desgallagher · Accepted solution]

Hi

Yes you need to install the Oracle Client information. In the SAP 518241 it is explained in detail how to set up the

connection. The note also contains information on known problems.

Best Regards,

Des Gallagher

[Former Member · Accepted solution]

Hi,

and thanks for the answers.

Now I have the oracle client installed on the BW server, and the dbsoraslib library has been copied to the BW run directory. But any attempt to connect to the system just gives me the error "No shared library found for the database with ID AGRESSO"

(I get ths error no matter what I input when trying to set up the connection, also if I intentionally gives wrong ID and/or IP)

I'm wondering if my input is the problem, and then, what would be correct.

My tnsnames.ora looks like this

AGRESSO =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = xxx.xxx.xxx.xxx)(Port = 1521))

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = xxx.xxx.xxx.xxx))(Port = 1521))

)

(CONNECT_DATA =

(SID = db06)

)

)

(edited out ip adress)

When creating the connection I give

Logical system name "AGRESSO",

source system name I assume I can give whatever here.

Type and release I leave blank.

Next screen I give:

DB Connection: AGRESSO (Can not be edited)

DBMS: ORA

Username/passord as given by the server admin

Conn. info I have tried many different inputs. AGRESSO, the IP adress, the SID (db06), but no luck.

Anyone have any knowledge about what to give as input? (if the tnsnames.ora is lacking information etc)

Thanks for any input.

Regards,

Øystein

[Former Member · Accepted solution]

Anybody have any clue?

Since I just keep getting the error "No shared library found for the database with ID AGRESSO" I'm guessing that BW is not pickup up that the Oracle client is installed on the system.

Do I need to use a user with a certain username etc, or configure something so that my BW system will try to connect and not just throw this error message?

Any help is appreciated.

Regards,

Øystein

[sven_mader2 · Accepted solution]

Hi,

Did you red the SAP note 518241?

First, please check the connection on the operation system, then in BW.

Sven

[Former Member · Accepted solution]

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

[Former Member]

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

[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.