ORA-01078: failure in processing system parameters

Hello Everyone,

When trying to upgrade the database using T-code DBUA, I am getting the following errors:

In the trace.log

[SQLEngine.done:2278]  Done called
[SQLEngine.spoolOff:2124]  Setting spool off = /oracle/<SID>/cfgtoollogs/dbua/<SID>/upgradeN/Oracle_Server.log
[RDBMSUpgradeStep.executeStepImpl:554]  ORA-01078: failure in processing system parameters

In the Oracle_Server.log

DIA-49108: Event Name [<PARAMETER>] not found
DIA-49100: Failed to process event statement [<parameter>]
ORA-01078: failure in processing system parameters

Regenerate the issue:

Please try to upgrade the database using T-code DBUA

Solution

This error is caused due to the invalid parameter in the pfile/spfile

Please follow the steps below in order to resolve this issue: 

• First please open Oracle_Server.log
• Now we need to check whether the issue is in the source or target (more likely the latest)
• Then get the value of the <PARAMETER> in the Oracle_Server.log
• Now delete the parameter from the pfile/spfile of the corresponding ORACLE_HOME (from 1.1)
• Then restart the database
• At last, go back to T-code DBUA and retry