| COMPATIBLE parameter [message #222173] |
Fri, 02 March 2007 03:03  |
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 #222193 is a reply to message #222173] |
Fri, 02 March 2007 04:14  |
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 |
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 |
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 |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
