Getting Oracle SID from TNSNAMES.ora file
360295Oct 18 2004 — edited Oct 20 2004I 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...