오라클 리스너 포트 추가

오라클 리스너 기본포트(1521) 이외에 신규 리스너 포트 추가

 

 

LISTENER.ORA

SID_LIST_LISTENER_9999
	(SID_LIST = 
  	(SID_DESC = 
    	(SID_NAME = ORCL)
      (ORACLE_HOME= /home/oracle)
    )
  )
ADR_BASE_LISTENER = /home/oracle/app

  
LISTENER = 
	(DESCRIPTION_LIST = 
  	(DESCRIPTION =
    	(ADDRESS = (PROTOCOL = TCP) (HOST = HOSTNM) (PORT = 1521))
    )
  )
  
LISTENER_9999 = 
	(DESCRIPTION_LIST = 
  	(DESCRIPTION =
    	(ADDRESS = (PROTOCOL = TCP) (HOST = HOSTNM) (PORT = 9999))
    )
  )

TNSNAMES.ORA

LISTENER_ORCL = 
	(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNM)(PORT = 1521))

LISTENER_ORCL2 = 
	(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNM)(PORT = 9999))
    
ORCL = 
	(DESCRIPTION =
  	(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNM)(PORT = 1521))
    (CONNECT_DATA =
    	(SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

ORCL_9999 = 
	(DESCRIPTION =
  	(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNM)(PORT = 9999))
    (CONNECT_DATA =
    	(SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )
  

리스너 재기동

  
lsnrctl START LISTENER_9999