could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora
来源:互联网 发布:淘宝店在线客服怎么 编辑:程序博客网 时间:2024/09/21 09:18
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle10g/product/10.2/db_1/dbs/initORA10G.ora'
查找文件,果然不存在。估计是非法关机造成的。
这是因为在oracle9i和oracle10g中,oracle默认将使用spfile启动数据库,如果spfile不存在,则就会出现上述错误。
解决方法1(已经验证):
将$ORACLE_BASE/admin/数据库名称/pfile目录下的init.ora.012009233838形式的文件copy到$ORACLE_HOME/dbs目录下initoracle.ora即可。(注:initoracle.ora中的oracle为你的实例名 即我的为 initora10g.ora)
[root@localhost dbs]# cp init.ora.721200911530 $ORACLE_HOME/dbs/initora10g.ora
0 0
- 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
- LRM-00109: could not open parameter file '/u01/oracle/product/10.2.0/db_1/dbs/initCRM.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 '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'
- LRM-00109: could not open parameter file '/oracle/app/oracle/11.2.0/db_1/dbs/initracdb2.ora
- could not open parameter file initOrcl.ora
- could not open parameter file initorcl.ora
- 【2017/4/13】LRM-00109: could not open parameter file '/u01/oracle/product/11.2.0/dbs/initora11g.ora'
- 关于非法关机造成开库造成的startup出现的LRM-00109:could not open parameter file initOrcl.ora
- could not open parameter file init**.ora
- linux 下oracle 报错could not open parameter file 'initxxx.ora'
- ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/oracle
- oracle 启动 could not open parameter file oracle10g startup database
- LRM-00109: could not open parameter file
- LRM-00109: could not open parameter file
- 解决Ubuntu12.04下some packages not fully installed or removed问题
- Hadoop第一天---初识Hadoop
- 如何在VS 2012开发平台中搭建CUDA开发环境以及opencv的配置方法
- Struts2动态方法调用
- Android-Mac电脑如何进行APK反编译-使用apktool、jd-gui
- could not open parameter file '/opt/oracle/product/10.2/db_1/dbs/initorcl.ora
- Spring整合struct2
- java8 lambda表达式-语法
- 栈(c实现)
- 如果设计中使用了非标准的字体,你该如何去实现?
- Eclipse sdk manager无法下载
- ORA-00845: MEMORY_TARGET not supported on this system
- JPA开发总结<七>--Bug总结
- tab响应式切换效果