ORA-01102: cannot mount database in EXCLUSIVE mode 处理方法

最新推荐文章于 2024-01-11 13:59:40 发布

原创

最新推荐文章于 2024-01-11 13:59:40 发布 · 7.2k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #ORA-01102 cannot mou #ORA-01102 #cannot mount databas #mount

当尝试启动Oracle数据库时遇到ORA-01102错误，表明数据库无法在独占模式下挂载。此问题可能由于sgadef.dbf文件存在、后台进程未关闭、共享内存段和信号量遗留或lk文件存在导致。解决方案包括删除sgadef.dbf和lk文件，检查并杀死占用数据库的进程，然后重新启动数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错现象：

数据库报出 ORA-01102 错误，无法 mount

[oracle@edbjr2p2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 25 02:38:03 2017

Connected to an idle instance.

SYS @ PROD4 >startup
ORACLE instance started.

Total System Global Area 941600768 bytes
Fixed Size                  1348860 bytes
Variable Size             549456644 bytes
Database Buffers          385875968 bytes
Redo Buffers                4919296 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

SYS @ PROD4 >alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode

查看日志：

大概意思为文件被占用，无法锁定（最后发现报错关系到一个文件和一个进程，就是日志里标出的两行）

[oracle@edbjr2p2 ~]$ tail -10 /u01/app/oracle/diag/rdbms/prod4/PROD4/trace/alert_PROD4.log

Wed Jan 25 03:07:39 2017
MMNL started with pid=16, OS id=20451
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Wed Jan 25 03:07:39 2017
ALTER DATABASE MOUNT
sculkget: failed to lock /u01/app/oracle/product/11.2.0/db_1/dbs/lkPROD4 exclusive
sculkget: lock held by PID: 17127
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 17127
ORA-1102 signalled during: ALTER DATABASE MOUNT...