Friday 7 October 2011

Secure DB network config

Secure db settings

listener.ora

# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools (NOT, ni).

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = N1DB.plum)
(ORACLE_HOME = /u01/oracle/product/10.2.0)
(SID_NAME = N1DB)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.185.40.40)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
ADMIN_RESTRICTIONS_LISTENER=ON
PASSWORDS_LISTENER=mypass


sqlnet.ora

TCP.VALIDNODE_CHECKING=YES
TCP.INVITED_NODES=(80.185.40.80,80.185.40.80)

No comments: