--设置启动orcl数据库
[oracle@localhost dbs]$ export ORACLE_SID=orcl
SQL> conn /as sysdba ;
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> shutdown immediate ;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> select instance_name from v$instance ;
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup ;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
SQL> alter database mount ;
alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> select open_mode from v$database ;
select open_mode from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> create pfile from spfile ;
create pfile from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> host ;
[oracle@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 18 23:04:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile ;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/u01/app/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
SQL> host ;