Re: Create 9.2.0 database manually

Thanks for your information. However, it seems that the mentioned feature would no longer available since 9.2.0.

Timmy

"Rauf Sarwar" <rs_arwar_at_hotmail.com>
???????:92eeeff0.0212270929.10485861_at_posting.google.com... > "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

>
>
> The easy way to do this is to run dbca, specify all parameters and
> then let dbca create the database creation scripts without actually
> creating the database. There will be 1 .sh and 4 to 5 .sql scripts.
> You can edit the creation scripts, if you want to, before running the
> .sh file. This way you will let dbca cross all the t's and dot all the
> i's for you.
>
> Other tasks invlove listing your new database in the oratab file,
> listener file and creating a script to shutdown and restart your
> instance on server reboots.
>
> Regards
> /Rauf Sarwar