Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database is up or down

Re: Database is up or down

From: joel garry <joel-garry_at_home.com>
Date: 9 Apr 2007 13:59:36 -0700
Message-ID: <1176152376.160851.318040@l77g2000hsb.googlegroups.com>


On Apr 8, 8:11 pm, "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.

$ echo $ORACLE_HOME
/oradata/oracle9/app/oracle/product/9.2.0 $ ps -ef|grep ZTST|grep -v grep

  oracle 20140     1  0  Apr  7  ?         0:55 ora_qmn0_ZTST
  oracle 20138     1  0  Apr  7  ?         0:13 ora_cjq0_ZTST
  oracle 20134     1  0  Apr  7  ?         0:14 ora_smon_ZTST
  oracle 20132     1  0  Apr  7  ?         0:21 ora_ckpt_ZTST
  oracle 20130     1  0  Apr  7  ?         0:07 ora_lgwr_ZTST
  oracle 20142     1  0  Apr  7  ?         0:00 ora_s000_ZTST
  oracle 20128     1  0  Apr  7  ?         0:07 ora_dbw0_ZTST
  oracle 20126     1  0  Apr  7  ?         0:11 ora_pmon_ZTST
 rossjeg  6321  6320  0 10:34:45 ?         0:00 oracleZTST
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oracle 20144     1  0  Apr  7  ?         0:00 ora_d000_ZTST
  oracle 20136     1  0  Apr  7  ?         0:00 ora_reco_ZTST
$ export ORACLE_HOME=/oracle9/app/oracle/product/9.2.0 $ echo $ORACLE_SID
ZTST
rossjeg:zt57ZTST_at_ZEUS /ross/iren57/custom57/sa/src$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Apr 9 13:55:55 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected
$ export ORACLE_HOME=/oradata/oracle9/app/oracle/product/9.2.0 $ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Apr 9 13:57:42 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> See? I have two ORACLE_HOMEs, if I set the wrong one, it is an idle instance. I do believe if I tried to start it up, there would be a problem with memory key hashing (at least on earlier releases, not sure about 9 or 10, solaris may be different than hp-ux).

jg

--
@home.com is bogus.
a .sig!  a .sig!  My shared memory realm for a .sig!
Received on Mon Apr 09 2007 - 15:59:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US