Home » RDBMS Server » Server Administration » downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3to 10 (10.2.0.4; aix p6.1)
downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3to 10 [message #455259] Mon, 10 May 2010 19:24 Go to next message
cakeday
Messages: 31
Registered: May 2010
Member
FIRST i just needed to change the compatible init parameter. but i couldn't. got the error below.
now i want to downgrade oracle from version 10.2.0.4 TO 10.2.0.3
AND
change the compatible parameter from 10.2.0.3 to 10.2.0

how and what is the best way of doing this.
it is AIX box.
i have backups and everything in place.
is there a catdowngrade available between these versions ?
============

Problem Description: REQUIREMENT:
To change the COMPATIBLE init parameter from 10.2.0.3 to 10.2.0

ERROR:
alter system set compatible='10.2.0.0' scope=spfile;
shutdown immediate;
SQL> startup;
ORACLE instance started.

Total System Global Area 4194304000 bytes
Fixed Size 2089344 bytes
Variable Size 637537920 bytes
Database Buffers 3539992576 bytes
Redo Buffers 14684160 bytes
ORA-00201: control file version 10.2.0.3.0 incompatible with ORACLE version
10.2.0.0.0
ORA-00202: control file: '/s063/sys001/control01.ctl'

====

ORACLE INSTANCE VERSION: 10.2.0.4.0

====

CAN i use downgrade this isntance to 10.2.0.3.0 and then set compatible parameter to 10.2.0 ?

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455260 is a reply to message #455259] Mon, 10 May 2010 19:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>CAN i use downgrade this isntance to 10.2.0.3.0 and then set compatible parameter to 10.2.0 ?

As far as I know, once a instance has been opened at one version it can not be opened at a lower version.

Be sure to post a solution if you ever find one.

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455272 is a reply to message #455260] Mon, 10 May 2010 23:15 Go to previous messageGo to next message
kiran_j
Messages: 7
Registered: April 2010
Location: Pune
Junior Member
Hi,

You can use the ?/rdbms/admin/catdwgrd.sql to downgrade the database from 10.2.0.4 to 10.2.0.3.

catdwgrd.sql:

DataBase DoWnGrade from the current release
to the original release


Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455273 is a reply to message #455272] Mon, 10 May 2010 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Learned something new today.

Rem    NAME
Rem      catdwgrd.sql -  DataBase DoWnGrade from the current release 
Rem                      to the original release (if supported)

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455278 is a reply to message #455273] Mon, 10 May 2010 23:27 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
hi all -

thank you for your quick response.
does anyone know of a good link to point me to, which explains all the preparation and gotcha's when i downgrade the instnace.
also, what about the COMPATIBLE init parameter ? when i downgrade, does this parameter change on it's own or can i change it to the 10.2.0 from the current 10.2.0.3 ?

thank you

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455280 is a reply to message #455278] Mon, 10 May 2010 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
WHY?

What problem are you trying to solve?
Why are you obsessed with downgrading this DB?

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455289 is a reply to message #455280] Mon, 10 May 2010 23:58 Go to previous messageGo to next message
cakeday
Messages: 31
Registered: May 2010
Member
it is a vendor requirement and they are having some performance issue(s) and are blaming it on the version. it was also an error that was committed by a junior member of my team and it is something i want to correct it before the vendor blames every problem that they run into in the future on this version mistake that a junior team member created.

Report message to a moderator

Re: downgrade oracle from vers 10.2.0.4 TO 10.2.0.3 &change compatible init param from 10.2.0.3t [message #455293 is a reply to message #455289] Tue, 11 May 2010 00:16 Go to previous message
kiran_j
Messages: 7
Registered: April 2010
Location: Pune
Junior Member
Hi,

check the 10.2.0.4 Patchset readme under Removing the Patch Set Software section. you will see the steps to downgrade.

But let me tell you one thing your chances to run a downgrade without a single problem are very low.

if you have a performance problem then it is having the solution.
try to resolve.

Report message to a moderator

Previous Topic: Freeing a tablespace
Next Topic: Large number of trace file generation in Bdump
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 15:51:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.