How do I change Oracle compatibility?

After the upgrade is complete, you can increase the setting of the COMPATIBLE initialization parameter to the maximum level for Oracle Database.

1. Change parameter value. SQL> ALTER SYSTEM SET COMPATIBLE = ‘11.0.0’ SCOPE=SPFILE;
2. Shutdown database.
3. Start database.
4. Cross check for parameter for new value.

What is Oracle compatibility?

The Oracle Database enables you to control the compatibility of your database with the COMPATIBLE initialization parameter. By default, when the COMPATIBLE initialization parameter is not set in your parameter file, it defaults to 10.2.

What is Oracle compatibility parameter?

The COMPATIBLE parameter specifies the Oracle version number that the database disk format must be compatible with. The database can be downgraded to the version specified in the COMPATIBLE parameter or any later version.

Is Oracle 12c client backwards compatible?

Oracle supports “backwards compatibility” for an Oracle client software, so a higher version of the client may be compatible with an older version of the database.

What is data compatibility?

Data Compatibility is an IT innovation that provides integrated data throughout an organization, among organizations and across industries. Data compatibility is so superior to traditional data integration methods that data compatibility is the inevitable replacement for data integration methods.

Does Oracle 12c client work with 11g database?

I use Oracle 12c Client for connect Oracle 11g DB and work is Ok, without problem.

What version of Oracle should I set the compatible parameter to?

You should set the compatible parameter to the version of Oracle that you are using in order to use all replication features of that version of the database.

What is compatible adjustment in Oracle Database?

COMPATIBLE gets adjusted when there is a forced COMPATIBLE change needed. This is the case when the release you are upgrading to does not support the COMPATIBLE setting of the source anymore. Simple example: You operate an Oracle 11.2.0.4 database with COMPATIBLE=10.2.0, then it will be pushed up.

How do I change the compatible value in Oracle 9i?

You can’t revert it to a lower value since Oracle 9i. The ALTER DATABASE RESET COMPATIBILITY command does not exist anymore for over a decade. Hence, once changed, you are not able to revert to the previous value. Changing COMPATIBLE requires a restart of the database: You can’t adjust COMPATIBLE while the database is up and running.

What should I set the compatible initialization parameter to before upgrading?

Before upgrading to Oracle Database 12 c, you must set the COMPATIBLE initialization parameter to at least 11.2.0. Oracle recommends increasing the COMPATIBLE parameter only after you have completed testing the upgraded database.