var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter Database Open
My Database is in a Mount State. I confirmed it from
SELECT * FROM V$INSTANCE;
Now to open the database, I am doing
ALTER DATABASE OPEN;
But it says that
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01531: a database already open by the instance
I checked v$session also, no other session is running. Can anyone tell why and when such situation come,
and how to open the database without shuting down and restarting it.
Alter Database Open
I forgot to add this info:
Actually the database was open previously. I did ALTER DATABASE CLOSE NORMAL
which went to MOUNT state. Now when I try to open it using ALTER DATABASE OPEN;
it doesn't work.
it sounds some background processes are (still) running...
and then try to startup again