on
오라클 19c RAC 리스너 포트 변경 방법
오라클 19c RAC 리스너 포트 변경 방법
1번 노드
$ lsnrctl status
LSNRCTL for Linux: Version 19. 0. 0. 0. 0 - Production on 15 - AUG - 2021 06 : 36 : 01
Copyright (c) 1991 , 2019 , Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)( KEY = LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19. 0. 0. 0. 0 - Production
Start Date 15 - AUG - 2021 06 : 34 : 50
Uptime 0 days 0 hr. 1 min. 10 sec
Trace Level off
Security ON : Local OS Authentication
SNMP OFF
Listener Parameter File / ORA19 / app / grid / 19. 3. 0 / network / admin / listener.ora
Listener Log File / ORA19 / app / oracle / diag / tnslsnr / oel19db1 / listener / alert / log.xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc)( KEY = LISTENER)))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 192. 168. 200. 10 )(PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 192. 168. 200. 100 )(PORT = 1521 )))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1" , status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1" , status READY, has 1 handler(s) for this service...
Service "+ASM_OCR_VOTE" has 1 instance(s).
Instance "+ASM1" , status READY, has 1 handler(s) for this service...
Service "ORADB" has 1 instance(s).
Instance "ORADB1" , status READY, has 1 handler(s) for this service...
Service "ORADBXDB" has 1 instance(s).
Instance "ORADB1" , status READY, has 1 handler(s) for this service...
The command completed successfully
2번 노드
$ lsnrctl status
LSNRCTL for Linux: Version 19. 0. 0. 0. 0 - Production on 15 - AUG - 2021 06 : 36 : 22
Copyright (c) 1991 , 2019 , Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)( KEY = LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19. 0. 0. 0. 0 - Production
Start Date 15 - AUG - 2021 06 : 34 : 53
Uptime 0 days 0 hr. 1 min. 29 sec
Trace Level off
Security ON : Local OS Authentication
SNMP OFF
Listener Parameter File / ORA19 / app / grid / 19. 3. 0 / network / admin / listener.ora
Listener Log File / ORA19 / app / oracle / diag / tnslsnr / oel19db2 / listener / alert / log.xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc)( KEY = LISTENER)))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 192. 168. 200. 20 )(PORT = 1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 192. 168. 200. 200 )(PORT = 1521 )))
Services Summary...
Service "+ASM" 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_OCR_VOTE" has 1 instance(s).
Instance "+ASM2" , status READY, has 1 handler(s) for this service...
Service "ORADB" has 1 instance(s).
Instance "ORADB2" , status READY, has 1 handler(s) for this service...
Service "ORADBXDB" has 1 instance(s).
Instance "ORADB2" , status READY, has 1 handler(s) for this service...
The command completed successfully
from http://positivemh.tistory.com/745 by ccl(A) rewrite - 2021-08-14 22:00:42