SQL upgrade script to update the AAI Oracle database gets timed out

Products

• Automation Analytics & Intelligence

Issue/Introduction

After upgrading the AAI binary when attemtping to run the Oracle SQL upgrade script it times out while trying to create the index xie12jobrun 

Environment

AAI 6.5.x

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/upgrade