Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java
by David Coffin
Trace Oracle Client Code
Often you will have the experience during development that things are not working, and your application can't tell you what's wrong. The error is happening in the underlying protocol somewhere, and is hidden or obscured. You may even see misleading error messages.
At that point, you may have to call in the reserves, asking your network administrators to put a network sniffer on your subnet and capture packets to analyze; hopefully, you'll spot the problem.
However, before it comes to that, you have some options yourself, when dealing with Oracle database. You can turn on trace in your client to see that underlying protocol dialog between the client and the Oracle database. Simply set the trace level in the client sqlnet.ora ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access