Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
-- script: 53_macosx_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 8_macosx_920_db_build_1.sh script
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 10-11-2002 dsimpson Initial Release for Oracle 9.2.0
-- 11-03-2002 dsimpson Corrected path to pfile when creating spfile.
-- This output file was created by Installgen version 1.38 on Sat Nov 23 07:13:32 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
connect / as SYSDBA
-- remove any previously created spfile
host rm /Users/oracle/v920/dbs/spfileprod1.ora
create spfile='/Users/oracle/v920/dbs/spfileprod1.ora' FROM pfile='/Users/oracle/v920/dbs/initprod1.ora';
-- remove any previously created orapw file
host rm /Users/oracle/v920/dbs/orapw
-- create new orapw file
host /Users/oracle/v920/bin/orapwd file=/Users/oracle/v920/dbs/orapw password=s9_21sv entries=20
spool /Users/oracle/v920/assistants/dbca/logs/CreateDB.log
set echo on
spool /Users/oracle/v920/assistants/dbca/logs/CreateDB.log
shutdown abort
connect / as SYSDBA
startup nomount pfile="/Users/oracle/v920/dbs/initprod1.ora";
CREATE DATABASE PROD1
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/Volumes/u01/prod1/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "undotbs" DATAFILE '/Volumes/u01/prod1/undo01.dbf' SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/Volumes/u03/prod1/temp01.dbf' SIZE 55M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/Volumes/u01/prod1/redo01.log', '/Volumes/u03/prod1/redo01g1f2.log') SIZE 10M,
GROUP 2 ('/Volumes/u02/prod1/redo02.log', '/Volumes/u01/prod1/redo02g2f2.log') SIZE 10M,
GROUP 3 ('/Volumes/u03/prod1/redo03.log', '/Volumes/u02/prod1/redo03g3f2.log') SIZE 10M
set time_zone = 'America/Los_Angeles';
spool off
spool /Users/oracle/v920/assistants/dbca/logs/CreateDBFiles.log
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/Volumes/u02/prod1/tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "USERS" LOGGING DATAFILE '/Volumes/u02/prod1/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "INDX" LOGGING DATAFILE '/Volumes/u02/prod1/indx01.dbf' SIZE 50M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "XDB" LOGGING DATAFILE '/Volumes/u03/prod1/xdb01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "DRSYS" LOGGING DATAFILE '/Volumes/u03/prod1/drsys01.dbf' SIZE 85M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE '/Volumes/u03/prod1/example01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
spool off
spool /Users/oracle/v920/assistants/dbca/logs/CreateDBCatalog.log
@/Users/oracle/v920/rdbms/admin/catalog.sql;
@/Users/oracle/v920/rdbms/admin/catexp7.sql;
@/Users/oracle/v920/rdbms/admin/catblock.sql;
@/Users/oracle/v920/rdbms/admin/catproc.sql;
@/Users/oracle/v920/rdbms/admin/catoctk.sql;
-- add obfuscation toolkit
@/Users/oracle/v920/rdbms/admin/catobtk.sql;
@/Users/oracle/v920/rdbms/admin/owminst.plb;
exit;
