unable to open DB

[abhaysk]

Only one instance is using this DB....coz while creation of DB i had given MAXINSTANCES 1......

am getting below error while opening DB....can any 1 let me know if i am going wrong ne where or do i have to set any thing else....or the very basic close and open wont work????????

SQL> alter database close;

Database altered.

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


SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL>

Am confused

Abhay.

[adewri]

What OS...
What version ??

[abhaysk]

Originally posted by adewri
What OS...
What version ??

OS : WIN2K
Version :
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE 9.0.1.1.1 Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production

Abhay.

[jovery]

According to Oracle the 'alter database close' is not a documented command and should not be used as it puts the database into a 'stange' state (thier words!)

There are several threads on Metalink relating to this 'feature'

Regards

[adewri]

Windows

Reboot your system

Is it possible to do that ?? i mean

alter database close...

every time i try i get

SQL> alter database close;
alter database close
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected


SQL> select username from v$session;

USERNAME
-----------------------------------------------------------------








SYS

9 rows selected.

SQL>

How did you do that ??

[abhaysk]

Originally posted by adewri
Windows

Is it possible to do that ?? i mean

alter database close...

How did you do that ??

SQL> select username from v$session;

USERNAME
------------------------------






SYS
SYS

8 rows selected.

SQL> alter database close normal;
alter database close normal
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

--i disconnected other session....

SQL> select username from v$session;

USERNAME
------------------------------






SYS

7 rows selected.

SQL> alter database close normal;

Database altered.

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


SQL>

[abhaysk]

Originally posted by jovery
According to Oracle the 'alter database close' is not a documented command
Regards

jovery :

Yes it indeed is not documented.......

but while going thru shut down steps....i was curious if close/open worked....

Abhay.

[adewri]

Good that its doesn't work at my place