Oracle启动报错:
[oracle@centos-fuwenchao dbs]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:57:58 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORA-01078: failure in processing system parametersLRM-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]$ lltotal 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_SIDorawen[oracle@centos-fuwenchao dbs]$ export ORACLE_SID=wencahodb[oracle@centos-fuwenchao dbs]$ echo $ORACLE_SIDwencahodb[oracle@centos-fuwenchao dbs]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:57:58 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORA-01078: failure in processing system parametersLRM-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 sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 13:59:21 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>