Installing Oracle 8i Release 3 (8.1.7)

This article describes how to install and configure Oracle on a local Solaris SPARC machine. The instructions assume the following: You do not have a previous version of Oracle already installed on your machine. If you have a previous version of Oracle installed, you might need to migrate databases, depending on the version installed. In this case, do not follow these instructions. Instead, refer to Oracle product documentation on the Oracle Web site at docs.oracle.com/database_mp_8i.html. Your Oracle database server will be located on the same machine as WebSphere Application Server. This configuration and the use of default settings documented in these instructions are appropriate only for development and very small production environments. For information on more complicated scenarios, refer to the IBM Redbook WebSphere V3.5 Handbook at www.redbooks.ibm.com/redbooks/SG246161.html. Although this Redbook was written for the WebSphere Application Server Version 3.5 product, much of the conceptual information also pertains to the WebSphere Application Server 4.0 product. You have checked the Oracle product documentation on the Oracle Web site at docs.oracle.com/database_mp_8i.html to verify that you have enough memory and disk space for your installation. Note: Install Oracle before installing WebSphere Application Server. Perform the following steps to install Oracle 8i from the product CD-ROM: Ensure that you are logged into the machine with superuser (root) privileges. Ensure that you have set the following UNIX kernel, shared memory, and semaphore parameters properly: SHMMAX SHMMIN SHMMNI SHMSEG SEMMNI SEMMSL SEMMNS SEMOPM SEMVMX For more information on the proper values for these parameters, refer to the Oracle 8i Installation Guide. It is recommended that you review these settings with your system administrator to ensure that they do not conflict with existing settings needed for other software programs on your system. Ensure that the DISPLAY and TERM environment variables are set correctly for your environment. Create a mount point for Oracle 8i. The mount point can be a directory in an existing volume, or you can set up a new logical volume. Note: If you plan to use Oracle in a production environment, it is recommended that you create a file system on a separate partition to store the database files. (If you are performing an Optimal Flexible Architecture (OFA)-compliant installation, you must create four mount points, one for Oracle 8i and three for the database files.) Refer to the Oracle 8i Installation Guide and your Solaris system documentation for more information on creating and mounting file systems. Use operating system utilities to create groups for database administrators (groups dba, osdba, osoper, and oinstall) and user oracle (who owns the Oracle software after installation) by doing the following: Start the admintool utility, as follows: # admintool In the Admintool window, click Browse > Groups. The Admintool:Groups window opens. In the Admintool:Groups window, click Edit > Add. The Admintool:Add Group window opens. In the Admintool:Add Group window, in the Group Name field, enter dba and click OK. Repeat Step c and Step d to create the groups osdba, osoper, and oinstall. In the Admintool:Groups window, click Browse > Users. The Admintool:Users window opens. In the Admintool:Users window, click Edit > Add. The Admintool:Add User window opens. In the Admintool:Add User window, do the following: In the User Name field, enter oracle. In the Primary Group field, enter oinstall. In the Secondary Groups field, enter dba. Select the desired user login shell by clicking the button beside the Login Shell field, and then clicking the desired shell. These instructions assume that the Bourne shell is the login shell for the user oracle. If you indicate a different shell for the user oracle, change the shell-specific instructions within this article accordingly. Ensure that the radio button beside the Create Home Directory field is selected. In the Path field, enter the desired home directory for the user oracle. Accept the default values for the other fields and click OK. Exit from the admintool utility. Note: Use the oracle account only for installing and maintaining Oracle software; do not log into a database as the user oracle. Ensure that the home directory for the user oracle is owned by the user oracle and the group oinstall. Log in as the user oracle, as follows: # su - oracle Ensure that the DISPLAY and TERM environment variables are still set properly. Ensure that the user mask value is set to 022 by entering the following command: $ umask If the command does not return a value of 022, set the value as follows: Edit the .profile file in the home directory of the user oracle by adding the line umask 022 to this file and then saving and closing it. Enter the following command: $ umask 022 Add the following information to the .profile file in the home directory for the user oracle. Your Oracle System Identifier (SID) can differ from the example shown, but it must be fewer than eight characters in length. #----------------------------------- # Oracle environment setup #----------------------------------- # ORACLE_BASE=oracle_home_directory export ORACLE_BASE ORACLE_SID=orcl export ORACLE_SID ORACLE_HOME=$ORACLE_BASE/product/8.1.7 export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin export PATH LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export LD_LIBRARY_PATH ORA_CLIENT_LIB=shared export ORA_CLIENT_LIB echo 'The Oracle 8.1.7 environment is set' Log in as user root, as follows: # su - root Insert the Oracle 8i CD-ROM and, if necessary, mount the CD-ROM drive. In most Solaris systems, the Volume Management daemon (vold) mounts the CD automatically and immediately, as well as each time the machine is restarted. If the vold process is not running on your machine, see your Solaris documentation for instructions on how to mount the CD-ROM drive. The following steps assume that the CD-ROM is mounted at /cdrom. Oracle8i is provided on two CD-ROMs called Disk 1 and Disk 2. To avoid having to switch between these CD-ROMs to complete a full installation, Oracle recommends copying the contents of each CD-ROM to the hard drive of the machine on which you will install Oracle and running the Oracle Universal Installer from the new location. To perform these tasks, do the following: As user root, create a directory to hold the Oracle software, as follows: # mkdir software_source_directory Within the software_source_directory, create two subdirectories called Disk1 and Disk2, as follows: # cd software_source_directory # mkdir Disk1 # mkdir Disk2 Navigate to the directory /cdrom/cdrom0/, as follows: # cd /cdrom/cdrom0 Copy the contents of the CD-ROM Disk 1 to the subdirectory Disk1, as follows: # cp -R * software_source_directory/Disk1 Copy the contents of the CD-ROM Disk 2 to the subdirectory Disk2, as follows: # cp -R * software_source_directory/Disk2 Navigate to the software_source_directory, as follows: # cd software_source_directory Change the ownership of the Disk1 and Disk2 subdirectories to user oracle, group oinstall, as follows: # chown -R oracle:oinstall Disk1 # chown -R oracle:oinstall Disk2 When copied in this fashion, the Oracle Universal Installer automatically finds the contents of each CD-ROM and does not prompt for the location of either CD-ROM during the course of installation. Log in as user oracle, as follows: # su - oracle Ensure that the DISPLAY and TERM environment variables are still set properly. Enter the following commands to begin the Oracle installation process: $ cd software_source_directory/Disk1 $ ./runInstaller where software_source_directory is the directory into which you've copied the Oracle CD-ROMs. The Oracle Universal Installer opens, displaying the Welcome window. Click Next. The File Locations window opens. Verify the values in the Source and Destination fields. The value of the Source field must be software_source_directory/Disk1/stage/products.jar, and the value of the Destination field must be the same as the value you set for the ORACLE_HOME environment variable. Click Next. The UNIX Group Name window opens. Enter oinstall in the UNIX Group Name field, and then click Next. Note: If the /var/opt/oracle directory does not exist or cannot be written to by the user oracle, you are prompted to run the /oracle_home_directory/product/8.1.7/oraInstRoot.sh script at this point in the installation process. Switch to another terminal, log in as the user root, and execute the script. After the script has been executed, return to the Oracle Universal Installer to continue the installation process. In the Available Products window, verify that the Oracle8i Enterprise Edition 8.1.7.0.0 option is selected, and then click Next. In the Installation Types window, choose the Typical option, and then click Next. In the Database Identification window, enter a global database name in the Global Database Name field (for example, orcl.machine_name), and verify that the value in the SID field is the same as the value you set for the ORACLE_SID environment variable. Click Next. In the Database File Location window, specify the installation location for the Oracle database files in the Directory for Database Files field and then click Next. Verify the information in the Summary window, which summarizes all of the installation choices that you have made so far. When you determine that the information is correct, click Install. The Install window opens; it tracks the status of the Oracle installation. Note: At this point in the installation, you are prompted to run the root.sh configuration script to set the necessary file permissions for Oracle products. Switch to another terminal, log in as the user root, and execute the script. After the script runs, return to the Oracle Universal Installer to finish the installation process. After the installation and linking processes finish, the Configuration Tools window opens. The Net8 Configuration Assistant and Oracle Database Configuration Assistant are automatically configured, along with an Oracle database. The Configuration Tools window identifies two user accounts and passwords automatically configured for the database by the Oracle Database Configuration Assistant. One is the SYS account with a password of change_on_install and the other is the SYSTEM account with a password of manager. Note these accounts and passwords for future use. After the configuration process is complete, click Next. The End of Installation window opens. Click Exit to close the Oracle Universal Installer. Click Yes to confirm the action. Apply to the product any Oracle-supplied patches located in the software_source_directory/Disk1/patch, software_source_directory/Disk2/patch, software_source_directory/Disk1/opspatch, and software_source_directory/Disk2/opspatch directories. Review the README included with each patch for installation instructions. At this point, check the Oracle product documentation on the Oracle Web site at docs.oracle.com/database_mp_8i.html to verify that your environment variables are set to optimize your particular installation. Unmount any CD-ROM before removing it from the CD-ROM drive by entering the following command: # umount cdrom/cdrom0 Proceed to the article "Configuring Oracle 8i Release 3 (8.1.7) for use with WebSphere Application Server" to configure Oracle for use with WebSphere Application Server.