Home » RDBMS Server » Networking and Gateways » controlling database access (db 10gr2)
controlling database access [message #483435] Mon, 22 November 2010 02:15 Go to next message
kamransagri
Messages: 13
Registered: May 2006
Location: india
Junior Member
hi,

i want to restrict particular ips ,for that i specified
TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)

in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),

kindly help me out.

thanks.

Report message to a moderator

Re: controlling database access [message #483438 is a reply to message #483435] Mon, 22 November 2010 02:35 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Of course, you INVITED this address to connect.
If you want to EXCLUDE this address then use TCP.EXCLUDED_NODES.

Regards
Michel

Report message to a moderator

Previous Topic: ORA-12505
Next Topic: Bind 1 Listener on 2 Interfaces
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 20:17:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.