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.
Printable View
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.
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.
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 ?