LRM

沈阳格力专卖店

　　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>