LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora
出自我安装oracle时:https://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阶段。