Are there tools API's provided by Oracle that allows us to
1) Find list of all oracle instances on a server like "db2list"
command in "DB2".
2) Get Configuration parameters for an Oracle Instance.

I wanted to do it programmatically so that my program is OS
independent.

Thanx & Regards
Vikash Kumar

vikash_kumar (AT) persistent (DOT) co.in (Vikash Kumar) wrote in message news:<75444dd.0409130056.900ee61 (AT) posting (DOT) google.com>...
Hi,
There are API's provided by various database driver specifications
like OLEDB/JDBC.
For example u can use OLEDB , you can call
IDBSchemaRowset::GetRowset() by setting DBSCHEMA_SCHEMATA. It will
list all table schemas.

Using JDBC, you can get database metadata by calling getSchemas() in
java.sql package. Ex: After getting the connection u can call
Connection.getMetaData() which returns DatabaseMetadata. Then using
that call
DatabaseMetadata.getSchemas() which returns a Resultset containing all
schemas.


Oracle also stores the information in system tables. You can query the
tables o get information

Regards
Zunil
Cordys

Hi sunil,

First of all let me thank u for your help. And actually i needed
a bit more, see i can get the details of the schema its fine that also
i needed but before that i need to know which INSTANCE of Oracle to
connect and query for schemas on the server.

My first n foremost need is to find out all instances running on a
server. So that i can query them for more information.

Ur valuable comment is awaited.

Regards,
Vikash

Vikash Kumar wrote:

Why don't you look at the "oratab" file or a "ps -ef | grep pmon "?

Dick.