Configure IP address access restrictions for Oracle 11g

Configure IP address access restrictions for Oracle 11g

For data security considerations, make some restrictions on the IP address of the Oracle database. Only a fixed IP address can be accessed.

Modify the $ JAVA_HOME/NETWORK/ADMIN/sqlnet. ora File

Add the following content (marked in red ):

# Enable ip address Restriction
Tcp. validnode_checking = yes
# List of IP addresses allowed to access the database. Separate multiple IP addresses with commas
Tcp. invited_nodes = (192.168.1.110)
# List of IP addresses that are prohibited from accessing the database. Separate multiple IP addresses with commas (,).
Tcp. excluded_nodes = (192.168.1.111)

Restart the listener.

Note:

1. The first line must be written. Any platform can, but only applies to TCP/IP.

2. Write any row in the second and third rows. If both tcp. invited_nodes and tcp. excluded_nodes both exist, tcp. invited_nodes is used as the primary node.

3. Do not disable the IP address of the local server. Otherwise, the listener cannot be started or stopped through lsnrctl because the listener accesses the listener through the local IP address.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian