Adsense Ad

Thursday, 16 March 2017

Giving access of Oracle DB to selected users by their IP Address

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: