리스너(Listener)관리

 

리스너 생성

srvctl add listener -l LISTENER_ADG -p 1525

srvctl add listener -l LISTENER_1526 -p 1526
srvctl add listener -l LISTENER_1527 -p 1527
srvctl add listener -l LISTENER_1528 -p 1528
srvctl add listener -l LISTENER_1529 -p 1529

srvctl add listener -l LISTENER -p 1521

$'sqlplus' "/as sysdba"

SQL> show parameter local_listener
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.48.99)(PORT=21521)))';
SQL> show parameter local_listener
SQL> alter system register;

 

리스너 삭제

srvctl remove listener -l LISTENER_ADG
srvctl remove listener -l LISTENER


srvctl stop listener -l LISTENER_1525
srvctl remove listener -l LISTENER_1525

 

리스너 포트 변경

srvctl stop listener -l LISTENER
srvctl modify listener -l LISTENER -p 1525
srvctl start listener -l LISTENER

 

리스너 상태&기동&중지 확인

 

-- All Node listener Down
srvctl status listener -l LISTENER
srvctl status listener -l LISTENER -n gftcp-oradb01

srvctl stop listener -l LISTENER
srvctl stop listener -l LISTENER -n gftcp-oradb01

srvctl start listener -l LISTENER
srvctl start listener -l LISTENER -n gftcp-oradb01

 

리스너 crs 정보 확인

crsctl stat res ora.LISTENER_1525.lsnr 
crsctl stat res ora.LISTENER_1525.lsnr -p
-- Port 정보 조회
crsctl stat res ora.LISTENER_1525.lsnr -p | grep PORT

 

리스너 DISABLE

crsctl modify resource "ora.LISTENER.lsnr" -attr "AUTO_START=never"
crsctl modify resource "ora.LISTENER_1526.lsnr" -attr "AUTO_START=never"
crsctl modify resource "ora.LISTENER_1527.lsnr" -attr "AUTO_START=never"
crsctl modify resource "ora.LISTENER_1528.lsnr" -attr "AUTO_START=never"
crsctl modify resource "ora.LISTENER_1529.lsnr" -attr "AUTO_START=never"

srvctl disable listener -l LISTENER_1526 -n rac-oradb01
srvctl disable listener -l LISTENER_1527 -n rac-oradb01
srvctl disable listener -l LISTENER_1528 -n rac-oradb01
srvctl disable listener -l LISTENER_1529 -n rac-oradb01

srvctl disable listener -l LISTENER_1526 -n rac-oradb02
srvctl disable listener -l LISTENER_1527 -n rac-oradb02
srvctl disable listener -l LISTENER_1528 -n rac-oradb02
srvctl disable listener -l LISTENER_1529 -n rac-oradb02

srvctl disable listener -l LISTENER_1526
srvctl disable listener -l LISTENER_1527
srvctl disable listener -l LISTENER_1528
srvctl disable listener -l LISTENER_1529

srvctl status listener -l LISTENER_1526 -n rac-oradb01
srvctl status listener -l LISTENER_1526 -n rac-oradb02
srvctl status listener -l LISTENER_1526 
srvctl status listener -l LISTENER_1527
srvctl status listener -l LISTENER_1528
srvctl status listener -l LISTENER_1529

srvctl enable listener -l LISTENER_1526 -n rac-oradb01
srvctl enable listener -l LISTENER_1527 -n rac-oradb01
srvctl enable listener -l LISTENER_1528 -n rac-oradb01
srvctl enable listener -l LISTENER_1529 -n rac-oradb01

srvctl enable listener -l LISTENER_1526 -n rac-oradb02
srvctl enable listener -l LISTENER_1527 -n rac-oradb02
srvctl enable listener -l LISTENER_1528 -n rac-oradb02
srvctl enable listener -l LISTENER_1529 -n rac-oradb02

srvctl enable listener -l LISTENER_1526
srvctl enable listener -l LISTENER_1527 
srvctl enable listener -l LISTENER_1528 
srvctl enable listener -l LISTENER_1529