Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
#! /usr/local/bin/perl
# script: 17_win_901_db_build_1_1.pl
# Features: This perl script is the main script which builds the Oracle database.
#
# Script Sequence#: 17
# Used By: 3_win_901_prepinstall_1.pl script or run manually by DBA as Administrator user
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 12-11-2001 dsimpson Initial Release
# 12-23-2001 dsimpson Added additional setting of ORACLE_SID environment
# variable for perl's environment
# 12-31-2001 dsimpson Corrected oradim -STARTMODE to -STARTUP parameter name.
# 04-24-2002 dsimpson Removed -STARTUP a from oradim command, added -STARTMODE separately,
# Corrected Oracle Home path by adding extra "" in oradim command line
# Added copying of sqlnet.ora file to network/admin directory.
# This output file was created by Installgen version 1.38 on Thu Nov 14 17:16:25 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
use strict;
use Win32::AdminMisc;
use File::Copy;
# make sure the Administrator user is running this script
my ($login_name) = Win32::LoginName;
my @proglist = '';
if ($login_name ne "Administrator")
{
# the user running this script is not Administrator - exit
print "You must be logged in as the Administrator user to run this script, exiting....";
# exit immediately!
die
}
# copy init.ora file to proper location
File::Copy::copy('24_win_initprod3_1.ora','c:\\v901\\database\\initprod3.ora');
# copy the tnsnames.ora file into the correct location
File::Copy::copy('25_win_901_tnsnames_1.ora','c:\\v901\\network\admin\\tnsnames.ora');
# copy the listener.ora file into the correct location
File::Copy::copy('49_listener_ora_1.ora','c:\\v901\\network\\admin\\listener.ora');
# copy the sqlnet.ora file into the correct location
File::Copy::copy('86_sqlnet_1.ora','c:\\v901\\network\\admin\\sqlnet.ora');
# start the listener ahead of time so it will be available during the build process
@proglist = ('c:\v901\\bin\\lsnrctl.exe start');
system (@proglist);
# 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
@proglist = ('rename','c:\\v901\\plsql\\spnc_makefile.mk','c:\\v901\\plsql\\orig-spnc_makefile.mk');
system (@proglist);
File::Copy::copy('63_win_901_spnc_makefile.mk','c:\\v901\\plsql\\spnc_makefile.mk');
# create ORACLE_SID environment variable - used only during install process
Win32::AdminMisc::SetEnvVar("ORACLE_SID","PROD3","ENV_SYSTEM",10);
# insure that environment variable is used by this perl script too
$ENV{'ORACLE_SID'} = "PROD3";
# create new service
@proglist = ('c:\\v901\\bin\\oradim.exe -NEW -SID PROD3 -PFILE c:\\v901\\database\\initprod3.ora');
system (@proglist);
# set service to start automatically
@proglist = ('c:\\v901\\bin\\oradim.exe -EDIT -SID PROD3 -STARTMODE a');
system (@proglist);
# run orapwd utility
@proglist = ('cd','c:\\v901\\database');
system (@proglist);
@proglist = ('c:\\v901\\bin\\orapwd.exe file=c:\\v901\\database\\pwdprod3.ora password=syspwd entries=20');
system (@proglist);
@proglist = ('cd','c:\\oracle');
system (@proglist);
# build the basic database - execution time - about 1 hour
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @53_win_901_db_build_2_1.sql');
system (@proglist);
# install SQL Plus Help - (always installed) - execution time: less than 1 minute
print "\n\nInstalling SQL Plus Help feature.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @23_win_901_build_sqlplus_help_1.sql');
system (@proglist);
# install Oracle JServer - (always installed) - execution time: 1 hour
print "\n\nInstalling Oracle JServe feature.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @18_win_901_build_jserver_1.sql');
system (@proglist);
# install Oracle Intermedia - execution time: 15 minutes
print "\n\nInstalling Oracle Intermedia feature.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @19_win_901_build_intermedia_1.sql');
system (@proglist);
# install Oracle Ultrasearch - execution time: 15 minutes
print "\n\nInstalling Oracle Ultrasearch feature.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @50_win_901_build_ultrasearch_1.sql');
system (@proglist);
# install Oracle Spatial - execution time: 15 minutes
# print "\n\nInstalling Oracle Spatial feature.\n\n";
# @proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @20_win_901_build_spatial_1.sql');
# system (@proglist);
# install Oracle Time Series - (not a 9i feature)
# print "\n\nInstalling Oracle Time Series feature.\n\n";
# @proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @21_win_901_build_time_series_1.sh');
# system (@proglist);
# install Oracle Visual Information Retrieval - (not a 9i feature)
# print "\n\nInstalling Oracle Visual Information Retrieval feature.\n\n";
# @proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @22_win_901_build_visual_info_1.sh');
# system (@proglist);
# install Oracle OLAP data warehouse feature - execution time: 15 minutes
print "\n\nInstalling Oracle OLAP data warehouse feature.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @54_win_901_build_olap_1.sql');
system (@proglist);
# install Oracle Demo Schemas - execution time: 5 minutes
print "\n\nInstalling Oracle Demo Schemas.\n\n";
@proglist = ('c:\\v901\\bin\\sqlplus.exe /nolog @51_win_901_build_demos_1.sql');
system (@proglist);
