Re: controlfile mismatch

"Morten" <morten_skovgaard_at_hotmail.com> wrote in message news:3c04e0a5$0$31393$edfadb0f_at_dspool01.news.tele.dk...
> 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
>
>

Did you, by any chance, *change* the init<sid>.ora parameter db_block_size from the default 2048 to 8192 *without recreating the database*? If so, change the parameter back, restart the database, and you should be OK.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address