Re: 8.1.5 to 8.1.6

I may have discovered the fix to that bug. I believe the problem is that 8.1.5 can
corrupt blocks in the system tablespace
and never detect it, but 8.1.6 detects it and rejects the blocks.

There is a hidden parameter named something like: '_always_checksum_system_ts' which is set to TRUE. Presumably if set to false the check would not take place, and 8.1.6 would run.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <3959E2D9.521A_at_yahoo.com>...


>Sunny wrote:

>>

>> hi everyone

>>

>> i have a question. when you upgrade oracle from 8.1.5 to 8.1.6 do you

 have


>> to do anything to the data. like i mean what happens if you had data

 already


>> in the database, do you have to do any migration or anything or you just

>> upgrade and data already comes into the later version..

>>

>> thanks

>>

>> sunny

>> Oracle Developer

>

>You do not have to unload and reload your data - however there is a note

>on metalink about possible database corruption (since 8.1.6 add error

>checks on the system tablespace)..

>

>HTH

>--

>===========================================

>Connor McDonald

>http://www.oracledba.co.uk

>

>We are born naked, wet and hungry...then things get worse