Home » RDBMS Server » Server Administration » Database Creation - DBCA bug!
Database Creation - DBCA bug! [message #61582] Thu, 06 May 2004 11:36
Tony
Messages: 190
Registered: June 2001
Senior Member
I have been getting the following error when I try to create a new database using 'dbca' on Oracle 9i (Solaris).  I wanted the db_block_size to be 8192 instead of the default 4096 in the dbca templates.    Unfortunately when I read metalink , there is a bug in DBCA which doesn't take the modified db_block_size into consideration when you create  new database.   So they recommend to create the database using scripts instead of using dbca.    Is there an equivalent default script provided in Oracle 9i for Solaris for creating databases?  If not, can I find one  somehwere which is comprehensive?    Any link will be great.

Error Info:  (I get this when creating a new db using dbca with db_block_size 8192):

ORA-01503: CREATE CONTROLFILE failed

ORA-0058: DB_BLOCK_SIZE must be 4096 to mount this database (not 8192).

Help Please

Tony
Previous Topic: Exporting Tables
Next Topic: Adding additional file to a tablespace
Goto Forum:
  


Current Time: Wed Jan 08 14:31:10 CST 2025