Re: SID enumeration help

From: EscVector <Junk_at_webthere.com>
Date: 13 Nov 2006 12:51:45 -0800
Message-ID: <1163451105.255472.297340@b28g2000cwb.googlegroups.com>

EdStevens wrote:
> schw wrote:
> > could you please then provide solutions for unix and winsows
> > seperately?
> >
> > cheers
> > paw
> >
> >
> > EdStevens napisal(a):
> > > schw wrote:
> > > > any OS, need to write a simple app in java working anywhere..
> > > >
> > > > two scenarios please
> > > > - all installed
> > > > - just those currently running..
> > > >
> > > > thanks!!!!
> > > >
> > > >
> > > > EdStevens napisal(a):
> > > > > schw wrote:
> > > > > > Hi All,
> > > > > >
> > > > > > apologies for trivial question...but i need help..
> > > > > >
> > > > > > it is possible to run few oracle databases on a single machine...how
> > > > >
> > > > > Yes
> > > > >
> > > > >
> > > > > > can I enumerate a list of SIDs?
> > > > > >
> > > > >
> > > > > What OS? In what environment do you need to do this? (ad hoc command
> > > > > line? shell script? etc?) All installed SIDs or just those currently
> > > > > running?
> > > > >
> > > > > > thanks for your help..
> > > > > >
> > > > > > best regards,
> > > > > > paw
> > >
> > > Maybe someone else can correct me, but I don't see how this can be os
> > > neutral. In Unix, each sid runs as multiple seprarate processes while
> > > in windows each sid runs as a separate, multithreaded service. In
> > > unix, the 'repository' of installed sids is the oratab file, while in
> > > windows it is in the registry.

>

> Please don't top-post.

>

> I'll leave the actual solution as an exercise for the student. Once
> you know where to get the raw information the solution is pretty
> trivial, though details will depend on your needs.

>

> For unix, As Steve pointed out, you can grep the oratab file (which is
> located in either /etc or /var/opt/oracle, depending on your flavor of
> unix) to get a list of installed sids. To get a list of currently
> running sids, play around with this:

>

> ps -ef | grep "pmon" | grep -v 'grep' |awk -F_ '{print $3}'

>

> For Windows, you'll have to poke around in the registry, starting with
> HKLM\software\oracle. Below that, I believe what your are looking for
> is somewhat version dependent. Take a gander with regedit to get a
> feel for what's there. When you know exactly what you are looking for,
> there are some windows APIs for reading the registry that I have used
> in the past, but I don't have any references handy. Search around on
> technet.microsoft.com

net start | find "OracleService"
this lists the running services.

PowerShell is the best way to walk the registry w/o api calls. Received on Mon Nov 13 2006 - 14:51:45 CST