Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!eusc.inter.net!bnewspeer00.bru.ops.eu.uu.net!news01.triaton.com!dnewsfeed02.dtm.ops.eu.uu.net!dnewsifeed00.dtm.ops.eu.uu.net!bnewsifeed02.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!businessnews.de.uu.net!not-for-mail Date: Mon, 03 Mar 2003 14:15:17 +0100 From: Andreas Necker Organization: ISB AG User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: de,en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Listing Oracle Databases on Windows References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <7hkv3b.9av.ln@ftp2.intern.isb-ka.de> Lines: 32 NNTP-Posting-Host: 194.175.108.130 X-Trace: 1046703616 businessnews.de.uu.net 26143 194.175.108.130 X-Complaints-To: abuse@de.uu.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:178259 X-Received-Date: Mon, 03 Mar 2003 08:04:54 MST (news.easynews.com) Hi, dan1999a@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