Oracle Real Application Clusters 10g設定手順書

Transcription

1 ~ RAC ~ Oracle Real Application Clusters 10g Firewire RAW

2 RAC RAC RAC RAC SIer ISV Oracle Real Application Clusters(RAC) Oracle Database 10g S/W RAC Cluster Ready Services(CRS) Automatic Storage Management(ASM) RAC RAC RAC RAC RAC RAC Oracle Real Application Clusters10g Firewire ASM Linux Oracle Real Application Clusters10g Firewire RAW Linux Oracle Real Application Clusters10g VMWare RAW Oracle Real Application Clusters10g VMWare ASM Windows Oracle Real Application Clusters10g NAS Linux Oracle Real Application Clusters10g 1 RAC ASM Linux Oracle Real Application Clusters10g 1 RAC Linux - RAC Firewire RAW - 2

3 OA RAC VMWare Firewire NAS S/W RAC RAC / Firewire SCSI FiberChanel RAC NAS NetApp EMC NAS Network Attached Storage NFS RAC Firewire RAC RAC RAC Oracle Database 10g Release 1 ( ) for Linux x86 Firewire RAC RAC - RAC STATSPACK RAC - RAC RAC - RAC Firewire RAW - 3

4 Firewire RAC Linux Firewire IA IDE SCSI FC RAC OS SCSI FC Windows firewire Windows Firewire Firewire Linux IEEE1394 4

5 Firewire...6 Firewire...7 Firewire RAC FirewireHDD IDE Firewire H/W...15 OS...15 OS...15 OS NIC CRS...49 Oracle Database 10g...67 VIP...74 DBCA Red Hat Enterprise Linux 3.0 Tips Appendix

6 Firewire OS CRS Appendix Firewire Firewire IEEE 1394 IEEE Ethernet IEEE802.3 LAN IEEE1394 Apple Firewire IEEE Apple IEEE1394 Firewire ilink IEEE1394 ilink Firewire Firewire 100/200/400Mbps USB2.0 HS HighSpped 480MBps USB2.0 Microsoft Windows2000/XP OS Firewire/USB2.0 - RAC Firewire RAW - 6

7 Firewire Firewire Firewire HDD HardDisk IEEE1394 FirewireHDD HardDiskCase IDE IEEE1394 HDD Firewire HDD Firewire HDD HDD HDD Firewire HDD HDD FirewireHDD FirewireHDD HDD Firewire Firewire RAC FirewireHDD Firewire PCI IEEE1394 Firewire IEEE1394 Firewire Firewire HDD IDE Firewire Firewire Firewire Card Firewire Card PC PC Firewire RAC RAC H/W RAC NIC NIC Ether - RAC Firewire RAW - 7

8 Ether S/W OS Linux MIRACLE LINUX V3.0 Firewire Oracle Oracle Database 10g Firewire Firewire SCSI Firewire Linux Oracle SCSI Oracle Oracle Firewire Firewire Firewire HDD Firewire NIC NIC HUB IDE Ether HDD Firewire NIC NIC Firewire Firewire Oracle Oracle Oracle ocssd crsd evmd Oracle Oracle RAC dbwr lgwr smon pmon lms lmd RAC - RAC Firewire RAW - 8

9 RAC Cluster Ready Service(CRS) Orace Database 10g RAC Oracle RAC Oracle9i Microsoft Windows Linux RAC Oracle UNIX Oracle9i Database RAC OS Oracle Database 10g CRS Oracle9i Database ORACM OracleClusterManagerService ocssd OracleSyncronizedService OCR OracleClusterRegistry OCR VIP( IP) RAC M CRS RAC OCR VotingDisk M CRS - RAC Firewire RAW - 9

10 VIP IP Virtual IP Address RAC VIP RAC IP TCP KeepAlive VIP - RAC Firewire RAW - 10

11 H/W x86 Pentium 600MHz 2 Ether PCI 2 Ether Ether PCI 3 512M IDEHardDisk 5G 3G CD-ROM 2G TEMP 1G IDE OK FirewireHDD IDE OS SWAP 512M SWAP 1.6G OS 2G SWAP 1.6G 3.6G 8.6G HDD OS SWAP OS 1G Firewire IDEHardDisk 1.5G 1.5G RAW RAW 12 FirewireHDD 6 2 Oxford911 Firewire 2 6 Texas Instruments TI VIA Firewire 2 Firewire LAN 4 1 LAN 2 4 Ether - RAC Firewire RAW - 11

12 S/W Red Hat Enterprise Linux 3.0 MIRACLE LINUX V3.0 Asianux 1.0 X-Windows Oracle Database 10g Release 1 (10.1.0) MIRACLE LINUX V3.0 MIRACLE LINUX V3.0 Red Hat Enterprise Linux 3.0 Firewire RAC RPM Red Hat Enterprise Linux 3.0 Tips Red Hat Enterprise Linux 3.0 Tips FirewireHDD IDE Firewire FirewireHDD IDE FirewirePCI OK FirewireHDD FirewireHDD Oxford911 HDD Oxford911 HDD Oxford911 Ocford911 HDD HDD ADS Technologies PYRO Drive Kit 1394 MediaFocus GXM-35F Novac Bytecc ME-320F IDE IDE Western Digital 80G IDE drive (model WD800BB) - RAC Firewire RAW - 12

13 Western Digital WDC WD40 Model: 0BB-00AUA1 Rev: 18.2 Western Digital 200BB 20GB Western Digital 2000BB 200GB IBM-DTLA Model: Rev: TW4O IDE Firewire TI VIA Western Digital WDC WD40 Model: 0BB-00AUA Novac NV-HD352E 8000 IEEE1394 Buffalo IFC-ILP94 IEEE Buffalo 10/100M PCI LAN LGY-PCI-TXD2 800 IEEE OS OS MIRACLE LINUX V3.0 - Asianux Inside Asianux RedHat3.0 MiracleLinux RedFlag Miracle Linux V /6/30 Oracle Tecnology NetWork Japan OS - RAC Firewire RAW - 13

14 MIRACLE LINUX V3.0 URL MIRACLE LINUX V3.0 Asianux Inside CRS Oracle Database 10g Release 1 (10.1.0) for Linux x86 CRS Firewire OTN Firewire [firewire] [files] kernel elorafw1.i686.rpm RPM SMP SMP 1CPU (2004/06/10 ) - RAC Firewire RAW - 14

15 H/W PCI Ether Firewire IEEE1394 HDD Master Masater/Slave Cable Select Master HDD HDD IEEE1394 HDD Firewire IEEE1394 HDD Firewire FirewireHDD OS OS RAC NIC IP 1 NIC IP oracle oracle OS OS RAC MIRACLE LINUX V3.0 Disk Druid 3G - RAC Firewire RAW - 15

16 NIC Ethercard (eth0) DHCP IP IP Firewire IP NIC(eth1) OS - IP IP oracle01 oracle02 2 OS DHCP IP DHCP DHCP LAN IP PrivateLAN PrivateIP OS NIC DHCP IP NIC DHCP OS /etc/sysconfig/network oracle01 NETWORKING yes HOSTNAME=oracle01 - RAC Firewire RAW - 16

17 [ M ] [ ] OS NIC 2 NIC OS OS NIC IP IP x.x IP Oracle Databse 10g Linux 512M 1G 5G /tmp 900M [root@oracle01 root]# grep MemTotal /proc/meminfo MemTotal: kb [root@oracle01 root]# [root@oracle01 root]# grep SwapTotal /proc/meminfo SwapTotal: kb [root@oracle01 root]# - RAC Firewire RAW - 17

18 1G Root df dd mkswap swapon swapon s swap [root@oracle01 root]# df Filesystem 1K- % /dev/hda % / /dev/hda % /boot none % /dev/shm [root@oracle01 root]# dd [root@oracle01 root]# dd if=/dev/zero of=/swapfile bs=1024k count= mkswap [root@oracle01root]# mkswap /swapfile Setting up swapspace version 1, size = kb [root@oracle01 root]# swapon sawpon s [root@oracle01 root]# swapon /swapfile [root@oracle01 root]# swapon -s Filename Type Size Used Priority /dev/hda3 partition /swapfile file swapon /etc/sysctl.conf - RAC Firewire RAW - 18

19 root sysctl p MIRACLE LINUX V3.0 Red Hat Enterprsie Linux kernel.msgmnb = kernel.msgmni = 2878 kernel.sem = kernel.shmmax = fs.file-max = fs.aio-max-size = net.ipv4.ip_local_port_range = /etc/security/limits.conf * soft nproc 2047 * hard nproc * soft nofile 2047 * hard nofile /etc/pam.d/login session required /lib/security/pam_limits.so IP OS Ethernet/IP root ifconfig Linux eth0 eth1 Ethernet NIC eth0 eth1 IP inet.addr [root@oracle01 root]# ifconfig eth0 Link encap:ethernet HWaddr 00:50:8B:8F:34:9B inet addr: Bcast: Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:37439 errors:0 dropped:0 overruns:0 frame:0 TX packets:129 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen: RAC Firewire RAW - 19

20 RX bytes: (3.0 Mb) TX bytes:12758 (12.4 Kb) Interrupt:10 Base address:0x2400 Memory: eth1 Link encap:ethernet HWaddr 00:07:40:C7:4D:A8 inet addr: Bcast: Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:4 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:240 (240.0 b) Interrupt:4 Base address:0x7000 lo Link encap:local Loopback inet addr: Mask: UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) eth0 eth1 IP eth0 PublicLAN IP eth0 IP PublicLAN CRS oracle01 oracle02 eth eth oracle01 eth0 PublicLAN oracle02 PublicLAN eth1 /etc/modules.conf alias eth0 8139too alias eth1 3c59x - RAC Firewire RAW - 20

21 3COM NIC eth1 Intel NIC eth0 Linux OS NIC eth0 IP NIC ifconfig eth0/eth1 /etc/modules.conf /etc/sysconfig/network-scrips Linux ifcfg-eth0 ifcfg-eth1 ifcfg-eth0 DEVICE=eth0 BOOTPROTO=dhcp ONBOOT=yes TYPE=Ethernet ifcfg-eth1 DEVICE=eth1 ONBOOT=yes BOOTPROTO=static IPADDR= NETMASK= GATEWAY= ping ifconfig ping oracle02 oracle01 ping eth0 eth1 IP ping root]# ping PING ( ) 56(84) bytes of data. 64 bytes from : icmp_seq=0 ttl=64 time=0.297 ms 64 bytes from : icmp_seq=1 ttl=64 time=0.250 ms 64 bytes from : icmp_seq=2 ttl=64 time=0.252 ms 64 bytes from : icmp_seq=3 ttl=64 time=0.252 ms - RAC Firewire RAW - 21

22 /etc/hosts /etc/hosts Oracle Universal Installer( ) /etc/hosts /etc/hosts IP NIC IP localhost.localdomain localhost oracle01 localhost.localdomain localhost localhost.localdomain localhost oracle oracle oracle01-priv oracle02-priv oracle01-vip oracle02-vip IP IP Telnet FTP SSH IP Oracle IP VIP VIP IP RAC Ether LAN HUB Ether - RAC Firewire RAW - 22

23 HUB VIP IP Virtual IP Address RAC VIP RAC IP TCP KeepAlive VIP Oracle ping oracle01-vip ping root]# ping oracle01-priv PING oracle01-priv ( ) 56(84) bytes of data. 64 bytes from oracle01-priv ( ): icmp_seq=0 ttl=64 time=0.279 ms 64 bytes from oracle01-priv ( ): icmp_seq=1 ttl=64 time=0.262 ms 64 bytes from oracle01-priv ( ): icmp_seq=2 ttl=64 time=0.250 ms VIP DHCP VIP /etc/hosts DHCP VIP DHCP IP IP x DHCP VIP IP VIP IP VIP x.x VIP DHCP IP IP CRS root]# hostname - RAC Firewire RAW - 23

24 oracle01 root]# localdomain CRS /etc/sysconfig/network RSH SSH RAC RSH SSH RSH SSH RSH RSH oracle01 oracle01 oracle02 oracle01 oracle02 Rsh /etc/xinetd.d/rsh disable=yes disable=no service shell { socket_type wait user log_on_success log_on_failure server disable } ~ = stream = no = root += USERID += USERID = /usr/sbin/in.rshd = no service xinetd restart MIRACLE LINUX V3.0 xinetd OK - RAC Firewire RAW - 24

25 root]# service xinetd restart xinetd : [ ] xinetd : [ OK ] [root@oracle01 root]# FTP MIRACLE LINUX V3.0 SSH Ftp otn CD WinSCP3 SSH FTP FTP Proftp /etc/proftpd.conf <limit STOR> <limit STOR> DenyAll AllowAll - - <Limit STOR> DenyAll </Limit> - - <Limit STOR> AllowAll </Limit> chkconfig proftpd on #chkconfig proftpd on proftpd [root@oracle01 root]# service proftpd start Starting proftpd: [ OK ] [root@oracle01root]# - RAC Firewire RAW - 25

26 oracle01 oracle02 Firewire Firewire ohci1394/sbp2 ohci1394/sbp2 dmesg dmesg Fdisk fdisk l fdisk l Raw Raw Firewire Firewire kernel elorafw1.i686.rpm Rpm -Uvh ivh U I Firewire [root@oracle01 oracle]# rpm -ivh kernel elorafw1.i686.rpm Preparing... ########################################### [100%] 1:kernel ########################################### [100%] [root@oracle021oracle]# - RAC Firewire RAW - 26

27 /boot/grub/menu.lst Asianux ( ELorafw1) #boot=/dev/hda default=1 timeout=10 title Asianux ( ELorafw1) root (hd0,0) kernel /vmlinuz elorafw1 ro root=label=/ initrd /initrd elorafw1.img title Asianux ( AX) root (hd0,0) kernel /vmlinuz ax ro root=label=/ initrd /initrd ax.img Firewire ELorafw1 root uname root]# uname -a Linux oracle ELorafw1 #1 Thu Jun 10 14:30:40 PDT 2004 i686 i686 i386 GNU/Linux root]# Firewire lsmod root]# lsmod Module Size Used by Not tainted ide-cd (autoclean) cdrom (autoclean) [ide-cd] soundcore (autoclean) 8139too RAC Firewire RAW - 27

28 mii [8139too] crc [8139too] e sbp (unused) ieee [sbp2] floppy (autoclean) sg (autoclean) (unused) scsi_mod (autoclean) [sbp2 sg] microcode (autoclean) keybdev (unused) mousedev hid (unused) input [keybdev mousedev hid] usb-uhci (unused) usbcore [hid usb-uhci] ext jbd [ext3] [root@oracle01 root]# ieee1394 sbp2 Firewire sbp2 ieee1394 firewire ieee1394 sbp2 ohci1394 ohci1394 rmmod ohci1394 [root@oracle01 root]# rmmod sbp2 [root@oracle01 root]# [root@oracle01 root]# rmmod ieee1394 [root@oracle01 root]# - RAC Firewire RAW - 28

29 firewire SCSI Firewire SCSI SCSI SCSI ohci1394 sbp2 root]# root]# modprobe ohci1394 root]# root]# modprobe sbp2 root]# lsmod ohci1394 sbp2 root]# lsmod Module Size Used by Not tainted sbp (unused) ohci (unused) ieee [sbp2 ohci1394] ide-cd (autoclean) cdrom (autoclean) [ide-cd] soundcore (autoclean) 8139too mii [8139too] crc [8139too] e floppy (autoclean) sg (autoclean) (unused) scsi_mod (autoclean) [sbp2 sg] microcode (autoclean) keybdev (unused) mousedev hid (unused) input [keybdev mousedev hid] usb-uhci (unused) - RAC Firewire RAW - 29

30 usbcore [hid usb-uhci] ext jbd [ext3] dmesg dmesg ieee1394: sbp2: Maximum concurrent logins supported: 4 4 Firewire ohci1394: $Rev: 896 $ Ben Collins <bcollins@debian.org> PCI: Found IRQ 11 for device 00:0e.0 ohci1394_0: OHCI (PCI): IRQ=[11] MMIO=[ ff] Max Packet= [2048] ieee1394: Host added: Node[00:1023] GUID[ d] [Linux OHCI-1394] ieee1394: Device added: Node[01:1023] GUID[00d04b ] [NOVAC CO.,LTD ] scsi0 : SCSI emulation for IEEE-1394 SBP-2 Devices blk: queue d , I/O limit 4095Mb (mask 0xffffffff) ieee1394: sbp2: Query logins to SBP-2 device successful ieee1394: sbp2: Maximum concurrent logins supported: 4 ieee1394: sbp2: Number of active logins: 0 ieee1394: sbp2: Logged into SBP-2 device ieee1394: sbp2: Node[01:1023]: Max speed [S400] - Max payload [2048] Vendor: WDC WD40 Model: 0BB-00AUA1 Rev: 18.2 Type: Direct-Access ANSI SCSI revision: 06 blk: queue d , I/O limit 4095Mb (mask 0xffffffff) [root@oracle02 root]# OK fdisk /dev/sda fdisk /dev/sda fdisk l - RAC Firewire RAW - 30

31 fdisk root]# fdisk /dev/sda : 1) (. LILO) 2) OS (. DOS FDISK, OS/2 FDISK) (m ): fdisk OK dmesg 40021M sda sda1 sda5 sda4 fdisk Attached scsi disk sda at scsi0, channel 0, id 0, lun 0 SCSI device sda: byte hdwr sectors (40021 MB) sda: unknown partisions [root@oracle01 root]# sda Firewire fdisk dmesg Attached scsi disk sda at scsi0, channel 0, id 0, lun 0 SCSI device sda: byte hdwr sectors (40021 MB) sda: sda1 sda2 sda3 sda4 < sda5 sda6 sda7 sda8 sda9 sda10 sda11 sda12 sda13 sda 14 sda15 > [root@oracle01 root]# /dev/sda1 /dev/sda2 15 sda4 sda4 sda1~sda RAC Firewire RAW - 31

32 LVM (logical VloumeManager) Linux Linux LVM RAC fdisk /dev/sdx OS /dev/hda /dev/sda firewire SCSI /dev/sda Oracle REDO Linux LVM Logical Volume Manager 14 10g RAW RAW RAW SYSTEM /dev/sda1 /dev/raw/raw1 461M 481M SYSAUX /dev/sda2 /dev/raw/raw2 231M 313M USER /dev/sda3 /dev/raw/raw3 10M 125M UNDO 1 /dev/sda5 /dev/raw/raw5 48M 125M UNDO /dev/sda6 /dev/raw/raw6 48M 125M TEMP /dev/sda7 /dev/raw/raw7 25M 125M RDDO /dev/sda8 /dev/raw/raw8 11M 125M ( oracle01 ) REDO /dev/sda9 /dev/raw/raw9 11M 125M oracle01 RDDO /dev/sda10 /dev/raw/raw10 11M 125M ( oracle02 ) REDO /dev/sda11 /dev/raw/raw11 11M 125M - RAC Firewire RAW - 32

33 oracle02 /dev/sda12 /dev/raw/raw12 3M 125M 1 OCR /dev/sda13 /dev/raw/raw13 100M 125M /dev/sda14 /dev/raw/raw14 10M 125M /dev/sda15 /dev/raw/raw15 3M 125M 983M USER DBCA CreateDatabase /dev/hda fdisk /dev/sda fdisk n SYSTEM P SYSTEM 480M +480M [+100M] P [root@oracle01 etc]# fdisk /dev/sda : 1) (. LILO) 2) OS - RAC Firewire RAW - 33

34 (. DOS FDISK, OS/2 FDISK) (m ): n e p p (1-4) (1-4): 1 ( , 1): M + K ( , ): 60 (m ): n e p p (1-4) (1-4): 2 ( , 61): M + K ( , ): 99 (m ): n e p p (1-4) (1-4): 3 ( , 100): M + K ( , - RAC Firewire RAW - 34

35 24321): 115 (m ): n e e p (1-4) Selected partition 4 ( , 116): M + K ( , 24321): +1500M (m ): n ( , 116): M + K ( , 29 8): 131 (m ): n ( , 132): M + K ( , 29 8): 147 (m ): n ( , 148): M + K ( , 29 8): 163 (m ): n ( , 164): M + K ( , 29 8): RAC Firewire RAW - 35

36 (m ): n ( , 180): M + K ( , 29 8): 195 (m ): n ( , 196): M + K ( , 29 8): 211 (m ): n ( , 212): M + K ( , 29 8): 227 (m ): n ( , 228): M + K ( , 29 8): 243 (m ): p Disk /dev/sda: GB, bytes 255 heads, 63 sectors/track, cylinders Units = of * 512 = bytes ID /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda RAC Firewire RAW - 36

37 /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux (m ): n ( , 244): M + K ( , 29 8): 259 (m ): n ( , 260): M + K ( , 29 8): 275 (m ): n ( , 276): M + K ( , 29 8): 298 (m ): p Disk /dev/sda: GB, bytes 255 heads, 63 sectors/track, cylinders Units = of * 512 = bytes ID /dev/sda Linux - RAC Firewire RAW - 37

38 /dev/sda Linux /dev/sda Linux /dev/sda /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux (m ): w ioctl() [oracle@oracle01 oracle]$ [root@oracle02 root]# fdisk -l Disk /dev/sda: GB, bytes 255 heads, 63 sectors/track, cylinders Units = of * 512 = bytes ID /dev/sda Linux /dev/sda Linux - RAC Firewire RAW - 38

39 /dev/sda Linux /dev/sda /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux /dev/sda Linux Disk /dev/hda: 6448 MB, bytes 240 heads, 63 sectors/track, 833 cylinders Units = of * 512 = bytes ID /dev/hda1 * Linux /dev/hda Linux /dev/hda Linux [root@oracle02 root]# RAW SCSI OS RAW root #!/bin/sh raw /dev/raw/raw1 /dev/sda1 raw /dev/raw/raw2 /dev/sda2 raw /dev/raw/raw3 /dev/sda3 raw /dev/raw/raw5 /dev/sda5 raw /dev/raw/raw6 /dev/sda6 raw /dev/raw/raw7 /dev/sda7 - RAC Firewire RAW - 39

40 raw /dev/raw/raw8 /dev/sda8 raw /dev/raw/raw9 /dev/sda9 raw /dev/raw/raw10 /dev/sda10 raw /dev/raw/raw11 /dev/sda11 raw /dev/raw/raw12 /dev/sda12 raw /dev/raw/raw13 /dev/sda13 raw /dev/raw/raw14 /dev/sda14 raw /dev/raw/raw15 /dev/sda15 root]#./raw.sh /dev/raw/raw1: bound to major 8, minor 1 /dev/raw/raw2: bound to major 8, minor 2 /dev/raw/raw3: bound to major 8, minor 3 /dev/raw/raw5: bound to major 8, minor 5 /dev/raw/raw6: bound to major 8, minor 6 /dev/raw/raw7: bound to major 8, minor 7 /dev/raw/raw8: bound to major 8, minor 8 /dev/raw/raw9: bound to major 8, minor 9 /dev/raw/raw10: bound to major 8, minor 10 /dev/raw/raw11: bound to major 8, minor 11 /dev/raw/raw12: bound to major 8, minor 12 /dev/raw/raw13: bound to major 8, minor 13 /dev/raw/raw14: bound to major 8, minor 14 /dev/raw/raw15: bound to major 8, minor 15 [root@oracle02 root]# [root@oracle02 root]# raw qa /dev/raw/raw1: bound to major 8, minor 1 /dev/raw/raw2: bound to major 8, minor 2 /dev/raw/raw3: bound to major 8, minor 3 /dev/raw/raw5: bound to major 8, minor 5 /dev/raw/raw6: bound to major 8, minor 6 - RAC Firewire RAW - 40

41 /dev/raw/raw7: bound to major 8, minor 7 /dev/raw/raw8: bound to major 8, minor 8 /dev/raw/raw9: bound to major 8, minor 9 /dev/raw/raw10: bound to major 8, minor 10 /dev/raw/raw11: bound to major 8, minor 11 /dev/raw/raw12: bound to major 8, minor 12 /dev/raw/raw13: bound to major 8, minor 13 /dev/raw/raw14: bound to major 8, minor 14 /dev/raw/raw15: bound to major 8, minor 15 [root@oracle02 root]# RAW major minor RAW RAW dd dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1000 firewire DBCA RAW DBCA RAW _raw.conf orcl_raw.conf GUI root [root@oracle02 root]$ more orcl_raw.conf system=/dev/raw/raw1 sysaux=/dev/raw/raw2 users=/dev/raw/raw3 undotbs1=/dev/raw/raw5 undotbs2=/dev/raw/raw6 - RAC Firewire RAW - 41

42 temp=/dev/raw/raw7 redo1_1=/dev/raw/raw8 redo1_2=/dev/raw/raw9 redo2_1=/dev/raw/raw10 redo2_2=/dev/raw/raw11 control1=/dev/raw/raw12 control2=/dev/raw/raw15 dmesg Firewire fdisk fdisk fdisk l OS HW Firewire REMOVE Firewire HW Do Nothig REMOVE do nothing fdisk /dev/sda raw raw /dev/sdx TIPS G HDD 2G HDD orcl_raw.conf /dev/raw/raw3 /dev/raw/raw15 DBCA 14 control_files - RAC Firewire RAW - 42

43 /dev/sda4 HDD /de/raw/sda15 100M orcl_raw.conf /dev/raw/raw15 drop control_files RAW fdisk /dev/raw/raw15 /dev/raw/raw15 mkfs DBCA HDD DBCA Create database oinstall dba Root groupadd ID root]# groupadd -g 500 oinstall root]# groupadd -g 501 dba root]# /etc/group root]# more /etc/group root:x:0:root bin:x:1:root,bin,daemon - RAC Firewire RAW - 43

44 oinstall:x:500: dba:x:501: root]# oinstall dba oinstall Oracle dba Oracle useradd u ID g G d [root@oracle01 root]#useradd oracle u 500 g oinstall G dba d /home/oracle [root@oracle01 root]# passwd oracle Changing password for user oracle. New password: BAD PASSWORD: it is based on a dictionary word Retype new password: passwd: all authentication tokens updated successfully. [root@oracle01 root]# /etc/passwd oracle [oracle@oracle01 oracle]$ pwd /home/oracle [oracle@oracle01 oracle]$ [oracle@oracle01 oracle]$ more /etc/passwd root:x:0:0:root:/root:/bin/bash bin:x:1:1:bin:/bin:/sbin/nologin squid:x:23:23::/var/spool/squid:/sbin/nologin - RAC Firewire RAW - 44

45 oracle:x:500:500::/home/oracle:/bin/bash oracle]$ su oracle Pwd id root]# su - oracle [oracle@oracle01 oracle]$ pwd /home/oracle [oracle@oracle01 oracle]$ id uid=500(oracle) gid=500(oinstall) =500(oinstall),501(dba) [oracle@oracle01 oracle]$ oracle01 oracle02 oracle.rhosts [oracle@oracle01 oracle]$ more.rhosts oracle01 oracle oracle02 oracle oracle01 oracle02 oracle [oracle@oracle02 oracle]$ rsh oracle01 date connect to address : Connection refused Trying krb4 rsh... connect to address : Connection refused trying normal rsh (/usr/bin/rsh) Mon Jul 26 20:42:19 JST 2004 [oracle@oracle02 oracle]$ Rsh normal rsh.rhosts rsh rsh xinetd - RAC Firewire RAW - 45

46 rsh RAW RAW OS raw root]# chown oracle:oinstall /dev/raw/raw[1-9] root]# chmod 660 /dev/raw/raw[1-9] root]# chown oracle:oinstall /dev/raw/raw[1][0-5] root]# chmod 660 /dev/raw/raw[1][0-5] ohci1394 raw modprobe ohci1394 ohci1394 /etc/rc.d/rc5.d S53fw1394 #!/bin/sh echo "Starting Firewire" /sbin/modprobe -v ohci1394 /sbin/modprobe-v sbp2 chmod rc5.d]# chmod +x S53fw1394 rc5.d]# ls -l S53fw1394 -rwxr-xr-x 1 root root :51 S53fw1394 /etc/sysconfig/rawdevices # raw device bindings # format: <rawdev> <major> <minor> # <rawdev> <blockdev> # example: /dev/raw/raw1 /dev/sda1 # #dev/raw/raw2 8 5 /dev/raw/raw1 /dev/sda1 /dev/raw/raw2 /dev/sda2 - RAC Firewire RAW - 46

47 /dev/raw/raw3 /dev/sda3 /dev/raw/raw5 /dev/sda5 /dev/raw/raw6 /dev/sda6 /dev/raw/raw7 /dev/sda7 /dev/raw/raw8 /dev/sda8 /dev/raw/raw9 /dev/sda9 /dev/raw/raw10 /dev/sda10 /dev/raw/raw11 /dev/sda11 /dev/raw/raw12 /dev/sda12 /dev/raw/raw13 /dev/sda13 /dev/raw/raw14 /dev/sda14 /dev/raw/raw15/dev/sda15 Oracle.bash_profile export ORACLE_BASE=$HOME/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db export ORA_CRS_HOME=$ORACLE_BASE/product/10.1.0/crs export CH=$ORA_CRS_HOME export LD_LIBRARY_PATH=.:$ORACLE_HOME/lib:$LD_LIBRARY_PATH export NLS_LANG=Japanese_Japan.JA16EUC export LANG=ja_JP #PATH=$PATH:$HOME/bin PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin export PATH unset USERNAME - RAC Firewire RAW - 47

48 alias cdo='cd $ORACLE_HOME' alias cds='cd $ORA_CRS_HOME' Oracle Database 10g ORACLE_SID RAC XX01 XX02 SQL*Plus ORACLE_SID xhost + root su oracle #xhost + access control disabled, clients can connect from any host OS CRS CRS /etc/hosts rsh ssh hostname /etc/sysconfig/network hostname /etc/hosts ifconfig eth IP CRS - RAC Firewire RAW - 48

49 CRS CRS (oracle01/oracle02) (oracle01) oracle01 oracle02 orainstroot.sh orainstroot.sh 2 orainstroot.sh 2 oracle02 - RAC Firewire RAW - 49

50 root.sh root.sh oracle01 OTN-J CRS DB CRS Disk1 DB CRS CRS $mkdir CRS $cp ship.crs.cpio.gz CRS $cd CRS $gzip d ship.crs.cpio.gz $cpio idmv < ship.crs.cpio Disk1 runinstaller CD-ROM OUI oracle01 X-Window CRS runinstaller OUI $ cd / $/mnt/cdrom/runinstaller oracle01 [ ] - RAC Firewire RAW - 50

51 Oracle Database 10g ( ) PSR CRS VIP R mii-tool Patch Set Release VIP p70 Oracle Oracle Universal Installer runinstaller oracle01 [oinstall] - RAC Firewire RAW - 51

52 orainstroot.sh oracle01 [ ] [root@oracle01 oracle]# cd /home/oracle/app/oracle/orainventory - RAC Firewire RAW - 52

53 orainventory]# ls orainstroot.sh orainventory]# orainventory]#./orainstroot.sh Oracle (/etc/orainst.loc) : /home/oracle/app/oracle/orainventory : oinstall. [root@oracle01 orainventory]# /etc/orainst.loc oracle01 CRS ORA_CRS_HOME ORACLE_HOME oracle01 [ ] - RAC Firewire RAW - 53

54 oracle01 /etc/hosts /etc/hosts rsh rsh xinetd xinetd oracle01 RAC [ - RAC Firewire RAW - 54

55 ] [Do not Use] [Private] [Public] IP Private Public eth0 [Public] eth1 [Private] OCR oracle01 OCR /dev/raw/raw13 OCR - RAC Firewire RAW - 55

56 oracle01 /dev/raw/raw14 orainstroot.sh oracle01 oracle02 root orainstroot.sh orainventory]#./orainstroot.sh Oracle (/etc/orainst.loc) - RAC Firewire RAW - 56

57 : /home/oracle/app/oracle/orainventory : oinstall. [root@oracle02 orainventory]# [ ] oracle01 OK [ ] [ ] - RAC Firewire RAW - 57

58 Cluster Ready Services [ ] CD-ROM oracle01 CRS root.sh oracle01 oracle02 100% Root root.sh oracle01 root.sh oracle01 - RAC Firewire RAW - 58

59 oracle01 oracle02 oracle01 root.sh oracle02 root.sh Root ORA_CRS_HOME root.sh [Expecting the CRS daemons to be up within 600 seconds] crs]#./root.sh Checking to see if Oracle CRS stack is already up... /etc/oracle does not exist. Creating it now. Setting the permissions on OCR backup directory Oracle Cluster Registry configuration upgraded successfully WARNING: directory '/home/oracle/app/oracle/product/10.1.0' is not owned by root WARNING: directory '/home/oracle/app/oracle/product' is not owned by root WARNING: directory '/home/oracle/app/oracle' is not owned by root WARNING: directory '/home/oracle/app' is not owned by root WARNING: directory '/home/oracle' is not owned by root assigning default hostname oracle01 for node 1. assigning default hostname oracle02 for node 2. Successfully accumulated necessary OCR keys. Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR= node <nodenumber>: <nodename> <private interconnect name> <hostname> node 1: oracle01 oracle01-priv oracle01 node 2: oracle02 oracle02-priv oracle02 Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Now formatting voting device: /dev/raw/raw14 Successful in setting block0 for voting disk. Format complete. Adding daemons to inittab Preparing Oracle Cluster Ready Services (CRS): Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. oracle01 CSS is inactive on these nodes. - RAC Firewire RAW - 59

60 oracle02 Local node checking complete. Run root.sh on remaining nodes to start CRS daemons. crs]# oracle02 root.sh oracle02 root.sh crs]# root.sh -bash: root.sh: command not found crs]#./root.sh Checking to see if Oracle CRS stack is already up... /etc/oracle does not exist. Creating it now. Setting the permissions on OCR backup directory Oracle Cluster Registry configuration upgraded successfully WARNING: directory '/home/oracle/app/oracle/product/10.1.0' is not owned by root WARNING: directory '/home/oracle/app/oracle/product' is not owned by root WARNING: directory '/home/oracle/app/oracle' is not owned by root WARNING: directory '/home/oracle/app' is not owned by root WARNING: directory '/home/oracle' is not owned by root clscfg: EXISTING configuration version 2 detected. clscfg: version 2 is 10G Release 1. assigning default hostname oracle01 for node 1. assigning default hostname oracle02 for node 2. Successfully accumulated necessary OCR keys. Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR= node <nodenumber>: <nodename> <private interconnect name> <hostname> node 1: oracle01 oracle01-priv oracle01 node 2: oracle02 oracle02-priv oracle02 clscfg: Arguments check out successfully. NO KEYS WERE WRITTEN. Supply -force parameter to override. -force is destructive and will destroy any previous cluster configuration. Oracle Cluster Registry for cluster has already been initialized Adding daemons to inittab - RAC Firewire RAW - 60

61 Preparing Oracle Cluster Ready Services (CRS): Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. oracle01 oracle02 CSS is active on all nodes. Waiting for the Oracle CRSD and EVMD to start Oracle CRS stack installed and running under init(1m) crs]# CRS CSS is active on these nodes. oracle01 CSS is inactive on these nodes. oracle02 Local node checking complete. CSS is active on these nodes. Expecting the CRS daemons to be up within 600 seconds. CRS /etc/hosts IP root.sh root.sh cp /etc/inittab.orig /etc/inittab CRS CRS /etc Oracle #rm r /etc/ora* Oracle Oracle $rm r app CRS Miraclelinux30 rm rm i - RAC Firewire RAW - 61

62 rm -f /etc/init.d/init.cssd rm -f /etc/init.d/init.crs rm -f /etc/init.d/init.crsd rm -f /etc/init.d/init.evmd rm -f /etc/rc2.d/k96init.crs rm -f /etc/rc2.d/s96init.crs rm -f /etc/rc3.d/k96init.crs rm -f /etc/rc3.d/s96init.crs rm -f /etc/rc5.d/k96init.crs rm -f /etc/rc5.d/s96init.crs rm -Rf /etc/oracle/scls_scr rm -f /etc/inittab.crs cp /etc/inittab.orig /etc/inittab OCR RAW CRS root root]# chown oracle:oinstall /dev/raw/raw13 root]# chmod 660 /dev/raw/raw13 CRS OS End CSS is active on these nodes. partner3 CSS is active on all nodes. CSS Waiting for the Oracle CRSD and EVMD to start CRS EVM CRS DBCA DB VIP Create Database SQL*Plus DB RAC CRS EVM CRS EVM CRS root.sh oracle01 oracle02 root.sh CRS ps elf /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin - RAC Firewire RAW - 62

63 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin 3 OK [root@oracle01 crs]# ps -ef grep oracle root Jul26? 00:00:00 sshd: oracle [priv] oracle Jul26? 00:00:00 sshd: oracle@pts/0 oracle Jul26 pts/0 00:00:00 -bash root :35? 00:00:00 sshd: oracle [priv] oracle :35? 00:00:00 sshd: oracle@notty oracle :35? 00:00:00 /usr/libexec/openssh/sftp-server root :20 pts/2 00:00:00 su - oracle oracle :20 pts/2 00:00:00 -bash oracle :43 pts/2 00:02:13 /tmp/orainstall _ PM/jre/1.4.2/bin/java -Doracle.installer.library_loc=/tmp/OraInstall _ PM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall _ PM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_locat root :00? 00:00:00 /bin/su oracle -c exec /home/ora cle/app/oracle/product/10.1.0/crs/bin/evmd root :00? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /bin/su oracle -c /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd exit 137 oracle :01? 00:00:00 bash -c /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd exit 137 oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin - RAC Firewire RAW - 63

64 oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/ /crs/bin/evmlogger.bin -o /home/oracle/app/oracle/product/10.1.0/crs/evm/l og/evmlogger.info -l /home/oracle/app/oracle/product/10.1.0/crs/evm/log/evmlogge r.log oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/ocssd.bin oracle :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/evmd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin - RAC Firewire RAW - 64

65 root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :01? 00:00:00 /home/oracle/app/oracle/product/10.1.0/crs/bin/crsd.bin root :02 pts/0 00:00:00 grep oracle [root@oracle01 crs]# - RAC Firewire RAW - 65

66 CRS CSS EVM OK CRS CRS CRS - RAC Firewire RAW - 66

67 Oracle Database 10g Oracle Universal Installer( ) SPFILE SPFILE RAW OS DBCA DBCA CRS (oracle01/oracle02) (oracle01) oracle01 oracle02 oracle02 - RAC Firewire RAW - 67

68 root.sh VIPCA VIP root.sh runinstaller oracle01 oracle01 - RAC Firewire RAW - 68

69 oracle01 [ ] ORACLE_HOME oracle01 CRS OUI [ ] - RAC Firewire RAW - 69

70 oracle01 Enterprise Edition [ ] - RAC Firewire RAW - 70

71 oracle01 DBCA DBCA [ ] Firewire RAW OUI SPFILE SPFILE SIFPLE oracle01 [ ] RAC [ ] [ ] - RAC Firewire RAW - 71

72 [ ] oracle01 - RAC Firewire RAW - 72

73 oracle01 oracle02 ORACLE_HOME root root.sh oracle01 root.sh root.sh [Enter the full pathname of the local bin directory: [/usr/local/bin]:] Running Oracle10 root.sh script... nthe following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/app/oracle/product/10.1.0/db Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin OK [Now product-specific root actions will be performed.] VIPCA VirtualIP Configuration Assistant Copying dbhome to /usr/local/bin... Copying oraenv to /usr/local/bin... Copying coraenv to /usr/local/bin... ncreating /etc/oratab file... Adding entry to /etc/oratab file... - RAC Firewire RAW - 73

74 Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Warning: Cannot convert string "-watanabe-mincho-medium-r-normal--*-140-*-*-c-*-jisx " to type VIP VIPCA VIP oracle01 VIP eth0 LAN eth1 LAN eth0 - RAC Firewire RAW - 74

75 VIP oracle01 VIP /etc/hosts VIP /etc/hosts VIP IP [IP ] - RAC Firewire RAW - 75

76 oracle01 VIPCA VIP IP [ ] [ ] VIP ~ oracle01 oracle01 [ ] - RAC Firewire RAW - 76

77 Oracle02 root.sh oracle02 root.sh Root ORACLE_HOME root.sh CRS resources are already VIP VIPCA (oracle01) [OK] - RAC Firewire RAW - 77

78 VIP VIP ONS Ps oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d oracle Sep21? 00:00:00 /home/oracle/app/oracle/product/10.1.0/db/opmn/bin/ons -d ifconfig eth0:1 eth0 Link encap:ethernet HWaddr 00:02:A5:33:AD:A2 inet addr: Bcast: Mask: RAC Firewire RAW - 78

79 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets: errors:0 dropped:0 overruns:0 frame:0 TX packets: errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes: ( Mb) TX bytes: (30.8 Mb) Interrupt:10 Base address:0x1480 Memory: eth0:1 Link encap:ethernet HWaddr 00:02:A5:33:AD:A2 inet addr: Bcast: Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:6554 errors:0 dropped:0 overruns:0 frame:0 TX packets:6446 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes: (3.2 Mb) TX bytes: (1.9 Mb) Interrupt:10 Base address:0x1480 Memory: eth1 Link encap:ethernet HWaddr 00:0D:0B:19:F3:2C inet addr: Bcast: Mask: UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:6554 errors:0 dropped:0 overruns:0 frame:0 TX packets:6446 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes: (3.2 Mb) TX bytes: (1.9 Mb) Interrupt:5 lo Link encap:local Loopback inet addr: Mask: UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:15693 errors:0 dropped:0 overruns:0 frame:0 TX packets:15693 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes: (478.5 Kb) TX bytes: (478.5 Kb) - RAC Firewire RAW - 79

80 DBCA oracle01 GUI Database Configuration Assistant DBCA CUI Linux Oracle Linux Oracale RAC OS Logical Volume Manager(LVM) OCFS Oraacle Cluseter File System ASM RAW RAW Linux 14 Oracle Database 10g RAC DBCA 14 RAW 12 DBCA DBCA User DBCA DBCA $dbca dbca DBCA - RAC Firewire RAW - 80

81 [ ] [Oracle Real Application Clusters] DBCA [ ] - RAC Firewire RAW - 81

82 oracle01 oracle02 RAC oracle01 oracle02 [ ] - RAC Firewire RAW - 82

83 db_name SID ORACLE_SID SID SID SID01 SID02 ORACLE_SID RAC SID [orcl] SID [rac0] - RAC Firewire RAW - 83

84 Change_on_install Manager DBSNMP SYSMAN [ ] [ASM] [RAW ] RAW [RAW ] [RAW ] [ ] - RAC Firewire RAW - 84

85 RAW OS RAW orcl_raw.conf [ ] - RAC Firewire RAW - 85

86 Oracle Database 10g OS ASM USER - RAC Firewire RAW - 86

87 Oracle RAC 10g RAC [ ] [RACTEST] - RAC Firewire RAW - 87

88 [ ] [ ] [ ] [ ] [TAF ] [ ] Oracle Database 10g - RAC Firewire RAW - 88

89 [ PFILE ] [ SPFILE ] PFILE SPFILE RAW RAW SPFILE orcl_raw.conf - RAC Firewire RAW - 89

90 [ ] [ ] [REDO ] REDO - RAC Firewire RAW - 90

91 [ ] [ ] [OK] - RAC Firewire RAW - 91

92 - RAC Firewire RAW - 92

93 URL [OK] - RAC Firewire RAW - 93

94 [OK] RAC DBCA DBCA DBCA control_files /dev/raw/raw15 mkfs oracle01 oracle02 mkfs - RAC Firewire RAW - 94

95 root]# mkfs /dev/sda15 mke2fs 1.32 (09-Nov-2002) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) inodes, blocks blocks (5.00%) reserved for the super user First data block=0 18 block groups blocks per group, fragments per group inodes per group Superblock backups stored on blocks: 32768, 98304, , , Writing inode tables: done Writing superblocks and filesystem accounting information: done This filesystem will be automatically checked every 27 mounts or 180 days, whichever comes first. Use tune2fs -c or -i to override. root]# RAC - RAC Firewire RAW - 95

96 DBCA SQL*Plus DBCA oracle01 oracle02 $ORACLE_HOME/dbs initrac01.ora initrac02.ora SGA 512M SGA db_block_size M java_pool_size 1024 pga_aggregate_target M large_pool_size M shared_pool_size M remote_login_passwordfile initrac01.ora background_dump_dest='/home/oracle/app/oracle/admin/ora101/bdump' user_dump_dest='/home/oracle/app/oracle/admin/ora101/udump' compatible=' ' control_files='/dev/raw/raw12 core_dump_dest='/home/oracle/app/oracle/admin/ora101/cdump' db_block_size=8192 db_cache_size= db_domain='' db_file_multiblock_read_count=16 db_name='ora101' db_recovery_file_dest='/home/oracle/app/oracle/flash_recovery_area' db_recovery_file_dest_size= dispatchers='(protocol=tcp) (SERVICE=rac01XDB)' java_pool_size= job_queue_processes=10 large_pool_size= open_cursors=300 - RAC Firewire RAW - 96

97 pga_aggregate_target= processes=250 remote_listener='listeners_ora101' #remote_login_passwordfile='exclusive' shared_pool_size= sort_area_size=65536 cluster_database_instances=2 cluster_database=true rac01.instance_number=1 rac01.thread=1 undo_management='auto' rac01.undo_tablespace='undotbs1' initrac02.ora background_dump_dest='/home/oracle/app/oracle/admin/ora101/bdump' user_dump_dest='/home/oracle/app/oracle/admin/ora101/udump' compatible=' ' control_files='/dev/raw/raw12' core_dump_dest='/home/oracle/app/oracle/admin/ora101/cdump' db_block_size=8192 db_cache_size= db_domain='' db_file_multiblock_read_count=16 db_name='ora101' db_recovery_file_dest='/home/oracle/app/oracle/flash_recovery_area' db_recovery_file_dest_size= dispatchers='(protocol=tcp) (SERVICE=rac01XDB)' java_pool_size= job_queue_processes=10 large_pool_size= open_cursors=300 pga_aggregate_target= processes=250 remote_listener='listeners_ora101' #remote_login_passwordfile='exclusive' shared_pool_size= sort_area_size=65536 cluster_database_instances=2 cluster_database=true rac02.thread=2 rac02.instance_number=2 undo_management='auto' rac02.undo_tablespace='undotbs2' RAC control_files cluster_database_instances cluster_database thread instance_number undo_tablespace - RAC Firewire RAW - 97

98 control_files control_files /dev/raw/raw12 DBCA cluster_database_instances cluster_database_instances RAC [2] cluster_database RAC [true] True false instance_number RAC [1] [2] thread REDO instance_number undo_tablespace UNDO UNDO undo_tablespace UNDO UNDO $mkdir p home/oracle/app/oracle/admin/ora101/bdump $mkdir p home/oracle/app/oracle/admin/ora101/udump $mkdir p home/oracle/app/oracle/admin/ora101/cdump - RAC Firewire RAW - 98