cancel
Showing results for 
Search instead for 
Did you mean: 

Connection with external oracle database

Former Member
0 Kudos

Hi,

I must connect to an external Oracle database, I work with SAP Netwaver 7.4s. I installed the Oracle client, set the ernvironment variables

ORACLE_HOME -> E:\oracle\ora92

NLS_LANG -> SPANISH_SPAIN.WE8ISO8859P1

ORA_NLS33 -> E:\oracle\ora92\ocommon\nls\ADMIN\DATA

TNS_ADMIN -> E:\oracle\ora92\network\ADMIN

I created an DBCON entry for the connection and I use it un my program, but when I try to execute the program it shows me the next error:

The connection identifier points to the data in the table DBCON

needed to establish a connection to the database system in the

context of the multi-connect. However, there is no entry

with the key "M".

What else must I do?

Thank you.

Cris.

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

login as SIDadm on your server at OS level and test connectity:

sqlplus MED_RIESGOS/YoUrPaSsWoRd@MLABD

this MUST work before trying to connect with DBCON. if this does not work, configure tnsnames.ora properly.

what database do you use for your SAP system? Is it also Oracle? MS-SQL? if not Oracle, you must install dboraslib.dll in the kernel directory.

Former Member
0 Kudos

Hi,

I can login with

sqlplus MED_RIESGOS/YoUrPaSsWoRd@MLABD

But I don't know what database use my SAP system, Do you know how can I know if my SAP system is working with an oracle database?

Thankyou.

Cris.

former_member204746
Active Contributor
0 Kudos

in the kernel directory, you must find file DBORASLIB.DLL for DBCON to work.

Former Member
0 Kudos

Hi,

I can't find the dboraslib.dll in my system, where can I get it? I'm a newbie and I don't know what you mean with kernel directory, which is this directory?

Thankyou!!

Cris.

former_member204746
Active Contributor
0 Kudos

go at http://service.sap.com/patches , navigate through your SAP vesion and go in the database dependant section, in sub-section ORACLE and download the file.

or better yet, ask your basis to do the job for you.

Former Member
0 Kudos

Hi,

thank you, I think that i'll ask my basis.

Thankyou very much.

Cris

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

please provide all fields contants in table DBCON.

Here's an example I use

PLMDB

ORA

PLM_USER

V01/0018ZctvSB67W5hXxdddddddddddddlJw==

PLMDEV

X

0

0

Former Member
0 Kudos

Hi Eric,

There's my fields content in DBCON:

CON_NAME -> MLABD

DBMS -> ORA

USER NAME -> MED_RIESGOS

PASSWORD -> V01/0050ZctvSB67Wv1K30ZVdVk+OygMtg3Ti4TIZqsQ3cKT

CON ENV -> MLABD

DB RECO ->

MAX CONNECTIONS -> 0

OPT CONNECTIONS -> 0

Thank you!

Cris.