Enumerate all Oracle databases on the net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

SQLDMO gives you a way to enumerate all SqlServer databases on the network
and for a given server, all databases on that server.

Is there a way to do this for Oracle?
 
David,

The short answer is: Oracle does not provide any such capability.

What we would really be looking for is a way to enumerate all TNS Listeners
on a network, then query each listener to find the instances that are being
serviced - but such is not an API that is provided.

The closest thing available is the OracleAgent service - but it is not
documented.

regards
Roy Fine
 
That's what I was afraid of - thanks

Roy Fine said:
David,

The short answer is: Oracle does not provide any such capability.

What we would really be looking for is a way to enumerate all TNS Listeners
on a network, then query each listener to find the instances that are being
serviced - but such is not an API that is provided.

The closest thing available is the OracleAgent service - but it is not
documented.

regards
Roy Fine
Click to expand...
 
Back
Top