ORA-01078: failure in processing system parameters.

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
ora
  • ANKUSH THAVALI
  • 16 Feb, 2024
  • 0 Comments
  • 25 Secs Read

ORA-01078: failure in processing system parameters.

Error:
ORA-01078: failure in processing system parameters.
Solution:
Go to alert log file location ‘/u01/app/oracle/diag/rdbms/prim/PRIM/trace’
[oracle@node1 ~]$ cat /u01/app/oracle/diag/rdbms/prim/PRIM/trace/alert_PRIM.log
copy below parameter:
ora

Go to ‘[oracle@node1 ~]$ cd $ORACLE_HOME/dbs’  location
create initPRIM.ora file
[oracle@node1 dbs]$ vi initPRIM.ora
paste the above parameter in initPRIM.ora file as per below given screenshot.
ORA-01078-solution

Now type sqlplus / as sysdba command and check database is start.