Tuesday, September 28, 2010

RESTRICT TNS CONNECTION FOR CLIENT

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: