Re: Stauts of an instance

From: Sanjeev K Singh <SJKSINGH_at_prodigy.net>
Date: 2000/03/09
Message-ID: <8af2a9$3pic$1@newssvr04-int.news.prodigy.com>#1/1

select status from v$instance;

Atta ur-Rehman <atta707_at_my-deja.com> wrote in message news:8acr0e$q0n$1_at_nnrp1.deja.com...
> hi oracle gurus,
>
> i've got a simple question here and thanks in advance for any help.
>
> we've got Oracle 8.0.5 on NT.
>
> i was trying to get the status of an instance from command line. how do
> i do that? by wanting to know the status i mean, if an instance is
> running and if database has been mounted.
>
> for a service i use NET START command to check the status of service,
> but it's the instance whose status i'm intersted in.
>
> thanks once more.
>
> :) ATTA
>
> --
>
> getting the meanin' of data...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Mar 09 2000 - 00:00:00 CST