Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

New connections to database are getting dropped and host CPU is reaching 100% for few secs

User_5XHV2Jan 7 2022

New connections to database are getting dropped and host CPU is reaching 100% for few secs and CPU is coming down to 5% post connection dropped. This is intermittent and there is no pattern.

Getting below errors in alert log:
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
2022-01-02T01:55:01.385605+00:00
opiodr aborting process unknown ospid (8446) as a result of ORA-609
2022-01-02T01:55:01.406238+00:00
Errors in file /rdsdbdata/log/diag/rdbms/bone_b/BONE/trace/BONE_ora_8446.trc:
ORA-00609: could not attach to incoming connection
ORA-12560: TNS:protocol adapter error
2022-01-02T01:56:03.544865+00:00
opiodr aborting process unknown ospid (8446) as a result of ORA-609
2022-01-02T01:55:01.406238+00:00
2022-01-06_08h09_00.png
This is AWS RDS Oracle instance. Any clues why this is happening and how to avoid this?

Comments
Post Details
Added on Jan 7 2022
0 comments
304 views