Re: Create 9.2.0 database manually

I mean the sql scripts under ~/app/oracle/product/9.2.0/rdbms/admin. Do I need to run other additional scripts for the proper functioning of my database. I will not use any Java and XML features.

Thanks for your assistance.

Regards,
Timmy

"Paul Brewer" <paul_at_paul.brewers.org.uk> 撰寫於郵件新聞 :3e11e23e_1_at_mk-nntp-1.news.uk.worldonline.com...
> "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> 撰寫於郵件新聞
> > :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?

>

>
>
>