Re: Create 9.2.0 database manually

"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 Received on Fri Dec 27 2002 - 11:29:43 CST