Re: Getting a List of SIDs on a network.

Thanks Billy ,

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:<9kapk8$7ns$1_at_ctb-nnrp1.saix.net>...
> "FaheemRao" <faheemrao_at_yahoo.com> wrote in message
>

  Thanks Billy

Well yes , If net8 is already Configured with all available Oracle Servers then there is no problem , But my application installer may need to Configure Net8 to connect to an Oracle Server , which has not been configured earlier, So in that case I need to go acroos the network and find out the available Oracle services. So any way I have an idea of using Oracle intelligent agent , which actually used by Oracle Enterprise manager , to Discover Services.

Ok I may explain you what Discover service does, In oracle Enterprise manager there is a Functionality called Discover New Services. It actually Discover the Services on a network on those machine on which Oracle Intelligent agent is started. I am think so(may be wrong) that oracle agent does something like Oracle Listener on a different port than 1521(listener's stanfdard port) and Oracle Enterprise Manager goes to that Port and pick up the Oracle Service Name form Oracle Intelligent agent. Oracle is keeping that Port secrete( atleast I dont know).

So what I need to do is find out that Port and do the same thing.

thanks a lot Billy for your help.

Faheem

> > 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.
>
> The easiest would be to retrieve the list of available Oracle db connections
> from the local TNSNAMES.ORA file. Assuming of course that this file had been
> configured with a list of valid local connections.
>
   

> > Now in this case Tnsnames.ora file may not have that information
> > unless net8 is already configured to connect to that database.
>
> Yes. In which case the only other option I think is using Oracle Name Server..
> in which case you need to have SQLNET.ORA configured correctly to access the
> Name Server.
>
> It's a catch 22 if there is nothing configured in SQLNET.ORA or TNSNAMES.ORA.
>
> > 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 ????
>
> Let me admit my biggest sin - not using Oracle Enterprise Manager. I tried
> version 1.0 many years ago. Hated it. Looked like crap. Worked like crap. Lacked
> support for OPS. Wrote my own customised enterprise OPS manager (based on the
> SQL-Server's Enterprise Manager GUI) and have been using that since '96. So I
> have NO idea what the "discover new services" are about. :-)
>
> At protocol level, what you can do is scan for well known listener ports on an
> IP address range and hope that you pick up the listeners like that. Very much a
> hack though. And I'm not sure if you can then interrogate the listener for the
> SIDs that it supports. I honestly think that such an attempt is not worth it.
>
> From an application perspective - you must assume that
> a) SQL*Net is installed
> b) optionally that SQL*Net is configured (TNSNAMES & SQLNET ora file)
>
> If (a) has not been done, there is little your application (or Installer) can do
> to rectify it. If (b) is not done, you can allow the user to define a new
> connection pretty much the same way that silly SQL*Net Client Config tool does -
> you prompt for port, SID and hostname and create a TNSNAMES.ORA entry. Much more
> than that and you will spend more time developing for something that should not
> be the focus of your application or installer.
>
> My 2'c on the subject. :-)
Received on Thu Aug 02 2001 - 13:15:04 CDT