Oracle启动报错:

[oracle@centos-fuwenchao dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:57:58 2014
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorawen.ora'
SQL> exit    
Disconnected

找不到参数文件,到该目录下

[root@centos-fuwenchao ~]# su - oracle
[oracle@centos-fuwenchao ~]$ cd $ORACLE_HOME
[oracle@centos-fuwenchao db_1]$ cd dbs/
[oracle@centos-fuwenchao dbs]$ ll
total 28
-rw-rw----. 1 oracle oinstall 1544 Feb 19 15:32 hc_DBUA0.dat
-rw-rw----. 1 oracle oinstall 1544 Feb 19 16:38 hc_wenchaodb.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r-----. 1 oracle oinstall   24 Feb 19 16:23 lkWENCHAOD
-rw-r-----. 1 oracle oinstall   24 Feb 19 16:29 lkWENCHAODB
-rw-r-----. 1 oracle oinstall 1536 Feb 19 16:38 orapwwenchaodb
-rw-r-----. 1 oracle oinstall 3584 Feb 20 00:05 spfilewenchaodb.ora

确实没有该文件,但是为什么是initorawen.ora这个文件名呢!!!想到环境变量

[oracle@centos-fuwenchao dbs]$ echo $ORACLE_SID
orawen
[oracle@centos-fuwenchao dbs]$ export ORACLE_SID=wencahodb
[oracle@centos-fuwenchao dbs]$ echo $ORACLE_SID
wencahodb
[oracle@centos-fuwenchao dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:57:58 2014
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initwencahodb.ora'
SQL> exit    
Disconnected
[oracle@centos-fuwenchao dbs]$ export ORACLE_SID=wenchaodb
[oracle@centos-fuwenchao dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:59:21 2014
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>