Problem on restricting host using sqlnet.ora in 9i
Folks,
Oracle 9i Rel 2 pach 3
OS Solaris 9
I am having a problem on restricting the access from the clients based on the host names. I have the following parameters set in my sqlnet.ora file
Code:
TCP.NODELAY=yes
TCP.VALIDNODE_CHECKING=yes
TCP.INVITED_NODES= (host1, host2,...)
After putting this entries in the sqlnet.ora, I was still being able to connect to the instances from the hosts that were not listed under the invited_nodes.
Some may say to restart the listener. I did that too, but still being able to connect to the instances from the hosts that were not listed under the invited nodes lists.
Rememeber this is 9i, so protocol.ora is obsolete in this.
Did anyone come across this problem? If so what was your solution? Any help would greatly be appreciated.
Thanx,
Sam
Thanx
Sam
Life is a journey, not a destination!