欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-03-23 21:33:31
出自我安装oracle时:https://blog.csdn.net/ssrmygod/article/details/69944691 LRM-00109: could not...

出自我安装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

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

环境变量中定义的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

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

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

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