Re: Setting db_block_size with installer

No, it does not generate sql-script (as it did in previous version). All you get is a template (in XML format), which you can only run in dbca. I like the way, it was before.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 09, 2002 11:53 AM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).