Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create 9.2.0 database manually

Re: Create 9.2.0 database manually

From: Timmy Sin <tswsin_at_yahoo.com>
Date: Tue, 31 Dec 2002 09:32:28 +0800
Message-ID: <auqs3e$1cr$1@news.hk.linkage.net>


Thanks for your input. I would change the script accordingly. BTW, how about the other scripts apart from catalog, catproc and pupbld?

Thanks.

Timmy
"Paul Brewer" <paul_at_paul.brewers.org.uk> ¼¶¼g©ó¶l¥ó·s»D :3e0f32c9$1_1_at_mk-nntp-1.news.uk.worldonline.com...
> "santosh" <santyspam_at_yahoo.com> wrote in message
> news:aui3vj$7f38d$1_at_ID-84096.news.dfncis.de...
> >
> > "Timmy Sin" <tswsin_at_yahoo.com> wrote in message
> > news:auh5c6$gd2$1_at_news.hk.linkage.net...
> > > Hi all,
> > >
> > > I want to have a very clean 9.2.0 database (without any unnecessary
> > objects)
> > > and choose to create it manually instead of using dbca. I've prepared
> the
> > > following script to create the database. I would like to know if there
> is
> > > any other administration scripts (apart from the three scripts shown)
> that
> > I
> > > have to run for the proper functioning of the database. Any comment on
> the
> > > script is also welcomed.
> > > #####################################
> > > CREATE DATABASE test
> > > MAXINSTANCES 1
> > > MAXLOGHISTORY 1
> > > MAXLOGFILES 5
> > > MAXLOGMEMBERS 5
> > > MAXDATAFILES 100
> > > CHARACTER SET UTF8
> > > NATIONAL CHARACTER SET UTF8
> > > LOGFILE GROUP 1 ('/database/oradata/test/dbfile/test_redo_11.rdo',
> > > '/database/oradata/test/dbfile/test_redo_12.rdo')
SIZE
> > 10M,
> > > GROUP 2
> ('/database/oradata/test/dbfile/test_redo_21.rdo',
> > > '/database/oradata/test/dbfile/test_redo_22.rdo')
SIZE
> > 10M,
> > > GROUP 3
> ('/database/oradata/test/dbfile/test_redo_31.rdo',
> > > '/database/oradata/test/dbfile/test_redo_32.rdo')
SIZE
> > 10M
> > > DATAFILE '/database/oradata/test/dbfile/test_system_01.dbf'
> > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
> > > DEFAULT TEMPORARY TABLESPACE temp
> > > TEMPFILE '/database/oradata/test/dbfile/test_temp_01.dbf'
> > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
> > > UNDO TABLESPACE undo
> > > DATAFILE '/database/oradata/test/dbfile/test_undo_01.dbf'
> > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
> > > CREATE TABLESPACE user DATAFILE
> > > '/database/oradata/test/dbfile/test_user_01.dbf'
> > > SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
> > > @/app/oracle/product/9.2.0/rdbms/admin/catalog.sql
> > > @/app/oracle/product/9.2.0/rdbms/admin/catproc.sql
> > > connect system/manager
> > > @/app/oracle/product/9.2.0/sqlplus/admin/pupbld.sql
> > > exit;
> > > ########################################
> > >
> > > Thank you very much for your comment.
> > >
> > > Regards,
> > > Timmy
> > >
> > I doubt that you can use UNIFORM allocation for UNDO tablespaces. I
> checked
> > this in 9.0.1 and it gave me an error. Can somebody clarify that this is
> > still the same in 9.2?
> >
> > TIA
> > santosh
> >
> >
> >
> >
> It seems so, but I rather think this is a syntax question, rather than
size
> of extents. For undo, in any version, I'd be surprised if the extent sizes
> were other than uniform :-)

>

> Out of interest, I tried out the above script (changing paths etc. as
> appropriate) in 9.2.0.1 on Windows XP.
>

> In the init.ora (copying Oracle's example) I put:
>

> undo_management=AUTO
> undo_retention=10800
> undo_tablespace=UNDO
>

> In the create database I then had to put:
> ...
> UNDO TABLESPACE undo
> DATAFILE 'G:\Oracle\oradata\test\test_undo_01.dbf'
> SIZE 200M;
>

> in order to make it work.
>

> BTW (to OP) I notice that both members of each logfile
> group are mounted on the same node....
> Also, as well as changing passwords for SYS and SYSTEM, I'd suggest
locking
> the OUTLN and DBSNMP accounts.
> Regards,
> Paul
>
>
>
Received on Mon Dec 30 2002 - 19:32:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US