Oracle 8.0.4 Database creation

[Manuel G]

Hi all:

Does anyone knows wich Oracle scripts must be runned after (or during) database creation?

I??ve got 4 of them:

catalog.sql
catexp7.sql
catproc.sql
caths.sql

Anymore is needed?

[Alexander M. Ermes]

Hi there.
I use this script as step 3 during the createion of a database :

spool $DBHOME/logbook/create_${ORACLE_SID}_3.lis

remark - This will take some time, please wait.
set termout on;

connect internal;

@$ORACLE_HOME/rdbms/admin/catalog
/*
@$ORACLE_HOME/rdbms/admin/catalog6
@$ORACLE_HOME/rdbms/admin/catexp6
*/
@$ORACLE_HOME/rdbms/admin/catexp
@$ORACLE_HOME/rdbms/admin/catproc
@$ORACLE_HOME/rdbms/admin/catparr
@$ORACLE_HOME/rdbms/admin/dbmslock
@$ORACLE_HOME/rdbms/admin/dbmspool
remark @$ORACLE_HOME/rdbms/admin/prvtpool
remark @$ORACLE_HOME/rdbms/admin/utlmontr

grant select on v_$parameter to public;
grant select on v_$process to public with grant option;
grant select on v_$session to public with grant option;
grant select on v_$thread to public;

grant execute on dbms_lock to public;
grant execute on dbms_pipe to public;
grant execute on dbms_output to public;
grant execute on standard to public;
grant select on v_$rollstat to public;
grant select on dba_free_space to public;
grant select on dba_ts_quotas to public;
grant select on dba_data_files to public;
grant select on dual to system with grant option;

@$ORACLE_HOME/rdbms/admin/dbmssql.sql
@$ORACLE_HOME/rdbms/admin/prvtsql.plb

grant execute on dbms_sys_sql to system with grant option;

create public synonym v_$session for sys.v_$session;
create public synonym v$rollstat for sys.v_$rollstat;
create public synonym v_$process for sys.v_$process;

create public synonym v$session for sys.v_$session;
create public synonym v$process for sys.v_$process;
create public synonym v$parameter for sys.v_$parameter;
create public synonym v$nls_parameter for sys.v_$nls_parameter;
create public synonym v$sga for sys.v_$sga;
create public synonym v$thread for sys.v_$thread;

rem Following line should be default by now! which it isn't.....

alter tablespace system default storage (pctincrease 0);

alter user system quota 0 on system;
alter user system quota unlimited on tools;
alter user system default tablespace tools temporary tablespace temp;
alter user sys temporary tablespace temp;
alter user sys quota unlimited on tools;
alter user sys quota unlimited on system;
alter user sys quota unlimited on rbs;
alter user sys quota unlimited on users;

connect system/manager;
create view dual as select * from sys.dual;
grant select on dual to public;

rem
@$ORACLE_HOME/rdbms/admin/catdbsyn
rem
@$ORACLE_HOME/sqlplus/admin/pupbld



End of script

Rgds
Alexander M. Ermes

[Andreas D. Skjervold]

Hi

Think you have nailed it.

But for all common purposes, only catalog and catproc is necessary.

catexp7 is only necessary if you'll be running Oracle7 exp og imp utilities against your database.

caths is only necessary for running Heterogeonus Services (connectivity between different database vendors)

If running replication you might also need catrep.sql

Andreas