Friday, January 29, 2010

DBCA Seed_Database_8k.dfb creation error

Problem:

ORA-19624, ORA-19870 , ORA-19505, ORA-27037 errors while creating database with DBCA.

Cause:


This issue is reported in Bug 5141453.

The database templates General Purpose, Transaction Procession, and
DataWarehouse are expected to be used only with 8k block size as the seed
database is shipped at 8k block size

Solution:

From Bug 5141453, development indicates that DB_BLOCK_SIZE cannot be changed
for the General Purpose, Transaction Procession and DataWarehouse templates
as the seed database is using 8k block size.

You should create a custom database to get a different block size.
References
Bug 5141453 - DBCA - CREATE DATABASE SCRIPTS - LOOKING FOR
SEED_DATABASE_8K.DFB Keywords CUSTOM~DATABASE; DB_BLOCK_SIZE; DBCA;

Thanks to guy Sallwasser Laura in the link:

http://www.lazydba.com/oracle/0__166384.html

1 comment:

Sameer said...

That's a very uselful information. Thanks!

Windows (powershell) counterparts of Linux commands

You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...