1

I'm using Oracle Client 12.1.0.2 and I need to generate client trace because im unable to connect my sql developer to the database server. However, i'm unable to generate the trace.

Here is my sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
TRACE_LEVEL_CLIENT = 16 
TRACE_FILE_CLIENT = client
TRACE_DIRECTORY_CLIENT = 'D:\app\client\product\12.1.0\client_1\network\admin'
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON
DIAG_ADR_ENABLED=OFF

I have the rights to write in the folder but unable to generate the logs.

I tried the same with net manager also.

But no luck.

Improve this question
2
  • 1
    SQL Developer uses (by default) the JDBC thin driver which does not use the TNS config files at all. What exactly is the error message you get when you try to connect?
    – user1822
    Commented Sep 7, 2015 at 12:35
  • Network IO adapter error. Oracle Support is asking for trace files and so Im trying.
    – tesla747
    Commented Sep 7, 2015 at 12:52

2 Answers 2

Reset to default
2

Add following line to sqlnet.ora:

adr_base=off

You should be able to find your traces then. Without it, all client traces go to %userprofile%\oracle\oradiag_%username% folder.

Improve this answer
1
  • tried and ain't working.
    – tesla747
    Commented Sep 7, 2015 at 12:29
1

Make sure you configure SQLDeveloper to use the installed Oracle Client and the OCI/Thick driver.

Tools / Preferences / Database / Advanced

Mark Use Oracle Client.
Browse the client home.
Mark Use OCI/Thick Driver.

Restart SQL Developer.

Since you have access to MOS, steps are shown here:

How to Use and Trace Oracle Net with SQLDeveloper (Doc ID 1991711.1)

Alternatively, you can use a different tracing method for SQLDeveloper:

How to generate a SQLNET trace with SQL Developer (Doc ID 1390063.1)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.