How to fix the error ORA-00723: Initialization parameter COMPATIBLE must be explicitly set?

AbundantCode 1 week ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorORA-00723: Initialization parameter COMPATIBLE must be explicitly set with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

Reason for the Error ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

Oracle detected that the initialization parameter COMPATIBLE was not explicitly specified, and the compatibility of the database is lower than the default value of the COMPATIBLE parameter. In order to use the new compatible setting, the intialization parameter must be explicitly set by the user.

How to fix the Error ORA-00723: Initialization parameter COMPATIBLE must be explicitly set ?

You can fix this error in Oracle by following the below steps

Explicitly set the value of COMPATIBLE parameter either in PFILE or SPFILE, whichever is used.

Tags :

Leave Your Comment