Using Oracle Net Server to Trace the Archiver Process
Last updated on SEPTEMBER 18, 2016
Applies to:Oracle Net Services - Version 18.104.22.168.0 to 22.214.171.124 [Release 9.2 to 11.2]
Information in this document applies to any platform.
During archive log shipment between primary and standby databases, the archiver process can fail with Oracle Net related errors such as Tns-12571, Ora-3113, Ora-3135, Ora-3136,etc.
Oracle Net server tracing can be enabled to help narrow down / resolve the point of failure. This is done by editing the SQLNET.ORA file being used for the Oracle home / Databases. The drawback is that database background processes only read the SQLNET.ORA file when they are created. This means the database needs to be restarted and that all database background processes and all connections to the database will be traced as well. And untill such time as the processes are stopped and the database shutdown, they will continue to trace.
This document explains how to workaround this issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms