SAP BI on SQL-Server with DB-Connect to Oracle Database

[Former Member]

Hi, Everybody.

I have a question.

I'm trying to configure the DB Connect to extract data from a Oracle Database (NON-SAP data) to our BI System (Windows + MS.SQL Server).

I've installed the Shared Library "dboraslib.dll" in the run directory and I've already installed the Oracle Client.

The problem is to Set the variable DBMS_TYPE which value it must has ?

DBMS_TYPE=mss --> (This is the current SAP Database)

DBMS_TYPE=ora --> (This is the Database that I want to connect to)

DBMS_TYPE=mss;ora ---> Am I mad ??

I've configured the TNS_ADMIN variable as well as NSL_LANG.

When I try to create the connection the process dies in GET_CONNECTION method.

Regard.

Andrew.

[lbreddemann]

> The problem is to Set the variable DBMS_TYPE which value it must has ?

> DBMS_TYPE=mss --> (This is the current SAP Database)

> DBMS_TYPE=ora --> (This is the Database that I want to connect to)

> DBMS_TYPE=mss;ora ---> Am I mad ??

Nope, just badly under-informed.

Why not check the documentation and the notes?

SAP Note 339092 DB MultiConnect with Oracle as secondary database

is the one you're looking for!

regards,

Lars

[Former Member]

Hi Lars,

Thanks for the data. I've already read this note and configure all this parameters. But when I'm executing the Create Source System in the BI system the process dies.

If I look into the logs I see this:

M call semaphore clean-up function ...

M ***LOG Q0E=> DpSigGenHandler, Exception (c06d007e) [dpnttool.c 432]

That's the reason why I start guessing about other possible problem.

Regards

[lbreddemann]

I look into the logs I see this:

>

> M call semaphore clean-up function ...

> M ***LOG Q0E=> DpSigGenHandler, Exception (c06d007e) [dpnttool.c 432]

>

> That's the reason why I start guessing about other possible problem.

STOP guessing and open a support message instead!

This issue above is on a totally different page than setting up a secondary db connection.

regards,

Lars