Enabling Oracle Client Side Logging 11g r1
Hi All,
have a two fold question.
How can you enable verbose logging on a Oracle Client? I would like to track all traffic from a server. It will be in a controlled single user envirionment
Secondly, I'm trying to find out what is causing one of our applications to randomly throw an error with the error details "Oracle Client and Network Compoents were not found". As we can not recreate the problem on demand it is very hard to chase down. Is there another more efficient way of trouble shooting this from a oracle point of view?
We are doing the std windows trouble shoot, just need assistance with the oracle side of this
Envirionment:-
Client
windows 2008 r2 (64)
Elderly VB application
Oracle Client 11.1.0.6 32bit
Server
AIX 6.1
Oracle 11g r1
Cheers
JL
have a two fold question.
How can you enable verbose logging on a Oracle Client? I would like to track all traffic from a server. It will be in a controlled single user envirionment
Secondly, I'm trying to find out what is causing one of our applications to randomly throw an error with the error details "Oracle Client and Network Compoents were not found". As we can not recreate the problem on demand it is very hard to chase down. Is there another more efficient way of trouble shooting this from a oracle point of view?
We are doing the std windows trouble shoot, just need assistance with the oracle side of this
Envirionment:-
Client
windows 2008 r2 (64)
Elderly VB application
Oracle Client 11.1.0.6 32bit
Server
AIX 6.1
Oracle 11g r1
Cheers
JL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- first of all, these question should be ask separately as it is 2 different question. this will allow more expert on those issue to assist you better. see the question tips: https://www.experts-exchange.com/questionTips.jsp
- for the components error, there are few suggestion to solve the problem in "How To Troubleshoot an ASP-to-Oracle Connectivity Problem" documentation. i understand that yours is VB application, i believe the method can also applied to both VB and ASP:
http://support.microsoft.com/kb/255084