Oracle 9i Database creation issue: Control file wrong block size
Posted on 2003-11-04
Help clarify something for me please, I haven't done an install since 7.x. Using dbca, I attempted to create a database, where the initial block size (db_block_size) was set to 8k. When DBCA attempted to create the database, it threw an error stating that the control files needed to be 4k (the default). I was not able to get DBCA to create the database until i reset the db_block_size parameter back to 4k.
Is this a known problem with dbca, or a misunderstanding on my part?
I'm also a bit confused by the pfile. When I let Oracle create a database, the only initialization file I could find appears to be a compiled form of the init<sid>.ora files I'm familiar with. I was able to see some typical text parameters in the file, but it is a binary file (not a text file).
Is there a way that one creates a pfile from an init<sid>.ora file?