Database Administration (MOSC)

MOSC Banner

cannot mount database in exclusive mode

edited Apr 26, 2010 5:31AM in Database Administration (MOSC) 9 commentsAnswered
 Hello,
On Oracle DB release 9.2.0.7.0   we had some problems after a shutdown and restart.


Connected to an idle instance.

SQL> ORACLE instance started.
...
ORA-01102: cannot mount database in EXCLUSIVE mode

Then when reconnecting:

SQL> grant select on v_$sysstat to SIGSTCLU
*
ERROR at line 1:
ORA-01109: database not open

.....
SELECT 'DB_ROLE:'|| DATABASE_ROLE FROM v$database
*
ERROR at line 1:
ORA-01507: database not mounted


DB_STATUS:STARTED
Role retrieval failed.

After another shutdown and restart all is well. Could you give me some tips what could have gone wrong?
Are there any logfiles I could get more information what happened?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center