Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting Oracle SID from TNSNAMES.ora file

360295Oct 18 2004 — edited Oct 20 2004
I am writing a visual basic application that pulls information from an Oracle database. I would like to be able to pull the names of the different Oracle SIDs from the TNSNAMES.ora file so that the user can choose which database to log into. Is there an easy way to do this?

Is this data stored in the registry anywhere or would I have to parse the TNSNAMES.ora file to get the info. Also, what about the issue of having multiple Oracle homes? If multiple Oracle homes exist on the computer, the location of the TNSNAMES.ora file would be different.

Any input would be greatly appreciated! Thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2004
Added on Oct 18 2004
9 comments
356 views