Re: Listing Oracle Databases on Windows

"Bill Davison" <wdavison_at_fpcc.net> wrote in message news:<3e62a8bc_at_news.starnetinc.com>...
> Since each database in Windows has its own service, you can search for
> service names. There's a command line utility in the Windows 2000 Resource
> Kit called Service List (sclist.exe). I can email it to you off list if you
> like, size is only 6KB. One caveat - depending on how you shut down your
> databases it's possible for the database to be down even though its service
> is still running.
>
> Finding the Oracle home for each DB is trickier, I think the only answer is
> to pull it out of the registry. There are probably some add-on Perl
> packages you can download for this. On Windows 2000 I think you're looking
> for
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleService<your_sid>
> \ImagePath. There's another windows resource kit tool called regdmp.exe
> that you can use instead of Perl, but it spits out everything under
> OracleService<your_sid>, so you'd have more output than you want.
>
> <dan1999a_at_attbi.com> wrote in message
> news:yVj8a.310694$HN5.1353446_at_rwcrnsc51.ops.asp.att.net...
> > Hi Oracle DBAs,
> >
> > In UNIX, to get a list of Oracle databases on a server, I do this in my
> > script:
> > grep ^[A-Z,a-z] /etc/oratab
> >
> > Is there a way that I can script out getting a list of Oracle databases
> > and its Oracle Home in a Windows environment?
> > I'm trying to write a script that
> > will run for each Oracle database on a server.
> > Also, is there a way of doing this using PERL?
> >
> > Thanks in advance.
> >
> >

Bill,

I was hoping to find such a tool at:
http://www.microsoft.com/windows2000/techinfo/reskit/tools/default.asp

where microsoft provides a subset of W2K Resource Kit tools. Its not there. Might just have to shell out the bucks to get the Resource Kit.
The Professional version is only $38.25 on bookpool. The Server version lists at $299 - discounted to $164.95, but out of stock.
That's too steep for me.

As sclist appeared to only provide details as to services that are running, I think that a simple "net start" command could provide the same info.

If one dumps out a "system info report" (w2K) aka "diagnostics report" (nt4) one could parse the contents of that, but again, the tool to create such a report in a command line fashion is part of the resource kit. This report tends to have all services - whether started or not - listed.

other thoughts:

If the server is configured in an OFA fashion,

1. examine all of the password file names in each %ORACLE_HOME%\Database
2. examine all of the ifiles names in each %ORACLE_HOME%\Database
3. examine all of the folders under %ORACLE_BASE%\Admin

guess that isn't much help.

Paul Received on Mon Mar 03 2003 - 00:19:49 CST