I upgraded an Oracle RAC database from 12c to 19c. After a while, I identified that some jobs were having problems running. Therefore, I investigated and found out about the new default feature on the 19c client database that requires tests if Out of Bound breaks are allowed. Thus. Follow below the steps to handle this:
The first step was to check the alert.log, and the errors messages were as below:
opiodr aborting process unknown ospid (10883) as a result of ORA-609 2022-03-18T11:48:53.500198+01:00 …. ORA-00609: could not attach to incoming connection ORA-12637: Packet receive failed
I have also checked traces to understand more about the error, and this is what looked like:
…. Redo thread mounted by this instance: 1 Oracle process number: 89 Unix process pid: 10942, image: oracle@techdatabase1 *** 2022-03-18T11:49:06.167564+01:00 *** CLIENT ID:() 2022-03-18T11:49:06.167591+01:00 *** SERVICE NAME:() 2022-03-18T11:49:06.167600+01:00 *** MODULE NAME:() 2022-03-18T11:49:06.167608+01:00 *** ACTION NAME:() 2022-03-18T11:49:06.167615+01:00 *** CLIENT DRIVER:() 2022-03-18T11:49:06.167623+01:00 opiino: Attach failed due to ORA-12637
From now, you have two solutions: one that requires a network specialist and another that you can use as a workaround. The one that requires a network specialist is to contact them to solve the underlying network’s inability to handle Out of Bound packets. On the other hand, the other solution is DISABLE_OOB=ON in the SQLNET.ORA on the server and this solution follows below:
[oracle@techdatabasket admin]$ cat sqlnet.ora DISABLE_OOB=ON
I hope this post helps you! If you want to know more about it, check the following sources below:
Oracle 19c Client returns ORA-12637 when connecting to a 19c Database. Does not reproduce when
Oracle 19c Client returns ORA-12637 when connecting to a 19c Database. Does not reproduce when using an older client version. (Doc ID 2662778.1)
ORA-00609 and ORA-12547 Reported by JDBC Application After Upgrading To Database 19C (Doc ID 2813629.1)
https://docs.oracle.com/en/database/oracle/oracle-database/20/netrf/database-net-services-reference.pdf
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
… [Trackback]
[…] There you will find 46759 more Info on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Here you can find 39196 additional Information on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Read More to that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Find More on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Find More here on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Find More on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Read More Information here on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Find More on to that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Information to that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]
… [Trackback]
[…] Read More Information here on that Topic: techdatabasket.com/2022/04/11/ora-00609-could-not-attach-to-incoming-connection-ora-12637-packet-receive-failed/ […]