高信頼化システム監視機能 HAモニタ kit for Oracle

Size: px

Start display at page:

Download "高信頼化システム監視機能 HAモニタ kit for Oracle"

ひでよりしげい
5 years ago
Views:

1 HA kit for Oracle

2 P-F9S2C-E1111 HA kit for Oracle OS Red Hat Enterprise Linux AS 4(x86) Red Hat Enterprise Linux ES 4(x86) Red Hat Enterprise Linux AS 4(AMD64 & Intel EM64T) Red Hat Enterprise Linux ES 4(AMD64 & Intel EM64T) Red Hat Enterprise Linux 5(x86) Red Hat Enterprise Linux 5(AMD/Intel 64) Red Hat Enterprise Linux 5 Advanced Platform(x86) Red Hat Enterprise Linux 5 Advanced Platform(AMD/Intel 64) Intel EM64T AMD Advanced Micro Devices, Inc. Linux Linus Torvalds Oracle Oracle 10g Oracle Corporation Oracle Oracle Database 11g Oracle Corporation Red Hat Red Hat, Inc. SQL*Plus Oracle Corporation UNIX The Open Group All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.

3 HA kit for Oracle HA HA kit for Oracle Oracle OS HA Oracle I

5 1 HA kit HA kit HA kit HA kit HA Oracle Oracle Oracle Oracle HA kit i

6 Oracle Oracle Oracle Oracle HA Oracle Oracle HA Oracle Oracle HA Oracle Oracle Oracle Oracle Oracle Oracle Oracle ii

7 115 A 116 A A A A.4 KB iii

8 1-1 HA kit HA kit Oracle HA kit HA kit RAC Oracle HA Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle iv

9 v

10 2-1 HA kit HA vi

11 1 HA kit HA kit HA kit HA kit HA HA kit for Oracle HA kit 1.1 HA kit 1.2 HA kit 1.3 HA kit 1.4 HA 1

12 1. HA kit 1.1 HA kit HA kit HA Oracle HA HA Oracle Oracle Oracle HA kit Oracle Oracle Oracle Oracle Oracle HA kit Oracle HA kit 1-1 HA kit 2

13 1. HA kit 1.2 HA kit HA HA HA kit Oracle Oracle 1 Oracle HA kit HA kit Oracle HA kit 1-2 HA kit Oracle 3

14 1. HA kit 1-3 HA kit HA kit Oracle RAC RAC HA kit RAC 1-4 HA kit RAC 2 Oracle HA kit Oracle Oracle Oracle Oracle Oracle Oracle Oracle 4

15 1. HA kit Oracle 1-5 Oracle HA kit Oracle Oracle Oracle 3 HA kit HA HA HA HA Linux(R) HA HA kit Oracle 5

16 1. HA kit 1.3 HA kit HA kit HA HA Linux(R) HA HA kit HA HA Linux(R) HA kit 1 Oracle REDO Oracle Oracle 2 Oracle HA kit Oracle Oracle Oracle 3 LAN 6

17 1. HA kit HA kit a Linux(x86) b HA HA kit HA HA c Oracle HA 2 7

18 1. HA kit ASM HA kit Oracle Clusterware Oracle Data Guard Broker Oracle RAC Oracle Restart 8

19 1. HA kit 1.4 HA HA kit HA HA kit HA Linux(R) HA kit HA kit HA HA HA 9

20 1. HA kit 1-7 HA 10

21 2 HA kit HA HA kit HA Linux(R)

22 HA kit HA Oracle Oracle Oracle HA kit Oracle Oracle HA HA 2-1 HA kit Oracle Oracle 3.2.7(2) 12

23 HA kit 1 HA kit HA kit Oracle 2-1 HA kit Oracle Oracle Oracle Oracle Oracle Oracle SQL SQL Oracle Oracle Oracle Oracle Oracle HA kit 2 HA Oracle HA kit HA 2-2 HA HA LAN LAN HA Linux(R) LAN HA alive HA Linux(R) 13

24 HA HA kit HA HA kit ID ID ID Oracle Oracle 14

25 Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 2-3 Oracle 15

26 2. 1 IP Oracle 2 HA 3 HA kit Oracle SQL*Plus startup 4 Oracle Oracle 2 Oracle Oracle HA HA kit 16

27 Oracle 1 IP Oracle 17

28 2. 2 HA 3 HA kit Oracle lsnrctl start 4 Oracle Oracle Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 18

29 Oracle 19

30 2. 1 IP Oracle 2 HA 2 Oracle Oracle HA HA kit 20

31 Oracle 21

32 2. 1 IP Oracle 2 HA 3 HA HA termcmd_at_abort use 4 Oracle Oracle 3 Oracle Oracle HA HA kit 22

33 Oracle 1 IP Oracle 23

34 2. 2 HA 4 Oracle Oracle HA HA kit 24

35 Oracle 25

2. 1 IP 3.1.2 3.2.6 Oracle 2 HA 3 HA HA termcmd_at_abort use 4 Oracle Oracle 2.

36 2. 1 IP Oracle 2 HA 3 HA HA termcmd_at_abort use 4 Oracle Oracle Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 26

37 Oracle 1 HA 2 HA kit Oracle SQL*Plus 27

38 2. shutdown transactional shutdown abort 3 Oracle Oracle 4 HA 5 IP Oracle 2 Oracle Oracle HA HA kit 28

39 Oracle 1 HA 2 HA kit Oracle OS lsnrctl stop 29

2. Oracle kill -9 3 Oracle Oracle 4 HA 5 IP 3.1.2 3.2.6 Oracle 2.2.4

40 2. Oracle kill -9 3 Oracle Oracle 4 HA 5 IP Oracle Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 2-11 Oracle 30

41 2. 1 HA 2 PATROL_INTERVAL 3 HA kit SQL*Plus SQL Oracle "OPEN" SQL select status from v$instance where instance_name = '&_CONNECT_IDENTIFIER'; SQL select file_name from dba_data_files; I/O Oracle PATROL 4 HA kit Oracle CKPT DBW0 LGWR PMON SMON 5 Oracle Oracle 2 Oracle Oracle HA HA kit 31

2. 2-12 Oracle 1 HA 2 PATROL_INTERVAL 3 HA kit lsnrctl status Oracle PATROL 4 HA

42 Oracle 1 HA 2 PATROL_INTERVAL 3 HA kit lsnrctl status Oracle PATROL 4 HA kit Oracle TNSLSNR 5 Oracle Oracle Oracle Oracle HA HA kit Oracle Oracle 32

43 2. 1 Oracle Oracle HA HA kit 2-13 Oracle 33

44 2. 34

45 2. 1 HA 2 Oracle Oracle 3 IP Oracle 4 HA 2 Oracle Oracle HA HA kit 35

46 Oracle 36

47 2. 37

48 2. 1 HA 2 Oracle Oracle 3 IP Oracle 4 HA 38

49 3 HA kit HA kit HA kit

50 HA kit HA HA kit HA HA Linux(R) HA Oracle Oracle HA HA kit Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle HA 40

51 Oracle Oracle 3-2 Oracle Oracle 41

52 Oracle Oracle Oracle HA Oracle Oracle IP IP IP Oracle LAN Oracle Oracle LAN HA HA Linux(R) 2 HA Linux(R) 42

53 HA kit HA HA Linux(R) HA kit Oracle HA HA Linux(R) HA Linux(R) 43

54 HA HA kit HA Linux(R) HA Linux(R) HA 44

55 3. HA Linux(R) Oracle HA Oracle Oracle HA Oracle Oracle HA kit HA kit HA kit /opt/hitachi HA kit HAmonOra HA kit HA kit 45

57 (1) 2. Oracle Oracle 3.2.7(2) 3. Oracle Oracle 3.2.7(2) 4. servers Oracle LAN IP IP Oracle Oracle Oracle Oracle Oracle Oracle Oracle oracle ID ID Oracle Oracle Oracle oracle ID ID OS 3.2.5(1) Oracle Enterprise Manager Database Control Oracle 47

58 Oracle Oracle Oracle Oracle Oracle Oracle 1 Oracle HA REDO SPFILE PFILE 2 Oracle Oracle IP IP Oracle 1. /etc/hosts IP 2. Oracle tnsnames.ora 1. IP 48

59 3. /etc/hosts server1 # alias IP address tnsnames.ora ORCL1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(port = 1521)) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = orcl1) ) ) 2. tnsnames.ora # sqlplus user/passwd@server1/orcl Oracle Oracle Oracle HA HA Linux(R) LAN IP HA IP LAN HA Linux(R) LAN HA kit Oracle HA kit HA kit 49

60 3. 1 HA kit HA /opt/hitachi/hamon/etc HA kit 3-1 /opt/hitachi/hamonora/lib/actcommand /opt/hitachi/hamonora/lib/termcommand /opt/hitachi/hamonora/lib/patrolcommand /opt/hitachi/hamonora/lib/patrol.sh 4. 2 HA kit Oracle Oracle HA kit Oracle Oracle Oracle Oracle 3-2 Oracle Oracle /opt/hitachi/hamonora/lib/ orcl1.env /opt/hitachi/hamonora/lib/ LISTENER.env /opt/hitachi/hamon/etc/ HAmonOra_etc/instance /opt/hitachi/hamon/etc/ HAmonOra_etc/listener 50

61 3. Oracle.env Oracle.env = 1 = 3-3 ORACLE_SID LISTENER_NAME ORACLE_HOME ORACLE_USER Oracle Oracle ORACLE_SID ORACLE_SID Oracle Oracle Oracle Oracle Oracle Oracle ORACLE_HOME Oracle ORACLE_HOME Oracle Oracle Oracle Oracle 51

62 3. DB_NOACCESS Oracle SQL Oracle yes SQL Oracle Oracle no SQL Oracle Oracle no yes HA kit SQL ALTER SYSTEM SUSPEND Oracle "OPEN" LISTENER_NOACCE SS Oracle Oracle yes Oracle no Oracle no PATROL ABORT_LIMIT Oracle Oracle DB_NOACCESS LISTENER_NOACCESS yes Oracle /opt/hitachi/hamon/etc/hamonora_etc/ instance/orcl1.env ORACLE_SID=orcl1 ORACLE_HOME=/home/oracle/product/10.2.0/db_1 ORACLE_USER=oracle PATROL=120 ABORT_LIMIT=180 Oracle /opt/hitachi/hamon/etc/hamonora_etc/listener/ LISTENER.env 52

63 3. LISTENER_NAME=LISTENER ORACLE_HOME=/home/oracle/product/10.2.0/db_1 ORACLE_USER=oracle PATROL=120 ABORT_LIMIT=180 Oracle Oracle HA kit Oracle Oracle Oracle Oracle HA HA kit Oracle HA HA Linux(R) servers 3-4 name acttype termcommand patrolcommand waitserv_exec group start_timeout stop_timeout 4.2 monitor yes Oracle HA termcmd_at_abort yes stop_timeout Oracle Oracle 53

64 Oracle UAP UAP HA Linux(R) HA kit HA Linux(R) 1 HA kit HA kit Oracle Oracle KAMK00302-I Oracle Oracle KAMK00322-I HA kit Oracle Oracle KAMK00305-I Oracle Oracle KAMK00325-I 2 HA kit HA kit Oracle Oracle 54

65 3. KAMK00302-I Oracle Oracle KAMK00322-I 55

3. 3.3 HA kit Oracle Oracle 3-7 Oracle Oracle 1 /opt/hitachi/hamon/etc/orasrv/actcommand_orasrv

66 HA kit Oracle Oracle 3-7 Oracle Oracle 1 /opt/hitachi/hamon/etc/orasrv/actcommand_orasrv /opt/hitachi/hamon/etc/orasrv/termcommand_orasrv /opt/hitachi/hamon/etc/orasrv/patrol_orasrv.sh 56

67 3. Oracle /home/oracle/product/10.2.0/db_1 2 /etc/hosts server1 # alias IP address Oracle tnsnames.ora ORCL1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(port = 1521)) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = orcl1) ) ) Oracle /opt/hitachi/hamon/etc/ HAmonOra_etc/instance/orcl1.env ORACLE_SID=orcl1 ORACLE_HOME=/home/oracle/product/10.2.0/db_1 ORACLE_USER=oracle PATROL=120 ABORT_LIMIT=180 Oracle /opt/hitachi/hamon/etc/ HAmonOra_etc/listener/LISTENER.env LISTENER_NAME=LISTENER ORACLE_HOME=/home/oracle/product/10.2.0/db_1 ORACLE_USER=oracle PATROL=120 ABORT_LIMIT=180 57

68 3. LAN.up /opt/hitachi/hamon/etc/orasrv.up #! /bin/sh INTERFACE=eth0:1 IPADDR= NETMASK= BROADCAST= # LAN interface name # alias IP address # netmask address # broadcast address # The alias IP address is added to the LAN interface. /sbin/ifconfig $INTERFACE inet $IPADDR netmask $NETMASK broadcast $BROADCAST # The information on old routing cache is deleted. /bin/echo 0 > /proc/sys/net/ipv4/route/flush # The ARP caches are updated. IFNAME=`echo $INTERFACE /bin/sed -e 's/:[0-9]*$//'` /sbin/arping -U -c 2 -I $IFNAME $IPADDR.down /opt/hitachi/hamon/etc/orasrv.down #!/bin/sh set -x INTERFACE=eth0:1 # LAN interface name # The alias IP address is deleted from the LAN interface. /sbin/ifconfig $INTERFACE down # The information on old routing cache is deleted. /bin/echo 0 > /proc/sys/net/ipv4/route/flush /opt/hitachi/hamon/etc/servers /* */ server name /opt/hitachi/hamon/etc/orasrv/actcommand_orasrv, alias orasrv, acttype monitor, initial online, termcommand /opt/hitachi/hamon/etc/orasrv/termcommand_orasrv, patrolcommand /opt/hitachi/hamon/etc/orasrv/patrol_orasrv.sh, disk /dev/vg01, fs_name /dev/vg01/lvol1, fs_mount_dir /ora_mnt, lan_updown use, waitserv_exec yes, start_timeout 180; standby 58

69 3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE= #################################################################### act_proc(){ RT_CD=0 # Listener /opt/hitachi/hamonora/bin/haoralsnrbgn LISTENER if [ "$?"!= "0" ] then RT_CD=2 fi # Instance /opt/hitachi/hamonora/bin/haorainsbgn orcl1 if [ "$?"!= "0" ] then RT_CD=1 fi return ${RT_CD} } #################################################################### 59

70 3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE= #################################################################### term_proc(){ RT_CD=0 case "$1" in "-e" ) # normal end # Instance /opt/hitachi/hamonora/bin/haorainsend orcl1 if [ "$?"!= "0" ] then RT_CD=1 fi "-w" ) "-c" ) # Listener /opt/hitachi/hamonora/bin/haoralsnrend LISTENER if [ "$?"!= "0" ] then RT_CD=2 fi ;; # monswap # Instance /opt/hitachi/hamonora/bin/haorainsend orcl1 if [ "$?"!= "0" ] then RT_CD=1 fi # Listener /opt/hitachi/hamonora/bin/haoralsnrend LISTENER if [ "$?"!= "0" ] then RT_CD=2 fi ;; # down # Instance /opt/hitachi/hamonora/bin/haorainsend orcl1 if [ "$?"!= "0" ] then RT_CD=1 fi esac return ${RT_CD} # Listener /opt/hitachi/hamonora/bin/haoralsnrend LISTENER if [ "$?"!= "0" ] then RT_CD=2 fi ;; } #################################################################### 60

71 3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE= PATROL_INTERVAL=5 #################################################################### patrol_proc(){ # Instance /opt/hitachi/hamonora/bin/haorainsptl orcl1 if [ "$?"!= "0" ] then return 1 fi # Listener /opt/hitachi/hamonora/bin/haoralsnrptl LISTENER if [ "$?"!= "0" ] then return 2 fi return 0 } #################################################################### #! /bin/sh #################################################################### ORACLE_USER=oracle PATROL_SHELL=/opt/hitachi/HAmon/etc/patrolcommand_orasrv #################################################################### 61

74 HA kit HA Linux(R) Oracle

75 HA kit 3.2.7(1) act_proc() Oracle Oracle (1) 2. Oracle haoralsnrbgn Oracle (2) haoralsnrbgn

76 4. haoralsnrbgn Oracle 3. Oracle haorainsbgn Oracle (2) haorainsbgn 4.5 haorainsbgn Oracle 4. (2) 5. act_proc() act_proc() (3) LOGNAME orasrv 5.4 LOGSIZE (2) LOGNAME LOGSIZE Oracle Oracle LISTENER Oracle 66

77 4. 2. Oracle 2. LISTENER LISTENER Oracle 3. Oracle Oracle orcl1 Oracle 3. Oracle 3. orcl1 orcl1 Oracle 4. Oracle Oracle Oracle Oracle 4. ${RT_CD} 0 3 Oracle HA Linux(R) act_proc() act_proc() act_proc() exit return act_proc() act_proc() 0 67

78 4. act_proc() 5.4 act_proc() LOGNAME LOGSIZE 68

79 HA kit 3.2.7(1) term_proc() Oracle Oracle

80 (1) 2. Oracle haorainsend Oracle (2) haorainsend 4.5 haorainsend Oracle 3. Oracle haoralsnrend Oracle (2) haoralsnrend 4.5 haoralsnrend Oracle 4. term_proc() term_proc() (3) 70

81 LOGNAME orasrv 5.4 LOGSIZE (2) LOGNAME LOGSIZE Oracle Oracle orcl1 Oracle 2. Oracle 2. orcl1 orcl1 Oracle 3. Oracle Oracle LISTENER Oracle 3. Oracle 3. LISTENER LISTENER Oracle 71

82 4. Oracle Oracle 3 Oracle HA Linux(R) term_proc() term_proc() term_proc() exit return term_proc() HA term_proc() 1 $1 term_proc() 5.4 term_proc() LOGNAME LOGSIZE 72

83 HA kit 3.2.7(1) patrol_proc() Oracle Oracle (1) 73

84 4. 2. Oracle haorainsptl Oracle (2) haorainsptl 4.5 haorainsptl Oracle 3. Oracle haoralsnrptl Oracle (2) haoralsnrptl 4.5 haoralsnrptl Oracle 4. patrol_proc() patrol_proc() (3) LOGNAME orasrv 5.4 LOGSIZE (2) LOGNAME LOGSIZE PATROL_INTERVAL

85 Oracle Oracle orcl1 Oracle 2. Oracle 2. orcl1 orcl1 Oracle 3. Oracle Oracle LISTENER Oracle 3. Oracle 3. LISTENER LISTENER Oracle Oracle Oracle 3 Oracle HA Linux(R) patrol_proc() patrol_proc() Oracle Oracle patrol_proc() exit return patrol_proc() 0 HA patrol_proc() 75

86 4. patrol_proc() patrol_proc() 5.4 patrol_proc() LOGNAME LOGSIZE PATROL_INTERVAL HA kit 3.2.7(1) (1) ORACLE_USER 76

87 4. Oracle PATROL_SHELL ORACLE_USER PATROL_SHELL 77

88 haorainsbgn haorainsend haorainsptl haoralsnrbgn haoralsnrend haoralsnrptl Oracle Oracle Oracle Oracle Oracle Oracle 78

89 4. 79

90 4. haorainsbgn Oracle haorainsbgn HA kit Oracle 4.2 HA kit Oracle Oracle ORACLE_SID Oracle 0 Oracle 0 80

91 4. haorainsend Oracle haorainsend HA kit Oracle 4.3 HA kit Oracle Oracle Oracle ABORT_LIMIT Oracle Oracle ORACLE_SID Oracle 0 Oracle 0 Oracle Oracle ABORT_LIMIT 2 81

92 4. haorainsptl Oracle haorainsptl Oracle Oracle Oracle DB_NOACCESS no Oracle 4.4 HA kit Oracle Oracle ORACLE_SID Oracle 0 Oracle 1 Oracle 82

93 4. haoralsnrbgn Oracle haoralsnrbgn HA kit Oracle 4.2 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 0 83

94 4. haoralsnrend Oracle haoralsnrend HA kit Oracle 4.3 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 0 84

95 4. haoralsnrptl Oracle haoralsnrptl Oracle Oracle Oracle LISTENER_NOACCESS no 4.4 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 1 Oracle 85

97 5 Oracle Oracle HA Linux(R) Oracle Oracle 5.3 Oracle Oracle HA

98 HA kit Oracle Oracle HA HA kit HA HA Linux(R) Oracle DB_NOACCESS no Oracle SQL ALTER SYSTEM SUSPEND I/O ALTER SYSTEM SUSPEND HA kit Oracle 88

99 Oracle Oracle HA kit Oracle Oracle Oracle Oracle Oracle Oracle HA HA Oracle Oracle HA HA kit Oracle Oracle HA HA 1 Oracle Oracle Oracle Oracle monbegin monbegin HA HA Linux(R) monbegin 2 Oracle Oracle Oracle Oracle monend monend HA HA kit Oracle Oracle Oracle Oracle Oracle Oracle HA Linux(R) monend 3 Oracle Oracle Oracle Oracle HA Oracle Oracle SQL Oracle 89

100 5. Oracle Oracle Oracle HA Linux(R) 90

101 Oracle Oracle HA HA kit Oracle Oracle HA Oracle Oracle Oracle Oracle Oracle Oracle Data Guard Oracle Data Guard Oracle Oracle HA Oracle Oracle HA HA Oracle Oracle HA HA kit HA HA HA Oracle Oracle HA Oracle Oracle 1. Oracle Oracle HA monend 2. Oracle Oracle IP 3. Oracle Oracle Oracle 91

102 Oracle Oracle HA HA Oracle Oracle HA HA kit HA Oracle Oracle 1. Oracle Oracle Oracle 2. Oracle Oracle IP HA 92

103 HA kit Oracle 1 HA kit LOGNAME 5-1 /opt/hitachi/hamon/spool/.oralog /opt/hitachi/hamon/spool/.oralog_old /opt/hitachi/hamon/spool/.oralog_err 1 "_old" 0 "_err" 2 LOGSIZE 1,048,

104 Oracle Oracle 160 Oracle HA kit Oracle Oracle 170 Oracle HA kit Oracle Oracle 160 Oracle HA kit LOGSIZE Oracle 94

105 5. 1. HA kit ID KAMK00401-I HA kit HA kit Oracle Oracle Oracle 4 Oracle HA 5-2 HA LANG Oracle NLS_LANG ja_jp.utf-8 JAPANESE_JAPAN.AL32UTF8 UTF-8 ja_jp.eucjp JAPANESE_JAPAN.JA16EUC EUC ja_jp.sjis JAPANESE_JAPAN.JA16SJIS S-JIS 95

106 HA kit HA Linux(R) HA kit HA kit HA monts HA HA HA Linux(R) HA kit (2) /opt/hitachi/hamon/etc 3.2.7(1) 96

107 HA kit HA kit HA kit Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle HA HA HA Linux(R) 97

108 Oracle Oracle Oracle 1. monend 2. Oracle OS 3. Oracle Oracle 4. Oracle Oracle Oracle Oracle ORACLE_HOME 5. OS 6. monbegin Oracle Oracle Oracle Oracle HA kit 1 Oracle Oracle 1. monend Oracle Oracle Oracle Oracle 2. 98

109 5. Oracle 3. Oracle Oracle 3.2.7(2) 4. Oracle Oracle monbegin 2 Oracle Oracle 3.2 Oracle Oracle Oracle Oracle Oracle Oracle HA kit 1. monend Oracle Oracle Oracle Oracle 2. Oracle Oracle Oracle Oracle 4. monbegin 99

110 Oracle Oracle Oracle Oracle 1. monend Oracle Oracle (2) 3. monbegin 100

111 6 HA kit

112 KAMKnnnnn-i xx...xx KAMKnnnnn-i ID xx...xx ID "yyyy/mm/ dd HH:MM:SS " KAMKnnnnn-i X Message text aa...aa S O O 2 ID ID KAMK HA kit 102

113 6. nnnnn i E W I E W X P L syslog " " 103

114 HA kit KAMK00021-E P L The aa...aa command contains syntax errors. HA kit aa...aa S O KAMK00120-E P L The file aa...aa contains errors. Parameter : bb...bb aa...aa bb...bb aa...aa bb...bb S 3.2.7(2) KAMK00130-E P L The file aa...aa does not exist. aa...aa aa...aa S Oracle Oracle 3.2.7(2) 104

115 6. KAMK00201-I P Usage : haorainsbgn ORACLE_SID Oracle haorainsbgn KAMK00021-E S KAMK00202-I P Usage : haorainsend ORACLE_SID Oracle haorainsend KAMK00021-E S KAMK00203-I P Usage : haorainsptl ORACLE_SID Oracle haorainsptl KAMK00021-E S KAMK00204-I P Usage : haoralsnrbgn LISTENER_NAME Oracle haoralsnrbgn KAMK00021-E S KAMK00205-I P Usage : haoralsnrend LISTENER_NAME Oracle haoralsnrend KAMK00021-E 105

116 6. S KAMK00206-I P Usage : haoralsnrptl LISTENER_NAME Oracle haoralsnrptl KAMK00021-E S KAMK00301-I P Oracle instance aa...aa will now start. aa...aa Oracle aa...aa S KAMK00302-I P Oracle instance aa...aa has started. aa...aa Oracle aa...aa S KAMK00303-E P L An attempt to start Oracle instance aa...aa has failed. aa...aa Oracle aa...aa S O 106

117 6. KAMK00304-I P Oracle instance aa...aa will now stop. aa...aa Oracle aa...aa S KAMK00305-I P Oracle instance aa...aa has stopped. aa...aa Oracle aa...aa S KAMK00306-E P L An attempt to stop Oracle instance aa...aa has failed. aa...aa Oracle aa...aa S O KAMK00308-E P L An error was detected in Oracle instance aa...aa. Oracle aa...aa Oracle aa...aa S Oracle 107

118 6. KAMK00309-E P L A slowdown was detected in Oracle instance aa...aa. Oracle aa...aa Oracle aa...aa S Oracle KAMK00310-W P Oracle instance aa...aa could not be terminated. aa...aa Oracle aa...aa S KAMK00311-W P The processing to stop Oracle instance aa...aa timed out. aa...aa Oracle Oracle aa...aa S KAMK00312-I P Oracle instance aa...aa will be forcibly stopped. aa...aa Oracle aa...aa S KAMK00321-I P Oracle listener aa...aa will now start. 108

119 6. aa...aa Oracle aa...aa S KAMK00322-I P Oracle listener aa...aa has started. aa...aa Oracle aa...aa S KAMK00323-E P L An attempt to start Oracle listener aa...aa has failed. aa...aa Oracle aa...aa S O KAMK00324-I P Oracle listener aa...aa will now stop. aa...aa Oracle aa...aa S KAMK00325-I P Oracle listener aa...aa has stopped. aa...aa Oracle aa...aa S 109

120 6. KAMK00326-E P L An attempt to stop Oracle listener aa...aa has failed. aa...aa Oracle aa...aa S O KAMK00328-E P L An error was detected in Oracle listener aa...aa. Oracle aa...aa Oracle aa...aa S Oracle KAMK00329-E P L A slowdown was detected in Oracle listener aa...aa. Oracle aa...aa Oracle aa...aa S Oracle KAMK00330-W P Oracle listener aa...aa could not be terminated. aa...aa Oracle aa...aa S 110

121 6. KAMK00331-W P The processing to stop Oracle listener aa...aa timed out. aa...aa Oracle Oracle aa...aa S KAMK00332-I P Oracle listener aa...aa will be forcibly stopped. aa...aa Oracle aa...aa S KAMK00401-I P ********** The actcommand start. ********** S KAMK00402-I P ********** The actcommand end. (aa...aa) ********** aa...aa S 0 111

122 6. KAMK00411-I P ********** The termcommand start. ********** S KAMK00412-I P ********** The termcommand end. (aa...aa) ********** aa...aa S 0 KAMK00421-I P ********** The patrolcommand start. ********** S KAMK00422-I P ********** The patrolcommand end. (aa...aa) ********** aa...aa S 0 KAMK00423-E P L An error was detected during monitoring process. The patrolcommand will now stop. 112

123 6. S KAMK00601-E P L An error occurred in the aa...aa system call. Error details : bb...bb Functional name : cc...cc HA kit OS aa...aa bb...bb 1 3 cc...cc S O 113

124

125 A 115

126 A A A.1 HA Linux(R) HA Linux(R) HA HA A.2 Linux Linux(R) Linux Linux x86 Red Hat Enterprise Linux AS 4(AMD64 & Intel EM64T) Red Hat Enterprise Linux AS 4(x86) Red Hat Enterprise Linux ES 4(AMD64 & Intel EM64T) Red Hat Enterprise Linux ES 4(x86) Red Hat Enterprise Linux 5(x86) Red Hat Enterprise Linux 5 Advanced Platform(x86) Red Hat Enterprise Linux 5(AMD/Intel 64) Red Hat Enterprise Linux 5 Advanced Platform(AMD/Intel 64) Oracle Oracle 10g Oracle Database 11g UNIX UNIX(R) A.3 ASM DB EUC Automatic Storage Management Database Extended UNIX Code 116

127 A FS HA I/O LAN LVM OS RAC UTF-8 File System High Availability Input/Output Local Area Network Logical Volume Manager Operating System Real Application Clusters 8-bit UCS Transformation Format A.4 KB 1KB 1MB 1GB 1TB 1,024 1, , ,

128

129 A ABORT_LIMIT 52 acttype 53 D DB_NOACCESS 52 G group 53 H haorainsbgn 80 haorainsend 81 haorainsptl 82 haoralsnrbgn 83 haoralsnrend 84 haoralsnrptl 85 HA kit HA kit 13 HA 13 L LAN 6 LISTENER_NAME 51 LISTENER_NOACCESS 52 LOGNAME 74 LOGNAME 66 LOGNAME 71 LOGSIZE 74 LOGSIZE 66 LOGSIZE 71 M monbegin 89 monend 89 monts 96 N name 53 O Oracle ORACLE_HOME 51 ORACLE_SID 51 ORACLE_USER 51 ORACLE_USER 76 Oracle 4 HA 91 HA Oracle 80 Oracle 82 Oracle 81 Oracle 4 HA 91 HA

130 Oracle 83 Oracle 85 Oracle 84 P PATROL 52 PATROL_INTERVAL 74 PATROL_SHELL 77 patrolcommand 53 S start_timeout 53 stop_timeout 53 T termcommand 53 W waitserv_exec Oracle Oracle 13 Oracle 13 Oracle 13 Oracle Oracle

131 Oracle 30 Oracle 15 Oracle 18 Oracle 20 Oracle 26 Oracle 35 Oracle 31 Oracle 16 Oracle 22 Oracle 24 Oracle

Oracle Database 10gのOracle Data Guard

Oracle Database 10gのOracle Data Guard Oracle Database 10g Oracle Data Guard 2004 Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data