The Installgen application generates the scripts required to install,
build, backup and document an Oracle database installation. The scripts
created by Installgen implement Oracle´s best practices for over
100 tasks required when performing the installation of Oracle database
servers. This graphical application generates dozens of scripts, configuration
files and documentation within a few seconds. An external module allows
site-specific customization of each generated file.
Installgen generates 61 output files for an Oracle 9.2.0
(Developer Release 1) installation on Mac OS X.
| File# |
Filename |
Extras |
Features |
| 1 |
1_macosx_920_prepinstall_1.sh |
|
This shell script creates the UNIX account
and group which will install and own the Oracle database software
on the server.
The UNIX account, encrypted password, group, and user directory
info is written into the Mac OS X NetInfo directory service using
the nicl (NetInfo command line) utility. The user account directory
is created from the template in /System/Library/User/Template/English.1proj
and ownership is set to the new oracle UNIX account and group.
This file is generally run manually via a remote terminal session.
Requirements: root account must be enabled on Mac OS X
SSH and FTP access should be enabled on Mac OS X |
| 2 |
2_macosx_920_prepinstall_1.bat |
|
This windows batch file opens an ftp
connection to the Mac OS X server and sends the configuration files
from the current directory to the server.
Note: Generally the configuration files/scripts will be copied to
the Mac OS X server via the network or generated via Installgen
directly on the destination Oracle database server machine therefore
this script will not be needed.When performing this task manually,
the files should be copied into the UNIX oracle owner account home
directory. |
| 3 |
3_macosx_920_prepinstall_1.sh |
|
This shell script sets the execute permissions
on each of the shell scripts in the oracle user directory.
Notes: 1) set this script to be executable before execution with
the following command
chmod u+x 3_macosx_920_prepinstall_1.sh
2) The execute status of the removal script 41_macosx_remove_oracle_1.sh
is disabled for safety. |
| 4 |
4_macosx_920_prepinstall_1.sh |
|
This shell script installs
the perl Mail::Sendmail module creates and installs the Oracle directory
within the /System/Library/StartupItems directory, installs the
Oracle startup/shutdown script, oratab file, sets permissions/ownership
of the mount point directories, installs a new /etc/profile file,
creates/installs /Users/oracle/server_scripts and rotateoraclefiles.sh
files script for rotating/removing log files, and updates /etc/hostconfig.
Requirements: Top-level mount point directories must already exist
under /Volumes prior to running this script. Mount point directories
must not contain spaces and are created as the volume or disk name
entered into the Disk Utility when erasing or partitioning disks. |
| 5 |
5_macosx_920_prep_copyoracle_cds_1.sh |
|
This shell script requests
the Oracle 9.2.0 (32bit) install CD to be inserted into the CD ROM
drive, then copies the macosx_920_dev_rel.tar.gz file to the hard
drive.
Requirements: The downloaded Oracle 9.2.0 Developer release file
needs to be burned onto a CD named ORACLE920_MACOSX or this script
needs modified to use the actual name of the CD. This file may be
skipped if the Oracle 9.2.0 Developer release file has already been
downloaded to the server, however this datafile needs to be placed
within the oracle UNIX account home directory. |
| 7 |
7_macosx_ora_install_1.sh |
|
This shell script decompresses
and renames the macosx_920_dev_rel.tar.gz file which has been downloaded
from OTN. Then the process of building the new database instance
is started. |
| 8 |
8_macosx_920_db_build_1.sh |
|
This shell script is the main script
which builds the Oracle database. |
| 9 |
9_macosx_920_ora_post_install_1.sh |
|
This shell script creates
the spfile, new Oracle DBA accounts changes default passwords, installs
database backup, export and performance tuning scripts. |
| 10 |
10_macosx_etc_profile_1.sh |
|
This is the /etc/profile
file which provides the proper info for the PATH, ORACLE_HOME, SRCHOME,
DYLD_LIBRARY_PATH, ORACLE_SID, ORACLE_BASE, ORACLE_OWNER, ORACLE_TERM,
ORAENV_ASK and TNS_ADMIN environment variables. |
| 11 |
11_macosx_920_dbora_1.sh |
|
This shell script starts up or shuts
down the Oracle database(s) upon system startup or shutdown.
Note: Mac OS X 10.2.1 (client and server) does not pass a "Stop"
value to scripts located within the /Library/StartupItems or /System/Library/StartupItems
directories. Therefore shutdown of the database must be performed
manually at this time. |
| 13 |
13_macosx_rotateoraclefiles_1.sh |
|
This shell script runs nightly
via CRON job to remove/rotate Oracle files. |
| 18 |
18_macosx_920_build_jserver_1.sql
|
|
This sql script adds the JServer feature to the Oracle database.
Note: This script is a placeholder in preparation for the addition
of the JServer feature to the Mac OS X version of Oracle 9.2.0.
|
| 19 |
19_macosx_920_build_intermedia_1.sql
|
|
This sql script adds the
Intermedia feature to the Oracle database. |
| 20 |
20_macosx_920_build_spatial_1.sql |
|
This sql script adds the Spatial feature
to the Oracle database. |
| 23 |
23_macosx_920_build_sqlplus_help_1.sql |
|
This sql script adds the
SQL Plus Help feature to the Oracle database. |
| 24 |
24_macosx_initprod1_1.ora |
|
This file provides the initial
configuration for the Oracle database instance.
Note: During the installation process this file will generally be
converted to an spfile for version 9i databases. |
| 25 |
25_macosx_920_tnsnames_1.ora |
|
This file provides configuration information for Oracle Net8.
|
| 28 |
28_macosx_oratab_standby_1.txt |
|
This file provides
Oracle database startup/shutdown configuration information for a
standby database.
This modified version of the oratab file configures the database
to be started up and shutdown by the existence of a Y at the end
of the configuration line. |
| 29 |
29_macosx_920_rman_backup_job_1.sh |
disaster_recovery.txt
|
This shell script performs
an RMAN full database backup of all datafiles, archivelogs, control
file, init.ora and the orapw file.
The prod1_disaster_recovery.txt file is also created every time
a backup is performed for disaster recovery purposes.
This RMAN backup procedure uses the controlfile for storage of information
about backup sets. |
| 30 |
30_macosx_920_prod1_rman_restore_db_1.sh |
|
This shell
script performs an RMAN full database restore in the case where
all datafiles have been lost.
Note: If ORA-12573 is encountered while performing a restore with
this script, then it may be necessary to restart the server in order
to insure that the OS is not holding any datafiles open. |
| 31 |
31_macosx_prod1_closed_db_backup_job_1.sh |
Diagram
disaster_recovery.txt
|
This shell script performs
a closed database backup to the /Users/oracle/backup location.
This script builds the closed database restore script when it builds
the shell script for the backup.
This script also backs up the init.ora, orapw, alert.log, backup
and restore scripts and creates the prod1_disaster_recovery.txt
file.
Note: This script only needs scheduled if the same task has not
been scheduled via a OEM job. |
| 33 |
33_macosx_prod1_open_db_backup_job_1.sh |
Diagram
disaster_recovery.txt
|
This shell
script creates a sql script which performs an open database backup
to the /Users/oracle/backup location. It then executes the sql script
it builds in order to perform the backup.
This script builds the open database restore shell script when it
builds the shell script for the backup.This script also backs up
the init.ora, orapw, alert.log, backup and restore scripts and creates
the prod1_disaster_recovery.txt file.
A DBVERIFY is performed on each of the backup files created during
the backup process.
Note: This script only needs scheduled via a CRON job if the same
task has not been scheduled via a OEM job. |
| 35 |
35_macosx_prod1_export_full_db_1.sh |
|
This shell script performs
a full database export to the /Users/oracle/backup location.
Note: This script only needs scheduled as a CRON job if the same
task has notbeen scheduled via an OEM job. |
| 36 |
36_macosx_prod1_controlfile_backup_to_trace_1.sh |
|
This shell
script backs up the control file to trace.
Note: This script only needs scheduled as a CRON job if the same
task has not been scheduled via an OEM job.
This task is also incorporated into each of the other backup scripts. |
| 37 |
37_macosx_prod1_rebuild_controlfile_1.sql |
|
This sql script rebuilds
the control file.
NOTE: The contents of this file can only be used to rebuild the
control file if no datafiles have been added/moved since the database
was originally created. The best option is to use the latest backed
up version of the control file backed up to trace (generally done
nightly).
In order to use the tracefile information, replace the #'s with
--for comments. |
| 39 |
39_macosx_prod1_documentation_1.txt |
|
Contains basic setup instructions for setting up the database
along with the site configuration and troubleshooting commands.
|
| 40 |
40_macosx_prod1_tasklist_sheet_1.slk |
|
This spreadsheet in SYLK format provides
a timeline of the various periodic tasks which are scheduled on
the database server. Tasks include performance tuning, export and
backup jobs.
Note: This file generally requires some manual modification after
the generation process. |
| 41 |
41_macosx_remove_oracle_1.sh |
|
This shell script removes
the UNIX account and group which owns the Oracle database software
on the server along with all files and directories of oracle software
and utilities installed as part.of the installation process. |
| 42 |
prod1_overview_diagram_1.svg
(22K) |
|
This XML file in SVG format
displays a database diagram for installations containing multiple
servers. The OEM/OMS server is shown along with the servers which
it manages.
Note: This file generally requires some manual modification after
the generation process. |
| 43 |
43_macosx_prod1_backup_timeline_1.slk |
|
This spreadsheet in SYLK format provides
a timeline of the various periodic tasks which are scheduled on
the database server. Tasks include performance tuning, export and
backup jobs.
Note: This file generally requires some manual modification after
the generation process . |
| 46 |
46_macosx_oratab_1.txt |
|
This file provides Oracle
database startup/shutdown configuration information.
This modified version of the oratab file configures the database
to be started up and shutdown by the existence of a Y at the end
of the configuration line. |
| 47 |
47_macosx_prepinstall_ftp_1.txt |
|
This file provides ftp commands to the
Windows ftp client software which will ftp the appropriate install
cd directories to the database server. |
| 49 |
49_listener_ora_1.ora |
|
This file provides configuration
information for the Oracle listener. |
| 50 |
50_macosx_920_build_ultrasearch_1.sql |
|
This shell script adds the Ultrasearch
feature to the Oracle database. |
| 51 |
51_macosx_920_build_demos_1.sql |
|
This sql script adds the
demo schemas to the Oracle database. |
| 52 |
52_macosx_920_patch_db_1.sh |
|
This is a placeholder script
because there are not any patches yet available for Oracle 9.2.0
on Mac OS X. |
| 53 |
53_macosx_920_db_build_2_1.sql |
|
This sql script is the main
script which builds the Oracle database. |
| 54 |
54_macosx_920_build_olap_1.sql |
|
This sql script adds the
OLAP data warehouse feature to the Oracle database. |
| 55 |
55_macosx_920_dbshut_1.sh |
|
This updated version of the
Oracle supplied dbshut script performs a shutdown immediate in order
to insure that the database gets shut down even if users are logged
in. |
| 56 |
56_macosx_920_prod1_schema_stats_job_1.sh |
|
This shell script generates
sql scripts which are then run in order to gather schema statistics
for all schemas except SYS and SYSTEM. |
| 70 |
70_prod1_primary_tnsnames_1.ora |
|
This file provides configuration
information for the Oracle Net8 configuration for the primary database
in a standby database configuration. |
| 71 |
71_prod1_failover_tnsnames_1.ora |
|
This file provides configuration
information for the Oracle Net8 configuration for the primary and
standby databases in a standby database configuration during a switchover
or failover situation. |
| 72 |
72_prod1_client_taf_tnsnames_1.ora |
|
This file provides configuration
information for the Oracle Net8 configuration for clients to connect
to either the primary or standby databases in a standby database
configuration. TAF (transparent application failover) is used to
automatically switch the connection from the primary to the standby
database in a switchover or failover situation. |
| 73 |
73_macosx_prod1_standby_etc_profile_1.sh |
|
Sets important environment variables
for PATH, ORACLE_HOME etc. on the standby database server. |
| 74 |
74_macosx_prod1_standby_listener_1.ora |
|
This file provides configuration
information for the Oracle listener on the standby database server
while operating in standby mode. |
| 75 |
75_macosx_920_prod1_primary_init_1.ora |
|
This file provides the initial configuration
for the Oracle database instance - for a primary database in a standby
configuration.
Note: During the installation process this file will generally be
converted to an spfile for version 9i databases. |
| 76 |
76_macosx_920_prod1_standby_init_1.ora |
|
This file provides the initial configuration
for the Oracle database instance - for a standby database in a standby
configuration.
Note: During the installation process this file will generally be
converted to an spfile for version 9i databases. |
| 77 |
77_macosx_920_prod1_primary_standbysetup_1.pl |
|
This perl script sets up
the primary server in a standby database configuration.
Tasks include:
performing the RMAN backup of the primary server, dynamically changing
init.ora parameters to the new standby settings, copying updated
versions of the tnsnames.ora, init.ora, status monitoring, change
role, backup files and archived logs to the standby server. |
| 78 |
78_macosx_920_prod1_standby_standbysetup_1.pl |
|
This perl script sets up
the standby server in a standby database configuration.
Tasks include:
copying updated versions of the tnsnames.ora, init.ora listener.ora,
status monitoring, change role files from the NFS shared directory,
and starting the database in managed recovery mode. |
| 79 |
79_prod1_standby_status_1.pl |
|
This script checks the automatic
application of archived redo logs on the standby database server.
If the standby database is behind by more than 3 archivelog files
- an email is sent to the DBA.
Note: If a standby delay is used, the max_error_difference will
need to be adjusted accordingly. |
| 80 |
80_macosx_prod1_standbydb_change_role_1.pl |
|
This perl script changes the role of
the servers in a standby database configuration.
Role changes include:
primary to standby switchover
primary to standby failover
standby to primary switchover
standby to primary failover
standby to read-only
read-only to standby |
| 81 |
81_prod1_standby_startup_script_1 |
|
This shell script runs during
system startup/shutdown to startup the standby database instance
in managed recovery mode or shutdown the instance. |
| 82 |
82_prod1_file_replicator_job_1.pl |
|
This script compares archivelog
directories on the primary and standby servers and copies new logs
from the primary server to the standby server. Archivelog files
are not copied until Oracle has completed writing them on the primary
server.
Notes: This script is expected to be scheduled to run regularly
on the primary server. The standby server's archivelog directory
is expected to be mounted via an NFS share available to the primary
server.
This script should generally only be required for use with standby
databases on Oracle 8.0.5. Oracle 8.1.5 and higher support copying
of files automatically via the RFS process.
Requires: network mounting of primary server's archivelog directory
prod1_file_replicator_job.pm (renamed from 83_prod1_file_replicator_job_1.pm) |
| 83 |
83_prod1_file_replicator_job_1.pm |
|
This perl module contains
the archivelog directory paths for the primary and standby servers. |
| 84 |
84_prod1_archivelog_move_job_1.pl |
|
This script moves archivelog
files more than 4 hours old to another location.
This script should only be used in situations where an RMAN backup
is not going to be scheduled on the server. The RMAN backup will
backup up and then clear the archivelog files. This script could
be used on a standby server which is not performing RMAN backups.
Notes: If a standby delay is implemented on the standbyserver, this
delay time needs considered when setting the delay_hours variable
in this program. The RFS process (Oracle 8.1.5 and higher) will
copy archived logs immediately, but the logs will not be applied
until the standby delay interval has elapsed.
Usage:
1) Edit the destination directory path as needed
2) Add to CRON |
| 85 |
85_prod1_rman_archivelog_backup_job_1.sh |
|
This shell script backs
up archivelog files via RMAN and removes the archivelog files from
the archivelog directory. This script is useful for situations in
which the nightly full database RMAN backup will not occur soon
enough to prevent the archivelog directory from filling up.
Notes: The RMAN max i/o rate is set to a default of 1500K/sec.This
value should be tuned by the DBA to reduce the impact on the server
if the standby database is going to be opened for Read Only usage.. |
| 86 |
86_sqlnet_1.ora |
|
This sqlnet.ora file disables
authentication_services on UNIX servers. Remote SYSDBA Authentication
is still provided via the orapw file and having remote_login_passwordfile=EXCLUSIVE
enabled in the init.ora file.
Note: This file is made available as a placeholder file on UNIX
servers which can be used as a starting point for further modifications
by the DBA. |
| 88 |
88_macosx_standby_primary_listener_1.ora |
|
This file provides configuration
information for the Oracle listener on the standby database server
while it is being used as a primary database. |
| 89 |
89_macosx_primary_standby_listener_1.ora |
|
This file provides configuration
information for the Oracle listener on the primary database server
while it is being used as a standby database. |
| 90 |
90_macosx_StartupParameters_1.plist |
|
This XML file provides the
startup parameters property list to /sbin/SystemStarter on Mac OS
X. This file instructs SystemStarter to start up the Oracle database
late in the system startup sequence after all disks, network services
and NFS are available. |
| 91 |
91_macosx_bashrc_1.txt |
|
This bashrc file configures
the ulimit parameters required by the Oracle database and any scripts
or Oracle utilities which will be used with the database. |
| 92 |
92_macosx_bash_profile_1.txt |
|
This .bash_profile
file configures the bash shell login parameters. |
