RHEL 6.8/Oracle RAC 설치 무작정 따라하기-2

Oracle Clusterware installation

Environment setting

# vim .bash_profile
export ORACLE_BASE=/u01/app/baseexport ORACLE_HOME=/u01/app/grid/12c

Check the environment before installation

(Grid Package 안에 포함되어 있음 (/tmp/grid - 아래 압축 푼 위치))

# /tmp/grid/runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose>>/tmp/cluvfy.log
# /tmp/grid/runcluvfy.sh stage -pre crsinst -n node2,node1 -verbose

# /tmp/grid/runcluvfy.sh comp nodecon -n node1,node2 -verbose

RunInstaller (in GUI)

root로 로그인 하여, switching user를 통해 수행하면 진행이 되지 않는다.

grid로 로그인하여 진행해야 한다. (나만 이런건가 ㅡ.ㅡ;)

미리 약속한(?) Cluster 명과 SCAN 정보 입력

각 멤버 노드 정보 확인 및 추가

grid 계정 정보 입력 후 설정(setup)

네트워크 정보 선택

오래 헤메인 부분인데 ... (가이드를 제대로 읽지 않아서 ㅡ0 ㅡ;;;;)

base 디렉토리를 생성하거나, grid 디렉토리로 변경하거나 해야한다.

사전 준비 작업 중 "Check the available disk space" 단계 진행 할 때 ...

구성에서 많은 경우 root 스크립트를 수행하는 것을 기점으로 좀 바뀌는 듯 ...

(고로 요거 하면 거의 다 한 거 같다는 ~_~;

설치하다보니 Cluster Verification이 실패하는데, DNS에 SCAN 정보가 없어서 발생하는 이슈라고 확인됨.

(어느 고수 분의 사이트에서 본 듯한데 ... 기억이 ...)

Check the installation

[grid@node1 ~]$
ps –ef|grep ora[grid@node1 ~]$
ps –ef|grep d.bin
[grid@node1 ~]$ cd /u01/app/grid/12c/bin/[grid@node1 bin]$ ./olsnodesnode1node2
[grid@node1 bin]$ olsnodes -i -nnode1 1 node1vipnode2 2 node2vip
[grid@node1 bin]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online[grid@node1 bin]$ crsctl check cluster -all**************************************************************node1:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************node2:CRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online**************************************************************
[grid@node1 bin]$ crsctl stat res -t -init--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.asm 1 ONLINE ONLINE node1 Started,STABLEora.cluster_interconnect.haip 1 ONLINE ONLINE node1 STABLEora.crf 1 ONLINE ONLINE node1 STABLEora.crsd 1 ONLINE ONLINE node1 STABLEora.cssd 1 ONLINE ONLINE node1 STABLEora.cssdmonitor 1 ONLINE ONLINE node1 STABLEora.ctssd 1 ONLINE ONLINE node1 OBSERVER,STABLEora.diskmon 1 OFFLINE OFFLINE STABLEora.drivers.acfs 1 ONLINE ONLINE node1 STABLEora.evmd 1 ONLINE ONLINE node1 STABLEora.gipcd 1 ONLINE ONLINE node1 STABLEora.gpnpd 1 ONLINE ONLINE node1 STABLEora.mdnsd 1 ONLINE ONLINE node1 STABLEora.storage 1 ONLINE ONLINE node1 STABLE--------------------------------------------------------------------------------
[grid@node1 bin]$ crsctl stat resNAME=ora.LISTENER.lsnrTYPE=ora.listener.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2
NAME=ora.LISTENER_SCAN1.lsnrTYPE=ora.scan_listener.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.MGMTLSNRTYPE=ora.mgmtlsnr.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.VOTING.dgTYPE=ora.diskgroup.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2
NAME=ora.asmTYPE=ora.asm.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2
NAME=ora.cvuTYPE=ora.cvu.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.mgmtdbTYPE=ora.mgmtdb.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.net1.networkTYPE=ora.network.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2
NAME=ora.node1.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.node2.vipTYPE=ora.cluster_vip_net1.typeTARGET=ONLINESTATE=ONLINE on node2
NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=ONLINESTATE=ONLINE on node1
NAME=ora.onsTYPE=ora.ons.typeTARGET=ONLINE , ONLINESTATE=ONLINE on node1, ONLINE on node2
NAME=ora.scan1.vipTYPE=ora.scan_vip.typeTARGET=ONLINESTATE=ONLINE on node1
[grid@node1 bin]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora....ER.lsnr ora....er.type ONLINE ONLINE node1 ora....N1.lsnr ora....er.type ONLINE ONLINE node1 ora.MGMTLSNR ora....nr.type ONLINE ONLINE node1 ora.VOTING.dg ora....up.type ONLINE ONLINE node1 ora.asm ora.asm.type ONLINE ONLINE node1 ora.cvu ora.cvu.type ONLINE ONLINE node1 ora.mgmtdb ora....db.type ONLINE ONLINE node1 ora....network ora....rk.type ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip ora....t1.type ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node1 ora.ons ora.ons.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node1
Checking the SCAN configuration
[grid@node1 bin]$ cluvfy comp scan
Verifying SCAN
Checking Single Client Access Name (SCAN)...
Checking TCP connectivity to SCAN listeners...TCP connectivity to SCAN listeners exists on all cluster nodes
Checking name resolution setup for "ora12c"...
Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...All nodes have same "hosts" entry defined in file "/etc/nsswitch.conf"Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed

ERROR: PRVG-1101 : SCAN name "ora12c" failed to resolve
ERROR: PRVF-4657 : Name resolution setup check for "ora12c" (IP address: 10.254.251.251) failed
ERROR: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "ora12c"
Checking SCAN IP addresses...Check of SCAN IP addresses passed
Verification of SCAN VIP and listener setup failed
Verification of SCAN was unsuccessful on all the specified nodes.

ASM disk group creation

[grid@node1 bin]$ ls asmca