Re: Listing Oracle Databases on Windows

From: Andreas Necker <Andreas.Necker_at_isb-ag.de.nospam>
Date: Mon, 03 Mar 2003 14:15:17 +0100
Message-ID: <7hkv3b.9av.ln@ftp2.intern.isb-ka.de>

Hi,

dan1999a_at_attbi.com wrote:
> 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.
>

you can get the service names with an NET START:

---

C:\>net start
Folgende Windows 2000-Dienste sind gestartet: ...

    OracleDEFAULT_HOMETNSListener
    OracleServiceTECD
...

---

 > Also, is there a way of doing this using PERL?  >
You can use the package "Win32::TieRegistry" for querying "HKLM\Software\Oracle\HOMEn".

hth
Andreas Received on Mon Mar 03 2003 - 07:15:17 CST