Basic System Setup
1. Install AIX 5.3 + latest maintenance level, and check metalink note 282036.1 for any additional
system prerequisites for Oracle
2. Verify the following filesets are installed, or install if not present:
•bos.adt.base
•bos.adt.lib
•bos.adt.libm
•bos.adt.syscalls
•bos.perf.libperfstat
•bos.perf.perfstat
•bos.perf.proctools
•bos.perf.gtools
•rsct.basic
•rsct.basic.compat
3. Create dba and oinstall groups with the same GID across all cluster nodes
4. Create oracle user with the same UID across all cluster nodes, primary group dba
5. set date and timezone (smit system)
6. start xntpd (smit xntpd)
implement tuning parameters from the Tuning Parameters and Settings for ASM section of this
document
Configure Network Settings & Services
1. Set up tcpip on the en0 adapter
# smitty tcpip
- Minimum configuration and startup for en0 ** public network **
- rac1: 10.1.1.101
- rac2: 10.1.1.102
- rac3: 10.1.1.103
- Minimum configuration and startup for en1 ** RAC Interconnect **
- rac1-en1: 10.1.10.101
- rac2-en1: 10.1.10.102
- rac3-en1: 10.1.10.103
2. Update /etc/hosts with all IP/DNS entries
3. Create entries in /etc/hosts.equiv for the oracle user
rac1 oracle
rac2 oracle
rac3 oracle
rac1-en1 oracle
rac2-en1 oracle
rac3-en1 oracle
Logical Volumes & Filesystems
1. Increase filesystem sizes:
- / = 256 MB
- /tmp = > 500 MB free
- /var = 512 MB
2. Make filesystems for Oracle SW ($ORACLE_HOME), ASM ($ORACLE_ASM_HOME) and
CRS ($ORA_CRS_HOME),
- $ORACLE_HOME, eg /opt/oracle/product/10.2.0, should be ~ 5-6 GB
- $ORA_CRS_HOME, eg /crs/oracle/product/10.2.0, should be ~ 2 GB
- mount filesystems after creation
- change ownerships & permissions, example:
- chown -R oracle:oinstall /opt/oracle
- chown -R 775 /opt/oracle
- mkdir -p /crs/oracle/product/10.2.0
- chown -R oracle:oinstall /crs/oracle
- chmod -R 755 /crs/oracle
3. Add $ORA_CRS_HOME/bin to root’s PATH
POWERPATH installation
See the EMC Host Connectivity Guide for IBM AIX, P/N 300-000-608, for full details
1. Install EMC ODM support package
- 5.3.0.2 from ftp://ftp.emc.com/pub/elab/aix/ODM_DEFINITIONS/EMC.AIX.5.3.0.2.tar.Z
- uncompress and extract the tar ball into a new directory
- install using smit install
2. remove any existing devices attached to the EMC
# rmdev –dl hdiskX
3. run /usr/lpp/EMC/Symmetrix/bin/emc_cfgmgr to detect devices
4. Install PowerPath using smit install
5. register PowerPath
# emcpreg –install
6. initialize PowerPath devices
# powermt config
7. verify that all PowerPath devices are named consistently across all cluster nodes
# /usr/lpp/EMC/Symmetrix/bin/inq.aix64 | grep hdiskpower
- compare results. Consistent naming is not required for ASM devices, but LUNs used
for the OCR and VOTE functions must have the same device names on all rac systems6:
8. On all hdiskpower devices to be used by Oracle for ASM, voting, or the OCR, the reserve_lock
attribute must be set to “no”
# chdev -l hdiskpowerX -a reserve_lock=no
9. Verify the attribute is set
# lsattr –El hdiskpowerX
10. Identify two small luns to be used for OCR and voting
11. Set permissions on all hdiskpower drives to be used for ASM, voting, or the OCR as follows:
# chown oracle:dba /dev/rhdiskpowerX
# chmod 660 /dev/rhdiskpowerX
The Oracle Installer will change these permissions and ownership as necessary during the
CRS install process.
Oracle 10g RAC installation
1. Add the following to the oracle user’s .profile:
ORACLE_BASE=<oracle base directory>; export ORACLE_BASE
ORA_CRS_HOME=<ora crs home>; export ORA_CRS_HOME
AIXTHREAD_SCOPE=S; export AIXTHREAD_SCOPE7
umask 022
2. Run the Oracle installer to install CRS
$ export LOG=/tmp/orainstall.log
$ export ORACLE_HOME=/crs/oracle/product/10.2.0
Load the CRS install cd
run rootpre.sh on ALL nodes
$ runInstaller –ignoreSysPrereqs
3. Check crs install for the correct number of nodes and interfaces
[rac1]/crs/oracle/product/10.1.0/bin> # ./olsnodes -n
rac1 1
rac2 2
rac3 3
[rac1]/crs/oracle/product/10.1.0/bin> # ./oifcfg getif
en0 10.1.3.0 global public
en1 10.1.30.0 global cluster_interconnect
4. Install Oracle Binaries
$export ORACLE_HOME=/home/oracle/product/10.2.0
$ cd <10g DVD directory, Disk1>
$ runInstaller –ignoreSysPrereqs
5. Install latest 10g patchset
6. Install any additional Oracle patches listed in the PowerPath for AIX installation guide.
7. For Clariion systems, refer to the “Requirements for Oracle 10g RAC with ASM on AIX
5L” document from EMC to set the miscount settings appropriately.
8. Run DBCA to set up ASM instances and create database
Create Data and Recovery disk groups, each with external redundancy
use /dev/rhdisk* as the disk discovery path
Choose option to Use Oracle-Managed Files
