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 - 10:45:01 CST
