Re: How to determine all the instances on a server

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Tue, 16 Jun 1998 13:44:34 +0200
Message-ID: <35865AA2.135B@mail.esrin.esa.it>

You can enter O/S commands from within sql*plus by prefixing with !

Randy Watts wrote:

I was looking for a command that you could enter from within an SQLPLUS session so that you could do connects to different instances.
Is there something like that for oracle? Sybase has a command "sp_helpdb" that can be entered from within a sql session that returns all the instances currently running on a server. Albert Borrull wrote:

> This is OS dependent. For instance:
>
> Netware 4.X: display oracle status
> Unix: ps -el | grep -i dbwr
> NT: see control-panel -> Services
> ....
>
> Randy Watts <wrwatts_at_pacbell.com> escribió en artículo
> <358004A6.B1306F71_at_pacbell.com>...
> > Is there a select statement or system command dimilar to sysbase's
> > sp_helpdb
> > that you can use to determine all the instances running on a
particular
> > server
Received on Tue Jun 16 1998 - 06:44:34 CDT