Re: Getting a List of SIDs on a network.

Thanks a lot Billy
You are the Only person who understand my problem correctly.:)

Now Actually I am want to popoulate a list of different SIDs in my application installer.
My application use Oralce Database Now I am trying to Minimize the need of DBA at time of installing my application at client's machine(s).
So now the Person Installing may even dont know what SIDs is . So I need to Populate different SIDs available on that Network(client's Network)and Display these SIDs to User as available Databases on that network.
User selects one SIDs then My application installer will logon as administrator and create tablespace and schema stuff on that database, and configure Net8 to connect to that specific database. So this is the whole story behind it.
Now in this case Tnsnames.ora file may not have that information unless net8 is already configured to connect to that database.

Now your second solution may seems to be good , but it is not necessary that Client have Oracle name server Configured and running , and each listener is registring its SID to oracel Name server.

I have any Idea about it , but I am not clear. I want to use the method which Oracle Enterprise manager does in "Discover New Services" , But I need to do it through My application, its mean I need to know excatly which API is used for this Purpose. Any Ideas ????

Any help would be appreciated.

Thanks

Faheem

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:<9k5i04$kca$1_at_ctb-nnrp1.saix.net>...
> "FaheemRao" <faheemrao_at_yahoo.com> wrote in message
>
> > How I can get a list of SIDs on a local network,
> > I know that Oracle Installer does that but How that
> > I dont Know.
>
> It does? You are not refering to the locally installed database and assuming
> that the ORACLE_SID environmental variable has been set?
>
> > I need this because I need to Populate a list of Different
> > SIDs on a Network in my Application Installer.
>
> There are two ways to get a list of database system id's (SIDs - not to be
> confused with Session ID's which are also called SIDs for some twisted job
> protection kind of way). One is to look at the local TNSNAMES.ORA file. The
> other option is to use Oracle Name Server (assuming that all the database
> listeners are registering their SIDs with the Name Server). The OCI I believe
> provides calls to retrieve information from these.
>
> Maybe if you tell us why you want a list of SIDs and exactly what you are trying
> to do, we can come up with a suggestion or three?
Received on Wed Aug 01 2001 - 12:43:36 CDT