ILMG1.sql

OCPdba.Net

set verify off
PROMPT specify a password for sys as parameter 1;
DEFINE sysPassword = &1
PROMPT specify a password for system as parameter 2;
DEFINE systemPassword = &2
--
-- This creates the database password file
--
host /xfer/oracle/OraHome10g/bin/orapwd file=/xfer/oracle/OraHome10g/dbs/orapwILMG1 password=&&sysPassword force=y
--
-- The scripts in green are required to create the database, underlying datafiles,
-- the data dictionary, and at the very end to stop and restart the database
--
@/u01/oracle/10g/ILMG1/scripts/CreateDB.sql
@/u01/oracle/10g/ILMG1/scripts/CreateDBFiles.sql
@/u01/oracle/10g/ILMG1/scripts/CreateDBCatalog.sql
-- 
-- The scripts in blue add the different options to your installation
-- Comment out the options you do NOT want
--
@/u01/oracle/10g/ILMG1/scripts/JServer.sql
@/u01/oracle/10g/ILMG1/scripts/ordinst.sql
@/u01/oracle/10g/ILMG1/scripts/interMedia.sql
@/u01/oracle/10g/ILMG1/scripts/odmmetadata.sql
@/u01/oracle/10g/ILMG1/scripts/context.sql
@/u01/oracle/10g/ILMG1/scripts/xdb_protocol.sql
@/u01/oracle/10g/ILMG1/scripts/cwmlite.sql
@/u01/oracle/10g/ILMG1/scripts/spatial.sql
@/u01/oracle/10g/ILMG1/scripts/odm.sql
@/u01/oracle/10g/ILMG1/scripts/ultraSearch.sql
@/u01/oracle/10g/ILMG1/scripts/emRepository.sql
@/u01/oracle/10g/ILMG1/scripts/ultraSearchCfg.sql 
--
-- Final database script
--
@/u01/oracle/10g/ILMG1/scripts/postDBCreation.sql

OCPdba.Net