opiodr aborting process unknown ospid (24117442) as a result of ORA-609

来源:互联网 发布:淘宝实拍保护平台 编辑:程序博客网 时间:2024/05/25 13:33
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;