Re: Getting a List of SIDs on a network.

Dear Faheem,

Patrick was convincing on his soapbox. And I concur. Equipping an application with so much of 'administrative' intelligence is like making the on-site DBA play on application's terms. Something that doesn't go down well with most of the 'indulged’ DBAs.

Yes, there may be ways, even though hacked, to discover all the Oracle services on a network segment. But the more primal question is: do you really need to that? Again, endorsing Patrick, the idea of customizable SQL scripts or, even better, the inclusion of comprehensive installation user guide is infinitely better option. This way you are taking the DBA, or the person acting for the job, in confidence and giving him necessary freedom of choice so that he/she could have local gameplans in place.

Now that was for a ‘normal business’ application.

If the application in question is some kind of Oracle DBA helper, developed to make the DBA task easier or customizable, then perhaps delving deeper into the OCI and Net* architecture would be the way to go. And I must admit this something I’ve never been to. So I leave it for the gurus….

My 1.25 Rupees' worth;)

Regards,

ATTA buckeye234_at_excite.com (Patrick) wrote in message news:<3bbfc440.0108020544.7a0ef71_at_posting.google.com>...
> Just thought I'd add my thoughts .....
>
> faheemrao_at_yahoo.com (FaheemRao) wrote in message news:<43b58913.0108010943.3a98264b_at_posting.google.com>...
> > 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).
>
> I appreciate your concern, I just wish it were possible.
>
> > 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,
>
> If a user doesn't know what a sid is, there is now way they are going
> to have the access to the database that allows them to create
> tablespaces, schemas or complete any 'administrative' type actions.
> Only the DBA's have that kind of access. Hence, it is not possible to
> avoid using the DBA's time.
>
>
> > 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.
>
> We have many different groups within our company. Each has these own
> a set of databases. For security reasons, they do not know about each
> others sids ( as much as we can realistically accomplish it). I would
> be vary weary of any application that tries to 'snoop' my network and
> discover any servers running Oracle listeners and then the sids that
> those listener were servicing. If I knew about it, I would not run
> that application. Period.
> >
> >
> One last thought and I'll climb down from my soapbox. I rather
> appreciate any application that delivers the database scripts seperate
> from the application installer. I prefer to comb through the scripts
> and make sure they follow our internal standards where possible. We
> have been bit by the application that create there own databases, with
> one tablespace, hmmm ... called system maybe, put all data and
> indexes into this tablespace and grant every role and system privilege
> under the sun to the application users schema. I am much more
> comfortable when I do the work myself, or like I said, can make sure
> the application's scripts are playing nice.
>
> Lastly, I agree with Billy's comment. Don't try too hard to make the
> application installer do something it probably shouldn't be doing in
> the first place.
Received on Fri Aug 03 2001 - 00:28:20 CDT