SOLVED

ORA-01078: failure in processing system parameters.

Asked by OracleDba••14 views•oracle
1
2
3
4
5
ORA-01078: failure in processing system parameters.

Error:

ORA-01078: failure in processing system parameters.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.
OracleDba•

Post Your Solution