"Timmy Sin" <tswsin_at_yahoo.com> wrote in message
news:auqs3e$1cr$1_at_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
> >
> >
> >
>
>
Sorry. What other scripts do you want?
Regards,
Paul
Received on Tue Dec 31 2002 - 11:51:32 CST
