Home » Other » General » Question regarding database URL (oracle)
Question regarding database URL [message #488259] Wed, 05 January 2011 23:10 Go to next message
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 #488263 is a reply to message #488259] Wed, 05 January 2011 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If your version allows it (ALWAYS post your Oracle version, with 4 decimals), use Easy Connect Naming Method.

Regards
Michel

Re: Question regarding database URL [message #488394 is a reply to message #488259] Fri, 07 January 2011 00:45 Go to previous message
Frank
Messages: 7892
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)
Previous Topic: Process steps for DBA at day first
Next Topic: DB Down with the alert java.sql.SQLRecoverableException
Goto Forum:
  


Current Time: Sun Aug 07 16:57:44 CDT 2022