| Database Creation
:::::::::::::: cr_TDB8.sql :::::::::::::: -- This script calls other scripts to create a new database, tablespaces, -- rollback segments, data dictionary views, setup admin users and roles -- @@cr_db.sql @@cr_ts.sql @@cr_rs.sql @@cr_dd.sql @@cr_users.sql @@cr_roles.sql @@utlmontr.sql :::::::::::::: cr_db.sql :::::::::::::: set echo on spool cr_db.log connect internal startup nomount pfile=/tools/oracle/admin/TDB8/pfile/initTDB8.ora create database "TDB8" maxinstances 16 maxlogfiles 32 maxdatafiles 1022 maxlogmembers 4 maxloghistory 1600 character set "US7ASCII" datafile '/disk1/oradata/TDB8/system01.dbf' SIZE 75M REUSE logfile group 1 ('/disk1/oradata/TDB8/redo01.log', '/disk2/oradata/TDB8/redo01_m.log' ) SIZE 10M REUSE, group 2 ('/disk1/oradata/TDB8/redo02.log', '/disk2/oradata/TDB8/redo02_m.log' ) SIZE 10M REUSE, group 3 ('/disk1/oradata/TDB8/redo03.log', '/disk2/oradata/TDB8/redo03_m.log' ) SIZE 10M REUSE, group 4 ('/disk1/oradata/TDB8/redo04.log', '/disk2/oradata/TDB8/redo04_m.log' ) SIZE 10M REUSE / spool off :::::::::::::: cr_ts.sql :::::::::::::: set echo on spool cr_ts.log CREATE TABLESPACE rollback DATAFILE '/disk1/oradata/TDB8/rollback01.dbf' SIZE 200M REUSE DEFAULT STORAGE (INITIAL 2M NEXT 2M MINEXTENTS 5 PCTINCREASE 0) / CREATE TABLESPACE temp DATAFILE '/disk2/oradata/TDB8/temp01.dbf' SIZE 100M REUSE DEFAULT STORAGE (PCTINCREASE 0) TEMPORARY / CREATE TABLESPACE users DATAFILE '/disk3/oradata/TDB8/users01.dbf' SIZE 1M REUSE DEFAULT STORAGE (PCTINCREASE 0) / CREATE TABLESPACE data_01 DATAFILE '/disk1/oradata/TDB8/data01.dbf' SIZE 200M REUSE DEFAULT STORAGE (PCTINCREASE 0) / CREATE TABLESPACE indx_01 DATAFILE '/disk2/oradata/TDB8/indx01.dbf' SIZE 200M REUSE DEFAULT STORAGE (PCTINCREASE 0) / spool off :::::::::::::: cr_rs.sql :::::::::::::: set echo on spool cr_rs.log CREATE ROLLBACK SEGMENT r01 TABLESPACE rollback STORAGE (OPTIMAL 10M) / CREATE ROLLBACK SEGMENT r02 TABLESPACE rollback STORAGE (OPTIMAL 10M) / CREATE ROLLBACK SEGMENT r03 TABLESPACE rollback STORAGE (OPTIMAL 10M) / CREATE ROLLBACK SEGMENT r04 TABLESPACE rollback STORAGE (OPTIMAL 10M) / ALTER ROLLBACK SEGMENT r01 ONLINE / ALTER ROLLBACK SEGMENT r02 ONLINE / ALTER ROLLBACK SEGMENT r03 ONLINE / ALTER ROLLBACK SEGMENT r04 ONLINE / spool off :::::::::::::: cr_dd.sql :::::::::::::: @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql @$ORACLE_HOME/rdbms/admin/catparr.sql @$ORACLE_HOME/rdbms/admin/catblock.sql @$ORACLE_HOME/rdbms/admin/catrep.sql connect system/manager @$ORACLE_HOME/sqlplus/admin/pupbld.sql CREATE SYNONYM dba_kgllock FOR sys.dba_kgllock / CREATE SYNONYM dba_locks FOR sys.dba_locks / CREATE SYNONYM dba_lock FOR sys.dba_lock / CREATE SYNONYM dba_lock_internal FOR sys.dba_lock_internal / CREATE SYNONYM dba_dml_locks FOR sys.dba_dml_locks / CREATE SYNONYM dba_ddl_locks FOR sys.dba_ddl_locks / CREATE SYNONYM dba_waiters FOR sys.dba_waiters / CREATE SYNONYM dba_blockers FOR sys.dba_blockers / :::::::::::::: cr_users.sql :::::::::::::: -- create user OPS$ORACLE and grant appropriate privileges CREATE USER ops$oracle IDENTIFIED EXTERNALLY DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp / GRANT analyze any, alter database, alter tablespace, create session, create synonym, exp_full_database, restricted session TO ops$oracle / -- alter DBSNMP's privileges GRANT create session TO dbsnmp / REVOKE connect, resource FROM dbsnmp / ALTER USER dbsnmp DEFAULT TABLESPACE users / -- alter user temporary tablespace ALTER USER SYS TEMPORARY TABLESPACE temp / ALTER USER SYSTEM TEMPORARY TABLESPACE temp / ALTER USER OUTLN TEMPORARY TABLESPACE temp / ALTER USER DBSNMP TEMPORARY TABLESPACE temp / ALTER USER TRACESVR TEMPORARY TABLESPACE temp / ALTER USER AURORA$ORB$UNAUTHENTICATED TEMPORARY TABLESPACE temp / :::::::::::::: cr_roles.sql :::::::::::::: CREATE ROLE product_owner / GRANT CREATE PROCEDURE TO product_owner / GRANT CREATE PUBLIC DATABASE LINK TO product_owner / GRANT CREATE DATABASE LINK TO product_owner / GRANT CREATE SYNONYM TO product_owner / GRANT CREATE PUBLIC SYNONYM TO product_owner / GRANT CREATE ROLE TO product_owner / GRANT CREATE SNAPSHOT TO product_owner / GRANT CREATE TABLE TO product_owner / GRANT CREATE VIEW TO product_owner / GRANT CREATE SEQUENCE TO product_owner / GRANT DROP PUBLIC SYNONYM TO product_owner / GRANT DROP PUBLIC DATABASE LINK TO product_owner / GRANT CREATE TRIGGER TO product_owner / GRANT CREATE CLUSTER TO product_owner /
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|