Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: COMPATIBLE parameter

Re: COMPATIBLE parameter

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 11 Dec 2005 10:13:21 -0800
Message-ID: <1134324798.194717@jetspin.drizzle.com>


Matthias Hoys wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1134240062.943709_at_jetspin.drizzle.com...
>

>>Matthias Hoys wrote:
>>
>>>I have a Oracle 9.2.0.5.0 db with COMPATIBLE = 9.2.0.7.0 ???
>>>
>>>This can only be changed manually, no ?
>>
>>Correct. Either by modifying the init.ora and recompiling the spfile
>>or patching to 9.2.0.7.
>>
>>Personally I'd choose the later path.
>>-- 

>
>
> Are you sure installing a patch changes the compatible parameter ? I did an
> upgrade of 9.2.0.6.0 to 9.2.0.7.0 and I believe COMPATIBLE was still set to
> 9.2.0.6.0.
>
> Matthias

Patching doesn't change the compatible parameter.

But you have two choices:
1. Change compatible down
2. Patch up to match ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Dec 11 2005 - 12:13:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US