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: How can you tell if an oracle database is open at the OS level

Re: How can you tell if an oracle database is open at the OS level

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Wed, 28 Feb 2007 15:53:51 +0100
Message-ID: <45e5969c$0$5087$426a74cc@news.free.fr> 





Massa Batheli wrote:


> Oracle 9.2.0.5  Hp UX

> 

> Is there a way to tell if a database is open or mounted at the OS

> level (without querying the database dict) ?




You could use "fuser" on datafile 1 (SYSTEM tablespace) and check 
whether crucial Oracle background processes such as DBWR have it opened.
Received on Wed Feb 28 2007 - 08:53:51 CST












Original text of this message













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