Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sid in jdbc oracle connection string

 
felix thomas
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic