LRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.ora
来源:互联网 发布:狸窝软件官网 编辑:程序博客网 时间:2024/06/11 01:17
系统装的oracle rac。归档日志经常报满,经分析,系统不需要归档日志那么频繁,于是果断关闭。主要步骤
a. 关闭数据库shutdown immediateb. startup mountc. alter database noarchivelogd. alter database open
结果执行到b步骤的时候怎么都启动不起来
SQL> startup mountORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.ora'SQL>
顿时头大,这是客户的生产线,吓死宝宝了!冷静,一定要冷静。 经过仔细分析:
数据做的rac 实例分别为 gis1 gis2 ,但是报错提示
initracdb2.ora 文件找不到,怎么回去找这个文件呐?
继续分析,实例名ORACLE_SID设置不对设置$oracle_home/.bash_profile 里面ORACLE_SID为安装实例名,再次 startup,ok!!!
1 0
- LRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.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
- 【2017/4/13】LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.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]
- linux 下oracle 报错could not open parameter file 'initxxx.ora'
- could not open parameter file initOrcl.ora
- 如何设置淘宝镜像
- 查看Chome浏览器中已保存的密码
- 文章标题
- VS自动代码整理和自动导包
- Java修改ArrayList的常见异常
- LRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.ora
- 队列实现
- Servlet的转发 VS 从定向
- ETL: 大数据之技术核心
- 酷我开发中遇到的问题
- 第13周OJ实践 学生成绩的处理
- elasticsearch5.0启动出现的错误
- Oracle-Alert log解读
- 文章标题