ORA-12637 Packet receive failed

Hi,

I understand that you have created a new RDS oracle 19c instance but you are unable to connect to it via SQL client getting error “ORA-12637 Packet receive failed”. Please correct me if I misunderstood.

You can start by checking the state of your Amazon RDS for Oracle DB instance.If the instance is in any state other than available, storage optimization, or backing-up, then you can't connect to the instance[1]. Secondly verify that you can connect to the database instance over the database port[2] by default oracle uses port 1521.For further assistance you can contact AWS Customer Support to review/validate or to get your instance available.

You can refer to the following documents on troubleshooting issues

Reference links:

[1]https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/

[2]https://aws.amazon.com/premiumsupport/knowledge-center/rds-oracle-connection-errors/

I hope you find this information useful.

Set the DISABLE_OOB_AUTO parameter in the client side sqlnet.ora file

Explanation:

New feature in 19c client that will trigger the server to Auto test if Out of Bound breaks are allowed on the network. This is on by default. So when the 19c client connects to the server it will trigger the server to test OOB. If the network underneath does not support the OOB, the connection will also fail and give ORA-12637 error.

Solution:

The True solution in this case would be to resolve the underlying network inability to handle Out of Bound packets. The network should support those in order to handle things like using a Control C to interrupt the communication between the client and server.

Workarounds (Use any one of the Two below):

1/ Set the DISABLE_OOB_AUTO parameter in the client side sqlnet.ora file. (Recommended) 2/ Set DISABLE_OOB=ON parameter in the sqlnet.ora file on the server.