Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
-- script: 53_win_920_db_build_2_1.sql
-- Features: This sql script is the main script which builds the Oracle database.
--
-- Script Sequence#: 53
-- Used By: run by 17_win_920_db_build_1_1.pl script
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 07-02-2002 dsimpson Initial Release for Oracle 9.2.0
-- (SYSTEM tablespace is now locally managed)
-- 07-09-2002 dsimpson Removed trailing "/" after create database.
-- This output file was created by Installgen version 1.38 on Thu Nov 14 17:48:05 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
connect / as SYSDBA
create spfile='c:\v901\database\spfileprod3.ora' FROM pfile='c:\v901\database\initprod3.ora';
set echo on
spool c:\v901\assistants\dbca\logs\CreateDB.log
shutdown abort
connect / as SYSDBA
startup nomount pfile="c:\v901\database\initprod3.ora";
CREATE DATABASE PROD3
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE 'c:\u01\prod3\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "undotbs" DATAFILE 'c:\u01\prod3\undo01.dbf' SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'c:\u01\prod3\temp01.dbf' SIZE 55M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('c:\u01\prod3\redo01.log', 'c:\u01\prod3\redo01g1f2.log') SIZE 10M,
GROUP 2 ('c:\u01\prod3\redo02.log', 'c:\u01\prod3\redo02g2f2.log') SIZE 10M,
GROUP 3 ('c:\u01\prod3\redo03.log', 'c:\u01\prod3\redo03g3f2.log') SIZE 10M
set time_zone = 'America/Los_Angeles';
spool off
--c:\v901\bin\sqlplus /nolog @\u01\scripts\CreateDBFiles.sql
spool c:\v901\assistants\dbca\logs\CreateDBFiles.log
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'c:\u01\prod3\tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "USERS" LOGGING DATAFILE 'c:\u01\prod3\users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "RBS" LOGGING DATAFILE 'c:\u01\prod3\rbs01.dbf' SIZE 20M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "INDX" LOGGING DATAFILE 'c:\u01\prod3\indx01.dbf' SIZE 50M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "XDB" LOGGING DATAFILE 'c:\u01\prod3\xdb01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'c:\u01\prod3\drsys01.dbf' SIZE 85M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
spool off
--c:\v901\bin\sqlplus /nolog @\u01\scripts\CreateDBCatalog.sql
spool c:\v901\assistants\dbca\logs\CreateDBCatalog.log
@c:\v901\rdbms\admin\catalog.sql;
@c:\v901\rdbms\admin\catexp7.sql;
@c:\v901\rdbms\admin\catblock.sql;
@c:\v901\rdbms\admin\catproc.sql;
@c:\v901\rdbms\admin\catoctk.sql;
-- add obfuscation toolkit
@c:\v901\rdbms\admin\catobtk.sql;
@c:\v901\rdbms\admin\owminst.plb;
exit;
