ORA-12609 error causing database upgrade failure from 11.3.6 to R12

Products

• Autosys Workload Automation

Issue/Introduction

When attempting to upgrade an 11.3.6 schema to R12 using the installer or the CreateAEDB.pl script, the upgrade failed due to an  Oracle TNS timeout when attempting to create an index...

2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - CREATE INDEX xak4ujo_proc_event ON ujo_proc_event
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread -                                    *
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - ERROR at line 1:
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - ORA-12609: TNS: Receive timeout occurred
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - 
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - 
2021-06-11 10:49:55,393 [Thread-33] DEBUG com.ca.autosys.db.utils.CommandExecutorThread - Elapsed: 00:00:03.04

Environment

Release : All Supported Versions

Component : CA Workload Automation AE (AutoSys)

Resolution

Check the $TNS_ADMIN/sqlnet.ora file on the machine where you are performing the upgrade and see if any of these settings exist.

SQLNET.RECV_TIMEOUT=
SQLNET.OUTBOUND_CONNECT_TIMEOUT=
SQLNET.INBOUND_CONNECT_TIMEOUT=

These are setting timeouts on the Oracle client for sql connections. If these are set too low, it can cause timeouts during the install. The recommendation would be to increase or remove these parameters from the sqlnet.ora file for the duration of the install.