RAC 리스너 설정
DB CAFE
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
1 리스너 상태 조회[편집]
lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 22-OCT-2019 17:20:27
Copyright (c) 1991, 2017, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production Start Date 09-SEP-2019 19:55:51 Uptime 42 days 21 hr. 24 min. 36 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/12.2.0/gi_home/network/admin/listener.ora Listener Log File /oracle/app/grid/diag/tnslsnr/xxxx/listener/alert/log.xml Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.22.33.44)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.22.33.55)(PORT=1521)))
Services Summary... Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_MGMT" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "XXX" has 1 instance(s).
Instance "XXX2", status READY, has 1 handler(s) for this service...
Service "XXXDB" has 1 instance(s).
Instance "XXX2", status READY, has 1 handler(s) for this service...
Service "AAA" has 1 instance(s).
Instance "AAA2", status READY, has 1 handler(s) for this service...
Service "XXXX" has 1 instance(s).
Instance "XXXX2", status READY, has 1 handler(s) for this service...
The command completed successfully
2 리스너 추가[편집]
1. 리스너 추가하기
- 리스너명은 LISTENER2, 포트는 1571로 리스너를 추가합니다.
srvctl add listener -l LISTENER2 -p 1571
2. crsctl로 상태 확인 및 시작하기 [grid@rac1 ~]$ crsctl stat res -t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ora.LISTENER2.lsnr
OFFLINE OFFLINE rac1
srvctl start listener -l LISTENER2
2-1.리스너 Port 확인 netstat -an | grep 1555 tcp 0 0 192.168.80.163:1555 0.0.0.0:* LISTEN tcp 0 0 192.168.80.161:1555 0.0.0.0:* LISTEN
crsctl stat res -t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
ora.LISTENER.lsnr ONLINE ONLINE rac1 ora.LISTENER2.lsnr ONLINE ONLINE rac1 Dbcafe (토론)
3. lsnrctl로 상태 확인하기
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-AUG-2015 15:30:51 Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 06-AUG-2015 14:31:57 Uptime 0 days 0 hr. 58 min. 54 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/grid/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/base/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.161)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.163)(PORT=1521)))
Services Summary... Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
lsnrctl status LISTENER2
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-AUG-2015 15:30:59
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER2))) STATUS of the LISTENER
Alias LISTENER2 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 06-AUG-2015 15:30:37 Uptime 0 days 0 hr. 0 min. 22 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/grid/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/11.2.0/grid/log/diag/tnslsnr/rac1/listener2/alert/log.xml Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER2))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.161)(PORT=1555))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.163)(PORT=1555)))
The listener supports no services The command completed successfully
4 리스너 변경[편집]
1. 리스너 포트 변경하기 - 리스너명 LISTENER2의 포트를 1621로 변경합니다.
1) 리스너 중지
srvctl stop listener -l LISTENER2 -n rac1
2) 리스너 포트 변경
srvctl modify listener -l LISTENER2 -p 1621
3) 리스너 시작
srvctl start listener -l LISTENER2 -n rac1
4) 상태 확인
crsctl stat res -t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
ora.LISTENER.lsnr ONLINE ONLINE rac1 ora.LISTENER2.lsnr ONLINE ONLINE rac1 Dbcafe (토론)
netstat -an | grep 1621 tcp 0 0 192.168.80.163:1621 0.0.0.0:* LISTEN tcp 0 0 192.168.80.161:1621 0.0.0.0:* LISTEN
lsnrctl status listener2
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-AUG-2015 16:12:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER2))) STATUS of the LISTENER
Alias LISTENER2 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 06-AUG-2015 16:11:40 Uptime 0 days 0 hr. 0 min. 36 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/grid/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/11.2.0/grid/log/diag/tnslsnr/rac1/listener2/alert/log.xml Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER2))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.161)(PORT=1621))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.80.163)(PORT=1621)))
The listener supports no services The command completed successfully
5 database 재시작하기[편집]
- 리스너 추가나 포트 변경 이후 srvctl을 이용하여 리스너를 재기동해야 한다.
srvctl stop database -d racdb
srvctl start database -d racdb
6 client에서 접속하기[편집]
1. tnsnames.ora 정보
IDC_XXX = (DESCRIPTION = (LOAD_BALANCE = ON) (FAILOVER=ON) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.44)(PORT = 1561)) (ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.55)(PORT = 1561)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.55)(PORT = 1561)) (ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.44)(PORT = 1561)) ) (CONNECT_DATA = (SERVICE_NAME = XXX) (FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 3)(DELAY = 30)) ) )