Re: Setting db_block_size with installer

Thanks, Yechiel

guess, I missed this option, should look again.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

The degree of normality in a database
is inversely proportional to that of its DBA.

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

> Igor, since you wanted it to be as before,
> you would like to hear that my DBCA on the last screen
> gives also an option to create the scripts.
>
> It bombed on some Java error so I can not verify
> that the scripts are created ok, but the screen is there.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 09, 2002 6:23 PM
>
>
> > 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).
>
> --
> 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: 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).