SQWareProduction:oracle:etc:sqwora CreDb Create.cfg

From wiki_dbSQWare
Jump to: navigation, search

Configuration file $gvsqw_OraBin/../etc/sqwora_CreDb_Create.cfg:



File content:

spool ./cr_base.log
connect / as sysdba
create spfile from pfile;
startup nomount
create database <ORACLE_SID>
user sys    identified by temp
user system identified by temp
	 extent management local
       datafile '<gvsqw_RootDbf>/base1/system_01.dbf' size 256m autoextend on next 32m maxsize 8192m
sysaux   datafile '<gvsqw_RootDbf>/base1/sysaux_01.dbf' size 256m autoextend on next 32m maxsize 8192m
default tablespace users
         datafile '<gvsqw_RootDbf>/base2/users_01.dbf'  size 32m autoextend on next 32m maxsize 128M
default temporary tablespace temp
         tempfile '<gvsqw_RootDbf>/base1/temp01.dbf' size 256m autoextend on next 32m maxsize 2048m
         extent management local uniform size 1M
undo tablespace undo
         datafile '<gvsqw_RootDbf>/base1/undo01.dbf' size 256m autoextend on next 32m maxsize 2048m
logfile
group 1 ('<gvsqw_RootDbf>/base1/redo_11.rdo', '<gvsqw_RootDbf>/base2/redo_12.rdo') size 64M,
group 2 ('<gvsqw_RootDbf>/base1/redo_21.rdo', '<gvsqw_RootDbf>/base2/redo_22.rdo') size 64M,
group 3 ('<gvsqw_RootDbf>/base1/redo_31.rdo', '<gvsqw_RootDbf>/base2/redo_32.rdo') size 64M,
group 4 ('<gvsqw_RootDbf>/base1/redo_41.rdo', '<gvsqw_RootDbf>/base2/redo_42.rdo') size 64M
CHARACTER SET <lvsqw_CharacterSet>
NATIONAL CHARACTER SET AL16UTF16
MAXLOGFILES 40
MAXLOGMEMBERS 4
MAXINSTANCES  1
MAXDATAFILES 200
/
connect / as sysdba
@?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catblock.sql;
@?/rdbms/admin/catproc.sql;
@?/rdbms/admin/catoctk.sql;
@?/rdbms/admin/owminst.plb;
@?/rdbms/admin/dbmssupp.sql

@?/rdbms/admin/utlrp.sql
grant select on v_$session to public;
grant execute on dbms_support to public;
create public synonym dbms_support for sys.dbms_support;
--Attention, revoke cause errors (see Note: [ID 247093.1])
--REVOKE ALL ON UTL_FILE FROM PUBLIC;
--REVOKE EXECUTE ON UTL_TCP FROM PUBLIC;
--REVOKE EXECUTE ON UTL_HTTP FROM PUBLIC;
--REVOKE EXECUTE ON UTL_SMTP FROM PUBLIC;
--REVOKE EXECUTE ON DBMS_LOB FROM PUBLIC;
--REVOKE EXECUTE ON DBMS_SQL FROM PUBLIC;
--REVOKE EXECUTE ON DBMS_SCHEDULER FROM PUBLIC;
--REVOKE EXECUTE ON OWA_UTIL FROM PUBLIC;

connect system/temp
@?/sqlplus/admin/pupbld.sql
@?/rdbms/admin/utlxplan.sql
GRANT DELETE ON  SYSTEM.PLAN_TABLE TO PUBLIC;
GRANT INSERT ON  SYSTEM.PLAN_TABLE TO PUBLIC;
GRANT SELECT ON  SYSTEM.PLAN_TABLE TO PUBLIC;
GRANT UPDATE ON  SYSTEM.PLAN_TABLE TO PUBLIC;

conn / as sysdba
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
create user ops$<gvsqw_UserExec> identified externally;
grant dba, select any table, select any dictionary, alter session to ops$<gvsqw_UserExec> with admin option;
alter user ops$<gvsqw_UserExec> default role all;
-- workaround bug 6392040
grant dba, EXP_FULL_DATABASE to ops$<gvsqw_UserExec> with admin option;
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO ops$<gvsqw_UserExec> with grant option;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO ops$<gvsqw_UserExec> with grant option;

select COMP_NAME, VERSION, STATUS from dba_registry;
spool off
exit