on 10-02-2008 4:17 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
please provide all fields contants in table DBCON.
Here's an example I use
PLMDB
ORA
PLM_USER
V01/0018ZctvSB67W5hXxdddddddddddddlJw==
PLMDEV
X
0
0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.