DBUA fails with “ORA-01078: failure in processing system parameters” error

(Doc ID 1665288.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

DBUA fails with following error while upgrading 10gR2 to 11.2.0.4

ORA-01078: failure in processing system parameters

Oracle_Server.log shows the following errors:

LRM-00121: ’10.2.0.5.1′ is not an allowable value for ‘optimizer_features_enable’
ORA-01078: failure in processing system parameters

 OR

Process ID: 0
DIA-49108: Event Name [COMMIT_LOGGING] not found
DIA-49100: Failed to process event statement [commit_logging]
ORA-01078: failure in processing system parameters

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms