Installgen generates 82 output files for an Oracle 9.0.1
installation on Solaris. These example files are listed below along
with links to the actual files and diagrams where necessary.
| File# |
Filename |
Extras |
Features |
| 1 |
1_sol_901_prepinstall_1.sh |
|
This shell
script creates the UNIX account and group which will install and
own the Oracle database software on the server. One or more UNIX
accounts are also created for admin use during the Oracle installation.
It is run manually via a remote terminal session. |
| 2 |
2_sol_901_prepinstall_1.bat |
|
This windows
batch file opens an ftp connection to the UNIX server and sends
the contents of the solaris_utilities directory from the oracle_build1
CD in the D: drive. |
| 3 |
3_sol_901_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_sol_901_prepinstall_1.sh
2) The execute status of the removal script 41_sol_remove_oracle_1.sh
is disabled for safety.
|
| 4 |
4_sol_901_prepinstall_1.sh |
|
This shell
script checks/installs various Solaris utilities creates and installs
dbora startup script, oratab file, creates mount point directories,
sets permissions/ownership of these directories, creates/installs
vfstab, defaultrouter, hosts, system, profile files, creates/installs
/opt/server_scripts and rotateoraclefiles.sh files script for rotating/removing
log files, create/install sshd startup script file in /rc3.d. |
| 5 |
5_sol_901_prep_copyoracle_cds_1.sh |
|
This shell
script requests for each of the Oracle 9.0.1 (32bit) install CDs
to be inserted into the CD ROM drive, then copies the contents to
the hard drive of the server.
NFS mount points are then created so that the data can then be copied
thru the network to build the OEM server. |
| 6 |
6_sol_901_prep_copyoracle_nfs_1.sh |
|
This shell
script mounts Oracle installer CD images via NFS then copies the
contents to the hard drive of the server. |
| 7 |
7_sol_ora_install_1.sh |
|
This shell
script starts the installation of Oracle from the CD data which
has been copied to the hard drive. |
| 8 |
8_sol_901_db_build_1.sh |
|
This shell
script is the main script which builds the Oracle database. |
| 9 |
9_sol_901_ora_post_install_1.sh |
|
This shell
script creates the spfile, new Oracle DBA accounts changes default
passwords, patches the database, installs database startup, backup,
export and performance tuning scripts. |
| 10 |
10_sol_etc_profile_1.sh |
|
This is the /etc/profile
file which provides the proper info for the PATH, ORACLE_HOME, ORACLE_SID,
ORACLE_BASE, ORACLE_OWNER, ORACLE_TERM, ORAENV_ASK and TNS_ADMIN
environment variables. |
| 11 |
11_sol_901_dbora_1.sh |
|
This shell
script starts up the Oracle database(s) upon system startup. Symbolic
links are created to /etc/rc3.d/S88dbora and /etc/rc0.d/K88dbora
from this file. |
| 12 |
12_sol_901_prod1_dbora_1.sh |
|
This shell script starts
up the Oracle database(s) for an OEM/OMS server upon system startup.
Symbolic links are created to /etc/rc3.d/S88dbora and /etc/rc0.d/K88dbora
from this file. |
| 13 |
13_sol_rotateoraclefiles_1.sh |
|
This shell
script runs nightly via CRON job to remove/rotate Oracle files. |
| 14 |
14_sol_etc_vfstab_1.txt |
|
This file includes the
info which can be appended to the /etc/vfstab file to mount the
disk array partitions used for the Oracle datafiles. |
| 15 |
15_sol_etc_hosts_1.txt |
|
This updated version
of the /etc/hosts file includes the hostname/ip address info for
each of the servers entered into the Installgen application. |
| 18 |
18_sol_901_build_jserver_1.sql |
|
This shell
script adds the JServer feature to the Oracle database. |
| 19 |
19_sol_901_build_intermedia_1.sql |
|
This sql
script adds the Intermedia feature to the Oracle database and unlocks
the ctxsys, wksys, ordsys and mdsys accounts. |
| 20 |
20_sol_901_build_spatial_1.sql |
|
This sql
script adds the Spatial feature to the Oracle database. |
| 23 |
23_sol_901_build_sqlplus_help_1.sql |
|
This sql
script adds the SQL Plus Help feature to the Oracle database. |
| 24 |
24_sol_initprod1_1.ora |
|
Features:
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_sol_901_tnsnames_1.ora |
|
This file
provides configuration information forOracle Net8. |
| 26 |
26_901_test_plsql_1.plsql |
|
This plsql procedure
is used for testing the performance of native compiled PL/SQL code. |
| 27 |
27_sol_901_rman_oem_setup_1.sh |
|
This shell script registers
a production database into the RMAN recovery catalog. This script
is run from the production server, not the OEM/OMS server. |
| 28 |
28_sol_var_opt_oratab_oracle_standby_1.txt |
|
This file
provides Oracle database startup/shutdown configuration informationfor
a standby database.This modified version of the oratab file configures
the databaseto be started up and shutdown by the existence of a
Y at theend of the configuration line. |
| 29 |
29_sol_901_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 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_sol_901_prod1_rman_restore_db_1.sh |
|
This shell script performs
an RMAN full database restore in the case where all datafiles have
been lost. |
| 31 |
31_sol_prod1_closed_db_backup_job_1.sh |
Diagram
disaster_recovery.txt
|
This shell
script performs a closed database backup to the $short_backup_location
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, vfstab, alert.log, backup and restore scripts and creates
the disaster_recovery.txt file.
Note: This script only needs scheduled if the same task has not
been scheduled via a OEM job. |
| 33 |
33_sol_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 /u01/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, vfstab, alert.log, backup and restore scripts
and creates the 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 if the same task has not
been scheduled via a OEM job. |
| 35 |
35_sol_prod1_export_full_db_1.sh |
|
This shell script performs
a full database export to the /u01/backup location.
Note: This script only needs scheduled if the same task has not
been scheduled via an OEM job. |
| 36 |
36_sol_prod1_controlfile_backup_to_trace_1.sh |
|
This sql script backs
up the control file to trace.
Note: This script only needs scheduled if the same task has not
been scheduled via an OEM job. |
| 37 |
37_sol_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 lastest 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. |
| 38 |
38_sol_901_etc_system_1.txt |
|
This is
the customized version of the /etc/system file which contains the
kernel tuning parameters required for the Oracle database installation.
These parameters are customized based upon the SGA and available
memory. |
| 39 |
39_sol_prod1_documentation_1.txt |
|
Contains basic setup
instructions for setting up the database along with the site configuration
and troubleshooting commands. Customized database recovery scenarios
are also included within this file. |
| 40 |
40_sol_prod1_tasklist_sheet_1.slk |
|
Contains a summary
of the tasks required to setup the database. This file is an SYLK
format file designed to be imported into a spreadsheet.
Note: This file generally requires some manual modification after
the generation process. |
| 41 |
41_sol_remove_oracle_1.sh |
|
This shell script removes
the UNIX account and group which own 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.
WARNING - This script is used for testing purposes only while testing
installation scripts. For safety, this file is removed from the
server during the post-install script. |
| 42 |
prod1_overview_diagram_1.svg
(26K) |
|
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_sol_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 . |
| 44 |
44_sol_901_etc_resolv_conf_1.txt |
|
This file specifies
the name server and search domain used by Solaris. |
| 45 |
45_sol_901_etc_defaultrouter_1.txt |
|
This file specifies
the network router used by Solaris. |
| 46 |
46_sol_var_opt_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_sol_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. |
| 48 |
48_sol_etc_nsswitch_1.txt |
|
This is
an updated version of the /etc/nsswitch.conf file. This file determines
where Solaris will obtain naming services. |
| 49 |
49_listener_ora_1.ora |
|
This file provides
configuration information for the Oracle listener. |
| 50 |
50_sol_901_build_ultrasearch_1.sql |
|
This shell
script adds the Ultrasearch feature to the Oracle database. |
| 51 |
51_sol_901_build_demos_1.sql |
|
This shell
script adds the demo schemas to the Oracle database. |
| 52 |
52_sol_901_patch_db_1.sh |
|
This shell
script applies the 9.0.1.3.0 patch to the Oracle 9.0.1 (32bit) database. |
| 53 |
53_sol_901_db_build_2_1.sql |
|
This sql script is
the main script which builds the Oracle database. |
| 54 |
54_sol_901_build_olap_1.sql |
|
This sql
script adds the OLAP data warehouse feature to the Oracle database. |
| 55 |
55_sol_901_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_sol_901_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. |
| 57 |
57_sol_901_prod1_import_stats_day_job_1.sh |
|
This shell script configures
Oracle CBO statistics to use the stats gathered during daytime processing.
Note: If ORA-20003 occurs, check the status of the stats with:
SELECT STATID,C1,C2,C3 FROM SYSSTATS; |
| 58 |
58_sol_901_prod1_import_stats_night_job_1.sh |
|
This shell script configures
Oracle CBO statistics to use the stats gathered during nightly batch
processing.
Note: If ORA-20003 occurs, check the status of the stats with:
SELECT STATID,C1,C2,C3 FROM SYSSTATS; |
| 59 |
59_sol_901_prod1_gather_stats_day_job_1.sh |
|
This shell script gathers
Oracle CBO statistics for 2 hours during daytime processing.
Notes:alter system set job_queue_processes = 1 scope=both may need
to be done prior to running this script if job_queue_processes =
0. DBMS_STATS.CREATE_STAT_TABLE(OWNNAME=>'SYS',STATTAB=>'SYSSTATS')
needs run once before using this script. |
| 60 |
60_sol_901_prod1_gather_stats_night_job_1.sh |
|
This shell script gathers
Oracle CBO statistics for 2 hours during nightly batch processing.
Notes: ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 1 SCOPE=BOTH may need
to be done prior to running this script if job_queue_processes =
0. DBMS_STATS.CREATE_STAT_TABLE(OWNNAME=>'SYS',STATTAB=>'SYSSTATS')
needs run once before using this script. |
| 61 |
prod1_disaster_recovery.txt |
|
The disaster_recovery.txt
file provides a listing of all database accounts, tablespace names,
sizes, filename paths, and tablespace usage. This info can be used
by the DBA during disaster recovery situations in order to rebuild
the database onto a different server. |
| 62 |
62_sol_901_prod1_rman_oem_backup_job_1.sh |
disaster_recovery.txt |
This shell script performs
an RMAN full database backup of all datafiles, archivelogs and the
control file. The init.ora and orapw files are backed up via OS
commands. The control file is also backed up to a trace file within
the /backup directory and the disaster_recovery.txt file is created.
Any backup corruption found by RMAN is reported. |
| 63 |
63_sol_901_spnc_makefile.mk |
|
This customized version
of the spnc_makefile.mk file makes use of the GCC compiler to compile
PL/SQL into machine code throughout the database. This feature is
configured into the init.ora file during the database build process,
therefore all procedures in the database are natively compiled.
Native PL/SQL compilation typically offers a 2x - 8x improvement
in performance for PL/SQL procedures. |
| 64 |
64_sol_901EE_prod1_db_installer_response_1.rsp |
|
This file provides
the installation responses Oracle 9i Enterprise Edition This file
allows the installation to run in silent install mode. |
| 65 |
65_sol_901_prod1_installer_location_1.loc |
|
This file provides
the installation location information for a silent install of Oracle.
This file gets copied into /var/opt/oracle |
| 66 |
66_sol_901_prod1_oem_installer_response_1.rsp |
|
This file
provides the installation responses for the Oracle Java-based installer
program to install the OEM/OMS software. |
| 67 |
67_sol_901STD_prod1_db_installer_response_1.rsp |
|
This file provides
the installation responses Oracle 9i Standard Edition This file
allows the installation to run in silent install mode. |
| 68 |
68_sol_901_patch9013_response_1.rsp |
|
This response file
provides information for a silent install of the 32 bit Oracle 9.0.1.3.0
patch. |
| 69 |
69_sol_sshd_config_1.txt |
|
This sshd_config file
is modified from the original to disable root login for improved
security |
| 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_sol_prod1_standby_etc_profile_1.sh |
|
Sets important environment
variables for PATH, ORACLE_HOME etc. on the standby database server. |
| 74 |
74_sol_prod1_standby_listener_1.ora |
|
This file provides
configuration information for the Oracle listener on the standby
database in a standby database configuration. |
| 75 |
75_sol_901_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_sol_901_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_sol_901_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,
Required Files:
77_sol_901_prod1_primary_standbysetup_1.pl
79_prod1_standby_status_1.pl
80_sol_prod1_standbydb_change_role_1.pl
70_prod1_primary_tnsnames_1.ora
71_prod1_failover_tnsnames_1.ora
72_prod1_client_taf_tnsnames_1.ora
75_sol_901_prod1_primary_init_1.ora
49_listener_ora_1.ora
74_sol_prod1_standby_listener_1.ora
76_sol_901_prod1_standby_init_1.ora
81_prod1_standby_startup_script_1
73_sol_prod1_standby_etc_profile_1.sh
10_sol_etc_profile_1.sh
46_sol_var_opt_oratab_1.txt
86_sqlnet_1.ora
88_sol_standby_primary_listener_1.ora
89_sol_primary_standby_listener_1.ora |
| 78 |
78_sol_901_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 databasein managed recovery mode
Required Files:
78_sol_901_prod1_standby_standbysetup_1.pl
79_prod1_standby_status_1.pl
80_sol_prod1_standbydb_change_role_1.pl
72_prod1_client_taf_tnsnames_1.ora
74_sol_prod1_standby_listener_1.ora
81_prod1_standby_startup_script_1
11_sol_901_dbora_1.sh
13_sol_rotateoraclefiles_1.sh
73_sol_prod1_standby_etc_profile_1.sh
10_sol_etc_profile_1.sh
46_sol_var_opt_oratab_1.txt
86_sqlnet_1.ora
28_sol_var_opt_oratab_standby_1.txt
88_sol_standby_primary_listener_1.ora |
| 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_sol_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.pl |
|
This perl script runs
during system startup to startup the standby database instance in
managed recovery mode. |
| 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 standby server. The primary server's archivelog directory
is expected to be mounted via the network on the standby 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. |
| 83 |
83_prod1_file_replicator_job_1.pm |
|
This perl
module is used by the 82_prod1_file_replicator_job_1.pl script to
define 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 standby server,
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. |
| 85 |
85_prod1_rman_archivelog_backup_job_1.pl |
|
This 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. |
| 86 |
86_sqlnet_1.ora |
|
This sqlnet.ora
file disables authentication_services on Solaris 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 Solaris
servers which can be used as a starting point for further modifications
by the DBA. |
| 87 |
87_sol_901_spnc_makefile_suncc_1.mk |
|
This makefile
along with the appropriate init.ora parametersenables the Oracle
database to compile PL/SQL code into nativemachine code. |
| 88 |
88_sol_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_sol_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. |
