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>