Oracle 10g for Solaris x86安装

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
• Unpack Files
• Hosts File
• Set Kernel Parameters
• Setup
• Installation
• Post Installation

Download Software

Download the following software:

• Oracle Database 10g Downloads

Unpack Files

Unzip the files:

unzip 10202_database_solx86.zip

You should now have a single directory called "database" containing installation files.

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.

set semsys:seminfo_semmni=100set semsys:seminfo_semmsl=256set shmsys:shminfo_shmmax=4294967295set shmsys:shminfo_shmmni=100

The Oracle installer recognizes kernel parameters set using this method, but it is now deprecated in favour of resource control projects, explained below.

As the root user, issue the following command.

projadd oracle

Append the following line to the "/etc/user_attr" file.

oracle::::project=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.

# prctl -n project.max-shm-memory -i project oracleproject: 100: oracleNAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENTproject.max-shm-memory        privileged       254MB      -   deny                                 -        system          16.0EB    max   deny                                 -#

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 -v 4gb -r -i project oracle# projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

The first dynamically resets the value, while the second makes changes to the "/etc/project" file so the value is persistent between reboots.

# cat /etc/projectsystem:0::::user.root:1::::noproject:2::::default:3::::group.staff:10::::oracle:100::::project.max-shm-memory=(priv,4294967296,deny)#

The Oracle installer seems incapable of recognising kernel parameter set using resource control projects, but if you ignore the warnings the installation completes successfully.

Setup

Add the "SUNWi1cs" and "SUNWi15cs" packages using the "pkgadd" command.

# pkgadd -d /cdrom/sol_10_106_x86/Solaris_10/Product SUNWi1cs SUNWi15csProcessing package instance  from X11 ISO8859-1 Codeset Support(i386) 2.0,REV=2004.10.17.15.04Copyright 2004 Sun Microsystems, Inc.  All rights reserved.Use is subject to license terms.This appears to be an attempt to install the same architecture andversion of a package which is already installed.  This installationwill 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-userpermission during the process of installing this package.Do you want to continue with the installation of  [y,n,?] yInstalling 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.04Copyright 2004 Sun Microsystems, Inc.  All rights reserved.Use is subject to license terms.This appears to be an attempt to install the same architecture andversion of a package which is already installed.  This installationwill 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-userpermission during the process of installing this package.Do you want to continue with the installation of  [y,n,?] yInstalling X11 ISO8859-15 Codeset Support as ## Installing part 1 of 1.Installation of  was successful.#

Create the new groups and users:

groupadd oinstallgroupadd dbagroupadd operuseradd -g oinstall -G dba -d /export/home/oracle oraclemkdir /export/home/oraclechown oracle:oinstall /export/home/oraclepasswd -r files oracle

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/10.2.0/db_1chown -R oracle:oinstall /u01

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 /export/home/oracle/product/10.2.0/db_1chown -R oracle:oinstall /export/home/oracle

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:

# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIR# Select the appropriate ORACLE_BASE#ORACLE_BASE=/export/home/oracle; export ORACLE_BASEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOMEORACLE_SID=TSH1; export ORACLE_SIDPATH=$ORACLE_HOME/bin:$PATH; export PATH

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

DISPLAY=<machine-name>:0.0; export DISPLAY

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

./runInstaller

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.

1. Select Installation Method
2. Specify Inventory Directory and Credentials
3. Select Installation Type
4. Specify Home Details
5. Product-Specific Prerequisite Checks
6. Select Configuration Option
7. Select Database Configuration
8. Specify Database Configuration Options
9. Select Database Management Option
10. Specify Database Storage Option
11. Specify Backup and Recovery Options
12. Specify Database Schema Passwords
13. Summary
14. Install
15. Configuration Assistants
16. Database Configuration Assistant
17. Database Configuration Assistant Password Management
18. Execute Configuration Scripts
19. End Of Installation

Post Installation

Edit the "/var/opt/oracle/oratab" file setting the restart flag for each instance to 'Y':

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

For more information see:

• Oracle Database Installation Guide 10g Release 2 (10.2) for Solaris Operating System (x86)

Hope this helps. Regards Tim...