net start | grep OracleService
will list all running Oracle instances in form of OracleServiceXXX where XXX is
SID. grep is to be obtained elsewhere (GNU). To find names for ALL (including
idle) instances you will have to write your own service lister. You may also
want to browse LISTENER.ORA file - it should have all instances listed (at
least those for which tns listener provides transport).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
<theo.verbinnen_at_mail.be> wrote in message news:3c73b264.93070808_at_news.tiscali.be...
> exactly
> On Wed, 20 Feb 2002 11:58:16 +0100, "koert54" <nospam_at_nospam.com>
> wrote:
>
> >I'm guessing this is for usage in a script ?
> >
> ><theo.verbinnen_at_mail.be> wrote in message
> >news:3c73780b.78134421_at_news.tiscali.be...
> >> hi all,
> >>
> >>
> >> does anyone know of a way to determine the different instances that
> >> have been created on an NT box ?
> >>
> >> the oradim command does not allow to do a list of the already created
> >> instances
> >>
> >> Many thanks for your help
> >>
> >>
> >
> >
>
Received on Thu Feb 21 2002 - 05:11:48 CST
