Marcelo Grimberg: maio 2013

terça-feira, 28 de maio de 2013

Clone

MSDOS

d: cd VM\Oracle RAC\RAC1

c:\Program File\Oracle\VirtualBox\VboxManage.exe clonehd d:\VM\Oracle RAC\RAC1\ol5-112-rac1.vdi VM\Oracle RAC\RAC2\ol5-112-rac2.vdi

após completar 100%

executa Virtual Box

Criar uma máquina virtual

Nome: ol5-112-rac2
Tipo: Linux
Versão Oracle (64)

Utilizar um disco rígido virtual existente
Localiza onde está gravado novo disco, "D:\VM\Oracle RAC\RAC2\ol5-112-rac2.vdi"

Aloca os discos ASM conforme exemplo acima

Na aba Rede

Habilita duas portas de rede

Conectado a: "Placa em modo Bride"

Incia Máquina Virtual ol5-112-rac2

Configuração rede

hostname: ol6-112-rac2.localdomain

Rede eth0: 192.168.0.102 (public address)

Gateway eth0: 192.168.0.1 (public address)

Rede eth1: 192.168.1.102 (private address)

Gateway eth1: nulo

Remove todos que tiver bkp, apenas deixa duas redes eth0 e eth1, conforme o exemplo acima

Configuração eth0

Configuração eth1

Hostname ol5-112-rac2.localdomain

.bash_profile

altera seguintes parâmetros

ORACLE_SID=RAC2

ORACLE_HOSTANAME=ol5-112-rac2.localdomain

db_env

ORACLE_SID=RAC2

Teste ip's PUBLIC e PRIVATE

Inicia a máquina virtual ol5-112-rac1

Resultado

RAC2

[root@ol5-112-rac2 scripts]# ping ol5-112-rac1

PING ol5-112-rac1.localdomain (127.0.0.1) 56(84) bytes of data.

64 bytes from ol5-112-rac1.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.065 ms

64 bytes from ol5-112-rac1.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.065 ms

64 bytes from ol5-112-rac1.localdomain (127.0.0.1): icmp_seq=3 ttl=64 time=0.117 ms

64 bytes from ol5-112-rac1.localdomain (127.0.0.1): icmp_seq=4 ttl=64 time=0.139 ms

--- ol5-112-rac1.localdomain ping statistics ---

4 packets transmitted, 4 received, 0% packet loss, time 2997ms

rtt min/avg/max/mdev = 0.065/0.096/0.139/0.033 ms

[root@ol5-112-rac2 scripts]# ping ol5-112-rac1-priv

PING ol5-112-rac1-priv.localdomain (192.168.2.101) 56(84) bytes of data.

64 bytes from ol5-112-rac1-priv.localdomain (192.168.2.101): icmp_seq=1 ttl=64 t ime=12.7 ms

64 bytes from ol5-112-rac1-priv.localdomain (192.168.2.101): icmp_seq=2 ttl=64 t ime=0.993 ms

64 bytes from ol5-112-rac1-priv.localdomain (192.168.2.101): icmp_seq=3 ttl=64 t ime=0.883 ms

64 bytes from ol5-112-rac1-priv.localdomain (192.168.2.101): icmp_seq=4 ttl=64 t ime=0.984 ms

--- ol5-112-rac1-priv.localdomain ping statistics ---

4 packets transmitted, 4 received, 0% packet loss, time 3001ms

rtt min/avg/max/mdev = 0.883/3.914/12.797/5.128 ms

RAC1

[root@ol5-112-rac1 ~]# ping ol5-112-rac2

PING ol5-112-rac2.localdomain (192.168.1.102) 56(84) bytes of data.

64 bytes from ol5-112-rac2.localdomain (192.168.1.102): icmp_seq=1 ttl=64 time=9.58 ms

64 bytes from ol5-112-rac2.localdomain (192.168.1.102): icmp_seq=2 ttl=64 time=1.01 ms

64 bytes from ol5-112-rac2.localdomain (192.168.1.102): icmp_seq=3 ttl=64 time=1.42 ms

--- ol5-112-rac2.localdomain ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 1998ms

rtt min/avg/max/mdev = 1.011/4.007/9.585/3.948 ms

[root@ol5-112-rac1 ~]# ping ol5-112-rac2-priv

PING ol5-112-rac2-priv.localdomain (192.168.2.102) 56(84) bytes of data.

64 bytes from ol5-112-rac2-priv.localdomain (192.168.2.102): icmp_seq=1 ttl=64 time=1.80 ms

64 bytes from ol5-112-rac2-priv.localdomain (192.168.2.102): icmp_seq=2 ttl=64 time=1.14 ms

64 bytes from ol5-112-rac2-priv.localdomain (192.168.2.102): icmp_seq=3 ttl=64 time=1.07 ms

--- ol5-112-rac2-priv.localdomain ping statistics ---

3 packets transmitted, 3 received, 0% packet loss, time 1998ms

rtt min/avg/max/mdev = 1.078/1.340/1.800/0.326 ms

[root@ol5-112-rac1 ~]#

Verificação disco ASM

[root@ol5-112-rac2 scripts]# /usr/sbin/oracleasm listdisks

DISK1

DISK2

DISK3

DISK4

DISK5

DISK6

[root@ol5-112-rac2 scripts]# /usr/sbin/oracleasm status

Checking if ASM is loaded: yes

Checking if /dev/oracleasm is mounted: yes

[root@ol5-112-rac2 scripts]#

segunda-feira, 27 de maio de 2013

Instalação Pacote Oracleasm

Instalação pacotes rpm

No cd instalação Oracle Enterprise Linux

[root@ol5-112-rac1 /]# cd /media/Enterprise\ Linux\ dvd\ 20100405/Server/
[root@ol5-112-rac1 Server]# rpm -ivh kernel-devel-2.6.18-194.el5.x86_64.rpm
warning: kernel-devel-2.6.18-194.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:kernel-devel ########################################### [100%]

[root@ol5-112-rac1 Server]# rpm -Uvh oracleasm*.rpm
warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
error: Failed dependencies:
kernel-debug = 2.6.18-194.el5 is needed by oracleasm-2.6.18-194.el5debug-2.0.5-1.el5.x86_64
kernel-xen = 2.6.18-194.el5 is needed by oracleasm-2.6.18-194.el5xen-2.0.5-1.el5.x86_64

[root@ol5-112-rac1 Server]# rpm -Uvh kernel-debug-*
warning: kernel-debug-2.6.18-194.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:kernel-debug-devel ########################################### [ 50%]
2:kernel-debug ########################################### [100%]

[root@ol5-112-rac1 Server]# rpm -Uvh kernel-xen*
warning: kernel-xen-2.6.18-194.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:kernel-xen-devel ########################################### [ 50%]
2:kernel-xen ########################################### [100%]

[root@ol5-112-rac1 Server]# rpm -Uvh oracleasm*.rpm
warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [ 25%]
2:oracleasm-2.6.18-194.el########################################### [ 50%]
3:oracleasm-2.6.18-194.el########################################### [ 75%]
4:oracleasm-2.6.18-194.el########################################### [100%]

Configurar Oraclasm

[root@ol5-112-rac1 Server]# oracleasm configure -i
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface [oracle]:
Default group to own the driver interface [dba]:
Start Oracle ASM library driver on boot (y/n) [y]:
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done

Carregar o modulo Kernel no oracleasm

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm init
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm

Criação disco ASM

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK1 /dev/sdb1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK2 /dev/sdc1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK3 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK4 /dev/sde1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK5 /dev/sdf1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm createdisk DISK6 /dev/sdg1

Writing disk header: done

Instantiating disk: done

[root@ol5-112-rac1 Server]#

SCANDISKS

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

[root@ol5-112-rac1 Server]#

Listdisks

[root@ol5-112-rac1 Server]# /usr/sbin/oracleasm listdisks

DISK1

DISK2

DISK3

DISK4

DISK5

DISK6

domingo, 26 de maio de 2013

Pré Configurações

Pré configuração

Instalações pacotes RPM

No VirtualBox aponta a imagem da instalação Oracle Linux Enterprise

No terminal

[root@ol5-112-rac1 ~]# cd /media/Enterprise\ Linux\ dvd\ 20100405/Server

Instala seguintes pacotes

rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh elfutils-libelf-devel-*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh glibc-headers-2.*
rpm -Uvh ksh-2*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh make-3.*
rpm -Uvh sysstat-7.*
rpm -Uvh unixODBC-2.*
rpm -Uvh unixODBC-devel-2.*

sysctl.conf

[root@ol5-112-rac1 /]# vi /etc/sysctl.conf

Comando Básico VI

I = inserir

Para sair

ESC :

q! sair sem salvar

wq! sair e salvar o arquivo

copiar seguintes parâmetro

# Controls the maximum shared segment size, in bytes

kernel.shmmax = 1054504960

# Controls the maximum number of shared memory segments, in pages

kernel.shmall = 2097152

kernel.shmmni = 4096

fs.aio-max-nr = 1048576

fs.file-max = 6815744

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

Executar seguintes comando para mudança do parâmetro

[root@ol5-112-rac1 /]# /sbin/sysctl -p

exemplo:

[root@ol5-112-rac1 /]# /sbin/sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 1054504960

kernel.shmall = 2097152

fs.aio-max-nr = 1048576

fs.file-max = 6815744

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@ol5-112-rac1 /]#

Limits.conf

[root@ol5-112-rac1 /]# vi /etc/security/limits.conf

copiar seguintes paramêtros

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

Login

[root@ol5-112-rac1 /]# vi /etc/pam.d/login

session required pam_limits.so

Adicionar usuário e grupo

[root@ol5-112-rac1 /]# groupadd -g 1000 oinstall

[root@ol5-112-rac1 /]# groupadd -g 1200 dba

[root@ol5-112-rac1 /]# useradd -u 1100 -g oinstall -G dba oracle

[root@ol5-112-rac1 /]# passwd oracle

Criar diretórios e permissão

[root@ol5-112-rac1 /]# mkdir -p /u01/app/11.2.0/grid

[root@ol5-112-rac1 /]# mkdir -p /u01/app/oracle/product/11.2.0/db_1

[root@ol5-112-rac1 /]# mkdir -p /u01/admin/scripts

[root@ol5-112-rac1 /]# chown -R oracle:oinstall /u01

[root@ol5-112-rac1 /]# chmod -R 775 /u01/

Hosts

[root@ol5-112-rac1 scripts]# vi /etc/hosts

OBS:

IP conforme a minha máquina poderá mudar conforme a sua necessidade

copiar seguintes configuração

127.0.0.1 localhost.localdomain localhost

#PUBLIC

192.168.1.101 ol5-112-rac1.localdomain ol5-112-rac1

192.168.1.102 ol5-112-rac2.localdomain ol5-112-rac2

#PRIVATE

192.168.2.101 ol5-112-rac1-priv.localdomain ol5-112-rac1-priv

192.168.2.102 ol5-112-rac2-priv.localdomain ol5-112-rac2-priv

# Virtual

192.168.1.103 ol5-112-rac1-vip.localdomain ol5-112-rac1-vip

192.168.1.104 ol5-112-rac2-vip.localdomain ol5-112-rac2-vip

# SCAN

192.168.1.105 ol5-112-scan.localdomain ol5-112-scan

192.168.1.106 ol5-112-scan.localdomain ol5-112-scan

192.168.1.107 ol5-112-scan.localdomain ol5-112-scan

Script do banco de dados

Conecta com usuário Oracle no terminal

.Bash_profile

[oracle@ol5-112-rac1 ~]$ cd /u01/admin/scripts/

[oracle@ol5-112-rac1 scripts]$ vi .bash_profile

copiar seguintes comando

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=ol5-112-rac1.localdomain; export ORACLE_HOSTNAME

ORACLE_UNQNAME=RAC; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

GRID_HOME=/u01/app/11.2.0/grid; export GRID_HOME

DB_HOME=$ORACLE_BASE/product/11.2.0/db_1; export DB_HOME

ORACLE_HOME=$DB_HOME; export ORACLE_HOME

ORACLE_SID=RAC1; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

BASE_PATH=/usr/sbin:$PATH; export BASE_PATH

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

alias grid_env='. /home/oracle/grid_env'

alias db_env='. /home/oracle/db_env'

Grid_env

[oracle@ol5-112-rac1 scripts]$ vi grid_env

ORACLE_SID=+ASM1; export ORACLE_SID

ORACLE_HOME=$GRID_HOME; export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

db_env

[oracle@ol5-112-rac1 scripts]$ vi db_env

ORACLE_SID=RAC1; export ORACLE_SID

ORACLE_HOME=$DB_HOME; export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

com usuário root

[root@ol5-112-rac1 scripts]# # shutdown -r now

Grub.con

Adicionar o parâmetro divider=10, conforme o exemplo abaixo

[root@ol5-112-rac1 scripts]# vi /etc/grub.conf

# grub.conf generated by anaconda
#
# Note that you do not have to rerun grub after making changes to this file
# NOTICE: You have a /boot partition. This means that
# all kernel and initrd paths are relative to /boot/, eg.
# root (hd0,0)
# kernel /vmlinuz-version ro root=/dev/VolGroup00/LogVol00
# initrd /initrd-version.img
#boot=/dev/sda
default=0
timeout=5
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title Enterprise Linux (2.6.18-194.el5)
root (hd0,0)
kernel /vmlinuz-2.6.18-194.el5 ro root=/dev/VolGroup00/LogVol00 rhgb quiet divider=10
initrd /initrd-2.6.18-194.el5.img

Instalação adicional

Instalar Adicionais para Convidado...

[root@ol5-112-rac1 scripts]# cd /media/VBOXADDITIONS_4.2.6_82870/
[root@ol5-112-rac1 VBOXADDITIONS_4.2.6_82870]# sh ./VBoxLinuxAdditions.run

Alocar disco virtual ASM

VBoxManage createhd --filename asm1.vdi --size 5120 --format VDI --variant Fixed

VBoxManage createhd --filename asm2.vdi --size 5120 --format VDI --variant Fixed

VBoxManage createhd --filename asm3.vdi --size 5120 --format VDI --variant Fixed

VBoxManage createhd --filename asm4.vdi --size 5120 --format VDI --variant Fixed

VBoxManage createhd --filename asm5.vdi --size 5120 --format VDI --variant Fixed

VBoxManage createhd --filename asm6.vdi --size 5120 --format VDI --variant Fixed

Desliga o Linux e pois fecha o VM

No pront MSDOS

Apontar diretório onde irá criar os discos
cd d:\VM\Oracle RAC\ASM

Apontar o diretório onde está localizado o programa Virtual Box

c:\Program File\Oracle\VirtualBox\VBoxManage.exe createhd --filename asm1.vdi --size 5120 --format VDI --variant Fixed

realizar o mesmo procedimento até criar os 6 disco, conforme o exemplo.

Alocar os discos

Compartilhar disco ASM

VBoxManage modifyhd asm1.vdi --type shareable

VBoxManage modifyhd asm2.vdi --type shareable

VBoxManage modifyhd asm3.vdi --type shareable

VBoxManage modifyhd asm4.vdi --type shareable

VBoxManage modifyhd asm5.vdi --type shareable

VBoxManage modifyhd asm6.vdi --type shareable

MSDOS

d:\
cd VM\Oracle RAC\ASM
c:\Programa Files\Oracle\VirtualBox\VBoxManage modifyhd asm1.vdi --type shareable

Inicia o Sistema Operacional

Configurar os discos

Com usuário root

[root@ol5-112-rac1 ~]# cd /dev/

[root@ol5-112-rac1 dev]# ls sd*

sda sda1 sda2 sdb sdc sdd sde sdf sdg

Utiliza seguintes passos

[root@ol5-112-rac1 dev]# fdisk /dev/sdb

Command (m for help): n

Command action

e extended

p primary partition (1-4)

Partition number (1-4): 1

First cylinder (1-652, default 1): 1

Last cylinder or +size or +sizeM or +sizeK (1-652, default 652):

Using default value 652

Command (m for help): p

Disk /dev/sdb: 5368 MB, 5368709120 bytes

255 heads, 63 sectors/track, 652 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sdb1 1 652 5237158+ 83 Linux

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

segue o mesmo exempo para
fdisk /dev/sdc ,
fdisk /dev/sdd,
fdisk /dev/sde,
fdisk /dev/sdf
fdisk /dev/sdg

Depois terminar, verificar as configurações
[root@ol5-112-rac1 dev]# cd /dev
[root@ol5-112-rac1 dev]# ls sd*
sda sda1 sda2 sdb sdb1 sdc sdc1 sdd sdd1 sde sde1 sdf sdf1 sdg sdg1

terça-feira, 28 de maio de 2013

Clone VM

Clone VM

Clone

Criar uma máquina virtual

Na aba Rede

Configuração rede

.bash_profile

db_env

Teste ip's PUBLIC e PRIVATE

Verificação disco ASM

segunda-feira, 27 de maio de 2013

Instalação pacote Oracleasm

Instalação Pacote Oracleasm

Instalação pacotes rpm

Configurar Oraclasm

Carregar o modulo Kernel no oracleasm

Criação disco ASM

SCANDISKS

Listdisks

domingo, 26 de maio de 2013

Pré Configurações

Pré configuração

Instalações pacotes RPM

sysctl.conf

Executar seguintes comando para mudança do parâmetro

Limits.conf

Login

Adicionar usuário e grupo

Criar diretórios e permissão

Hosts

Script do banco de dados

.Bash_profile

Grid_env

db_env

Grub.con

Instalação adicional

Alocar disco virtual ASM

Alocar os discos

Configurar os discos Com usuário root

Configurar os discos

Com usuário root