Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 31)

Install Oracle Configuration Manager
Database Installation Guide 23
GROUP 3 ('<datafile_path>/redo3a.log') SIZE 1000M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '<datafile_path>/temp01.dbf' SIZE 5000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE undo_ts DATAFILE '<datafile_path>/undo_ts01.dbf' SIZE 5000M
SYSAUX DATAFILE '<datafile_path>/sysaux01.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M
MAXSIZE 2000M
;
exit
spool off
----------------------------------------------------------------------------------
---
--- Script: crdb2.sql
--- Execute as: sysdba in 10.1.0.2 databases or higher
--- Note: This script installs the data dictionary views in addition to
--- granting necessary privileges to public.
----------------------------------------------------------------------------------
---
spool crdb2.log
REM # install data dictionary views:
PROMPT Running catalog.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql;
PROMPT Running catblock.sql
@$ORACLE_HOME/rdbms/admin/catblock.sql;
PROMPT Running catproc.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql;
PROMPT Running catoctk.sql
@$ORACLE_HOME/rdbms/admin/catoctk.sql;
PROMPT Running catrep.sql
@$ORACLE_HOME/rdbms/admin/catrep.sql;
PROMPT Running owminst.plb
@$ORACLE_HOME/rdbms/admin/owminst.plb;
REM * These privs needed for users to run proper grant code when creating users.
grant select on dba_jobs to public with grant option;
grant select on dba_roles to public with grant option;
grant select on dba_role_privs to public with grant option;
grant execute on dbms_rls to public with grant option;
grant execute on dbms_alert to public;
grant select_catalog_role to public;
grant execute_catalog_role to public;
grant execute on dbms_lock to public;
grant execute on dbms_rls to public;
grant execute on dbms_crypto to public;
grant select on dba_sys_privs to public with grant option;
REM * query rewrite privilege needed to create function-based indexes
grant query rewrite to public;
REM * dbms_system is needed for tracing
grant execute on sys.dbms_system to public;
PROMPT Creating PLAN table owned by SYSTEM
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
PROMPT Creating public synonyn for the plan table
create public synonym PLAN_TABLE for SYSTEM.PLAN_TABLE;
connect SYSTEM/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;