This is the ORACLE instance parameter file used to create and run the instance and database.
### File : initECL0.ora
### Author : James Bischoff
### Purpose : Eclipse Database Instance Parameters
always_anti_join = HASH
background_dump_dest = D:\Oracle\Admin\ECL0\bdump
compatible = 8.0.4.0.0
control_files = F:\Oracle\Data\ECL0\Control1.dbf H:\Oracle\Data\ECL0\Control2.dbf
db_block_buffers = 50000
db_block_size = 8192
db_domain = btsinet.com
db_files = 1020
db_file_multiblock_read_count = 16
db_file_simultaneous_writes = 20
db_name = ECL0
dml_locks = 5000
global_names = TRUE
hash_area_size = 4000000
hash_join_enabled = TRUE
hash_multiblock_io_count = 4
job_queue_processes = 1
log_archive_buffers = 4
log_archive_buffer_size = 127
log_archive_dest = J:\Outgoing\Archive
log_archive_format = Seq%sThrd%t.log
log_archive_start = FALSE
log_buffer = 8388608
log_checkpoint_interval = 8000
max_dump_file_size = 10240
log_checkpoint_timeout = 0
open_cursors = 250
open_links = 25
open_links_per_instance = 25
parallel_min_servers = 10
parallel_max_servers = 100
processes = 200
pre_page_sga = TRUE
remote_login_passwordfile = exclusive
rollback_segments = (R01,R02,R03,R04)
sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
shared_pool_size = 100000000
shared_pool_reserved_size = 10000000
sort_area_size = 4000000
sort_area_retained_size = 4000000
sort_direct_writes = AUTO
timed_statistics = TRUE
user_dump_dest = D:\Oracle\Admin\ECL0\udump
This command file creates the NT service that will host all of the ORACLE background processes.
rem *****************************************************************
rem File : crdbECL0.cmd
rem Author : James Bischoff
rem Purpose : Create the ECL0 instance
rem *****************************************************************
D:\Oracle\Product\Orant\bin\oradim80 -new -sid ECL0 -intpwd ****** -startmode auto -pfile D:\Oracle\Admin\ECL0\PFile\initECL0.ora
D:\Oracle\Product\Orant\bin\oradim80 -startup -sid ECL0 -starttype srvc,inst -usrpwd ****** -pfile D:\Oracle\Admin\ECL0\PFile\initECL0.ora
D:\Oracle\Product\Orant\bin\svrmgr30 @crdbECL0.sql
This script creates the ORACLE database and runs the scripts needed to set up the system resources.
rem *****************************************************************
rem File : crdbECL0.sql
rem Author : James Bischoff
rem Purpose : Create the ECL0 database
rem *****************************************************************
set termout on
set echo on
spool K:\Oracle\Admin\ECL0\Create\Base\crdbECL0.log
rem *** Connect as the internal user ***
connect internal/**********
rem *** Startup the database instance without mounting it ***
startup nomount pfile=D:\Oracle\Admin\ECL0\PFile\initECL0.ora
rem *** Create the system and redo log files ***
create database ECL0
logfile
group 1 ('F:\Oracle\Data\ECL0\grp1log0.dbf','H:\Oracle\Data\ECL0\grp1log1.dbf') size 100M,
group 2 ('F:\Oracle\Data\ECL0\grp2log0.dbf','H:\Oracle\Data\ECL0\grp2log1.dbf') size 100M,
group 3 ('F:\Oracle\Data\ECL0\grp3log0.dbf','H:\Oracle\Data\ECL0\grp3log1.dbf') size 100M,
group 4 ('F:\Oracle\Data\ECL0\grp4log0.dbf','H:\Oracle\Data\ECL0\grp4log1.dbf') size 100M,
group 5 ('F:\Oracle\Data\ECL0\grp5log0.dbf','H:\Oracle\Data\ECL0\grp5log1.dbf') size 100M
maxlogfiles 32
maxlogmembers 2
maxloghistory 1
noarchivelog
datafile 'K:\Oracle\Data\ECL0\system.dbf' size 100M
maxdatafiles 254
maxinstances 1
character set WE8ISO8859P1
national character set WE8ISO8859P1;
rem *** Create temporary rollback segment to use when creating tablespaces ***
create rollback segment r0
tablespace system
storage (
initial 16K
next 16K
minextents 2
maxextents 20);
rem *** Put the temporary rollback segment online ***
alter rollback segment r0 online;
rem *** Alter system tablespace ***
alter tablespace system
default storage (
initial 100K
next 100K
pctincrease 0
minextents 1
maxextents 300);
rem *** Create rollback segment tablespace ***
create tablespace rbs
datafile 'K:\oracle\data\ECL0\Rollback.dbf'
size 5000M
default storage (
initial 1M
next 1M
pctincrease 0
minextents 2
maxextents 500);
rem *** Create temporary segment tablespace ***
create tablespace temp
datafile 'K:\oracle\data\ECL0\Temporary.dbf'
size 15000M
temporary
default storage (
initial 256K
next 256K
pctincrease 0
minextents 1
maxextents UNLIMITED);
rem *** Create tools tablespace ***
create tablespace tools
datafile 'K:\oracle\data\ECL0\Tools.dbf'
size 500M
default storage (
initial 256K
next 256K
pctincrease 0
minextents 1
maxextents UNLIMITED);
rem *** Create rollback segments ***
create public rollback segment r01
tablespace rbs
storage(
initial 1M
next 1M
minextents 100
maxextents 4000
optimal 100M);
create public rollback segment r02
tablespace rbs
storage(
initial 1M
next 1M
minextents 100
maxextents 4000
optimal 100M);
create public rollback segment r03
tablespace rbs
storage(
initial 1M
next 1M
minextents 100
maxextents 4000
optimal 100M);
create public rollback segment r04
tablespace rbs
storage(
initial 1M
next 1M
minextents 100
maxextents 4000
optimal 100M);
rem *** Put the new rollback segments online ***
alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
rem *** The temporary rollback segment is not needed anymore ***
alter rollback segment r0 offline;
drop rollback segment r0;
rem *** Alter sys/internal and system users ***
alter user sys
identified by **********
temporary tablespace temp;
alter user system
identified by **********
temporary tablespace temp
default tablespace tools
quota unlimited on tools;
rem *** Create standard data dictionary views ***
@D:\Oracle\Product\Orant\Rdbms80\admin\catalog.sql;
rem *** Install PL/SQL support ***
@D:\Oracle\Product\Orant\Rdbms80\admin\catproc.sql;
rem *** Install heterogeneous services ***
@D:\Oracle\Product\Orant\Rdbms80\admin\caths.sql;
rem *** Create dynamic lock views ***
@D:\Oracle\Product\Orant\Rdbms80\admin\catblock.sql;
rem *** Install dbms_shared_pool utility package ***
@D:\Oracle\Product\Orant\Rdbms80\admin\dbmspool.sql;
rem *** Install dbms_pipe utility package ***
@D:\Oracle\Product\Orant\Rdbms80\admin\dbmspipe.sql;
rem *** The remaining scripts must be run from the system account ***
connect system/**********;
rem *** Create the data dictionary synonyms ***
@D:\Oracle\Product\Orant\Rdbms80\admin\catdbsyn.sql;
rem *** Create the product user profile tables ***
@D:\Oracle\Product\Orant\dbs\pupbld.sql;
rem *** Create the explain plan table ***
@D:\Oracle\Product\Orant\Rdbms80\admin\utlxplan.sql;
create public synonym PLAN_TABLE for system.plan_table;
grant all on plan_table to public;
rem *** Create the validate structure table ***
@D:\Oracle\Product\Orant\Rdbms80\admin\utlvalid.sql;
create public synonym INVALID_ROWS for system.invalid_rows;
grant all on invalid_rows to public;
rem *** Create the list chained rows table ***
@D:\Oracle\Product\Orant\Rdbms80\admin\utlchain.sql;
create public synonym CHAINED_ROWS for system.chained_rows;
grant all on chained_rows to public;
rem *** The plan table must also belong to SYS for the Enterprise Manager ***
connect sys/**********;
@D:\Oracle\Product\Orant\Rdbms80\admin\utlxplan.sql;
rem *** Shut it down clean ***
connect internal/**********
shutdown immediate
exit
spool off
|
