『AskWan』

生命

[

2009/05/24 19:59 | by askwan ]

       "人的生命跟朝露没有什么两样，看起来不乏美丽，甚至有的时候是如此的凄美壮观，但是只要阳光一照射，一眨眼的工夫它就蒸发消逝在这个空间而变得无影无踪了，生命短暂，值得珍惜。在拥有的每一分每一秒，都要提醒自己不要虚度。珍惜生命中的所有，不断前进，不枉度此生。" 佛曰。
    生命只在一呼一吸之间！
    “露水有一瞬，浮游有一昼夜，花草有一季，凡人有几十年。生命只在一呼一吸……”！

     愿我劳碌一生的父亲在天堂里得到安息！永远安息！

Tags: 生命

My Diary | Comments(0) | Trackbacks(0) | Reads(491)

遭遇 ORA-01102: cannot mount database in EXCLUSIVE mode

[

2009/05/18 16:38 | by askwan ]

刚刚装好的库，简单测试没有问题后，放下，不到半个钟头，再次连接上去，发现数据库已经不可用了……

Quotation

oracle@staging:~$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 18 16:13:29 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.

SQL> select * from scott.emp;
select * from scott.emp
*
ERROR at line 1:
ORA-01034: ORACLE not available

机器并没有重启，oracle莫名其妙的到了不可用状态！我开始以为是谁关闭了，下开启指令

Quotation

SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

这下遭遇ORA-01102: cannot mount database in EXCLUSIVE mode 错误了
Search On Google，then get the problem's anwser
大意是 “Oracle被异常关闭时，有资源没有被释放……”

检查警告日志，也证实了这一点，系统异常

马上查$ORACLE_HOME/dbs,发现一lk【SID】文件，果然呆在这里

Quotation

staging:dbs# fuser -u lkCAPITALV
lkCAPITALV: 368(oracle) 370(oracle) 372(oracle) 374(oracle) 376(oracle) 378(oracle) 380(oracle) 382(oracle) 384(oracle) 386(oracle) 388(oracle) 397(oracle) 1472(oracle) 1557(oracle) 8852(oracle)

杀掉先：

Quotation

staging:dbs# fuser -k lkCAPITALV

再查，发现已经没有资源占用

Quotation

staging:dbs# fuser -u lkCAPITALV

ok！
再次启动Oracle

Quotation

oracle@staging:~$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 18 16:24:05 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

----------------------END----------------------------