Re: controlfile mismatch

From: Morten <solbjerg_at_.post.opasia.dk>
Date: Wed, 28 Nov 2001 17:45:01 +0100
Message-ID: <3c05149f$0$25386$edfadb0f_at_dspool01.news.tele.dk>

Hi!

Thanks for your help but where do I change DB_BLOCK_SIZE? And I read somewhere that doing so will imply rebuilding the database?

/Morten

Ron Reidy wrote:

> Morten wrote:

>>
>> Hi!
>>
>> I've installed an Oracle 9i server on my Linux RedHat 7.2 system. I've
>> had various problems getting the database which was created as part of
>> the installation started. My latest attempt has brought me in a situation
>> where I'm told that there is a mismatch between my DB_BLOCK_SIZE (2048)
>> and the controlfile blocksize (8192). (ORA-00218 error).
>>
>> Does anyone know how this can be resolved? I've seen a previous post that
>> suggests that the controlfiles can be recreated - but how is that done?
>> On otn.oracle.com the only suggestion is this:
>>
>> Action: Restore a good copy of the control file.
>>
>> Having never had a good control file makes this advice kind of hard to
>> follow. I'd be very happy if someone could help me out of this mess.
>>
>> Morten
> Change DB_BLOCK_SIZE to match what the control file says (8192). Received on Wed Nov 28 2001 - 17:45:01 CET