turning on server side SQLNet tracing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: turning on server side SQLNet tracing

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Unhappy

    Oracle 8.1.5 on COmpaq TRU64 Server

    We are experiencing ora-03113 End-of-File Communication error from different PL/SQL processes !

    Can someone tell me how to turn on SQLNet/Net8 logging/tracing on the server-side?

    Thanks in advance.

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    You should set:

    trace_level_server= (USER,ADMIN or SUPPORT)
    trace_file_server
    trace_directory_server
    log_level_server=(USER, ADMIN)
    log_directory_server
    log_file_server

    variables in you sqlnet.ora file on the server. Be careful with SQL*Net tracing. The trace file supposed to be very large on the server and you can get worse performance.

    Sergey.

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    We don't have a sqlnet.ora on our server right now; is it not needed ??

    And, to set logging and tracing on, do I create the file sqlnet.ora in the approp. dir and set the parameters. Do I need to recycle the DB ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width