Oracle Real Application Clusters 10g 設定手順書

Transcription

1 ~ RAC ~ Oracle Real Application Clusters 10g VMware ASM Linux

2 RAC 2002 Oracle9i Real Application Clusters (RAC) RAC Oracle10g Standard Edition(SE) RAC RAC RAC PC1 RAC RAC RAC RAC PC RAC RAC PC RAC Oracle Real Application Clusters10g VMware ASM (for Windows) Oracle Real Application Clusters10g Firewire ASM (for Linux) Oracle Real Application Clusters10g Firewire RAW ( for Linux)) Oracle Real Application Clusters10g NAS (for Linux) Oracle Real Application Clusters10g NAS (for Linux) Oracle Real Application Clusters10g 1 RAC ASM (for Linux) Oracle Real Application Clusters10g 1 RAC File system (for Linux) RAC Life Oracle Real Application Clusters 10g Firewire ASM Linux 2

3 VMware 2 RAC RAC NIC VMware 1 PC RAC PC1 RAC RAC VMware Miracle Linux R3.0 (ML3.0) ML3.0 Oracle OS Oracle RAC Linux ML3.0 Oracle hosts OS RAC 2 VMware 2 RAC Oracle Real Application Clusters 10g Firewire ASM Linux 3

4 RAC OCFS RAW Automatic Storage Management (ASM) Standard Edition RAC ASM ASM Oracle ASM VMware RAC ASM Network Address Translation(NAT) RAC RAC IP DHCP IP (DNS DHCPd ) RAC VMware NAT RAC RAC RAC Oracle Real Application Clusters 10g Firewire ASM Linux 4

5 RAC 1 VMware RAC ASM 2 IP VMware 3 4 VMware 5 6 RAC OS VMware 7 Oracle VMware Oracle Real Application Clusters 10g Firewire ASM Linux 5

6 8 CRS 8 Oracle 9 CRS RAC 10 CRS Cluster Ready Service (CRS) 11 Oracle RAC DB 12 DB RAC DB ASM Oracle Real Application Clusters 10g Firewire ASM Linux 6

7 VMware Miracle Linux Oracle ( ) Oracle Oracle Oracle VMware OS VMware Oracle VMware OS Oracle VMware OS Oracle Oracle DNS Oracle10g RAC IP DNS /etc/hosts DNS DNS Miracle VMware OS Miracle Linux R3.0 Miracle Linux VMware RAC VMware RAC RAC Oracle Real Application Clusters 10g Firewire ASM Linux 7

8 RAC10g Cluster Ready Service (CRS) 11 Automatic Storage Management (ASM) 13 VMware VMware RAC 15 VMware RAC VMware OS 33 VMware X 51 Oracle Real Application Clusters 10g Firewire ASM Linux 8

9 8 CRS 52 OS RAW 63 RAW CRS Oracle DB 94 Oracle Real Application Clusters 10g Firewire ASM Linux 9

10 1 Oracle Cluster Ready Services (CRS) Oracle Database 10g RAC Cluster Ready Services (CRS) CRS Oracle CRS CRS CRS CRS CRS CRS Oracle CRS Service RAC Instance Listener GSD ON (ASM) Virtual IP Address Service RAC Instance Listener GSD ON (ASM) CRS EVM+CRSD+CSSD CRS CRS EVM Cluster Ready Services Cluster Sync. Services(CSS) Virtual IP Address Cluster Ready Services EVM Cluster Sync. Services(CSS) CRSD CRS O/S Kernel Hardware CRS Oracle Cluster Registry Data Voting Disk O/S Kernel Hardware CSSD Voting Disk CRS CRS Oracle Oracle Cluster Registry(OCR) OCR VIP RAC CRS 100MB ASM OCR ASM Oracle Real Application Clusters 10g Firewire ASM Linux 10

11 Voting Disk( ) Voting Disk Voting Disk 20MB ASM Voting Disk ASM Virtual IP Address (VIP) RAC VIP IP TCP Keep Alive Oracle Real Application Clusters 10g Firewire ASM Linux 11

12 Automatic Storage Management (ASM) ASM Oracle Oracle Database 10g Oracle ASM ASM RAC RAW ASM Oracle SAME SAME Stripe And Mirror Everything Oracle RAC ASM Node1 Node2 DB DB ASM ASM Disk Group1 Disk Group2 Disk GroupN ASM ASM Oracle DB SGA RAC ASM RAC ASM RAC Disk Group ASM / Disk Group Disk Group Disk Group * ASM Redo SP OCR Voting Disk Oracle Real Application Clusters 10g Firewire ASM Linux 12

13 VMware VMware VMware VMware OS(Host OS) OS(Guest OS) Guest OS( ) Host OS Guest OS VMware Win AP Win AP Word Host OS (Windows) X86 HW( ) Bind Send Mail Oracle Tomcat Guest OS Guest OS Guest OS Win AP VMware Apache CPU OS CPU Guest OS Host OS OS CPU Host OS CPU Memory Host OS OS Network NIC NIC NIC NIC 1 NIC NAT DHCP Disk Guest OS Host OS Guest OS Host OS Oracle Real Application Clusters 10g Firewire ASM Linux 13

14 2 VMware RAC Oracle IP VMware DHCP IP VMware NAT Guest OS (Internet ) ( NAT ) DNS Internet Eth0 Public Hostname: console.jp.oracle.com (Guest OS: Linux) Hostname: xxx.jp.oracle.com Eth0 LAN DHCP VMnet8 Public GW VMnet8 Public NATSwitch /24 Office PC (Host OS: Windows) Hostname: oracle01.jp.oracle.com VIP-name: oracle01-vip.jp.oracle.com Private-name: oracle01-priv.jp.oracle.com Eth0 Public NIC Eth0:1 public VIP Eth1 Private VMnet7 Private Switch /24 DB Server (Guest OS: Linux) Hostname: oracle02.jp.oracle.com VIP-name: oracle02-vip.jp.oracle.com Private-name: oracle02-priv.jp.oracle.com Eth1 Private Eth0 Public NIC Eth0:1 public VIP DB Server (Guest OS: Linux) Public DB ( /24) Eth0 IP Eth0:1 Oracle (VMware ) VIP Eth0 NIC VIP IP Eth0 Eth0 Eth0:1 VMware NAT VMnet8 VMnet8 NIC Public Oracle Real Application Clusters 10g Firewire ASM Linux 14

15 Private RAC Oracle VMnet7 Eth0:1 NIC Eth0 1 Eth0 Eth1 2 NIC Eth0:1 Oracle HOST OS LAN :x.x.x Eth0 : x.x.x.x ( ) NAT Public Switch VM8: /24 Gateway VM8: /24 *NAT HOST OS Public Eth0 : console.jp.oracle.com IP: /24*VM8 GW: DNS: LAN DNS Oracle Server1 Public Eth0 : Oracle01.jp.oracle.com IP: /24 * VMnet8 Public(VIP) Eth0:1 : Oracle01-vip.jp.oracle.com IP: * VMnet 8 Private Eth1 : Oracle01-priv.jp.oracle.com IP: * VMnet 7 GW: DNS: LAN DNS Oracle Server2 Public Eth0 : Oracle02.jp.oracle.com IP: /24 * VMnet 8 Public(VIP) Eth0:1 : Oracle02-vip.jp.oracle.com IP: * VMnet 8 Private Eth1 : Oracle02-priv.jp.oracle.com IP: * VMnet 7 GW: DNS: LAN DNS DNS IP LAN DNS Oracle Real Application Clusters 10g Firewire ASM Linux 15

16 VMware RAC PC PC PC : Dell Latitude D600 CPU: Pentium M 1600MHz Memory: 1024MB Disk: 60GB OS: Windows2000 SP4 : 1024 * 768 PC MB PC SCSI sda 200MB SCSI sdb 200MB SCSI sdc 3GB SCS sdd 3GB Eth0 Eth0 Eth1 SCSI Eth0 Eth1 SCSI Console CPU: Pentium M 1600MHz Memory: 128MB Disk: 8GB Oracle01 CPU: Pentium M 1600MHz Memory: 320MB Disk: 8GB(OS/Oracle Bin) Oracle02 CPU: Pentium M 1600MHz Memory: 320MB Disk: 8GB(OS/Oracle Bin) Win AP Win AP Word Eth0 Eth1 Guest OS: ML3.0 Win AP VMware Guest OS: ML3.0 Guest OS: ML3.0 Host OS: Windows2000SP4 Memory: 256MB Disk: 60GB ( VMware ) X86 HW CPU: Pentium M 1600MHz Memory: 1024MB Disk: 60GB Oracle Real Application Clusters 10g Firewire ASM Linux 16

17 CPU Host Guest CPU CPU Memory Host Guest VMware RAC 1024MB : 1024MB Host OS: 256MB Console: 128MB Oracle01: 320MB Oracle02: 320MB Disk Host OS 30.4GB Console: 8GB *Linux OS Oracle01: 8GB *Linux OS Oracle Oracle02: 8GB *Linux OS Oracle : 6.4GB DB : 3GB*2 CRS : 200MB Voting : 200MB Oracle Real Application Clusters 10g Firewire ASM Linux 17

18 Host OS Guest OS1 Guest OS2 Guest OS3 Public xxx.jp.oracle.com console.jp.oracle.com oracle01.jp.oracle.com oracle02.jp.oracle.com Eth0 Public IP DHCP / / /24 VIP N/A N/A oracle01-vip.jp.oracle.com oracle02-vip.jp.oracle.com Eth0:1 VIP N/A N/A / /24 Private N/A N/A oracle01-priv.jp.oracle.com oracle02-priv.jp.oracle.com Eth1 Private IP N/A N/A / /24 Gateway / DNS LAN DNS LAN DNS LAN DNS LAN DNS NAT N/A N/A N/A Pentium M 1600MHz CPU Memory 1024GB 256MB 128MB 320MB 320MB 60GB 60GB 8GB 8GB 8GB Disk sda N/A N/A 200MB sdb N/A N/A 200MB sdc N/A N/A 3GB sdd N/A N/A 3GB Oracle Real Application Clusters 10g Firewire ASM Linux 18

19 3 3 Oracle Real Application Clusters 10g Firewire ASM Linux 19

20 Host OS D D D: VMware VMware VMware D: VMware console Console D: VMware oracle01 Oracle01 D: VMware oracle02 Oracle02 D: VMware storage RAC D: VMware share VMware Host OS Guest OS Oracle VMTools VMTools D: VMware iso VMware iso CD iso Miracle Linux Oracle Real Application Clusters 10g Firewire ASM Linux 20

21 3 VMware Workstation MIRACLE LINUX V3.0 - Asianux Inside Oracle Database 10g Release 1 (10.1.0) for Linux VMware VMware Networld ( VMware 1.1. URL VMware Register Oracle Real Application Clusters 10g Firewire ASM Linux 21

22 1.2. Product Host Platform Windows Continue Here Yes 1.4. Binary.exe D: VMware VMware Oracle Real Application Clusters 10g Firewire ASM Linux 22

23 2. Miracle Linux R3.0 Miracle Linux R3.0 OTN OTN OTN 2.1. URL MIRACLE LINUX V3.0 Asianux Inside ISO Disk1 Disk2 D: VMware iso Miracle Linux Oracle Real Application Clusters 10g Firewire ASM Linux 23

24 3. Oracle Oracle OTN OTN OTN 3.1. URL Oracle Database 10g Release 1 (10.1.0) for Linux x OTN Oracle 3.2. Database Oracle Cluster Ready Services 2 D: VMware share CPIO.GZIP Linux Oracle Real Application Clusters 10g Firewire ASM Linux 24

25 VMware D:VMware VMware-workstation-4.5.XXXX.exe VMware 1. D:VMware VMware-workstation-4.5.XXXX.exe C: Program Files VMware VMware Workstation 2. CD-ROM (Y) ( ) Oracle Real Application Clusters 10g Firewire ASM Linux 25

26 3. (N) VMnet1 VMnet8 Windows VMnet1 VMnet1 VMnet8 NAT VMnet1 VMnet8 Windows NIC NAT DHCP NAT DHCP Windows DHCP VMware Oracle Real Application Clusters 10g Firewire ASM Linux 26

27 1. NIC VMnet1 / VMnet1 VMware DHCP / VMwareDHCPServer 2. OS NAT Switch (VMnet8) NAT VMnet8 VMnet8 (TCP/IP) IP DNS IP : : Oracle Real Application Clusters 10g Firewire ASM Linux 27

28 3. VMware VMnet VMware 3.1. VMware 3.2. VMware NAT Switch(VMnet8 *Public ) VMnet8 DHCP NAT IP : : VMnet8 NAT NAT OK NAT NAT Oracle Real Application Clusters 10g Firewire ASM Linux 28

29 3.3. VMnet7 (Private Switch) VMnet7 OK IP : : DHCP DHCP DHCP VMnet1 VMnet8 DHCP Windows DHCP OS VMnet1 VMnet8 DHCP OK VMnet Public Private NAT Oracle Real Application Clusters 10g Firewire ASM Linux 29

30 Linux Red Hat Enterprise Linux 3 console console D: VMware console Oracle Real Application Clusters 10g Firewire ASM Linux 30

31 MB 320MB NAT NIC VMnet I/O VMware-tools Buslogic Buslogic IDE 2.4. OS Oracle Database 8.0GB VMware Windows D: VMware console console.vmdk Oracle Real Application Clusters 10g Firewire ASM Linux 31

32 5 OS Miracle Linux OS Guest OS Host OS VMware OS Guest OS Guest OS Guest OS OS Ctrl+Alt Guest OS 1. CD VMware CD-ROM ISO CD-ROM Miracle Linux ISO console CD-ROM1(IDE 1.0) ISO D: VMware iso Linux ISO (disk1.iso) OK 2. OS 2.1. BIOS Boot GUI Oracle Real Application Clusters 10g Firewire ASM Linux 32

33 2.2. Welcome 2.3. Oracle Real Application Clusters 10g Firewire ASM Linux 33

34 2.4. eth0 DHCP IP OK console.jp.oracle.com DNS LAN DNS 2.5. root Oracle Real Application Clusters 10g Firewire ASM Linux 34

35 CD-ROM 2 disk2.iso ISO 1 ISO True Color(24bit) OS OS Oracle Real Application Clusters 10g Firewire ASM Linux 35

36 VMware VMware VMware-tools VMware-tools BusLogic SCSI VMware-tools Guest OS VMware-tools 1. VMware-tools VMware-tools VMware 1.1. Guest OS VMware VM VMware Tools Guest OS root 1.2. Kon Vmtooles VMware VM VMware Tools ISO Vmtooles ISO vmware-install.pl kon Oracle Real Application Clusters 10g Firewire ASM Linux 36

37 1.3. Enter 1.4. X 1024*768 PC 800*600 VMWare Vmware-Tools Vmware-Tools Oracle Real Application Clusters 10g Firewire ASM Linux 37

38 2. CRS Oracle Database ISO OS CR-ROM Guest OS Host OS CRS Oracle Database D: vmware share 2.1. Vmware VM 2.2. Share D: vmware Share OK share hgfs hgfs VMware Oracle Real Application Clusters 10g Firewire ASM Linux 38

39 6 5 console oracle01 oracle02 VMware Host OS Host OS Vmware-Tools Root IP NIC MAC oracle01 oracle02 Host OS 1. VMware console root console VMware 2. Host OS D: vmware console D: vmware oracle01 D: vmware oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 39

40 oracle01 oracle02 Host OS VMware NIC Guest OS IP 1. Host OS VMware D: vmware console D: vmware oracle01 D: vmware oracle02 rhel3.vmx D: vmware oracle01 rhel3.vmx Ide0:0.filename = console.vmdk displayname = console Ide0:0.filename = oracle01.vmdk displayname = oracle01 console.vmdk oracle01.vmdk oracle02 oracle02 oracle01 Oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 40

41 2. NIC NIC MAC MAC NIC Public Private 2 NIC 2.1. NIC NIC VMware VMware VMware oracle01 oracle02 D: vmware oracle01 rhel3.vmx D: vmware oracle02 rhel3.vmx oracle01 OK oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 41

42 oracle01 UUID UUID OK Miracle Linux Kudzu Kudzu Remove Configuration NIC Kudzu NIC root oracle NIC VMware OS Kudzu NIC Public Private 2 NIC oracle01 Oracle Real Application Clusters 10g Firewire ASM Linux 42

43 Public NIC NAT Private 2 NIC 2 NIC : VMnet7 oracle oracle01 Kudzu Configure Public Eth0 OK IP Address: Oracle Real Application Clusters 10g Firewire ASM Linux 43

44 Netmask: Default gateway (IP): Primary Nameserver: LAN DNS 2 Private Eth1 Configure OK gateway DNS Eth0 IP Address: Netmask: Default gateway (IP): Primary Nameserver: oracle02 oracle02 Eth0 IP Address: Netmask: Default gateway (IP): Primary Nameserver: LAN DNS Eth1 IP Address: Netmask: Default gateway (IP): Primary Nameserver: Oracle Real Application Clusters 10g Firewire ASM Linux 44

45 3. oracle01 oracle02 OS /etc/sysconfig/network vi /etc/sysconfig/network HOSTNAME root]# vi /etc/sysconfig/network Oracle01 HOSTNAME=console.jp.oracle.com HOSTNAME=oracle01.jp.oracle.com Oracle02 HOSTNAME=console.jp.oracle.com HOSTNAME=oracle02.jp.oracle.com oracle01 oracle02 OS 128MB OK 7 Oracle Real Application Clusters 10g Firewire ASM Linux 45

46 7 SSH X Oracle console oracle01 oracle02 3 /etc/hosts Public /etc/hosts DNS console oracle01 oracle02 vi /etc/hosts oracle01.jp.oracle.com oracle oracle02.jp.oracle.com oracle console.jp.oracle.com console /etc/hosts 3 Oracle Real Application Clusters 10g Firewire ASM Linux 46

47 SSH SSH SSH Oracle01 Oracle02 root SSH 1. SSH Client root SSH Server.shosts sshd ssh_config sshd_config SSH SSH /etc/ssh/ssh_config /etc/sshd_config.shosts.shosts root root.shosts SSH SSH SSH SSH oracle01 oracle02 SSH Client console.jp.oracle.com Root SSH Server oracle01.jp.oracle.com SSH Serve oracle02.jp.oracle.com Oracle Real Application Clusters 10g Firewire ASM Linux 47

48 2. SSH Client console oracle01 oracle02 vi /etc/ssh/ssh_config ssh 6 3. SSH Server console oracle01 oracle02 vi /etc/ssh/sshd_config sshd_config Oracle Real Application Clusters 10g Firewire ASM Linux 48

49 sshd sshd 4. /root/.shosts oracle01 oracle02 root /root/.shosts 5. oracle01 console oracle02 console ssh Root oracle01 console Yes console root yes 2 SSH console oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 49

50 X OUI(Oracle Universal Installer) X X 1. X (console) Console X /etc/x0.hosts vi 2. X (oracle01 oracle02) oracle01 oracle02 root /root/.bash_profile.bash_profile 3. console X X /etc/x0.hosts X Oracle01 X xclock Console OK Oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 50

51 8 CRS RAC OS 7 SSH X console oracle01 oracle02 oracle01 oracle02 OS OS Linux Windows /etc/sysctl.conf Miracle Linux R3.0 oracle DB /etc/sysctl.conf # for RAC System ssh oracle01, oracle02 /etc/sysctl.conf Oracle Real Application Clusters 10g Firewire ASM Linux 51

52 oracle01, oracle02 oinstall dba oinstall dba oinstall Oracle dba 1. groupadd ID /etc/group 2. Oracle useradd ID 500 /home/oracle ID ID oracle01 oracle02 passwd Oracle Real Application Clusters 10g Firewire ASM Linux 52

53 oracle oracle02 3. oracle.bash_profile /home/oracle/rac.env.bash_profile DISPLAY.bash_profile Oracle01 oracle vi /home/oracle/rac.env /home/oracle/.bash_profile oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 53

54 1. oracle01 oracle02 /etc/hosts RAC VIP Private /etc/hosts oracle01 ( ) IP : : oracle01 oracle02 VIP IP : : oracle01-vip oracle02-vip vip IP : : oracle01-priv oracle02-priv -priv console local oracle01 oracle02 3. RAC 7 Oracle Real Application Clusters 10g Firewire ASM Linux 54

55 console.jp.oracle.com Root oracle01.jp.oracle.com oracle oracle02.jp.oracle.com oracle oracle oracle01 oracle02 SSH /etc/ssh_config /etc/sshd_config oracle.shosts oracle01 oracle02 Oracle /home/oracle/.shosts oracle01.jp.oracle.com oracle02.jp.oracle.com 7 SSH SSH 4. Oracle X DISPLAY oracle01 oracle02 oracle xclock oracle01 oracle02 Shutdown Oracle Real Application Clusters 10g Firewire ASM Linux 55

56 D: vmware share 2 Disk1 CRS D: vmware share crs Oracle D: vmware share db DB Oracle Real Application Clusters 10g Firewire ASM Linux 56

57 9 RAC VMware VMware VMware oracle01,oracle02 D: vmware oracle01 D: vmware oracle02 rhel3.vmx RAC Oracle Real Application Clusters 10g Firewire ASM Linux 57

58 RAC 4 D vmware storage SCSI OCR ocr.vmdk 200MB sda Voting Disk vot.vmdk 200MB sdb ASM DG1 dg1_1.vmdk 3GB sdc ASM DG1 dg1_2.vmdk 3GB sdd OCR ASM 2 ASM DG VMware oracle01 Oracle Real Application Clusters 10g Firewire ASM Linux 58

59 2.2. SCSI 0.2 GB 2.3. RAC D: vmware storage D: vmware storage ocr.vmdk SCSI0:0 sda sda sdb sdc sdd Oracle Real Application Clusters 10g Firewire ASM Linux 59

60 2.4. Voting Disk ASM DG1_1 ASM DG1_2 OK * OS Oracle Real Application Clusters 10g Firewire ASM Linux 60

61 2.5. Oracle02 Oracle02 oracle01 oracle01 oracle01 D: vmware storage ocr.vmdk oracle01 oracle02 4 Oracle Real Application Clusters 10g Firewire ASM Linux 61

62 RAW OS 1. console oracle01 SSH root]# fdisk l /dev/sda /dev/sdb /dev/sdc /dev/sdd 4 Oracle Real Application Clusters 10g Firewire ASM Linux 62

63 2. fdisk OCR Voting Disk ASM OCR sda oracle01 oracle02 oracle01 oracle02 fdisk fdisk OS 2.1. n 2.2. p Enter 2.5. w(writing) /dev/sdb /dev/sdc /dev/sdd fdisk -l oracle01 oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 63

64 RAW RAW RAW oracle 1. etc/sysconfig/rawdevices oracle01 oracle02 vi etc/sysconfig/rawdevices 2. oracle01 oracle02 RAW etc/sysconfig/rawservices rawdevices raw qa oracle02 RAW /dev/raw/rawx Oracle Real Application Clusters 10g Firewire ASM Linux 64

65 3. RAW Oracle RAW oracle chown oracle01 oracle02 4. RAW dd RAW raw1 raw4 oracle01 oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 65

66 10 CRS 1. OUI OUI X console root X console SSH oracle01 CRS runinstaller OUI [root@console root]# startx Disk1 oracle01 oracle runinstaller 2. [ ] Oracle Database 10g ( ) PSR CRS VIP R mii-tool Patch Set Release VIP p70 Oracle Real Application Clusters 10g Firewire ASM Linux 66

67 Oracle Oracle Universal Installer runinstaller 3. [oinstall] oracle01 root [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 67

68 4. CRS ORA_CRS_HOME ORACLE_HOME /mnt/hgfs/share/ocr/disk/stage/products.xml OraCr10g_home1 /home/oracle/oracle/product/10.1.0/crs Oracle Real Application Clusters 10g Firewire ASM Linux 68

69 5. [ ] 6. /etc/hosts /etc/hosts oracle01 oracle01-priv oracle02 oracle02-priv Oracle Real Application Clusters 10g Firewire ASM Linux 69

70 7. RAC [ ] [Do not Use] [Private] [Public] IP Private Public eth0 [Public] eth1 [Private] 8. OCR OCR /dev/raw/raw1 OCR Oracle Real Application Clusters 10g Firewire ASM Linux 70

71 9. /dev/raw/raw2 10. orainstroot.sh root orainstroot.sh oracle01 oracle02 Oracle Real Application Clusters 10g Firewire ASM Linux 71

72 [ ] 11. Oracle Real Application Clusters 10g Firewire ASM Linux 72

73 OK [ ] 12. Oracle Real Application Clusters 10g Firewire ASM Linux 73

74 CRS 13. root.sh 100% Root root.sh 14. Oracle01 root.sh Root ORA_CRS_HOME root.sh [Expecting the CRS daemons to be up within 600 seconds] Oracle Real Application Clusters 10g Firewire ASM Linux 74

75 15. Oracle02 root.sh Oracle01 root.sh oracle02 root.sh Oracle Real Application Clusters 10g Firewire ASM Linux 75

76 Oracle Real Application Clusters 10g Firewire ASM Linux 76

77 Oracle02 root.sh CRS CSS is active on these nodes. Expecting the CRS daemons to be up within 600 seconds. CRS /etc/hosts IP root.sh CRS root OS root.sh CRS ps elf grep crsd /home/oracle/product/10.1.0/crs/bin/crsd.bin /home/oracle/product/10.1.0/crs/bin/evmd.bin /home/oracle/product/10.1.0/crs/bin/ocssd.bin 3 OK Oracle Real Application Clusters 10g Firewire ASM Linux 77

78 OK 16. Oracle Notification Server Oracle Private Interconnect Oracle Notification Server Oracle Private Interconnect 17. CRS Oracle Real Application Clusters 10g Firewire ASM Linux 78

79 2 olsnodes Oracle Real Application Clusters 10g Firewire ASM Linux 79

80 11 Oracle Oracle Oracle Oracle rac.env ORACLE_HOME PATH ORACLE_SID rac.env oracle]#../rac.env Oracle 1. runinstaller oracle01 oracle runinstaller D: vmware share db Oracle Real Application Clusters 10g Firewire ASM Linux 80

81 2. [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 81

82 3. [ ] ORACLE_HOME 4. CRS OUI CRS [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 82

83 5. Enterprise Edition 6. [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 83

84 7. DBCA DBCA [ ] 8. Oracle Real Application Clusters 10g Firewire ASM Linux 84

85 9. CRS 10. root.sh 100% CRS RAC root root.sh root.sh Oracle vipca GUI IP(VIP) vipca IP root DISPLAY LANG root.sh Oracle Real Application Clusters 10g Firewire ASM Linux 85

86 \ /usr/local/bin Oracle OK Enter [Now product-specific root actions will be performaed.] VIPCA(VirtualIP Configuration Assistant) \ \ Oracle Real Application Clusters 10g Firewire ASM Linux 86

87 [ ] VIPCA 11. VIPCA VIPCA 12. VIP VIP eth0 LAN eth1 LAN eth0 Oracle Real Application Clusters 10g Firewire ASM Linux 87

88 13. VIP VIP /etc/hosts VIP /etc/hosts VIP IP [IP ] 14. VIPCA [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 88

89 15. [ ] VIP ~ 100% [OK] 16. [ ] oracle01 root.sh oracle02 root.sh Oracle Real Application Clusters 10g Firewire ASM Linux 89

90 17. Oracle02 root.sh oracle02 root.sh Root ORACLE_HOME (/home/oracle/product/10.1.0/db) root.sh Oracle02 CRS resources are already \ \ 2 root.sh 2 IP VIPCA root.sh VIPCA [ ] Oracle Real Application Clusters 10g Firewire ASM Linux 90

91 OK 18. Oracle Real Application Clusters 10g Firewire ASM Linux 91

92 ifconfig vip eth0:1 Interrupt:10 Base address:0x2400 Memory: Oracle Real Application Clusters 10g Firewire ASM Linux 92

93 12 DB DB 1. dbca oracle01 oracle PATH DISPLAY 2 dbca dbca Database Configuration Assistant dbca 2. RAC Oracle Real Application Clusters Oracle Real Application Clusters 10g Firewire ASM Linux 93

94 Oracle Real Application Clusters 10g Firewire ASM Linux 94

95 5. 6. SID RAC SID SID + SID SID rac Oracle Real Application Clusters 10g Firewire ASM Linux 95

96 7. Enterprise Manager Enterprise Manager Oracle 10g HTML Oracle Real Application Clusters 10g Firewire ASM Linux 96

97 8. 9. ASM Automatic Storage Management(ASM) Oracle Real Application Clusters 10g Firewire ASM Linux 97

98 10. ASM ASM Oracle SYS ( RAC10 SYS ) ASM (IFILE) ASM OK ASM ASM Oracle Real Application Clusters 10g Firewire ASM Linux 98

99 11. ASM ASM ASM ASM ASM (LVM) RAW raw3, raw4 2 ( ) Oracle Real Application Clusters 10g Firewire ASM Linux 99

100 OK ASM Oracle Real Application Clusters 10g Firewire ASM Linux 100

101 v$asm_diskgroup 1 ASM sqlplus ORACLE_SID ASM +ASM1 sqlplus v$asm_diskgroup EERAC 2 (oracle02) 2 ORACLE_SID 2 ASM +ASM2 alter diskgroup < > mount Oracle Real Application Clusters 10g Firewire ASM Linux 101

102 ASM EERAC 12. Oracle Managed Files EERAC Oracle Real Application Clusters 10g Firewire ASM Linux 102

103 13. 10g 10g 14. Oracle Real Application Clusters 10g Firewire ASM Linux 103

104 15. 10g RAC dbca % Oracle Real Application Clusters 10g Firewire ASM Linux 104

105 Oracle Real Application Clusters 10g Firewire ASM Linux 105

106 Oracle Real Application Clusters 10g Firewire ASM Linux 106

107 19. OK OK Oracle Real Application Clusters 10g Firewire ASM Linux 107

108 20. RAC * Oracle Real Application Clusters 10g Firewire ASM Linux 108

109 RAC SQL STATUS OPEN RAC Oracle Real Application Clusters 10g Firewire ASM Linux 109

110 su /etc/pam.d/su #auth required /lib/security/pam_wheel.so use_uid /sbin/lkcd_config OUI TMP TMP 777 RedHatAS2.1 CRS OCR OCR OUI CRS OUI RAW dd dd if=/dev/zero of=/dev/raw/raw12 bs=1024k count=10 CRS root.sh /etc/hosts 32 CRS /etc Oracle #rm r /etc/ora* Oracle Oracle $rm r app CRS Miraclelinux30 rm rm i Oracle Real Application Clusters 10g Firewire ASM Linux 110

111 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/raw1 root]# chmod 660 /dev/raw/raw2 ASM RAW umount 2 [/dev/raw/raw1*] [/dev/raw/raw12*] Oracle Real Application Clusters 10g Firewire ASM Linux 111

112 3 dd dd if=/dev/zero of=/dev/raw/raw15 bs=1024k count=100 4 mkfs Mkfs RAW [root@oracle02 crs]# mkfs /dev/sda5 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@oracle02 crs]# [ ] [ ] VIP Ora-15018/Ora failure RAW Oracle Real Application Clusters 10g Firewire ASM Linux 112

113 CD-ROM FULL Oracle URL Oracle Database 10g for UNIX Systems Oracle Database 10g for UNIX Systems Oracle Real Application Clusters 10g for UNIX Systems Oracle Databasae 10g Oracle Real Application Clusters 10g Firewire ASM Linux 113

114 Oracle Real Application Clusters 10g VMWare ASM Linux Copyright Oracle Corporation Japan 2004,2005 All Rights Reserved Oracle Oracle Corporation