Re: The history of a -probably- 13 years old Oracle bug: TNS Poison

[laurenz.albe () wien gv at]

I wanted to comment on the workarounds for this problem:

1) Setting SQLNET.ENCRYPTION_SERVER=REQUIRED on the server is not enough to protect you.
   To avoid "man in the middle" attacks, you need to have an SSL certificate on
   the server and SSL_SERVER_DN_MATCH=TRUE in the client's sqlnet.ora.

2) Another way to protect yourself in Oracle 11.1 or better is to configure the listener
   to only accept registration requests from the local machine by adding
   SECURE_REGISTER_<listener>=(IPC) to listener.ora.
   The databases must be configured with LOCAL_LISTENER='(ADDRESS=(PROTOCOL=IPC)(KEY=<like in listener.ora>))'

Yours,
Laurenz Albe