On Apr 9, 11:00 am, sybra..._at_hccnet.nl wrote:
> On 8 Apr 2007 20:11:59 -0700, "Steve Robin" <ocma..._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- Hide quoted text -
>
> - Show quoted text -
Well Sybrand. What you are saying is absolutly right. And we are going
to upgrade our database server very soon.
Actually problem is this, that other user from different machine can
connect to this database and with sysdba privilege.
But when I try to connect with sys, I am not able to. Now I cann't use
there username and password but I can connect as sysdba. But..... I
cann't.
Received on Mon Apr 09 2007 - 01:41:55 CDT
