在STARTUP一数据库时,报ORA-01102错误:
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<SID>没有删除造成的.
1.先关闭数据库
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
2.检查$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)
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<SID>没有删除造成的.
1.先关闭数据库
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
2.检查$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)