RE: Setting db_block_size with installer

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.
dwilliams_at_lifetouch.com

-----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 <ORACLE-L_at_fatcity.com> 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.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).