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 -> Database is up or down

Database is up or down

From: Steve Robin <ocmaman_at_gmail.com>
Date: 8 Apr 2007 20:11:59 -0700
Message-ID: <1176088319.064703.300930@w1g2000hsg.googlegroups.com>


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. Received on Sun Apr 08 2007 - 22:11:59 CDT

Original text of this message

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