Two Laptop Bag*
The moose likes JDBC and the fly likes sid in jdbc oracle connection string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sid in jdbc oracle connection string" Watch "sid in jdbc oracle connection string" New topic

sid in jdbc oracle connection string

felix thomas
Ranch Hand

Joined: Jun 10, 2001
Posts: 89
could any one tell me what sid is in jdbc connection parameter.
i have oracle81 installed in win98 where can i find the SID of my table names INVOICE.
i am getting a network adapter error while connecting to oracle database.
Rodney Teggins

Joined: May 06, 2002
Posts: 10
From memory this is the DB name. Sould be in the TNSNAMES.ORA or similar file which I think is in NET or NET8 directory. It should be something like ORCL... make sure the TNSListener service is running..
Hope this helps
felix thomas
Ranch Hand

Joined: Jun 10, 2001
Posts: 89
could anyone help me with sid.

where to find it in oracle8.1.5 and what entries should it contain.
the name of the database i use is invoice.
it is showing network adapter error could not open connection
Please help
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17257

Either do a find on your computer for your tnsnames.ora file, or go to your oracle directory
mine is in
Open this file in a text editor. Find your entry for this database that you use to connect to, and the first part is the sid name.

(SERVICE_NAME = myServiceName)

DATA_SID would be the sid in the above example from the tnsnames.ora file.
I don't mean to be rude in the following statement, so please don't take it that way. If you don't know what a sid is, you might want to ask your DBA. If you don't have a DBA, who is managing your Oracle server? go to that person.

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: sid in jdbc oracle connection string