We are able to block/allow clients based on their IP address or host name
using oracle sqlnet.ora file which exist in
following path <in our case. follow as per your configuration>.
·
Go to
D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN and open sqlnet.ora file.
·
Insert the following lines.
# authentication, they will not be able to connect to the database on
NT.
SQLNET.AUTHENTICATION_SERVICES
= (NTS)
tcp.validnode_checking =
yes
#This turns on the hostname/IP checking for your listeners. After this
you can select list of host/IP # which you are allow to database connection.
tcp.invited_nodes = (localhost,
10.11.201.150, 10.11.201.200)
# This the list of host name or IP Address.
·
Now restart your listener.
Now you can try to connect your database from another IP Like
10.11.201.204 you can get error message.
No comments:
Post a Comment