Oracle Listener 설정

오라클 default 포트(1521) 외 리스너 구성이 필요할때 참고

 

Oracle LISTENER 설정
 
--#############################
1. 동적 LISTENER 설정
-. local_listener 사용.
--#############################
(1) initSID.ora 설정
local_listener='TESTDB_LOCAL'
 
(1-2) tnsnames.ora 설정
TALMDB_LOCAL = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1580))
 
(2) lsnrctl status 결과 - READY
Services Summary...
Service "TESTDB" has 1 instance(s).
  Instance "TESTDB", status READY, has 1 handler(s) for this service...
 
[참고] 동적등록
ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=5300))' SCOPE=MEMORY;
ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=5300))'
                  ,'(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=5301))' SCOPE=MEMORY;
 
--#############################
2. 정적 LISTENER 설정
-. listener.ora 파일에 직접 서비스를 등록
--#############################
(1) listener.ora 설정
 
SID_LIST_LISTENER_TESTDB =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = TESTDB)
      (ORACLE_HOME = /oracle/db/19)
      (GLOBAL_DBNAME = TESTDB)
    )
  )
 
LISTENER_TESTDB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 5300))
    )
  )
 
(2) lsnrctl status 결과 - UNKNOWN
Services Summary...
Service "TESTDB" has 1 instance(s).
  Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service...
 
 
--#############################
3. RAC LISTENER 설정
--#############################
(1) 리스너 추가
srvctl add listener -l LISTENER_TESTDB -p 1590
 
(2) 리스너 기동
srvctl start listener -l LISTENER_TESTDB
srvctl start listener -l LISTENER_TESTDB -n hostname
 
(3) 리스너 중지
srvctl stop listener -l LISTENER_TESTDB -n hostname
 
(4) 포트 변경
srvctl modify listener -l LISTENER_TESTDB -p 1591
 
(5) local_listener 설정 확인
ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1591))' SCOPE=MEMORY;