8/24/2004
.com Solutions Inc.(TM) Installgen 1.75 Read Me file

Linux Installation Notes
1) Download the installgenxxx_linux.gz file from the web site (where xxx is replaced with the version number). 
2) Decompress the file with gunzip:
gunzip installgenxxx_linux.gz.
3) If necessary, move the application to the permanent location where you want to keep it on your hard drive. This location should be within your path variable if you will launch it from the shell. 
4) Make sure that Perl is installed on your system (Perl 5.6.1 is recommended):
perl -v
5) Make the application executable:
chmod +x installgenxxx_linux

Solaris Installation Notes
1) Download the installgenxxx_solaris.gz file from the web site (where xxx is replaced with the version number). 
2) Decompress the file with gunzip:
gunzip installgenxxx_solaris.gz.
3) If necessary, move the application to the permanent location where you want to keep it on your hard drive. This location should be within your path variable if you will launch it from the shell. 
4) Make sure that Perl is installed on your system (Perl 5.6.1 is recommended):
perl -v
5) Make the application executable:
chmod +x installgenxxx_solaris

Mac OS X Installation Notes
1) Download the InstallgenxxxMacOSX.sit file from the web site (where xxx is replaced with the version number). 
2) The file should be uncompressed automatically by your browser. Otherwise, just use Stuffit to decompress the file.
3) Move the application folder to your Applications folder. Launch Installgen by double-clicking on its icon.

Windows Installation Notes
1) Download the InstallgenxxxWindows.zip file from the web site to the location where you want it to reside on your hard drive. The application file may be installed anywhere on your hard drive, it does not have to go into the C:\Program Files directory.
2) Use WinZip to decompress the file containing Installgen.
3) Launch the application by double-clicking on it. There are no registry entries or external DLLs required. You may make a shortcut to the application on your desktop or in the Start/Programs menu. 


VERSION HISTORY:

Version 1.75: 8/24/2004 [MacOS X only release]
- Re-compiled Installgen for MacOS X for compatibility with MacOS X 10.3 (Panther).
- Added application icon.

Version 1.72: 1/3/2003
- Added installation of Oracle 8.1.7 32bit EE/STD editions on Red Hat Linux (including 8.1.7.4. patch installation). Red Hat Linux versions 6.1, 6.2, 7.0, 7.1, 7.2, 7.3, 8.0 and Advanced Server 2.1 are supported by this relase of Installgen.All relevant OS patches, and glibc installation procedures are customized appropriately for each of these versions of Red Hat Linux. Note: Red Hat Linux versions 7.2, 7.3 and 8.0 are not certified by Oracle, however they are supported by Installgen to provide the DBA with flexibility when installing test versions of database servers on low-cost hardware.

Version 1.61: 12/18/2002
- Added installation of Oracle 8.1.7 32bit EE/STD editions on Windows NT/2000 (including 8.1.7.4.1 patch installation).

Version 1.50: 12/9/2002
- Added installation of Oracle 9.2.0 patch 9.2.0.2.1 for Windows. The patch install procedure implemented in File#52 prevents an undocumented problem caused by Oracle's patch procedure which will damage the existing Oracle binary files thus preventing the database from starting after install of the patch.

Version 1.49: 12/6/2002
- Added installation of Oracle 8.1.7 32bit/64bit EE/STD editions on Solaris.
- Oracle 8.1.7.4 32bit/64bit patches are installed during database install process.
- Implemented use of svrmgrl instead of sqlplus within scripts used for 8.1.7 databases in order to prevent problems with SQL/Plus when starting up/shutting down Oracle 8.?.? databases.
- Added use of database character set variable when generating File#37 which rebuilds the database controlfile. This way the character set specified within the controlfile will match the character set used when the database was created.
- Added use of database and NLS character set variables from configuration file when generating File#53 when building Oracle 9.0.1 databases. These values are now globally set via the installgen_conf configuration file instead of being hard-coded.
- Corrected alert.log filename format listed in documentation within File#39 to match UNIX style filename instead of Windows filename format. 
- Corrected File#40 tasklist spreadsheet to list that only the File#13 script runs as a root CRON job.
- Improved /etc/vfstab entries for standby database configurations by mounting remote NFS mount points with the "soft,bg" options.
- Added the removal of Sun's older version of Perl (SUNWpl5m,SUNWpl5p,SUNWpl5u packages) from Solaris while installing the newer 5.6.1 version. This is only done if the installation of Perl 5.6.1 is requested while running File#4.
- Improved OEM setup instructions to match the Java GUI.

Version 1.38: 11/15/2002
- Added installation of Oracle 9.2.0 32bit/64bit EE/STD editions on Solaris.
- Oracle 9.2.0.2 32bit/64bit patches are installed during database install process.
- Added workaround for Oracle bug id# 2448243 in File#9 on Solaris (which is not scheduled to be fixed until Oracle 10). This bug causes ORA-1031 and EXP-00008 when executing SYS.LT_EXPORT_PKG during a full database export.
- Resolved issue with standby database switchover/switchback functionality on UNIX servers. (Was originally fixed with Installgen 1.27 for Mac OS X.)
- Resolved issue with standby database being started with standby instance name instead of primary instance name after standby database failover to primary was performed using File #80. (Was originally fixed with Installgen 1.27 for Mac OS X.)
- Corrected /Library/StartupItems/Oracle/Oracle startup file pathname used in File #80 on Mac OS X for standby database failover/switchover situations.
- Corrected reading/writing of Backup Channel format field info from Installgen configuration files. This issue was entirely with the graphical interface, scripts were always generated corrected based upon the info entered into the field.
- Corrected Ultrasearch installation script for Mac OS X and Solaris (File #50).
- Corrected pathname to DBV in hot backup script (File#33).
- Corrected path to pfile when creating spfile before creating database in File#53 (for Oracle 9.2.0 on Solaris and Mac OS X).
- Added check for 150Mb of Shared Pool and Java Pool memory allocation in GUI whenever Oracle 9.2.0 databases are installed. This memory allocation is required during the installing the 9.0.2.0.2 patch. The memory allocation can be reduced after the patch is installed.
- Added check for the existence of the installgen_conf.pm file within the directory containing the GUI application. Having a copy of this file in this location was causing Perl to execute this version of the installgen_conf.pm file instead of the version located within the output directory.

Version 1.27: 10/23/2002
- Added installation of Oracle 9.2.0.1.0 32bit EE edition (Developer Release 1) on Mac OS X 10.2 (or higher).
- Resolved issue with standby database switchover/switchback functionality on UNIX servers.
- Resolved issue with standby database being started with standby instance name instead of primary instance name after standby database failover to primary was performed using File #80.

[Open Issues]
1) Resolved issue with standby database switchover/switchback functionality on UNIX servers.
2) Standby database setup is still limited to EE edition databases in which the managed recovery feature is available.
3) Installation of OMS, configuration of OEM server, OLAP, JServer, Ultrasearch are not installed (due to limitations with Developer Release 1 on Mac OS X).
4) Installation of the obfuscation toolkit is not done due to the lack of availability of the owinst.plb file (due to limitations with Developer Release 1 on Mac OS X).
5) Files 57,58,59,60 are not used because dbms_stats.gather_system_stats() does not populate the stats table for use by the dbms_stats.import_system_stats() package (due to limitations with Developer Release 1 on Mac OS X).
6) Files 11 and 81 are not able to shutdown the database properly upon system shutdown due to a limitation with Mac OS X. The /sbin/SystemStarter program on Mac OS X 10.2/10.2.1 (client and server versions) does not pass a "Stop" value to startup/shutdown scripts in the /Library/StartupItems or /System/Library/StartupItems directories. Therefore at this time it is necessary to manually shutdown any running Oracle databases before shutting down the operating system.
7) File # 63 is not used because the PL/SQL native compilation feature is not available (due to limitations with Developer Release 1 on Mac OS X). [Note: Even when the PL/SQL native compilation feature is available as a feature, File #63 may not be required because Oracle supplies a well-written default spnc_makefile.mk file which already specified the use of the gcc compiler.]
8) Files 64 and 67 are not used as response files for silent Oracle installation because the Oracle Java based installer is yet available (due to limitations with Developer Release 1 on Mac OS X).

Version 1.1.6: 8/22/2002
- Added installation of Oracle 9.2.0.1.0 32bit STD and EE editions on Windows.
- File#2 - Prepinstall Batch File - Commented out the installation of MinGW because Oracle only supports the Microsoft Visual C++ compiler. 
Corrected Win32-Lanman, Win32-Daemon, Win32-AdminMisc ppm commands.
- File#3 - Prepinstall Perl Script - Added prompt to request CD-ROM drive letter. 
Added check for Service Pack 2 or higher - which is required for Oracle 9.2.0.1.0. The Oracle installer dialog requests Service Pack 1, however in most cases it can not determine that Service Pack 1 is already installed, therefore Service Pack 2 actually needs installed to resolve this issue.
- File#4 - Postinstall Perl Script - Removed enclosing conditional to if oem_sid = oem_sid code - which could prevent this code from being run. 
Added change of DBSNMP password in snmp_rw.ora file. Removed perl.exe within AT scheduler commands.
Added grant of dba role to dba accounts to work-around Oracle bug id# 2448243 which is specific to 9.2.0.1 (causing ORA-1031 on SYS.LT_EXPORT_PKG.system_info_exp during full database exports.
OEM Console opening commands now open a new console window in order to get proper environment variables.
- File#11 - Rotate Alert Log Service - Alert log filename gets rotated appropriately depending upon whether Oracle 9.0.1 or 9.2.0 is used. This change was required because Oracle 9.0.1 used the alert log filename format of sidALRT.LOG, however Oracle 9.2.0 uses alert log filename format of: alert_sid.log.
- File#13 - Rotate Log Files - Corrected ORACLE_HOME pathnames.
Replaced rotation of dbsnmpc.log and dbsnmpw.log files with dbsnmp.log files (for Oracle 9i).
Added rotation of agntsrvc.log file rotation.
Added stopping of intelligent agent and stopping only the listener logging (without stopping the listener itself) during log rotations. (The previous code newer stopped the listener during log file rotation, but the file might not get rotated due to being in use on Windows systems.)
Added rotation of Oracle(Oracle Home Name)Agent.nohup file.
- File#18 - Build JServe - New file revision for 9.2.0 - adds building of XDB feature into the database. If the DBA has not specified a tablespace named XDB, a new one is created by using the same pathname as the USERS tablespace.
- File#19 - Build Intermedia - Initial Release for Oracle 9.2.0. Updated parameters passed to dr0csys
- File#24 - init.ora - Initial Release for Oracle 9.2.0.1.0 on Windows. Includes parameters for STD or EE edition databases - depending upon DBA specified configuration.
- File#25 - tnsnames.ora - Removed additional sid using dns_search_domain and removed entry if dbdomain = ''.
Added use of dbdomain for service_name of each connection.
- File#29 - RMAN Backup - Using Controlfile - Fixed controlfile backup location to backup_location.
Added snapshot controlfile backup path to prevent file from being written into ORACLE_HOME/dbs.
Added "TO directoryname" clause to restore controlfile validate command for Oracle 9.2.0.
Removed "delete obsolete" command for backup sets - due to unexpected deletion of all but the oldest full backup sets, which did not occur with Oracle 9.0.1. Apparently this is by design according to Oracle, thus this feature is being removed for Oracle 9.0.1 and 9.2.0 scripts to prevent a future Oracle 9.0.1 from causing this same problem. Removal of backup files from the hard drive is now entirely done by  File#13 - the Rotate Log Files script. 
- File#30 - RMAN Restore - Corrected pathname separators.
- File#31 - Closed db Backup - Simplified "system" call code - this change was made to most of the Perl scripts.
- File#33 - Open db Backup - Simplified "system" call code.
Corrected orapwd filename format.
- File#36 - Controlfile Backup to Trace - Simplified "system" call code.
- File#37 - Rebuild Controlfile Script - Added "M" after redo log size.
- File#39 - Documentation File - Added Oracle 9.2.0 - specific notes regarding installation of XDB feature. The XDB feature now gets installed anytime the JServer feature is implemented within the database.
- File#41 - Remove Oracle Script - Added note about Oracle registry entries needing removed manually.
Added removal of Oracle OLAP and Agent services.
Added removal of OracleMTSRecoveryService.
Commented out removal of MinGW since it is no longer being installed.
- File#50 - Build UltraSearch - Initial Release for Oracle 9.2.0
- File#51 - Build Demos - Changed demo schemas loaded based upon EE vs STD edition of database installed.
- File#52 - Patch DB - Initial Release for Oracle 9.2.0.
- File#53 - Build DB - Removed trailing "/" after create database - for Oracle 9.0.1 and 9.2.0 generated scripts. This "/" was causing the create database command to be attempted a 2nd time only when installing Oracle 9.2.0 - and was not observed as an issue when creating Oracle 9.0.1 databases.
- File#62 - Added "TO directoryname" clause to restore controlfile validate command for Oracle 9.2.0.
Simplified "system" command calls.
Removed "delete obsolete" command for backup sets - due to unexpected deletion of all but the oldest full backup sets, which did not occur with Oracle 9.0.1. Apparently this is by design according to Oracle, thus this feature is being removed for Oracle 9.0.1 and 9.2.0 scripts to prevent a future Oracle 9.0.1 from causing this same problem. Removal of backup files from the hard drive is now entirely done by  File#13 - the Rotate Log Files script.
- File#63 - spnc makefile - for MS Visual C++ - Updated comments at top of file. This feature of using natively compiled PL/SQL is still not enabled by default during database installs due to a number of bugs affecting this feature (including RMAN bugs). 
- File#64 - EE Edition DB Installer Response File - Initial Release for Oracle 9.2.0.1
- File#66 - OEM Installer Response File - Initial Release for Oracle 9.2.0.1.0
- File#67 - STD Edition DB Installer Response File - Initial Release for Oracle 9.2.0.1
- File#70 - tnsnames.ora - primary database - Removed additional oem sid using dns_search_domain and removed entry if dbdomain = ''.
- File#71 - tnsnames.ora - failover configuration - Removed additional oem sid using dns_search_domain and removed entry if dbdomain = ''.

[Open Issues]
1) Same as last revision, since this release is primarily designed to support Oracle 9.2.0.1.0 on Windows.
2) Same as last revision.
3) Resolved - init.ora parameters are configured properly for STD edition vs EE edition databases.


Version 1.0.5: 5/30/2002
- Added installation of Oracle 9.0.1.3.0 32bit and 64bit patches on Solaris.
- Added file#87 spnc_makefile for Sun cc compiler [Solaris].
- Added file#88 listener.ora file for standby database while in primary role [Solaris].
- Added file#89 listener.ora file for primary database while in standby role [Solaris].
- Updated RMAN backup scripts to use NOEXCLUDE parameter in order to insure that Read-Only tablespaces are always backed up [Solaris].
- Changed maxpiecesize = 1900M in RMAN backup scripts to avoid any possible 32bit OS issues [Solaris].
- Re-wrote standby server setup/maintenance code to use Perl scripts [Solaris].
- Updated init.ora primary parameters appropriately for STD or EE edition of database [Solaris].
- Disabled use of natively compiled PL/SQL due to RMAN and other bugs known by Oracle [Solaris].
[Open Issues]
1) When performing a standby server switchover or failover, the standby server fails with ORA-3113. This issue is being actively investigated with Oracle Technical Support [Solaris]. This issue does not occur using the same process on Windows.
2) The standby server implementation requires handling the setup on STD edition servers instead of just EE edition.[Windows and Solaris].
3) The init.ora configuration parameters need to be modified if STD edition is used instead of EE edition [Windows]

Version 1.0.4: 4/26/2002
- Added installation of Oracle 9.0.1.3.1 32bit patch on Windows.
- Added use of db_domain and oem db_domain throughout scripts.
- Added file#86 sqlnet.ora file for Windows NTS authentication the database because this file does not always get created automatically by the installer.
- Added file#87 spnc_makefile for MS Visual C++ compiler use.
- Updated RMAN backup scripts to use NOEXCLUDE parameter in order to insure that Read-Only tablespaces are always backed up.
- Changed maxpiecesize = 1900M in RMAN backup scripts to avoid any possible 32bit OS issues.

Version 1.0.3: 3/28/2002
- Initial public release.