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
Subscribe to:
Post Comments (Atom)
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...
-
Simple but very handy way of taking exports without knowing database password. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFIL...
-
It seems an easy topic, I prefer being careful with the easy ones... so it is handy to have all you need, in one place and which will lead i...
-
This directory is created in the home directory of the oracle user, after making a local connection. I had tested it as follows: [oracle@geo...
1 comment:
That's a very uselful information. Thanks!
Post a Comment