Re: Listing Oracle Databases on Windows

On Sun, 02 Mar 2003 09:11:58 GMT, <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.
>
>Also, is there a way of doing this using PERL?
>
>Thanks in advance.
>

You would probably need VBscrpt to call the Windows API to retrieve a list of appropiate services.

A database in sqlserver equates a schema in Oracle. Your post distinctly smells of having way too many instances on a server

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Mar 02 2003 - 10:51:02 CST