Re: instance / db

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/27
Message-ID: <397fa073$1@news.iprimus.com.au>#1/1

"SP" <sdpant_at_yahoo.com> wrote in message news:YvJf5.65$R87.6543_at_sjc-read...
> select * from v$parameter;
> select * from v$database;

These only tell him what Instance he's connected to, and its settings. It doesn't tell him about ALL the databases that are installed on a server.

On NT, have a look at the Services applet -that should list all validly installed databases, whether running or not. On Unix, I usually do a ps- ef | grep SMON and see what gets listed -but that only shows all Instances which are actually running. To find out about those which happen not to have been started, there is (as someone else has pointed out) the oratab file.

Regards
HJR
> Andreas Lommel <him_lommel_at_t-online.de> wrote in message
> news:395b0105.2493835_at_news.btx.dtag.de...
> > Hi there. How can I get information which instances and databases are
> > installed on the server ?
>
>
Received on Thu Jul 27 2000 - 00:00:00 CDT