| Question regarding database URL [message #488259] |
Wed, 05 January 2011 23:10  |
 |
sakhytech99
Messages: 1
Registered: January 2011
Location: US
|
Junior Member |
|
|
Hi there,
I would like to know, what is database url mean in oracle for example,
database url:
jdbc:oracle:thin@OR900....:1540:OQ0900
userid/psswd : xyz/xyz
DBA has given these details instead of tns entries, to connect to oracle
i am just wondering how to deal with this in sqlplus or sqlcommand prompt.
i tried sqlplus by entering url in host string and username and psswd. but it wont work.
Any insight on this?
Thanks,
|
|
|
|
|
|
| Re: Question regarding database URL [message #488394 is a reply to message #488259] |
Fri, 07 January 2011 00:45  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
This is a jdbc url that is used to connect jdbc-driven tools to the database. (e.g. SQL Developer).
From it, you can extract the elements you need to fill in your tnsnames (if they support that)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
