| Main Menu
Online
|
|
Posted by: admin on Sep 02, 2009 - 07:33 PM
Linux
|
For ENABLE restricted access :
Edit the sqlnet.ora file in $ORACLE_HOME/network/admin/ :
change "tcp.validnode_checking = yes" and "tcp.invited_nodes=(myhost,172.16.3.251)"
only "myhost" and host with ip "172.16.3.251" can connect to database.
this the content of sqlnet.ora file :
...
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = yes
tcp.invited_nodes=(myhost,172.16.3.251)
...
For DISABLE restricted access :
change "tcp.validnode_checking = no"
so, every client can connect to database.
this the content of sqlnet.ora file :
...
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = no
tcp.invited_nodes=(myhost,172.16.3.251)
...
You must restart the oracle listener to activated that new setting above, with the following command :
lsnrctl stop
lsnrctl start
---
Dedi
|
|
|
|
Login
|
