A Way to List Oracle Server Instances
554523Jan 4 2007 — edited Jan 5 2007Hello:
I'm trying to find if there is a way to enumerate the Oracle instances that exist on a given physical machine. I want to do this programatically (C++). Of course, this is easy with SQL Server since there is the SQLDMOServer2 COM interface through which you can call "ListInstalledInstances()".
Is there anyway to do this for Oracle? I realize that there probably won't be any kind of interface built into Windows MDAC components...but is there any option at all? So far, all of the documentation I have seen gives plenty of examples of using "OraSession" and so on. But, you have to know what you are looking for / connecting to first. What I really need is a way to first enumerate the Oracle Instances that are available and then a way to enumerate the Databases in each.
Any help would be appreciated.