Wednesday, June 6, 2012

Limit Access to your Database

Its Simple Easy Way to Limit Access for your Database to Prevent People to miss Around , we all know there's File Called "sqlnet.ora" All you Have to do is Follow The Below Steps and Add what you want :

Sqlnet.ora : $ORACLE_HOME/network/admin


TCP.EXCLUDED_NODES

Purpose
Use the parameter TCP.EXCLUDED_NODES to specify which clients are denied access to the database.


Example
TCP.EXCLUDED_NODES=(finance.us.acme.com, mktg.us.acme.com, 144.25.5.25)

TCP.INVITED_NODES

Purpose
Use the parameter TCP.INVITED_NODES to specify which clients are allowed access to the database.
 This list takes precedence over the TCP.EXCLUDED_NODES parameter if both lists are present.

Example
TCP.INVITED_NODES=(sales.us.acme.com, hr.us.acme.com, 144.185.5.73)

TCP.VALIDNODE_CHECKING


 Purpose
Use the parameter TCP.VALIDNODE_CHECKING to check for the TCP.INVITED_NODES and TCP.
EXCLUDED_NODES to determine which clients to allow or deny access.

Example

TCP.VALIDNODE_CHECKING=yes
TCP.VALIDNODE_CHECKING=no



Simple Way to keep your database Clean . you maybe need to restart your Listener after this

Thank you
Osama Mustafa

5 comments:

  1. THx Mr oussama

    ReplyDelete
  2. your welcome , thank you for your comment

    ReplyDelete
  3. Great help
    Satti
    gallian_pak@yahoo.com

    ReplyDelete
  4. sqlnet.ora tcp.invited_nodes - what is limit to number of hosts

    ReplyDelete
  5. tcp.invited_nodes parameter must be include database machine ip or hostname if not include take this error.

    TNS-12547: TNS:lost contact
    TNS-12560: TNS:protocol adapter error
    TNS-00517: Lost contact
    Linux Error: 104: Connection reset by peer

    ReplyDelete