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 ...
Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
