Re: Oracle SQLPLUS Question.

From: Brian McKerr <bmckerr_at_hotmail.com>
Date: Sun, 8 Apr 2001 21:43:43 +1000
Message-ID: <9apith$1jtc$1@corolla.OntheNet.com.au>

Each instance of oracle is its own entity and does not implicitly know of any other oracle instances running on the same server.

Mysql is completely different in that there is 1 group of database processes and they can talk to how ever many mysql databases you have on that server.

So ...

the only way you can be sure from SQLPLUS is to shell out and do something like 'ps -ef | grep pmon'

this will show you all currently running oracle instances on the server (there may be others that are down !) you then have to decide how to "talk" to them yourself ... via a DB link or via perlDBI etc etc etc

this tends to be a very flexible approach IMHO.

HTH Brian.

"Roland Dunn" <roland_dunn_at_hotmail.com> wrote in message news:hYXz6.110$fG3.31594_at_news2.cableinet.net...
> Hi,
> Does anyone know the command to use in SQLPLUS (Linux and Oracle 8.1.6) to
> find what databases are present in an oracle installation?
> In MySQL the command is "mysqlshow" - is there something similar in Oracle
> SQLPLUS?
>
> If you do reply could you possibly cc me at roland_dunn_at_hotmail.com?
> Thanks if you do reply.
>
> Cheers Roland.
>
>
>
>
>
Received on Sun Apr 08 2001 - 06:43:43 CDT