Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
552320Feb 1 2007 — edited Feb 2 2007I really appreciate if you can help me.
In the test environment Oracle 10g r2, I was trying to change some init.ora parameters and some flashback database parameters. Flashback required to start in mount exclusive, and the init parameters only start mount. I do not know the difference between mount and mount exclusive. i used start mount exclusive to alter all the parameters. At the end, I used ALTER DATABASE OPEN. Now, I can't start the database. The following is the error that I am getting. Can you explain the difference between start mount and start mount exclusive.
Thanks, Terry
-----------------------------------------------------------------------------------------------
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1980616 bytes
Variable Size 230688568 bytes
Database Buffers 377487360 bytes
Redo Buffers 2211840 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode