1. Adding some parameters into sqlnet.ora( both server and client).
DIAG_ADR_ENABLED = off # Diable ADR if version 11g
TRACE_LEVEL_SERVER = 16 # Enable level 16 trace
TRACE_TIMESTAMP_SERVER = ON # Set timestamp in the trace files
TRACE_DIRECTORY_SERVER = <DIRECTORY> # Control trace file location
TRACE_FILELEN_SERVER = 20480 #Control size of trace set in kilobytes eg 20480
TRACE_FILENO_SERVER = 1 #Control number of trace files per process
alter session set events '609 errorstack(3)';
alter session set events '609 off';
2. 还有一种可能导致这样的问题,就是linstener.log 文件已经超过了2G ,这个要根据自己机器平台不同来区分。
show parameter control_file;
show parameter remote_listener;