On Feb 28, 9:53 am, Jerome Vitalis
<vitalismanN0S..._at_gmail.com.invalid> wrote:
> 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.
Check the alert log. You should see lines like:
Completed: ALTER DATABASE MOUNT
or
Completed: alter database open
Received on Wed Feb 28 2007 - 09:10:21 CST
