ORA-01078: failure in processing system parameters

 

Error Message:

 ORA-01078: failure in processing

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

srvctl start database -db KARDB

PRCR-1079 : Failed to start resource ora.kardb.db

CRS-5017: The resource action "ora.kardb.db start" encountered the following error:

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/oracle/product/12.2.0.1/db/dbs/initKARDB.ora'

. For details refer to "(:CLSN00107:)" in "/oracle/diag/crs/vm-kardb-tst/crs/trace/ohasd_oraagent_oracle.trc".

 

CRS-2674: Start of 'ora.kardb.db' on vm-kardb-tst 'vm-kardb-tst' failed

 

Solution:

It is missing detail in the server Control (srvctl) Utility. We need to add as follow.

create spfile from pfile='/oracle/product/12.2.0.1/db/dbs/initKARDB.ora';

srvctl start database -db KARDB

srvctl status database -db KARDB

Database is running.