DB Load utilizing Oracle fails with TNS-04610.

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation
• CA Automic Operations Manager
• CA Automic Oracle

Issue/Introduction

DB Load fails during the upgrade process with the following message:

20200823/100359.291 - 1      U00003545 UCUDB: Opening database ...
20200823/100359.420 - 1      U00003611 DB OPEN executed. Return Code = '17002'
20200823/100359.421 - 1      U00003590 UCUDB - DB error: '08006', 'IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair', '17002', 'java.sql.SQLRecoverableException'
20200823/100359.422 - 1      U00032031 Error when connecting to Database
(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PRO
TOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))

 

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The sqlDriverConnect= string included a line break:

(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PRO

TOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))

Once this was corrected to:

(DESCRIPTION = (ENABLE = BROKEN) (ADDRESS_LIST = (LOAD_BALANCE = OFF)(FAILOVER = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_01)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_02)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SERVICE_NAME) (FAILOVER_MODE = (TYPE = SESSION)(METHOD = BASIC)(RETRIES = 20)(DELAY = 30))))

The DB Load was able to perform.