Hi,
We are receiving below error in oracle database.
2017-07-05 23:24:27.156000 -07:00
opiodr aborting process unknown ospid (20121) as a result of ORA-609
opiodr aborting process unknown ospid (20123) as a result of ORA-609
opiodr aborting process unknown ospid (20119) as a result of ORA-609
opiodr aborting process unknown ospid (20125) as a result of ORA-609
opiodr aborting process unknown ospid (20129) as a result of ORA-609
opiodr aborting process unknown ospid (20135) as a result of ORA-609
opiodr aborting process unknown ospid (20131) as a result of ORA-609
opiodr aborting process unknown ospid (20133) as a result of ORA-609
opiodr aborting process unknown ospid (20127) as a result of ORA-609
opiodr aborting process unknown ospid (20137) as a result of ORA-609
Findings
The ORA-609 error is thrown when a client connection of any kind failed to complete or aborted the connection process before the server process was completely spawned.
Entry found in the listener log file.
<msg time='2017-07-05T23:24:10.901-07:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='amdtbh0'
host_addr='168.189.41.175'>
<txt>05-JUL-2017 23:24:10 * (CONNECT_DATA=(SID=EQ5)(GLOBAL_NAME=EQ5.WORLD)(CID=(PROGRAM=D:\Program?Files??x86?\Nimsoft\probes\database\oracle\oracle_monitor.exe)(HOST=SNSPVW105)(USER=SYSTEM))) * (
ADDRESS=(PROTOCOL=tcp)(HOST=168.189.245.20)(PORT=62542)) * establish * EQ5 * 0
</txt>
http://www.dba-oracle.com/t_ora_609_opiodr_aborting_process_unknown_ospid.htm
In above link, it says
" If the problem is due to connection timeouts, and increase in the following parameters should eliminate or reduce the occurrence of the ORA-609 error."
Could you please tell me how to confirm whether the problem is due to connection timeouts or reduce the occurrence of the ORA-609 error?
Oracle --11.2.0.4.0
OS -- HP-UX
This is standalone database.
Regards,
Balaji.C