LRM
Oracle启动报错：$ 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 找不到参数文件，到该目录下
# su - oracle
$ cd $ORACLE_HOME
$ cd 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 152009 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这个文件名呢！！！想到环境变量
$ echo $ORACLE_SID
orawen
$ export ORACLE_SID=wencahodb
$ echo $ORACLE_SID
wencahodb
$ 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
$ export ORACLE_SID=wenchaodb
$ 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>
页:
[1]