ORA-01102: cannot mount database in EXCLUSIVE mode

最新推荐文章于 2024-12-30 16:24:37 发布

转载最新推荐文章于 2024-12-30 16:24:37 发布 · 97 阅读

文章标签：

本文介绍了如何解决Oracle数据库启动时遇到的ORA-01102错误，包括检查背景进程、清理semaphore资源等步骤，并分享了重启系统的解决经验。

ORACLE instance started.

Total System Global Area 100663296 bytes
Fixed Size 1217884 bytes
Variable Size 88083108 bytes
Database Buffers 8388608 bytes
Redo Buffers 2973696 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

reply:

Are you by chance using Data Guard or a physical standby database?

In any case, Oracle Metalink Note 1034037.6 may be of assistance if you have access to Oracle Support and Metalink.

I would try to shutdown the instance cleanly and check that no background processes owned by oracle are running. Then I would check for current open semaphores are running that are owned by oracle.
You can use ipcs and ipcrm to do this. Then try to startup the instance again.

详见 http://dbaforums.org/oracle/index.php?showtopic=6054

自己的经验把系统重新启动一下解决了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15142212/viewspace-610774/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15142212/viewspace-610774/