Showing posts with label oracle login from IP address. Show all posts
Showing posts with label oracle login from IP address. Show all posts

Wednesday, September 22, 2010

How to enable IP filtering for oracle login?

Modify $TNS_ADMIN/sqlnet.ora:

tcp.validnode_checking = YES
tcp.invited_nodes = ( X.X.X.X, hostname, ... )
tcp.excluded_nodes = ( hostname, X.X.X.X, ... )