sid in jdbc oracle connection string

[felix thomas]

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]

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]

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]

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