cancel
Showing results for 
Search instead for 
Did you mean: 

db connection string to ORACLE

Former Member
0 Kudos

HI.

I try to configure connection to ORACLE db. I use db connect,

DB Connection: name

DBMS: ORA

User Name: login

DB password: password

Conn. info: here I should put connection string, how this connection string look?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Dariusz,

you have to use the Oracle Network name as connect string. If your database SID is ABC, your Listener is configured as ABC.<domain>, your tnsnames.ora file contains an entry ABC.<domain> and your sqlnet.ora file contains a line NAMES.DEFAULT_DOMAIN = <domain>, you could simply use ABC as connect string. Replace <domain> by world or your Oracle Network domain name.

Best regards

Ralph

markus_doehr2
Active Contributor
0 Kudos

Where are you trying to configure that? Local PC? external database?

Markus

Former Member
0 Kudos

I tray to to connfigure on local PC. I was configure this same connection to MSSQL later, and I have'nt problem. Naw I tray to configure connection to ORACLE and I have problem with connection string

markus_doehr2
Active Contributor
0 Kudos

You're trying to connect via ODBC?

Markus

Former Member
0 Kudos

No. I configure in SAP BW. I use transaction DBCO to put new connection to db.

markus_doehr2
Active Contributor
0 Kudos

You need to

- install the Oracle client for the database you plan to connect to

- install the dboraslib for your platform on your server in the kernel directory

did you do that?

Markus

Former Member
0 Kudos

Hi,

check Note 518241 - DB Connect in BW for an external Oracle database

regards,

kaushal

Former Member
0 Kudos

Yes I instaled dboraslib on SAP BW server, and on this server I have ORACLE CLIENT.

Former Member
0 Kudos

Hi

Please do all the settings related to oracle configuration files before checking and applying this note i.e. configure tnsnames.ora, listener.ora.

Use Transaction DBCO to maintain table DBCON. The F1 help in transaction DBCO provides you with an explanation regarding the general meaning of the fields. The meaning of the fields in the Oracle environment is explained below:

Connection name Logical name of the connection

DBMS ORA

User name Oracle user

DB password Password for the Oracle user mentioned above

Conn.info TNS alias

Permanent Should not normally be set for a secondary connection.

Please check the note 339092.

Former Member
0 Kudos

It was a problem with version of dboraslib.dll