重起数据库后,打开数据库报错:
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
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博客 ” ，链接：https://blog.itpub.net/22779391/viewspace-1028391/ ，如需转载，请注明出处，否则将追究法律责任。
