- 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:
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.
Now type sqlplus / as sysdba command and check database is start.