环境
OS: RedHat AS5.0
DB: Oracle10gR2 (running)
Oracle11gR1 (stop)
问题
启动11g数据库时报错:
SQL> startup
ORACLE instance started.
Total System Global Area 790941696 bytes
Fixed Size 1302820 bytes
Variable Size 557846236 bytes
Database Buffers 226492416 bytes
Redo Buffers 5300224 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
原因
服务器异常关机,导致数据库被异常关闭,用于锁内存的lk<sid>文件没有被删除
[oracle@DN2WEB04 ~]$ cd /u01/app/oracle/product/11.1.0/db_1/dbs
[oracle@DN2WEB04 ~]$ ls
hc_DEMO11G.dat initdw.ora init.ora lkDEMO11G orapwDEMO11G spfileDEMO11G.ora
解决办法
删除文件lk<sid>
[oracle@DN2WEB04 ~]$ rm lkDEMO11G
参考资料:
Subject: ORA-01102: WHEN STARTING THE DATABASE
Doc ID: 1034037.6