Oracle Database 10g Release 2 (10.2.0.2) Installation On Solaris 10 (x86)
In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.2) on Solaris 10 (x86). The article is based on a default server installation as shown here. Alternative installations may require a different setup procedure.Download Software
Download the following software:Unpack Files
Unzip the files:You should now have a single directory called "database" containing installation files.unzip 10202_database_solx86.zip
Hosts File
The /etc/hosts file must contain a fully qualified name for the server:<IP-address> <fully-qualified-machine-name> <machine-name>
Set Kernel Parameters
In previous versions of Solaris, kernel parameters were amended by adding entries to the "/etc/system" file, followed by a system reboot.The Oracle installer recognizes kernel parameters set using this method, but it is now deprecated in favour of resource control projects, explained below.set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=256 set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmni=100
As the root user, issue the following command.
Append the following line to the "/etc/user_attr" file.projadd oracle
If you've performed a default installation, it is likely that the only kernel parameter you need to alter is "max-shm-memory". To check the current value issue the following command.oracle::::project=oracle
To reset this value, make sure at least one session is logged in as the oracle user, then from the root user issue the following commands.# prctl -n project.max-shm-memory -i project oracle project: 100: oracle NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT project.max-shm-memory privileged 254MB - deny - system 16.0EB max deny - #
The first dynamically resets the value, while the second makes changes to the "/etc/project" file so the value is persistent between reboots.# prctl -n project.max-shm-memory -v 4gb -r -i project oracle # projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle
The Oracle installer seems incapable of recognising kernel parameter set using resource control projects, but if you ignore the warnings the installation completes successfully.# cat /etc/project system:0:::: user.root:1:::: noproject:2:::: default:3:::: group.staff:10:::: oracle:100::::project.max-shm-memory=(priv,4294967296,deny) #
Setup
Add the "SUNWi1cs" and "SUNWi15cs" packages using the "pkgadd" command.Create the new groups and users:# pkgadd -d /cdrom/sol_10_106_x86/Solaris_10/Product SUNWi1cs SUNWi15cs Processing package instance from X11 ISO8859-1 Codeset Support(i386) 2.0,REV=2004.10.17.15.04 Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. This appears to be an attempt to install the same architecture and version of a package which is already installed. This installation will attempt to overwrite this package. Using as the package base directory. ## Processing package information. ## Processing system information. 16 package pathnames are already properly installed. ## Verifying package dependencies. ## Verifying disk space requirements. ## Checking for conflicts with packages already installed. ## Checking for setuid/setgid programs. This package contains scripts which will be executed with super-user permission during the process of installing this package. Do you want to continue with the installation of [y,n,?] y Installing X11 ISO8859-1 Codeset Support as ## Installing part 1 of 1. Installation of was successful. Processing package instance from X11 ISO8859-15 Codeset Support(i386) 2.0,REV=2004.10.17.15.04 Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. This appears to be an attempt to install the same architecture and version of a package which is already installed. This installation will attempt to overwrite this package. Using as the package base directory. ## Processing package information. ## Processing system information. 21 package pathnames are already properly installed. ## Verifying package dependencies. ## Verifying disk space requirements. ## Checking for conflicts with packages already installed. ## Checking for setuid/setgid programs. This package contains scripts which will be executed with super-user permission during the process of installing this package. Do you want to continue with the installation of [y,n,?] y Installing X11 ISO8859-15 Codeset Support as ## Installing part 1 of 1. Installation of was successful. #
Create the directories in which the Oracle software will be installed:groupadd oinstall groupadd dba groupadd oper useradd -g oinstall -G dba -d /export/home/oracle oracle mkdir /export/home/oracle chown oracle:oinstall /export/home/oracle passwd -r files oracle
If you have not partitioned your disks to allow a "/u01" mount point, you may want to install the software in the "/export/home/oracle" directory as follows:mkdir -p /u01/app/oracle/product/10.2.0/db_1 chown -R oracle:oinstall /u01
Login as the oracle user and add the following lines at the end of the .profile file, making sure you have set the correct ORACLE_BASE value:mkdir -p /export/home/oracle/product/10.2.0/db_1 chown -R oracle:oinstall /export/home/oracle
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR # Select the appropriate ORACLE_BASE #ORACLE_BASE=/export/home/oracle; export ORACLE_BASE ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME ORACLE_SID=TSH1; export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH; export PATH
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:DISPLAY=<machine-name>:0.0; export DISPLAY
During the installation enter the appropriate ORACLE_HOME and name then continue installation. For a more detailed look at the installation process, click on the links below to see screen shots of each stage../runInstaller
- Select Installation Method
- Specify Inventory Directory and Credentials
- Select Installation Type
- Specify Home Details
- Product-Specific Prerequisite Checks
- Select Configuration Option
- Select Database Configuration
- Specify Database Configuration Options
- Select Database Management Option
- Specify Database Storage Option
- Specify Backup and Recovery Options
- Specify Database Schema Passwords
- Summary
- Install
- Configuration Assistants
- Database Configuration Assistant
- Database Configuration Assistant Password Management
- Execute Configuration Scripts
- End Of Installation
Post Installation
Edit the "/var/opt/oracle/oratab" file setting the restart flag for each instance to 'Y':For more information see:TSH1:/u01/app/oracle/product/10.2.0/db_1:Y
Hope this helps. Regards Tim...