Installgen
Features and Benefits
Installgen
Demo Available for download...
#!/bin/sh
# script: 8_sol_901_db_build_1.sh
# Features: This shell script is the main script which builds the Oracle database.
#
# Script Sequence#: 8
# Used By: run manually as oracle UNIX user
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 9-29-2001 dsimpson Initial Release
# 5-05-2002 dsimpson Added copying of sqlnet.ora file.
# added fully qualified paths to
# generated files in /export/oracle.
# 10-11-2002 dsimpson Updated with changes for Mac OS X.
# (This file is used for Solaris and Mac OS X.)
# This output file was created by Installgen version 1.38 on Sun Nov 10 14:51:56 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
# define globally used paths/variables
ORACLE_BASE=/u01/v901
ORACLE_HOME=/u01/v901
ORACLE_OWNER=oracle
ORACLE_OWNER_PATH=/export/oracle
ORACLE_GROUP=dba
ORACLE_HOME=/u01/v901
ORACLE_SID=prod1
LD_LIBRARY_PATH=/u01/v901/lib:/u01/v901/lib64:/usr/dt/lib
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
ORAENV_ASK=NO
TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=/usr/sbin/:/bin:/usr/bin:/usr/ccs/bin:/usr/ucb/bin:/usr/ucb:/usr/openwin/bin:/usr/dt/bin:/usr/local/bin:/opt/bin:/usr/opt/SUNWmd/sbin:/usr/platform/sun4u/sbin:/opt/sfw/bin:.:/usr/local/sbin:/u01/v901/bin
TERM=vt100
NLS_LANG=AMERICAN_AMERICA.US7ASCII
export ORACLE_OWNER ORACLE_OWNER_PATH ORACLE_GROUP ORACLE_HOME ORACLE_SID ORA_BDUMP_DIR LD_LIBRARY_PATH PATH ORAENV_ASK TNS_ADMIN TERM NLS_LANG
# make sure the oracle user is running this script
if [ ! $LOGNAME = "$ORACLE_OWNER" ]
then
# the user running this script is not oracle - exit
echo "You must be logged in as the $ORACLE_OWNER user to run this script, exiting...."
# exit immediately!
exit
fi
# copy init.ora file to proper location
cp /export/oracle/24_sol_initprod1_1.ora $ORACLE_HOME/dbs/initprod1.ora
# copy the tnsnames.ora file into the correct location
cp /export/oracle/25_sol_901_tnsnames_1.ora /u01/v901/network/admin/tnsnames.ora
# copy the listener.ora file into the correct location
cp /export/oracle/49_listener_ora_1.ora /u01/v901/network/admin/listener.ora
# copy the sqlnet.ora file into the correct location
cp /export/oracle/86_sqlnet_1.ora /u01/v901/network/admin/sqlnet.ora
# start the listener ahead of time so it will be available during the build process
/u01/v901/bin/lsnrctl start &
# copy new spnc_makefile.mk file to proper location
# This file contains updated parameters to allow native compilation of
# PL/SQL during the database build process using the gcc compiler
mv $ORACLE_HOME/plsql/spnc_makefile.mk $ORACLE_HOME/plsql/orig-spnc_makefile.mk
cp /export/oracle/63_sol_901_spnc_makefile.mk $ORACLE_HOME/plsql/spnc_makefile.mk
# build the basic database - execution time - about 1 hour
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/53_sol_901_db_build_2_1.sql
# install SQL Plus Help - (always installed) - execution time: less than 1 minute
echo "Installing SQL Plus Help feature."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/23_sol_901_build_sqlplus_help_1.sql
# install Oracle JServer - (always installed) - execution time: 1 hour
echo "Installing Oracle JServe feature."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/18_sol_901_build_jserver_1.sql
# install Oracle Intermedia - execution time: 15 minutes
echo "Installing Oracle Intermedia feature."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/19_sol_901_build_intermedia_1.sql
# install Oracle Ultrasearch - execution time: 15 minutes
echo "Installing Oracle Ultrasearch feature."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/50_sol_901_build_ultrasearch_1.sql
# install Oracle Spatial - execution time: 15 minutes
# echo "Installing Oracle Spatial feature."
# $ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/20_sol_901_build_spatial_1.sql
# install Oracle Time Series - (not a 9i feature)
# echo "Installing Oracle Time Series feature."
# $ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/21_sol_901_build_time_series_1.sh
# install Oracle Visual Information Retrieval - (not a 9i feature)
# echo "Installing Oracle Visual Information Retrieval feature."
# $ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/22_sol_901_build_visual_info_1.sh
# install Oracle OLAP data warehouse feature - execution time: 15 minutes
echo "Installing Oracle OLAP data warehouse feature."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/54_sol_901_build_olap_1.sql
# install Oracle Demo Schemas - execution time: 5 minutes
echo "Installing Oracle Demo Schemas."
$ORACLE_HOME/bin/sqlplus /nolog @/export/oracle/51_sol_901_build_demos_1.sql
