행위

"SCAN 리스너 재구성"의 두 판 사이의 차이

DB CAFE

(새 문서: == SCAN 리스너 재구성 방법 == * RAC1,2번 노드에 DNS를 재구성 한 후 SCAN IP를 오라클에서 권장하는 3개로 변경. === SCAN IP / LISTENER 의 Configuration...)
 
(→‎SCAN 리스너 재구성 방법)
 
1번째 줄: 1번째 줄:
 +
----
 +
 
== SCAN 리스너 재구성 방법 ==
 
== SCAN 리스너 재구성 방법 ==
 
* RAC1,2번 노드에 DNS를 재구성 한 후 SCAN IP를 오라클에서 권장하는 3개로 변경.
 
* RAC1,2번 노드에 DNS를 재구성 한 후 SCAN IP를 오라클에서 권장하는 3개로 변경.

2024년 5월 24일 (금) 00:05 기준 최신판

thumb_up 추천메뉴 바로가기

1 SCAN 리스너 재구성 방법[편집]

  • RAC1,2번 노드에 DNS를 재구성 한 후 SCAN IP를 오라클에서 권장하는 3개로 변경.

1.1 SCAN IP / LISTENER 의 Configuration 상태 확인[편집]

#> srvctl config scan
SCAN name: rac-scan.localdomain, Network: 1/192.168.1.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /rac-scan.localdomain/192.168.1.51

1.2 Local DNS에서 SCAN IP 접속 가능한지 확인[편집]

# host rac-scan
# nslookup rac-scan
rac-scan.localdomain has address 192.168.1.52
rac-scan.localdomain has address 192.168.1.53
rac-scan.localdomain has address 192.168.1.51

Server: 192.168.1.101
Address: 192.168.1.101#53
Name: rac-scan.localdomain
Address: 192.168.1.51
Name: rac-scan.localdomain
Address: 192.168.1.52
Name: rac-scan.localdomain
Address: 192.168.1.53

1.3 SCAN IP / LISTENER 중지[편집]

#> srvctl stop scan_listener
#> srvctl stop scan
#> crsctl stat res -t
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 OFFLINE OFFLINE
ora.scan1.vip
1 OFFLINE OFFLINE

1.4 SCAN LISTENER & IP 삭제[편집]

#> srvctl remove scan_listener
Remove scan listener? (y/[n]) y
#> srvctl remove scan
Remove the scan? (y/[n]) y

1.5 SCAN IP 등록[편집]

#> srvctl add scan -n rac-scan
#> srvctl config scan
SCAN name: rac-scan, Network: 1/192.168.1.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /192.168.1.53/192.168.1.53
SCAN VIP name: scan2, IP: /192.168.1.51/192.168.1.51
SCAN VIP name: scan3, IP: /192.168.1.52/192.168.1.52
  • PRCS-1016 : Failed to resolve Single Client Access Name rac-scan 에러가 발생 하면 "/etc/nsswitch.conf" 파일의 설정 확인.
  • /etc/nsswitch.conf


# Oracle RAC
hosts: dns files

1.6 SCAN LISTENER 등록[편집]

#> srvctl add scan_listener
#> srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

1.7 SCAN Listener & IP 실행[편집]

#> srvctl start scan
#> srvctl start scan_listener
#> crsctl stat res -t
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE rac1
ora.scan2.vip
1 ONLINE ONLINE rac1
ora.scan3.vip
1 ONLINE ONLINE rac1

1.8 OCR 백업 경로 확인[편집]

#> ocrconfig -showbackup

rac1 2012/12/07 07:35:33 /u01/app/11.2.0/grid/cdata/rac-scan/backup00.ocr
rac1 2012/12/07 03:23:30 /u01/app/11.2.0/grid/cdata/rac-scan/backup01.ocr
rac1 2012/12/06 23:11:29 /u01/app/11.2.0/grid/cdata/rac-scan/backup02.ocr
rac1 2012/12/06 23:11:29 /u01/app/11.2.0/grid/cdata/rac-scan/day.ocr
rac1 2012/12/06 23:11:29 /u01/app/11.2.0/grid/cdata/rac-scan/week.ocr

1.9 OCR Manual Backup[편집]

#> ocrconfig -export /u01/app/11.2.0/grid/cdata/rac-scan/manual_bk_121207_0946.ocr
# ls -al /u01/app/11.2.0/grid/cdata/rac-scan/manual*

-rw-r--r-- 1 root root 73130 Dec 7 09:47 /u01/app/11.2.0/grid/cdata/rac-scan/manual_bk_121207_0946.ocr
원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=SCAN_리스너_재구성&oldid=11681"