Open/not open ?

astalavista

unread,

Dec 1, 2007, 4:24:14 AM12/1/07

to

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

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>

Mark D Powell

unread,

Dec 1, 2007, 9:44:25 AM12/1/07

to

What you have displayed is normal behavior that has existed since at
least version 7.0 and probably before that.

You cannot re-open the database because it is still mounted and has
already been open. The state you are in exists to allow changes to be
made to the control file before shutting down. To reopen the database
you should shut it down the restart the instance.

HTH -- Mark D Powell --

Mladen Gogala

unread,

Dec 4, 2007, 6:32:27 AM12/4/07

to

On Sat, 01 Dec 2007 06:44:25 -0800, Mark D Powell wrote:

> What you have displayed is normal behavior that has existed since at
> least version 7.0 and probably before that.

I can vouch for 6.0.36 and 62 (VAX/VMS only). Oracle5 was using a command
known as IOR and had no utilities like sqldba or svrmgrl that could
display such behavior. Oracle 5.1.22 used to run perfectly well on a
mVAXII with 16MB RAM. Nowadays, notepad requires more then that.

--
Mladen Gogala