Re: Database is up or down

On 8 Apr 2007 20:11:59 -0700, "Steve Robin" <ocmaman_at_gmail.com> wrote:

>Sun Sol> ps -ef|grep PSPATCH|grep -v grep
> oracle 5079 1 0 Apr 07 ? 0:28 ora_pmon_PSPATCH
> oracle 5081 1 0 Apr 07 ? 0:00 ora_dbw0_PSPATCH
> oracle 5083 1 0 Apr 07 ? 0:00 ora_lgwr_PSPATCH
> oracle 5085 1 0 Apr 07 ? 0:20 ora_ckpt_PSPATCH
> oracle 5087 1 0 Apr 07 ? 0:04 ora_smon_PSPATCH
> oracle 5089 1 0 Apr 07 ? 0:00 ora_reco_PSPATCH
> root 5091 1 0 Apr 07 ? 0:00 ora_dism_PSPATCH
>Sun Sol> export ORACLE_SID=PSPATCH
>Sun Sol> sqlplus "/ as sysdba"
>
>SQL*Plus: Release 9.2.0.3.0 - Production on Sun Apr 8 22:27:11 2007
>
>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>Connected to an idle instance.
>
>SQL>
>
>Please let know, whether database is up or down here. As well if it is
>up then how can I connect to database.
>It is oracle 9.2.0.3 on Sun Solaris.

The message 'connected to an idle instance' means the database has been started, but not MOUNTed, nor OPENed. Startup always go to three phases

- start the background processes
- open the controlfile (this MOUNTing the database)
- Open the database files.

This is all outlined in the manuals, you consistently avoid to read.

9iR2 goes out of premier support on July 31. After July 31 there will be only extended support for 9.2.0.*8*.
You need to upgrade soon.

-- 
Sybrand Bakker
Senior Oracle DBA