일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 |
Tags
- 데이터베이스
- Database
- ogg
- diskgroup
- Opatch
- 데이터가드
- OracleGoldenGate
- oracle goldengate
- SILENTMODE
- Oracle
- 오라클설치
- oracle recovery
- adg
- 19c
- 디비투
- goldengate
- 티베로
- linux
- 오지지
- 오라클
- 오라클구조
- DataGuard
- ORACLE19C
- SSH
- oracle installation
- ActiveDataGuard
- 사일런트모드
- Installation
- Oracle 19c
- 오라클아키텍쳐
Archives
- Today
- Total
DoubleDBDeep
[ORACLE] SCAN IP 재설정 및 SCAN IP NAME(Interface명) 변경 본문
scan ip 재설정
rac-scan 10.0.5.192 , 192, 193 -> racdr-scan 10.0.5.194, 195, 196으로 변경
1. 기존 네트워크 정보 확인
$GI_HOME/bin/srvctl config scan
[rac1|root:/root]> $GI_HOME/bin/srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 10.0.5.0/255.255.255.0/enp0s3, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.0.5.191
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.0.5.192
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.0.5.193
SCAN VIP is enabled.
2. 기존 scan resource 확인
crsctl stat res -t | grep -E -A1 "SCAN|scan"
[rac1|root:/root]> crsctl stat res -t | grep -E -A1 "SCAN|scan"
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 STABLE
--
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
3. 기존 scan resource 중지
srvctl stop scan_listener
srvctl stop scan
# 확인
[rac1|root:/root]> crsctl stat res -t | grep -E -A1 "SCAN|scan"
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN2.lsnr
1 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN3.lsnr
1 OFFLINE OFFLINE STABLE
--
ora.scan1.vip
1 OFFLINE OFFLINE STABLE
ora.scan2.vip
1 OFFLINE OFFLINE STABLE
ora.scan3.vip
1 OFFLINE OFFLINE STABLE
4. scan ip 변경 - [root]
vi /etc/hosts
# scan
10.0.5.194 racdr-scan racdr-scan.localdomain
10.0.5.195 racdr-scan racdr-scan.localdomain
10.0.5.196 racdr-scan racdr-scan.localdomain
---------------------------------------------------------------------------
srvctl modify scan -n rac-scan
srvctl config scan
[rac1|root:/root]> srvctl modify scan -n rac-scan
[rac1|root:/root]> srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 10.0.5.0/255.255.255.0/enp0s3, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.0.5.194
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.0.5.195
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.0.5.196
SCAN VIP is enabled.
5. scan resource 시작 및 확인
srvctl start scan
srvctl start scan_listener
crsctl stat res -t | grep -E -A1 "SCAN|scan"
[rac1|root:/root]> srvctl start scan
[rac2|root:/root]> srvctl start scan_listener
[rac2|root:/root]> crsctl stat res -t | grep -E -A1 "SCAN|scan"
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 STABLE
--
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
scan ip interface명 재설정 (scan ip 이름 재설정)
1. 현재 scan ip 설정 확인
$ srvctl config scan
SCAN name: rac-scan, Network: 1
Subnet IPv4: 10.0.5.0/255.255.255.0/enp0s3, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.0.5.194
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.0.5.195
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.0.5.196
SCAN VIP is enabled.
2. scan resource 중지
srvctl stop SCAN_LISTENER
srvctl stop scan
3. scan ip name 변경
srvctl modify scan -n racdr-scan.localdomain
srvctl modify scan_listener -u
4. scan resource 재시작 및 확인
srvctl start SCAN_LISTENER
[racdr2|root:/root]> srvctl config scan
SCAN name: racdr-scan.localdomain, Network: 1
728x90
'ORACLE > Administration' 카테고리의 다른 글
[ORACLE] TDE 암호화 설정 (0) | 2023.07.13 |
---|---|
[ORACLE] INS-30132 PRVF-4008 PRVF-4098 | 노드간 SSH 비밀번호 없는 접속 설정 (0) | 2023.07.12 |
[ORACLE] dbca Node Sellection 에서 모든 노드가 뜨지 않는 경우 해결 (0) | 2023.05.03 |
[ORACLE] 19.3 -> 19.17 Grid & Oracle Database Patch | 오라클 19.17 수동 및 자동 패치 (0) | 2023.04.26 |
[ORACLE] 18c -> 19c RAC AutoUpgrade.jar 를 사용한 업그레이드 (0) | 2023.04.19 |