【2017/4/13】LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'
来源:互联网 发布:ubuntu 16.04镜像文件 编辑:程序博客网 时间:2024/04/26 11:57
出自我安装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阶段
- 【2017/4/13】LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'
- LRM-00109: could not open parameter file '/u01/oracle/product/10.2.0/db_1/dbs/initCRM.ora'
- LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'
- could not open parameter file '/u01/app/oracle/product/11.1.0/db_1/dbs/initorc11g.ora
- LRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.ora
- could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora
- could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora
- could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora
- could not open parameter file "..../product/11.2/db_1/dbs/initorcl.ora
- ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/oracle
- LRM-00109: could not open parameter file
- LRM-00109: could not open parameter file
- LRM-00109: could not open parameter file
- LRM-00109: could not open parameter file
- 关于非法关机造成开库造成的startup出现的LRM-00109:could not open parameter file initOrcl.ora
- LRM-109: Could Not Open Parameter File [ID 734930.1]
- could not open parameter file initOrcl.ora
- could not open parameter file init**.ora
- C++学习路线借鉴
- java面向对象第7章 集合框架
- bzoj1704: [Usaco2007 Mar]Face The Right Way 自动转身机
- 【HTML】1.介绍
- 最大化平均值
- 【2017/4/13】LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'
- 结构体指针
- 第七届蓝桥杯—寒假作业
- 移植Qt4.8.7到ARM40-A5
- 按键驱动——plat_button分析总结
- 四月十三
- 蓝丝雨第十四季商业实战系列《全民奇迹中控台实战》-收集整理视频教程
- 跨站的艺术-XSS Fuzzing 的技巧
- bzoj4659: Lcm