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: Release10.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/22779291/viewspace-625237/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-625237/