ORA-01109

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

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.

[@more@]

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

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