64 bit SAP to 32 bit External Oracle Database connectivity failing

[Former Member]

Dear All,

We are trying to connect to an external Oracle database thru DBCON method. We are able to connect to Oracle server from our IDES server which is a 32 bit server, but when we are trying to connect our development server which is a 64 bit server, the connectivity is failing.

we copied the correct 64 bit *.lib file to the SAP server but still same result. We are getting the error message - Work Process restarted. Session terminated.

the Oracle server we are trying to connect is 32 bit, can this create some problem ?

kindly any one help us in this reagrd.

thanks in advance,

Saurabh.

[former_member204746 · Accepted solution]

using the 64-bit version of file dboraslib.dll WILL NOT resolve your issue.

you need to 32-bit version of this file.

to test out connectivity, us this:

sqlplus system/password@DEV

this MUST work before attempting DBCON tests.

[Former Member · Accepted solution]

Hi Eric,

thanks for the advice but I am a bit confused as where to execute that sqlplus command/query ?

in the Oracle server or from SAP and what does system/password@DEV means ??

can you elaborate on this please.

here i would like to add that we have connected to the external Oracle server using linked server approach of MS SQL (our SAP default database) and so our connectivity is happening till SQL level i.e. I am able to connect to the Oracle and query it using OpenQuery syntax. the problem is appearing when I am trying to connect from the ABAP level.

kindly suggest as to what can be the solution of this issue.

thanks

Saurabh.

[former_member204746 · Accepted solution]

on your SAP server, open a windows command prompt (or unix shell).

run program sqlplus:

sqlplus system/password@DEV

system: is the username

password is the assigned password (manager is the default)

DEV is the SID you are trying to conenct to.

[Former Member · Accepted solution]

Hi Eric,

sqlplus system/password@SID works, I am able to login into oracle from our 64 bit server with this command and able to select data from the external Oracle database tables.

I have doubts on the version of the dboraslib.dll file to be used. Is this doubt correct ??

I would like to reiterate that connectivity session terminates, we are not getting dump error.

So this means connectivity is there and ABAP is trying hard to fetch the data.

can any help be provided on this ?

Regards,

Saurabh.

[former_member204746 · Accepted solution]

dboraslib.dll must match your kernel version and it 32/64 bit version too.

if you use dboraslib.dll made for Basis 6.40 and using Netweaver 7.0, this will not work.

if you use dboraslib.dll made for Netweaver 7.0 in 64-bit mode and using Netweaver 7.0 in 32-bit mode, this will not work.

check trace file dev_rd for more clues.

[Former Member]

hi saurabh,

your Oracle Server (32 bit) was installed on 64 bit server ? Am I right ?

Please mention it more clearly.

ardhian

http://sapbasis.wordpress.com