RESTRICT TNS CONNECTION FOR CLIENT :
====================================
TARGET SERVER : VIS
CLIENT SERVER : SAMPLE.DOYEN.IN
SCENARIO :
=========
STEP 1 : We are restricting the TNS Access for the VIS server and Permitting only the SAMPLE.DOYEN.IN server.
STEP 2 : Add the Below entry in the sqlnet.ora file in the VIS Server.
STEP 3 : Restart the Listener in the VIS Server
STEP 4 : Now check connecting from some other server ex. TEST.DOYEN.IN it will says "TNS CONNECTION CLOSED".
STEP 5 : IF you connect from the SAMPLE.DOYEN.IN it will connect.
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = yes
tcp.invited_nodes=(sample.doyen.in,192.168.2.143)
No comments:
Post a Comment