Open/not open ?

From: astalavista <nobody_at_nowhere.com>
Date: Sat, 1 Dec 2007 10:24:14 +0100
Message-ID: <4751283c$0$15308$426a74cc@news.free.fr>

HI,

I got something weird
the database said it is open and not open in the same time ...

any lights ?
Thanks in advance
Oracle 9.2.0.6/AIX

U13:oracle:/prd/app/system/exploit/shell#sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Nov 30 09:45:09 2007

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

SQL> connect / as sysdba
Connected.
SQL>
SQL> select status from v$instance;

STATUS

---

OPEN SQL> alter database close;

Database altered.

SQL> select status from v$instance;

STATUS

---

MOUNTED SQL> alter tablespace temp add tempfile '/prd/data/ora/P200/02/P200_temp01.dbf'; alter tablespace temp add tempfile '/prd/data/ora/P200/02/P200_temp01.dbf' *
ERROR at line 1:
ORA-01109: database not open

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance

SQL> select status from v$instance;

STATUS

---

MOUNTED SQL> Received on Sat Dec 01 2007 - 03:24:14 CST