Thank you Yechiel! I'm assuming that if you select this option, it might also generate a database creation script.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Tuesday, July 09, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hello Dennis You probably used one of the 3 preconfigured databases in step 2. If you choose instead "new database" you can change the block size in step 7: Initialization parameters. The reason is that the other 3 databases are created from data files that are already included in the CD, so you can not change their block size. When I choose general database, step 7 did not gave me an option to change the db_block_size. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 7:48 PM > I am trying to install Oracle 9.2 on Solaris using dbca (Database > Configuration Assistant) and didn't see a handy box to set the > db_block_size. I just edited the initialization parameter, but when dbca > started installing the database, it returned the errors: > ORA-01503 Create controlfile failed > ORA-00058 DB_BLOCK_SIZE must be 4096 to mount this database, not 8182 > > This made me think that since dbca copies the files rather than creates > them, that it may not be possible to use other than a 4k block size. > But on the other hand, I wanted to use dbca to ensure that I created the > database like an Oracle 9.2 database, rather than just create it like I > would in Oracle 8i. > Has anyone else faced this issue and have any thoughts to share? > > Thanks. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).