Re: Create 9.2.0 database manually

"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 Sun Dec 29 2002 - 11:24:06 CST