なぐりがきメモ

目標

Oracle Database 11g R2をPacemakerでHA冗長化

環境

RHEL5.6 x86_64

インストール前

片方セットアップ

[root@rhel5-1 ~]# groupadd oinstall
[root@rhel5-1 ~]# groupadd dba
[root@rhel5-1 ~]# useradd -g oinstall -G dba oracle
[root@rhel5-1 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@rhel5-1 ~]# vi /etc/sysctl.conf

# Oracle Database 11g R2
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

[root@rhel5-1 ~]# vi /etc/security/limits.conf

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240

[oracle@rhel5-1 ~]$ ulimit -Sn
1024
[oracle@rhel5-1 ~]$ ulimit -Hn
65536
[oracle@rhel5-1 ~]$ ulimit -Su
2047
[oracle@rhel5-1 ~]$ ulimit -Hu
16384
[oracle@rhel5-1 ~]$ ulimit -Ss
10240
[oracle@rhel5-1 ~]$ ulimit -Hs
unlimited

[root@rhel5-1 ~]# cd /opt/
[root@rhel5-1 opt]# mkdir app
[root@rhel5-1 opt]# cd
[root@rhel5-1 ~]# chown -R oracle:oinstall /opt/app
[root@rhel5-1 ~]# chmod -R 755 /opt/app
[root@rhel5-1 ~]#

[oracle@rhel5-1 ~]$ vi .bashrc
# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# User specific aliases and functions

# Oracle Database 11g R2
ORACLE_BASE=/opt/app/oracle
ORACLE_SID=orcl
export ORACLE_BASE ORACLE_SID