User's Manual

2.3 Install and set up Oracle software

This section explains how to install and set up Oracle.

Initial setup

● /etc/system

Set up values in the “/etc/system” file for Oracle in addition to the values for

PRIMECLUSTER.

The kernel parameter values vary depending on the implemented Oracle versions.

Refer to the Oracle installation guide. The parameter values should be identical on all

nodes.

Before installing Oracle, you need to change the “/etc/system” file and reboot the node.

The setup examples are shown below:

set shmsys:shminfo_shmmax=4294967295

set shmsys:shminfo_shmmin=1

set shmsys:shminfo_shmmni=100

set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmni=100

set semsys:seminfo_semmsl=200

set semsys:seminfo_semmns=400

set semsys:seminfo_semopm=100

set semsys:seminfo_semvmx=32767

● /etc/services

Set up a port number for the Oracle listener.

listener 1521/tcp oracle

● Oracle User

Create DBA (database administrator) user to allow a user to install Oracle and operate.

The user ID and the group ID should be identical on all nodes.

# groupadd –g <group ID> dba

# useradd –u <user ID> –g dba –d /export/home/oracle –s /bin/sh –m oracle

# passwd oracle

Normally, the group name should be “dba”.

Set up environment variables of Oracle user.