Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Mismatch between COMPATIBLE Parameter and Oracle Version

SID3Feb 15 2012 — edited Feb 15 2012
Hi,

If the ORACLE version is say 11g but the compatible parameter in init.ora is say 9.2.0 or 8.1.7 what will be the effect on the database?

Will the database behave as like 11g or of the lower version?

If we alter the init.ora to the new version for compatible paremeter will it affect DB rebooting?

This is an interview question and i could not answer.

Please let me know the answers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2012
Added on Feb 15 2012
7 comments
2,003 views