本文共 1434 字,大约阅读时间需要 4 分钟。
今天在STARTUP一数据库时,发生如下错误:[oracle@bogon ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 18 06:38:59 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2217872 bytesVariable Size 1811941488 bytesDatabase Buffers 1476395008 bytesRedo Buffers 16494592 bytesORA-01102: cannot mount database in EXCLUSIVE modeSQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.GOOGLE一下,发现是lk<SID>文件造成的,该文件位于ORALCE_HOME下的dbs目录下,马上检查该文件:[root@bogon dbs]# fuser -u lkORCLlkORCL: 18897(oracle) 18903(oracle) 18907(oracle) 18909(oracle) 18913(oracle) 18915(oracle) 18917(oracle) 18919(oracle) 18921(oracle) 18923(oracle) 18925(oracle) 18927(oracle) 19019(oracle) 19021(oracle) 19023(oracle) 19025(oracle) 19029(oracle) 19044(oracle) 19046(oracle) 19048(oracle) 19094(oracle)果然该文件没释放,用fuser命令kill掉:[root@bogon dbs]# fuser -k lkORCLlkORCL: 18897 18903 18907 18909 18913 18915 18917 18919 18921 18923 18925 18927 19019 19021 19023 19025 19029 19044 19046 19048 19094然后:SQL> startupORACLE instance started.Total System Global Area 3307048960 bytesFixed Size 2217872 bytesVariable Size 1811941488 bytesDatabase Buffers 1476395008 bytesRedo Buffers 16494592 bytesDatabase mounted.Database opened.SQL>数据库STARTUP成功。
转载于:https://blog.51cto.com/hyjtao/1134795