ORA-03113 and init.ora setting db

From: Rytis Sileika <rytis_at__NS--PLEASE-REMOVE-THIS_dr.com>
Date: Fri, 17 Dec 2004 11:14:59 +0000
Message-ID: <32fteaF3mmavjU1@individual.net>

Hello,

I encountered this problem and thought it might be helpful to someone if I share my experience.

When creating a DB with 'dbca' tool (Oracle 9i (9.2.xx)) it failed with the error code ORA-03110 (end of file on communication channel).

This error was caused by wrong setting in generated init.ora file. I set variable 'db_block_size' to 8MB and Oracle just failed. When I reduced it to more reasonable value of 64k, I got an error message telling me that this variable can only be set to values from 2k to 32k. So I set it to 16k and everything went well.

Regards,
Rytis Received on Fri Dec 17 2004 - 05:14:59 CST

ORA-03113 and init.ora setting db_block size