Re: Open/not open ?

On Dec 1, 4:24 am, "astalavista" <nob..._at_nowhere.com> wrote:
> 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>
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 -- Received on Sat Dec 01 2007 - 08:44:25 CST