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.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。 |