oracle listener ip

oracle listener ip

SQLNET.ORA ip

--------------------------------------------------------------------------------

# SQLNET.ORA Network Configuration File: /oracle/10g/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

#sqlnet.expire_time=1

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

tcp.validnode_checking = yes 

# tcp.invited_nodes=(접속을 허용할 ip) 

# tcp.excluded_nodes=(접속을 차단할 ip)

tcp.excluded_nodes = ( xxx.xxx.xxx.xxx )

--------------------------------------------------------------------------------

listener restart

lsnrctl 

LSNRCTL> help

LSNRCTL> start

 

LSNRCTL> stop

 

LSNRCTL> reload

LSNRCTL> status