Re: Oracle SQLPLUS Question.

From: Steve Long <steven.long_at_erols.com>
Date: Sun, 8 Apr 2001 16:20:17 -0400
Message-ID: <9aqhao$ppn$1@bob.news.rcn.net>

try this:

find / -name init*.ora -print 2>&1 | grep -v denied

if you are logged in as root, you can skip everything starting a 2> to the end and just run the find command starting at /.

every oracle instance requires an initialization file, usually called initSID.ora where SID is a unique identifier of the instance. you can also check for a file named oratab, usually /etc/oratab and see what is in there, as well as looking in dbstart and dbshut.

the ps -ef only works if the database is running.

"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 - 15:20:17 CDT