Home » RDBMS Server » Server Administration » COMPATIBLE parameter
COMPATIBLE parameter [message #222173] Fri, 02 March 2007 03:03 Go to next message
gkodakalla
Messages: 49
Registered: March 2005
Member
Hi,
Details from my database are as follows:

show parameter compatible

NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
compatible string 10.2.0.1.0

select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production


My doubt is, when we upgrade/apply patches, is it required to manually change the COMPATIBLE parameter to that upgraded version? As i see different values in the v$parameter and v$version, i have this doubt.

Thanks.
Re: COMPATIBLE parameter [message #222190 is a reply to message #222173] Fri, 02 March 2007 04:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends ( and not usually within the same release).
If you are migrating between say 9i to 10g, compatible could make a big difference. Unles you are using any 10.2.0.3.0 explicit feature, you no need to set it.
Re: COMPATIBLE parameter [message #222193 is a reply to message #222173] Fri, 02 March 2007 04:14 Go to previous messageGo to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
Hi,

COMPATIBLE Parameter shows
The Version of the server with which this instance should
be compatible.

I think that was the minimum compatibility level of the instance, so u don't need to change this parameter,

wht do u say?

Regards,
Re: COMPATIBLE parameter [message #222213 is a reply to message #222173] Fri, 02 March 2007 05:49 Go to previous messageGo to next message
gkodakalla
Messages: 49
Registered: March 2005
Member
Thanks for your quick replies.
My doubt is

1) Do we have to change this value manually after any patch/upgrade. wont it happen automatically during the patch/upgrade?
2) Unless we keep the value in sync with the version, we can't use any of the features of the Database. Please correct me if i am wrong.

Thanks
Giridhar
Re: COMPATIBLE parameter [message #222244 is a reply to message #222173] Fri, 02 March 2007 08:02 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I have a same question. I upgraded from 8.1.7.4 to 9.2.0.1 on solaris 9. I did not change the compatible parameter to 9.2.0 after upgrading and my database version shows 9.2.0.1.
Do I still have to change the compatible parameter or just leave it as it is??
Re: COMPATIBLE parameter [message #222260 is a reply to message #222213] Fri, 02 March 2007 09:48 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1). For patching, most probably you dont need to. For upgrade yes.
2). There are specific features ( many with CBO) that are dependent on this parameter.
>>we can't use any of the features of the Database.
'Any' would be a strong assumption.
'Some' would be safe.
Consult your documentation.
Previous Topic: New Oracle 10g processes
Next Topic: Temporary tablespace Mgmt
Goto Forum:
  


Current Time: Wed Dec 07 06:32:14 CST 2016

Total time taken to generate the page: 0.08500 seconds