SAP Multiconnect to Oracle not working.

[Former Member]

Hi,

I am trying to do a multi connect to an external oracle database.

Our SAP is on SQL server and we are on ECC6.0 and I have done all the settings in DBCO and also all the settings based on the SAP Note 339092 - DB MultiConnect with Oracle as secondary database.

Still if I try to connect through native SQL I get the following error. Any Ideas?

Runtime Errors DBIF_DSQL2_CONNECTERR

Except. CX_SY_NATIVE_SQL_ERROR

Short text

Error setting up a secondary database connection

What happened?

Connection to database system not possible with identifier "SMQS".

Thanks and Regards,

Mahesh.

[former_member204746]

Have you installed dboraslib.dll in your kernel directory?

check dev_w* (where * is your dialog process number),.

You will get more info on your error.

[Former Member]

Hi,

Thanks a lot for the info.

I found out that it says

C CLIENT_ORACLE_HOME is not set as environment variable or

C DIR_CLIENT_ORAHOME is not set as profile parameter.

Then I set the CLIENT_ORACLE_HOME and then it did not give anything, but straight away called the semaphore cleanup function and restarted my workprocess and thus logging me off the system.

create_con (con_name=SMQS)

Loading DB library 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' ...

Library 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' loaded

Version of 'C:\usr\sap\DEV\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.167)

New connection 1 created

Connect to SMQS as smqs2 with ORCL.mason.makino.biz

Prepending C:\Oracle\Ora81 to Path.

call semaphore clean-up function ...

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

Any help?

Thanks and Regards,

Mahesh.

[Former Member]

Hi,

C:\Oracle\Ora81

That is the place where my oracle client is installed in the box, where my SAP is sitting.

Am I doing anything wrong here?

Thanks and Regards,

Mahesh.

[lbreddemann]

> C:\Oracle\Ora81

>

> That is the place where my oracle client is installed in the box, where my SAP is sitting.

>

> Am I doing anything wrong here?

Are you using the Oracle 8.1 client? For the current dbsoraslib-Libraries you'll need to use the Oracle 10g Instantclient instead.

Oracle 8.1 is loooong gone by now...

regards,

Lars

[Former Member]

Hi,

Thanks for the info. The Oracle database it is connecting to is Oracle 8.1, so I installed the client 8.1. Now can I connect DB 8.1 with the 10g client? In Zombie state now......

Thanks and Regards,

Mahesh.

[former_member204746]

try to connect from OS level to start out:

sqlplus username/password@SID

this MUST work before attempting playing with this at SAP level.

[Former Member]

Hi,

Thanks a lot. OS level SQL connect works fine.I suspect that dbaoraslib.dll needs client 10g or above like Lars has mentioned....but i am still not sure what to do. Any leads...?

Thanks and Regards,

Mahesh.

[lbreddemann]

Hi there,

why don't just use the search function here in SDN?

Looking up "Oralcle + instant client" brought up this one:

SAP Note Number: 998004 - Update the Oracle Instant Client on Windows

In general you should follow

SAP Note Number: 339092 - DB MultiConnect with Oracle as secondary database

for this requirement.

best regards,

Lars

[Former Member]

Hi Lars,

Thanks. If you see my first post, I have already mentioned that I have followed the SAP Note 339092. Once approval is given for upgrading the client, I would have definitely searched for the oracle client upgrade instructions.

I am very sorry If I have annoyed you.

Anyway, Thanks for the SAP Note for Oracle client upgrade, I will try to upgrade the oracle client and update you whether it is working..

Thanks and Regards,

Mahesh.

[lbreddemann]

> Thanks. If you see my first post, I have already mentioned that I have followed the SAP Note 339092. Once approval is given for upgrading the client, I would have definitely searched for the oracle client upgrade instructions.

>

> I am very sorry If I have annoyed you.

Hi Mahesh,

you did not annoy me - I just find that the available documentation and search facilities are largely underused. Therefore I try to "advertise" them a little bit...

Good luck with your installation!

Lars

[Former Member]

Thanks a lot.

[Former Member]

Hi,

After installing the instant client 10g, Multiconnect worked liked a breeze.....but in the process of installing the instant client, the deldbclient.vbs VB script did something to the system, now my J2EE is not coming up at all.

Looking into that. Thanks a lot.

Thanks and Regards,

Mahesh.

[former_member204746]

search on Google with keyword:

deldbclient.vbs