 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Network Security
The next task is to place the following
parameters on the file sqlnet.ora in the TNS_ADMIN directory of the
second home, located in /u02/oracle/product/9.2/network/admin.
tcp.validnode_checking = yes
tcp.excluded_nodes = (enrollment1, enrollment2)
tcp.invited_nodes = (claims1, claims2)
These lines are not present in the file
sqlnet.ora under the directory
/u01/oracle/product/9.2/network/admin.
The next step is to configure two listeners.
Since they should be listening on separate ports, we will configure
a listener that allows unrestricted access as listener1, listening
on port 1521. The other listener will be named listener2 and will
listen on port 1526. On the first Oracle Home, under the directory
for TNS_ADMIN, typically /u01/oracle/product/9.2/network/admin,
modify the file listener.ora to look like the following.
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = claimdbsvr1)
(PORT = 1521)
)
)
)
)
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
download of working security scripts:
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
