RE: Post-Database creation scripts

One of the things I do whenever I get a new Oracle release is to see what scripts are called by the cat*.sql programs in $ORACLE_HOME/rdbms/admin. Under Oracle 8.1.6 dbmsutil.sql, dbmslock.sql, and prvtlock.plb are all called by catproc.sql.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Monday, July 24, 2000 3:19 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Post-Database creation scripts

In my case, it is always:

catalog.sql
catproc.sql
catrep.sql
utlrp.sql
catblock.sql
catoctk.sql

dbmsutil.sql
dbmspool.sql
dbmslock.sql
prvtlock.plb

Winnie

Glenn Travis <Glenn.Travis_at_wcom.com> on 07/24/2000 01:54:30 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Pardon the question, but somone (I believe Rachel, among others) posted here
recently a list of scripts (from $ORACLE_HOME/rdbms/admin, I believe) that should always be run after database creation.

Does anyone have that list, or a reference to it? Basically it was a personal opinion of scripts which DBAs should always execute when creating Received on Tue Jul 25 2000 - 10:23:35 CDT