on 06-16-2008 11:40 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Where are you trying to configure that? Local PC? external database?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.