Database Upgrade Fails with Error:"ORA-00723: Initialization parameter COMPATIBLE must be explicitly set"

(Doc ID 2203953.1)

Last updated on NOVEMBER 20, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Database upgrade fails with following error when DBUA starts the source database in upgrade mode.

And if upgrading manually ,then startup upgrade command fails with following errors:

ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

 

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