This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.
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
Joined: Jun 10, 2001
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
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 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