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
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)
Merci pour l’information.
Cordialement
Luc