HA kit for Oracle 3000-9-135
P-F9S2C-E1111 HA kit for Oracle 01-00 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 2011 6 3000-9-135 All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.
HA kit for Oracle HA HA kit for Oracle Oracle OS HA Oracle I
1 HA kit 1 1.1 HA kit 2 1.2 HA kit 3 1.3 HA kit 6 1.3.1 6 1.3.2 7 1.4 HA 9 2 11 2.1 12 2.1.1 12 2.1.2 13 2.2 14 2.2.1 15 2.2.2 18 2.2.3 26 2.2.4 30 2.2.5 32 3 39 3.1 40 3.1.1 Oracle 40 3.1.2 42 3.2 43 3.2.1 43 3.2.2 45 3.2.3 45 3.2.4 Oracle 47 3.2.5 Oracle 48 3.2.6 Oracle 49 3.2.7 HA kit 49 3.2.8 53 i
3.2.9 54 3.2.10 54 3.3 56 4 63 4.1 64 4.2 65 4.3 69 4.4 73 4.4.1 73 4.4.2 76 4.5 78 5 87 5.1 88 5.2 Oracle Oracle 89 5.3 Oracle Oracle HA 91 5.3.1 Oracle Oracle HA 91 5.3.2 Oracle Oracle HA 92 5.4 93 5.5 96 5.5.1 96 5.6 97 5.7 98 5.7.1 Oracle 98 5.7.2 Oracle Oracle 98 5.7.3 Oracle Oracle 99 5.7.4 Oracle Oracle 100 6 101 6.1 102 6.1.1 102 6.1.2 102 6.2 104 ii
115 A 116 A.1 116 A.2 116 A.3 116 A.4 KB 117 119 iii
1-1 HA kit 2 1-2 HA kit Oracle 3 1-3 HA kit 4 1-4 HA kit RAC 4 1-5 Oracle 5 1-6 7 1-7 HA 10 2-1 12 2-2 14 2-3 Oracle 15 2-4 Oracle 17 2-5 Oracle 19 2-6 Oracle 21 2-7 Oracle 23 2-8 Oracle 25 2-9 Oracle 27 2-10 Oracle 29 2-11 Oracle 30 2-12 Oracle 32 2-13 Oracle 33 2-14 Oracle 36 3-1 41 3-2 Oracle Oracle 41 3-3 Oracle Oracle 42 3-4 44 3-5 45 3-6 46 3-7 Oracle Oracle 56 4-1 65 4-2 69 iv
4-3 73 4-4 76 v
2-1 HA kit 13 2-2 HA 13 3-1 50 3-2 50 3-3 51 3-4 53 4-1 78 5-1 93 5-2 95 vi
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
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
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
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
1. HA kit Oracle 1-5 Oracle HA kit Oracle Oracle 3.1.1 Oracle 3 HA kit HA HA HA HA Linux(R) HA HA kit Oracle 5
1. HA kit 1.3 HA kit HA kit HA HA Linux(R) HA 1.3.1 HA kit HA HA Linux(R) HA kit 1 Oracle REDO Oracle Oracle 2 Oracle HA kit Oracle Oracle 3.2.4 Oracle 3 LAN 6
1. HA kit 1.3.2 HA kit 1 1-6 a Linux(x86) b HA HA kit HA HA c Oracle HA 2 7
1. HA kit ASM HA kit Oracle Clusterware Oracle Data Guard Broker Oracle RAC Oracle Restart 8
1. HA kit 1.4 HA HA kit HA HA kit HA Linux(R) HA kit HA kit HA HA HA 9
1. HA kit 1-7 HA 10
2 HA kit HA HA kit HA Linux(R) 2.1 2.2 11
2. 2.1 HA kit HA Oracle Oracle Oracle 2.1.1 HA kit Oracle Oracle HA HA 2-1 HA kit Oracle Oracle 3.2.7(2) 12
2. 2.1.2 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
2. 2.2 HA HA kit HA HA kit ID ID ID 2-2 2.2.2 5.2 Oracle Oracle 14
2. 2.2.1 Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 2-3 Oracle 15
2. 1 IP 3.1.2 3.2.6 Oracle 2 HA 3 HA kit Oracle SQL*Plus startup 4 Oracle Oracle 2 Oracle Oracle HA HA kit 16
2. 2-4 Oracle 1 IP 3.1.2 3.2.6 Oracle 17
2. 2 HA 3 HA kit Oracle lsnrctl start 4 Oracle Oracle 2.2.2 Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 18
2. 2-5 Oracle 19
2. 1 IP 3.1.2 3.2.6 Oracle 2 HA 2 Oracle Oracle HA HA kit 20
2. 2-6 Oracle 21
2. 1 IP 3.1.2 3.2.6 Oracle 2 HA 3 HA HA termcmd_at_abort use 4 Oracle Oracle 3 Oracle Oracle HA HA kit 22
2. 2-7 Oracle 1 IP 3.1.2 3.2.6 Oracle 23
2. 2 HA 4 Oracle Oracle HA HA kit 24
2. 2-8 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.2.3 Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 26
2. 2-9 Oracle 1 HA 2 HA kit Oracle SQL*Plus 27
2. shutdown transactional shutdown abort 3 Oracle Oracle 4 HA 5 IP 3.1.2 3.2.6 Oracle 2 Oracle Oracle HA HA kit 28
2. 2-10 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 Oracle Oracle HA HA kit Oracle Oracle 1 Oracle Oracle HA HA kit 2-11 Oracle 30
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 kit Oracle TNSLSNR 5 Oracle Oracle 2.2.5 Oracle Oracle HA HA kit Oracle Oracle 32
2. 1 Oracle Oracle HA HA kit 2-13 Oracle 33
2. 34
2. 1 HA 2 Oracle Oracle 3 IP 3.1.2 3.2.6 Oracle 4 HA 2 Oracle Oracle HA HA kit 35
2. 2-14 Oracle 36
2. 37
2. 1 HA 2 Oracle Oracle 3 IP 3.1.2 3.2.6 Oracle 4 HA 38
3 HA kit HA kit HA kit 3.1 3.2 3.3 39
3. 3.1 HA kit HA HA kit HA HA Linux(R) HA Oracle 3.1.1 Oracle HA HA kit Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle HA 40
3. 3-1 Oracle Oracle 3-2 Oracle Oracle 41
3. 3-3 Oracle Oracle 3.1.2 1 Oracle HA Oracle Oracle IP IP IP Oracle LAN Oracle Oracle LAN HA HA Linux(R) 2 HA Linux(R) 42
3. 3.2 HA kit HA HA Linux(R) 3.2.1 HA kit Oracle HA HA Linux(R) HA Linux(R) 43
3. 3-4 HA HA kit HA Linux(R) HA Linux(R) HA 44
3. HA Linux(R) Oracle HA Oracle Oracle HA Oracle Oracle HA kit HA kit 3.2.2 HA kit /opt/hitachi HA kit HAmonOra HA kit 3-5 3.2.3 HA kit 45
3. 3-6 46
3. 1. 3.2.7(1) 2. Oracle Oracle 3.2.7(2) 3. Oracle Oracle 3.2.7(2) 4. servers 3.1.1 Oracle 3.2.8 5. LAN IP IP 3.1.2 3.2.6 Oracle 3.2.4 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
3. 3.2.5 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
3. /etc/hosts 192.168.0.11 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/orcl1 3.2.6 Oracle Oracle Oracle HA HA Linux(R) LAN IP HA IP LAN HA Linux(R) LAN 3.2.7 HA kit Oracle HA kit HA kit 49
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
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
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 60 3600 DB_NOACCESS LISTENER_NOACCESS yes 10 3600 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
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 3.2.8 HA kit 3.1.1 Oracle HA HA Linux(R) servers 3-4 name acttype termcommand patrolcommand waitserv_exec group start_timeout stop_timeout 4.2 monitor 4.3 4.4.2 yes 3.1.1 Oracle HA termcmd_at_abort yes stop_timeout Oracle Oracle 53
3. 3.2.9 Oracle UAP UAP HA Linux(R) 3.2.10 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
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 /opt/hitachi/hamon/etc/orasrv/termcommand_orasrv /opt/hitachi/hamon/etc/orasrv/patrol_orasrv.sh 56
3. Oracle /home/oracle/product/10.2.0/db_1 2 /etc/hosts 192.168.100.1 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
3. LAN.up /opt/hitachi/hamon/etc/orasrv.up #! /bin/sh INTERFACE=eth0:1 IPADDR=192.168.100.1 NETMASK=255.255.255.0 BROADCAST=192.168.100.255 # 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
3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE=1048576 #################################################################### 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
3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE=1048576 #################################################################### 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
3. #! /bin/sh #################################################################### LOGNAME=orasrv LOGSIZE=1048576 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
4 4.1 4.2 4.3 4.4 4.5 63
4. 4.1 HA kit HA Linux(R) Oracle 5.4 64
4. 4.2 HA kit 3.2.7(1) act_proc() Oracle Oracle 4-1 1. 5. 1. (1) 2. Oracle haoralsnrbgn Oracle (2) haoralsnrbgn 4.5 65
4. haoralsnrbgn Oracle 3. Oracle haorainsbgn Oracle (2) haorainsbgn 4.5 haorainsbgn Oracle 4. (2) 5. act_proc() act_proc() (3) 1 4-1 1. LOGNAME orasrv 5.4 LOGSIZE 1048576 5.4(2) LOGNAME LOGSIZE 2 4-1 2. 4. 2. Oracle Oracle LISTENER Oracle 66
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
4. act_proc() 5.4 act_proc() LOGNAME LOGSIZE 68
4. 4.3 HA kit 3.2.7(1) term_proc() Oracle Oracle 4-2 69
4. 1. 4. 1. (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
4. 1 4-2 1. LOGNAME orasrv 5.4 LOGSIZE 1048576 5.4(2) LOGNAME LOGSIZE 2 4-2 2. 3. 2. Oracle Oracle orcl1 Oracle 2. Oracle 2. orcl1 orcl1 Oracle 3. Oracle Oracle LISTENER Oracle 3. Oracle 3. LISTENER LISTENER Oracle 71
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
4. 4.4 4.4.1 HA kit 3.2.7(1) patrol_proc() Oracle Oracle 4-3 1. 4. 1. (1) 73
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) 1 4-3 1. LOGNAME orasrv 5.4 LOGSIZE 1048576 5.4(2) LOGNAME LOGSIZE PATROL_INTERVAL 1 3600 5 74
4. 2 4-3 2. 3. 2. 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
4. patrol_proc() patrol_proc() 5.4 patrol_proc() LOGNAME LOGSIZE PATROL_INTERVAL 4.4.2 HA kit 3.2.7(1) 4-4 1. 1. (1) 1 4-4 1. ORACLE_USER 76
4. Oracle PATROL_SHELL 4.4.1 2 ORACLE_USER PATROL_SHELL 77
4. 4.5 4-1 haorainsbgn haorainsend haorainsptl haoralsnrbgn haoralsnrend haoralsnrptl Oracle Oracle Oracle Oracle Oracle Oracle 78
4. 79
4. haorainsbgn Oracle haorainsbgn HA kit Oracle 4.2 HA kit Oracle Oracle ORACLE_SID Oracle 0 Oracle 0 80
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
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
4. haoralsnrbgn Oracle haoralsnrbgn HA kit Oracle 4.2 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 0 83
4. haoralsnrend Oracle haoralsnrend HA kit Oracle 4.3 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 0 84
4. haoralsnrptl Oracle haoralsnrptl Oracle Oracle Oracle LISTENER_NOACCESS no 4.4 HA kit Oracle Oracle LISTENER_NAME Oracle 0 Oracle 1 Oracle 85
5 Oracle Oracle HA Linux(R) 5.1 5.2 Oracle Oracle 5.3 Oracle Oracle HA 5.4 5.5 5.6 5.7 87
5. 5.1 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
5. 5.2 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
5. Oracle Oracle Oracle HA Linux(R) 90
5. 5.3 Oracle Oracle HA HA kit Oracle Oracle HA Oracle Oracle Oracle Oracle Oracle Oracle Data Guard Oracle Data Guard Oracle Oracle HA 5.3.1 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
5. 5.3.2 Oracle Oracle HA HA Oracle Oracle HA HA kit HA Oracle Oracle 1. Oracle Oracle Oracle 2. Oracle Oracle IP HA 92
5. 5.4 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,576 1 93
5. 1 3 1 240+ Oracle Oracle 160 Oracle HA kit 2 60+ Oracle Oracle 170 Oracle HA kit 1 3 240+ Oracle Oracle 160 Oracle HA kit LOGSIZE 4. 1 2 3 1 2 3 3 Oracle 94
5. 1. HA kit ID KAMK00401-I HA kit 6.2 2. 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
5. 5.5 HA kit HA Linux(R) 5.5.1 HA kit HA kit HA monts HA HA HA Linux(R) HA kit 5.4 3.2.7(2) /opt/hitachi/hamon/etc 3.2.7(1) 96
5. 5.6 HA kit HA kit 5.5.1 HA kit Oracle Oracle Oracle Oracle Oracle Oracle Oracle Oracle 5.4 6. HA HA HA Linux(R) 97
5. 5.7 5.7.1 Oracle Oracle Oracle 1. monend 2. Oracle OS 3. Oracle Oracle 4. Oracle Oracle Oracle Oracle ORACLE_HOME 5. OS 6. monbegin 5.7.2 Oracle Oracle Oracle Oracle HA kit 1 Oracle Oracle 1. monend Oracle Oracle Oracle Oracle 2. 98
5. Oracle 3. Oracle Oracle 3.2.7(2) 4. Oracle Oracle 4. 5. monbegin 2 Oracle Oracle 3.2 Oracle Oracle 4. 5.7.3 Oracle Oracle Oracle Oracle HA kit 1. monend Oracle Oracle Oracle Oracle 2. Oracle Oracle 4. 3. Oracle Oracle 4. monbegin 99
5. 5.7.4 Oracle Oracle Oracle Oracle 1. monend Oracle Oracle 2. 4. 3.2.7(2) 3. monbegin 100
6 HA kit 6.1 6.2 101
6. 6.1 6.1.1 KAMKnnnnn-i xx...xx KAMKnnnnn-i ID xx...xx ID "yyyy/mm/ dd HH:MM:SS " 6.1.2 1 KAMKnnnnn-i X Message text aa...aa S O O 2 ID ID KAMK HA kit 102
6. nnnnn i E W I E W X P L syslog " " 103
6. 6.2 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
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
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
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
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
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
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
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
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
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
A 115
A A A.1 HA Linux(R) 3000-9-132 HA Linux(R) HA 3000-9-134 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
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,024 2 1,024 3 1,024 4 117
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 2 3 49 7 6 2 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 98 47 4 40 48 ORACLE_HOME 51 ORACLE_SID 51 ORACLE_USER 51 ORACLE_USER 76 Oracle 4 HA 91 HA 92 89 89 99 50 98 89 Oracle 80 Oracle 82 Oracle 81 Oracle 4 HA 91 HA 92 89 89 48 119
99 50 98 89 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 53 51 56 6 Oracle 49 5 54 45 3 54 75 73 50 67 65 72 69 93 44 54 Oracle 13 Oracle 13 Oracle 13 Oracle 13 13 13 12 96 13 14 Oracle 33 120
Oracle 30 Oracle 15 Oracle 18 Oracle 20 Oracle 26 Oracle 35 Oracle 31 Oracle 16 Oracle 22 Oracle 24 Oracle 28 50 50 53 45 95 51 42 42 42 6 121