重起数据库后,打开数据库报错:

ORA-01109: database not open

oracle@ria1:~> cd $ORACLE_HOME/dbs

oracle@ria1:~/product/10.2/db_1/dbs> ls

cms_data.dbf   initdw.ora  inittmorcl.ora  orapwtmorcl       sqlnet.log

hc_tmorcl.dat  init.ora    lkTMORCL        spfiletmorcl.ora

oracle@ria1:~/product/10.2/db_1/dbs> fuser -u lkTMORCL

lkTMORCL:             4380(oracle)  4382(oracle)  4384(oracle)  4386(oracle)  4388(oracle)  4390(oracle)  4392(oracle)  4394(oracle)  4396(oracle)  4398(oracle)  4400(oracle)  4408(oracle)  4410(oracle)  4412(oracle)

oracle@ria1:~/product/10.2/db_1/dbs> fuser -k lkTMORCL

lkTMORCL:             4380  4382  4384  4386  4388  4390  4392  4394  4396  4398  4400  4408  4410  4412

oracle@ria1:~/product/10.2/db_1/dbs> sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 11月 3 20:05:28 2009

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

SQL> conn /as sysdba

SQL> startup

ORACLE instance started.

Total System Global Area 1677721600 bytes

Fixed Size                  1219760 bytes

Variable Size             402654032 bytes

Database Buffers         1258291200 bytes

Redo Buffers               15556608 bytes

Database mounted.

Database opened.