在STARTUP一数据库时,发生如下错误:
SQL> startup
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 1322944 bytes
Variable Size 166187072 bytes
Database Buffers 369098752 bytes
Redo Buffers 262144 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
在网上查了下可能是由于数据库异常关闭,用于锁定内存的方件lk没有删除造成的.
先关闭数据库
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
检查$ORACLE_HOEM/dbs目录,果然有lkEMREP文件,检查该文件
[oracle@cfbgc dbs]$ fuser -u lkEMREP
lkEMREP: 2744(oracle) 2746(oracle) 2748(oracle) 2750(oracle) 2752(oracle) 2754(oracle) 2756(oracle) 2758(oracle) 2786(oracle) 2788(oracle) 2790(oracle) 2792(oracle) 2794(oracle) 10437(oracle) 10672(oracle) 10674(oracle) 10676(oracle)
kill掉所有进程
[oracle@cfbgc dbs]$ fuser -k lkEMREP
lkEMREP: 2744 2746 2748 2750 2752 2754 2756 2758 2786 2788 2790 2792 2794 10437 10672 10674 10676
[oracle@cfbgc dbs]$ fuser -u lkEMREP
再次启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 536870912 bytes
Fixed Size 1322944 bytes
Variable Size 166187072 bytes
Database Buffers 369098752 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/618537/viewspace-691446/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/618537/viewspace-691446/