File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sid in jdbc oracle connection string" Watch "sid in jdbc oracle connection string" New topic
Author

sid in jdbc oracle connection string

felix thomas
Ranch Hand

Joined: Jun 10, 2001
Posts: 89
hi,
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
Greenhorn

Joined: May 06, 2002
Posts: 10
hi,
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
Rodney
felix thomas
Ranch Hand

Joined: Jun 10, 2001
Posts: 89
hi,
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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17259
    
    6

Either do a find on your computer for your tnsnames.ora file, or go to your oracle directory
mine is in
c:\oracle\ora81\network\admin
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.

DATA_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database.blah.com)(PORT = 1521))
)
(CONNECT_DATA =
(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.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: sid in jdbc oracle connection string