Any news about 'kernel bug in aio'?

"Alexei_Roudnev" <[email protected]>
Newsgroups gmane.linux.suse.oracle.general
Message-ID <[email protected]>
Any news?

For now:
- kernel 286 or 287 has an aio bug so it panic time-to-time
- kernel 308 has another aio bug so rman and FAL don't work with it.



>
> I assume that your database use 3 control files.
>
> /opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl
> /opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl
> /opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl
>
> You can check this in your init.ora file parameter
> control_files=
>
> May be it is like this:
>
> control_files=("/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl",
> "/opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl",
> "/opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl")
>
> The name of the init.ora file is normally init[SID].ora.
>
> So your SID is 'fprd' like in the name of the controle files.
>
> control02[SID].ctl
>
> As described in Note:1014751.6 you should start your database with
> a SINGLE good copy of the control file
>
> You should change your init.ora Parameter like this
> control_files=("/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl")
>
> PLEASE make a backup of all database files BEFORE you start with your
> experiments.
>
> Kind regards
> Ronald Breuer
> ---
> Entimo AG
> Stralauer Platz 33 - 34 | 10243 Berlin | Germany
> Tel: +49.30.52 00 24 111 | Fax: +49.30.52 00 24 101
> [email protected] | http://www.entimo.com/
>
> Sitz der Gesellschaft: Berlin, Germany
> Handelsregister: HRB Berlin-Charlottenburg 85073
>
> Vorstand: Jürgen Spieler (Vors.), Erika Tannenbaum, Marianne Neumann,
> Dimitrios Karadimas
>
> Aufsichtratsvorsitzender: Klaus Kögler
>
>
>
> On 31.01.2008 20:27 Dennis Soper wrote:
>> Hi all,
>>         We had a major power outage last night, and our database server, 
>> which
>> was hooked up to a UPS shutdown abnormally (go figure, all the other
>> servers hooked up to this UPS shutdown correctly).  Anyway, when I go to
>> restart the database, I get the following:ORA-00214: controlfile 
>> '/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl' version
>> 281067 inconsistent with file
>> '/opt/oracle/db10gr1/oradata/eprd/control03fprd.ctl' version 28105
>>         So, I found a document on metalink that tells me how to fix the 
>> problem.
>> It tells me to edit the init.ora file, which in this case is, I'm
>> assuming ORACLE_HOME/dbs/initfprd.ora (the name of the file for the
>> particular database), removing all but one control file from the
>> initfprd.ora configuration and doing a STARTUP RESTRICT until I get a
>> startup that doesn't squawk, then copy that control file back to the
>> broken ones, change the config files back to original, then starting up
>> the database.
>>         Anyway, I changed the ORACLE_HOME/dbs/initfprd.ora and the
>> ORACLE_HOME/dbs/init.ora files.  Now I get the following message:
>>         controlfile '/opt/oracle/db10gr1/oradata/eprd/control01fprd.ctl'
>> version 281067 inconsistent with file
>> '/opt/oracle/db10gr1/oradata/eprd/control02fprd.ctl' version 28105
>>         Notice the change in the control file name.
>>         So, I figure I've missed a configuration file somewhere.  Would 
>> anyone
>> happen to know what it might be?  The database is 10gR1 running on SLES
>> 10.
>>         Cheers,
>>         Dennis Soper [email protected]
>> Systems Administrator                             phone:  541.346.2027
>> Facilities Services-- The University of Oregon    fax:    541.346.2299
>> 1276 University of Oregon                         cell:   541.335.1254 
>> Eugene, OR  97403
>
>
>

-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting



-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.