Real Application Cluster 10G R2 [OEL4 x86_64, NFS, Clusterware]

[Marley]

Real Application Cluster [Oracle Enterprise Linux Server 4.8 x86_64, Oracle Clusterware, Oracle DataBase 10g]

How to install Real Application Cluster on Oracle Enterprise Linux Server whith Oracle DataBase 10G
------------------------------------------------------------


ЧЕРНОВИК





Дистрибутивы:

Proxmox
https://odba.ru/showthread.php?t=351

Oracle Enterprise Linux 4.8 x86_64
https://linux.oracle.com/pls/apex/f?p=101:3

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64 и Oracle Clusterware Release 2 (10.2.0.1.0) for Linux x86-64
http://www.oracle.com/technetwork/da...ft-092456.html

JDK
http://java.sun.com/products/archive..._10/index.html

Xming и шрифты к нему
http://sourceforge.net/projects/xming/
http://sourceforge.net/projects/xmin...s/Xming-fonts/

Oracle SQL Developer
http://www.oracle.com/technetwork/de...ads/index.html

[Marley]

Необходимо 3 виртуальные машины.
rac1, rac2 и storage

У rac1 и rac2 по 3 сетевых интерфейса - public, private interconnect и private storage
У storage 2 сетевых интерфейса - public и private storage.

На каждой виртуаьной машине по 2 GB RAM

На rac1 и rac2 2 HDD и 1 NAS от storage

[Marley]

rac1 и rac2
2 HDD 40 GB



/dev/sda1

swap 4096
/home 40960 ext3
/ остальное ext3



/dev/sdb1

/u01 весь диск ext3

[Marley]

На каждой машине
vi /etc/hosts

127.0.0.1 localhost.localdomain localhost

## eth0 Public Network (DNS)

192.168.1.10 rac1.marley.local rac1
192.168.1.11 rac2.marley.local rac2
192.168.1.12 storage.marley.local storage


## eth1 Private Network (Interconnect) (DNS, hosts file)


192.168.2.10 rac1-priv
192.168.2.11 rac2-priv


## eth2 Private Network (Network storage) (DNS, hosts file)


192.168.3.10 rac1-priv-nas
192.168.3.11 rac2-priv-nas


## Virtual VIP IPs (DNS, hosts file)

192.168.1.20 rac1-vip.marley.local rac1-vip
192.168.1.21 rac2-vip.marley.local rac2-vip

[Marley]

На каждой машине
vi /etc/resolv.conf

search marley.local
nameserver 192.168.1.1


vi /etc/sysconfig/network

каждому хосту соответсвует свое имя

NETWORKING=yes
HOSTNAME=rac1.marley.local
GATEWAY=192.168.1.1

[Marley]

rac1.marley.local

(public)
vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.1.10
NETMASK=255.255.255.0

(private-clusters)
vi /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.2.10
NETMASK=255.255.255.0

(private-nas)
vi /etc/sysconfig/network-scripts/ifcfg-eth2

DEVICE=eth2
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.3.10
NETMASK=255.255.255.0

===============================================


rac2.marley.local

(public)
vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.1.11
NETMASK=255.255.255.0

(private-clusters)
vi /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.2.11
NETMASK=255.255.255.0

(private-nas)
vi /etc/sysconfig/network-scripts/ifcfg-eth2

DEVICE=eth2
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.3.11
NETMASK=255.255.255.0

===============================================

storage.marley.local


(public)
vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.1.12
NETMASK=255.255.255.0

(private-nas)
vi /etc/sysconfig/network-scripts/ifcfg-eth1

DEVICE=eth1
ONBOOT=yes
BOOTPROTO=static
IPADDR=192.168.3.12
NETMASK=255.255.255.0

================================================== ===

service network restart

[Marley]

На всех виртуальных машинах:

Установка необходимых пакетов для инсталляции Oracle

cd /etc/yum.repos.d
vi /etc/yum.repos.d/oraclelinux.repo

[el_latest]
name=Enterprise Linux $releasever - $basearch - latest
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL4/8/base/x86_64/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el4
gpgcheck=1
enabled=1

wget http://public-yum.oracle.com/repo/En...el4.x86_64.rpm

yum install oracle-validated-1.0.0-18.el4.x86_64.rpm -y


--------------------------------------------------------


{
{
yum install mc -y
yum install samba -y
yum install screen -y
yum install sharutils -y
yum install vim-common -y
yum install vim-enhanced -y
yum install vsftpd -y
yum install xinetd -y
}
echo $?
}


{
yum install net-snmp -y
yum install net-snmp-utils -y
}

{
yum install libaio-devel -y
yum install unixODBC-devel -y
}

[Marley]

Необходимо настроить автозапуск на всех виртуальных машинах:

Runlevels

export LANG=C
ntsysv 3


acpid
atd
auditd
autofs
crond
haldaemon
irqbalance
messagebus
netfs
network
nfs
nfslock
portmap
readahead
readahead-early
rpcgssd
rpcidmapd
sendmail
snmpd
sshd
syslog
sysstat
vsftpd
xinetd

[Marley]

На всех виртуальных машинах.
Сервера ru.pool.ntp.org выбраны в качестве примера

crontab -e

# Set the date and time via NTP
*/15 * * * * /usr/sbin/ntpdate 0.ru.pool.ntp.org 1.ru.pool.ntp.org 2.ru.pool.ntp.org 3.ru.pool.ntp.org > /var/log/time.log

[Marley]

На всех виртуальных машинах:

Смонтируем второй диск в /u1

ls /dev/hd*

fdisk /dev/hdb

The number of cylinders for this disk is set to 5221.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): m
Command action
a toggle a bootable flag
b edit bsd disklabel
c toggle the dos compatibility flag
d delete a partition
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)

Command (m for help): d
No partition is defined yet!

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p

Partition number (1-4): 1
First cylinder (1-5221, default 1): Enter
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-5221, default 5221): Enter
Using default value 5221

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.




mke2fs -j /dev/hdb1

mke2fs 1.35 (28-Feb-2004)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
5242880 inodes, 10484412 blocks
524220 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
320 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624

Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 33 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

------------------------------------------------------------------

На rac1 и rac2:

mkdir /u01

vi /etc/fstab

добавляем

/dev/hdb1              /u01          ext3      defaults

mount /u01


df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 16G 843M 15G 6% /
none 1004M 0 1004M 0% /dev/shm
/dev/hda2 20G 76M 19G 1% /home
/dev/hdb1 40G 80M 38G 1% /u01

------------------------------------------------------------------

На storage:

mkdir /share

vi /etc/fstab

добавляем

/dev/hdb1              /share          ext3      defaults

mount /share


df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 16G 843M 15G 6% /
none 1004M 0 1004M 0% /dev/shm
/dev/hda2 20G 76M 19G 1% /home
/dev/hdb1 40G 80M 38G 1% /share