backward compatibility with an earlier release. This is helpful if it becomes necessary to revert to the earlier release.
This parameter specifies the release with which Oracle must maintain compatibility. It allows you to take advantage of the maintenance improvements of a new release immediately in your production systems without testing the new functionality in your environment. Some features of the release may be restricted.
When using a standby database, this parameter must have the same value on both the primary and standby databases.
RAC Multiple instances must have the same value.
This parameter specifies the release with which Oracle must maintain compatibility. It allows you to take advantage of the maintenance improvements of a new release immediately in your production systems without testing the new functionality in your environment. Some features of the release may be restricted.
When using a standby database, this parameter must have the same value on both the primary and standby databases.
RAC Multiple instances must have the same value.
like Ora-00600 else some other errors.
--How this is possible a bug which is fixed in lower version still exists in higher version ?
The reason was very simple, the compatible parameter of database was set to 11.2.0.2, That is the reason online dba was still seeing this bug.
Command to check compatible parameter
SQL> SELECT name, value, description FROM v$parameter WHERE name = 'compatible';
Steps to change compatible parameter of database
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
SQL> SHUTDOWN IMMEDIATE
3. Start database
SQL> Startup
4. Cross check for parameter for new value
SQL> SELECT name, value, description FROM v$parameter WHERE name = 'compatible';
Note: Please take your database backup before changing this parameter, because after changing this parameter database will become incompatible with earlier releases of Oracle Database.
Oracle Database Release DefaultValue MinimumValue MaximumValue
Oracle8i release 8.1.7 8.0.0 8.0.0.0.0 8.1.7.x.x
Oracle9i release 9.0.1 8.1.0 8.1.0.0.0 9.0.1.x.x
Oracle9i release 9.2 8.1.0 8.1.0.0.0 9.2.0.x.x
Oracle Database 10g release 10.1 10.0.0 9.2.0.0.0 10.1.0.x.x
Oracle Database 10g release 10.2 10.2.0 9.2.0.0.0 10.2.0.x.x
Oracle 11g Release 11.1 11.0.0 10.0.0.0.0 11.1.0.x.x
Oracle 11g Release 11.2 11.0.0 10.0.0.0.0 11.2.0.x.x
No comments:
Post a Comment