Short Guide to install Oracle 8.1.7 on SUN Solaris 2.6, 7, 8
The following, short Installation Guide shows how to install Oracle 8.1.7 for SUN Solaris 2.6 / 2.7. You may download our scripts to create a database, we suggest this way and NOT using DBASSIST. Use DBASSIST only to generate a template script, because some important INITSID.ora values are wrong and may lead to a poorly tuned database. Besides this scripts, you can download our NET8 configuration files TNSNAMES.ORA. LISTENER.ORA and SQLNET.ORA.
For our installation, we used the following ORACLE_HOME and ORACLE_SID, please adjust these parameters for your own environment.
Check Hardware Requirements
Minimal Memory: 256 MB
To determine the amount of RAM memory installed on your system, enter the following command.
To determine the amount of SWAP installed on your system, enter the following command and multiply the BLOCKS column by 512.
Use the latest kernel patch from Sun Microsystems (http://sunsolve.sun.com)
Operating System Software Requirements
Use the latest kernel patch from Sun Microsystems. Solaris 2.6 requires at least kernel jumbo patch revision #105181-15 for successful installation of Release 2 (8.1.7).
- Download the Patch from: http://sunsolve.sun.com
$ cd <patch cluster directory>
To determine your current operating system information:
$ uname -a
To determine which operating system patches are installed:
$ showrev -p
To determine which operating system packages are installed:
$ pkginfo -i [package_name]
To determine if your X-windows system is working properly on your local system, but you can redirect the X-windows output to another system.
To determine if you are using the correct system executables:
$ /usr/bin/which make
Each of the four commands above should point to the
Java Runtime Environment (JRE)
The JRE shipped with Oracle8i is used by Oracle Java applications such as the Oracle Universal Installer is the only one supported. You should not modify this JRE, unless it is done through a patch provided by Oracle Support Services. The inventory can contain multiple versions of the JRE, each of which can be used by one or more products or releases. The Installer creates the oraInventory directory the first time it is run to keep an inventory of products that it installs on your system as well as other installation information. The location of oraInventory is defined in /var/opt/oracle/oraInst.loc. Products in an ORACLE_HOME access the JRE through a symbolic link in $ORACLE_HOME/JRE to the actual location of a JRE within the inventory. You should not modify the symbolic link.
The Solaris 2.6 following patches are required or recommended for JRE 1.1.8_10
Check Software Limits
Oracle8i Release 3 (8.1.7) includes native support for files greater than 2 GB. Check your shell to determine whether it will impose a limit.
To check current soft shell limits, enter the following command:
$ ulimit -Sa
To check maximum hard limits, enter the following command:
$ ulimit -Ha
The file (blocks) value should be multiplied by 512 to obtain the maximum file size imposed by the shell. A value of unlimited is the operating system default and is the maximum value of 1 TB.
Setup the Solaris Kernel
Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest
one twice, then add an additional 10 for each database. For example, consider a system
that has three Oracle instances with the PROCESSES parameter in their
The value of SEMMNS is calculated as follows:
SEMMNS = [(A=100) + (B=100)] + [(C=200) * 2] + [(# of instances=3) * 10] = 630
Setting parameters too high for the operating system can prevent the machine from booting up. Refer to Sun Microsystems Sun SPARC Solaris system administration documentation for parameter limits.
Create Unix Group «dba»
$ groupadd -g 400 dba
Create Unix User «oracle»
$ useradd -u 400 -c "Oracle Owner" -d /export/home/oracle \
Setup ORACLE environment ($HOME/.profile) as follows
# Setup ORACLE environment
Install from CD-ROM
Usually the CD-ROM will be mounted automatically by the Solaris Volume Manager, if not, do it as follows as user root.
$ su root
Check oraInst.loc File
If you used Oracle 8.1.x before on your system, then you must edit the Oracle Inventory
File, usually located in:
Install with Installer
Install Oracle 8i with customized Response File: svrtypical.rsp as User «oracle». We suggest to start runInstaller in the foreground, therefore remove the "&" from runInstaller at the end of the file.
$ cd /cdrom/oracle8i
A configuration script needs to be run as root before installation can proceed. Please leave this window up, go run /opt/oracle/product/8.1.7/root.sh as root from another window, then come back here and click OK to continue.The installation of Oracle8i Enterprise Edition was successful.
Start root.sh as «root»
Start the script root.sh as User «root». Note that the File /var/opt/oracle/oratab is not used in the High Availabilty Environment.
$ su root
Setup Listener for Oracle8.1.7
Create the necessary log- and config directories. Set ORACLE_HOME to the new location. Setup the Net8 Files: listener.ora, tnsnames.ora and sqlnet.ora.
$ cd $ORACLE_HOME
Start / Stop and check the listener
It is very important that the listener works correctly.
Check that listener starts without an error, check that listener is running.
$ ps -ef | grep tns
Install current patches
Download patchsets from:
Read the patch_note.htm file to install the patch.
Create the Database
Edit and save the CREATE DATABASE File initDIA2.sql in $ORACLE_HOME/dbs, or create a symbolic-Link from $ORACLE_HOME/dbs to your Location.
initDIA2.ora -> /export/home/oracle/config/8.1.7/initDIA2.ora
Check the Logfile, then stop and start the Database
Create own DB-Create Script (optional)
You can generate your own DB-Create Script using the Tool: $ORACLE_HOME/bin/dbassist.
To start the Database automatically on Boot-Time, create or use our Startup Scripts dbora and lsnrora (included in ALL_FILES.tar.gz), which must be installed in /etc/init.d. Create symbolic Links from the Startup Directories in /etc (e.g. /etc/rc2.d).
lrwxrwxrwx 1 root root S99dbora -> ../init.d/dbora
Download Scripts for Sun Solaris
These Scripts can be used as Templates. Please note, that some Parameters like ORACLE_HOME, ORACLE_SID and PATH must be adjusted on your own Environment. Besides this, you should check the initSID.ora Parameters for your Database (Size, Archivelog, ...)