참고글 및 문제해결/문제해결

RAC환경, ORACLE Engine설치중 PRVF-4555오류및 rac2 노드에 vip가 구성되지 않는 경우 생성해주기; rac2에 vip구성하기, ora....C2.lsnr, ora.rac2.vip, PRKO-2310

에몽이ㅋ 2012. 4. 25. 03:37
환경 : OEL, 11gR2
참고사이트 : 
http://surachartopun.com/2010/01/11gr2-add-vip-to-node.html 


요약
0. rac환경에서 oracle engine설치중 '노드 응용 프로그램 존재여부' 실패(위 스크린샷)
1. 상황확인
2. rac2에 vip 구성설정시도  (srvctl config vip -n rac2)  >> Failed 
3. rac2 노드에 vip서비스를 생성 (srvctl add vip -n rac2 -A 192.168.0.116/255.255.255.0/eth0 -k 1)
4. rac2 노드에 vip서비스 시작  (srvctl start vip -n rac2)
5. 이후 상황확인 (crs_stat -t, 4번 실행하자마자 ONLINE이 되는게 아니기 때문에 30초 정도 기다렸다가 확인해주세요)
6. 다시 처음부터 엔진설치를 진행



1. 상황확인
(보시면 ora.rac2.vip 서비스가 아예 존재하지 않는다는 것을 확인할 수 있습니다.
그로인해 ora.rac2.LISTENER_RAC2.lsnr상태도 OFFLINE)
[root@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2
ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac1
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2
ora.gsd        ora.gsd.type   ONLINE    ONLINE    rac1
ora....network ora....rk.type ONLINE    ONLINE    rac1
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    OFFLINE    OFFLINE    << 문제
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2


2. rac2에 vip 구성설정시도  (srvctl config vip -n rac2)  >> Failed
[oracle@rac2 ~]$ srvctl config vip -n rac2
PRKO-2310 : VIP가 rac2 노드에 존재하지 않습니다.


3. rac2 노드에 vip서비스를 생성(192.168.0.116은 rac2-vip입니다.)
[oracle@rac2 ~]$ su
암호:
[root@rac2 oracle]# srvctl add vip -n rac2 -A 192.168.0.116/255.255.255.0/eth0 -k 1


4. rac2 노드에 vip서비스 시작
[root@rac2 oracle]# srvctl start vip -n rac2


5. 이후 상황확인
[root@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2
ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac1
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2
ora.gsd        ora.gsd.type   ONLINE    ONLINE    rac1
ora....network ora....rk.type ONLINE    ONLINE    rac1
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2

모든 서비스가 OFFLINE없이 시작되었음을 확인하세요.

6. 다시 처음부터 엔진설치를 진행하면 해당 오류가 사라집니다.



위 환경에 쓰인 IP주소들

/etc/hosts 파일
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
192.168.0.15 rac1
192.168.0.16 rac2
192.168.79.130 rac1-priv
192.168.79.131 rac2-priv
192.168.0.115 rac1-vip
192.168.0.116 rac2-vip
192.168.0.30 rac-cluster-scan

rac1 (node1)
[root@rac1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=none
BROADCAST=192.168.0.255
HWADDR=00:0C:29:47:D7:2F
IPADDR=192.168.0.15
NETMASK=255.255.255.0
NETWORK=192.168.0.0
ONBOOT=yes
TYPE=Ethernet
GATEWAY=192.168.0.1
USERCTL=no
IPV6INIT=no
PEERDNS=yes

[root@rac1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth1
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth1
BOOTPROTO=none
HWADDR=00:0C:29:47:D7:39
ONBOOT=yes
DHCP_HOSTNAME=rac1
TYPE=Ethernet
IPADDR=192.168.79.130
NETMASK=255.255.255.0
USERCTL=no
IPV6INIT=no
PEERDNS=yes

rac2 (node2)
[root@rac2 oracle]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
HWADDR=00:0c:29:f4:43:91
NETMASK=255.255.255.0
IPADDR=192.168.0.16
GATEWAY=192.168.0.1
TYPE=Ethernet
USERCTL=no
IPV6INIT=no
PEERDNS=yes

[root@rac2 oracle]# cat /etc/sysconfig/network-scripts/ifcfg-eth1
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth1
BOOTPROTO=none
ONBOOT=yes
HWADDR=00:0c:29:f4:43:9b
NETMASK=255.255.255.0
IPADDR=192.168.79.131
TYPE=Ethernet
USERCTL=no
IPV6INIT=no
PEERDNS=yes