irpas技术客

ORA-01078: failure in processing system parametersLRM-00109: could not open para

网络投稿 3878

SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/opt/app/oracle/product/19.3.0/dbhome_1/dbs/initcolystdb01.ora'

解决方法:

?su - root?

[root@oracle19c dbs]# cd /opt/app/oracle/admin/orcl/ adump/ ? ? ?dpdump/ ? ? pfile/ ? ? ?xdb_wallet/? [root@oracle19c dbs]# cd /opt/app/oracle/admin/orcl/pfile/ [root@oracle19c pfile]# pwd /opt/app/oracle/admin/orcl/pfile [root@oracle19c pfile]# ls init.ora.0122022181530

[root@oracle19c dbs]# cp init.ora.0122022181530 /opt/app/oracle/product/19.3.0/dbhome_1/dbs/initcolystdb01.ora

[root@oracle19c pfile]# chown -R oracle:oinstall /opt/app/oracle/product/19.3.0/dbhome_1/dbs/initcolystdb01.ora

su - oracle?

[oracle@oracle19c bin]$ sqlplus / as sysdba

SQL> startup ?? ORACLE instance started.

Total System Global Area 2466250400 bytes Fixed Size?? ??? ? ? ?9137824 bytes Variable Size?? ??? ? ?536870912 bytes Database Buffers?? ? 1912602624 bytes Redo Buffers?? ??? ? ? ?7639040 bytes Database mounted. Database opened.

[oracle@oracle19c bin]$ lsnrctl status


1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,会注明原创字样,如未注明都非原创,如有侵权请联系删除!;3.作者投稿可能会经我们编辑修改或补充;4.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。

标签: #ORA01078 #failure #in #processing #system #could #not