Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database is up or down
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
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