Trace Net8

[Carlos]

When I set up sqlnet.ora for trace, I don

 

[Marco Kalter]

If you set the TRACE_LEVEL_CLIENT key in the sqlnet.ora file to USER or ADMIN, you will get a sqlnet.trc file in the default directory of your program with the trace information. Is this what you want to accomplish?

------------------
Marco Kalter
Allround Automations

 

[Carlos]

Hi Marco,

I set up this parameters in sqlnet.ora file:

TRACE_LEVEL_CLIENT = 16
TRACE_FILE_CLIENT = ora_1400
TRACE_DIRECTORY_CLIENT = d:\temp
TRACE_UNIQUE_CLIENT = TRUE

I made a test using BDE and this parameters in sqlnet.ora file and I got a ".trc" file, but when I use DOA I get no .trc file.

Thank you in advance.

 

[Marco Kalter]

If the BDE produces a trace file and Direct Oracle Access does not, then it is probably using a different version of SQL*Net or Net8. You can check the oracle registry key, oracle home directory, SQL*Net or Net8 DLL, OCI version, and Server version by calling ShowDOAInfo(Session) after making a connection to the database.

------------------
Marco Kalter
Allround Automations