LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'

出自我安装oracle时：http://blog.csdn.net/ssrmygod/article/details/69944691

 

LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'

 

情况如下：

建立数据库时候指定SID为 oracle11g

环境变量中定义的SID为 ora11g

 

[oracle@mygod ~]$ cat .bash_profile

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

         .~/.bashrc

fi

 

# User specific environment and startupprograms

 

PATH=$PATH:$HOME/bin

 

export PATH

export ORACLE_BASE=/u01/oracle

exportORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORACLE_SID=ora11g

exportPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

[oracle@mygod ~]$

 

[oracle@mygod ~]$ ps -ef |grep pmon
oracle    51406      1  0 08:09 ?        00:00:00 ora_pmon_oracle11g
oracle    54640  54599  0 08:14 pts/3    00:00:00 grep pmon
[oracle@mygod ~]$ 
[oracle@mygod ~]$ echo $ORACLE_SID
ora11g

dbca建立数据库的时候SID与环境变量中定义的SID不一致导致了这个报错：

[oracle@mygod ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 10 08:14:39 2017
Copyright (c) 1982, 2013, 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/oracle/product/11.2.0/dbs/initora11g.ora'
SQL> exit

 

解决方法：

 

重新建立数据库

 

先kill数据库进程

[oracle@mygod ~]$ ps -ef |grep pmon
oracle    51406      1  0 08:09 ?        00:00:00 ora_pmon_oracle11g
oracle    54640  54599  0 08:14 pts/3    00:00:00 grep pmon
[oracle@mygod ~]$ 

[oracle@mygod ~]$ kill -9 51406
[oracle@mygod ~]$

 

使用dbca删除database

 

 

 

然后建立数据库时候注意SID就行了

 

再次规范建库后，若成功的话数据库在open阶段