Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: controlfile mismatch

Re: controlfile mismatch

From: Rüdiger J. Schulz <johannes.schulz_at_web.de>
Date: 28 Nov 2001 17:54:35 +0200
Message-ID: <3c0516cb$1@netnews.web.de>


set the DB_BLOCK_SIZE parameter in the init.ora to 8192. then the db will startup successfull.
however, the block-size off 2k (2048) is very small ...

hth
Rüdiger J. Schulz
rjs_at_berlin.de

"Morten" <morten_skovgaard_at_hotmail.com> 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
>
>

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Wed Nov 28 2001 - 09:54:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US