ORA-01102: cannot mount database in EXCLUSIVE mode

た入场券 2022-01-16 07:04 169阅读 0赞

今天在STARTUP一数据库时，发生如下错误：

SQL> conn /as sysdba  
Connected to an idle instance.  
SQL> startup  
[oracle][] instance started.

Total System Global Area 276824064 bytes  
Fixed Size 778736 bytes  
Variable Size 137371152 bytes  
Database Buffers 138412032 bytes  
Redo Buffers 262144 bytes  
ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> shutdown immediate  
ORA-01507: database not mounted

[oracle][] instance shut down.

GOOGLE一下，发现是lk<SID>文件造成的，该文件位于ORALCE\_HOME下的dbs目录下，马上检查该文件：

\[root@qa- [oracle][] dbs\]\# fuser -u lkNDMSQA  
lkNDMSQA: 6666( [oracle][] ) 6668( [oracle][] ) 6670( [oracle][] ) 6672( [oracle][] ) 6674( [oracle][] ) 6676( [oracle][] ) 6678( [oracle][] ) 6680( [oracle][] ) 6690( [oracle][] ) 6692( [oracle][] ) 6694( [oracle][] ) 6696( [oracle][] ) 6737( [oracle][] ) 6830([oracle][] )

果然该文件没释放，用fuser命令kill掉：

\[root@qa- [oracle][] dbs\]\# fuser -k lkNDMSQA  
lkNDMSQA: 6666 6668 6670 6672 6674 6676 6678 6680 6690 6692 6694 6696 6737 6830  
\[root@qa- [oracle][] dbs\]\# fuser -u lkNDMSQA

然后：

SQL> startup  
[oracle][] instance started.

Total System Global Area 276824064 bytes  
Fixed Size 778736 bytes  
Variable Size 137371152 bytes  
Database Buffers 138412032 bytes  
Redo Buffers 262144 bytes  
Database mounted.  
Database opened.  
SQL>

数据库成功OPEN.

关于该错误更详细的介绍如下：原文链接：[http://www.hellodba.com/cases/case-unexception\_down.htm][http_www.hellodba.com_cases_case-unexception_down.htm]

数据库异常关闭后无法启动问题处理一例

[oracle]: http://www.oracle.com/
[http_www.hellodba.com_cases_case-unexception_down.htm]: http://www.hellodba.com/cases/case-unexception_down.htm