ORA-01109: database not open

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

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779391/viewspace-618044/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779391/viewspace-618044/