Manualsbrain.com
  1. Handbücher
  2. Marken
  3. Oracle Audio Technologies
  4. 13
  5. Benutzerhandbuch

Oracle Audio Technologies 13 Benutzerhandbuch

Download
Seite von 35
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;