Seeing ORA-02396 and ORA-01012 in RA logs
search cancel

Seeing ORA-02396 and ORA-01012 in RA logs

book

Article ID: 233871

calendar_today

Updated On:

Products

CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

Hi Team,

We are seeing ORA related errors in nolio_dm_all.log and because of this deployments are failing. This is happening in our production environment. Please look into this issue on priority.

2022-02-03T13:07:20.344Z [StageExecutorTask-26] WARN  (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143) - SQL Error: 2396, SQLState: 61000
2022-02-03T13:07:20.345Z [StageExecutorTask-26] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144) - ORA-02396: exceeded maximum idle time, please connect again

Environment

Release : 6.x

Component : CA Release Automation

DB: Oracle

Cause

The cause of issue, seems to be a configuration IDLE_TIME in Oracle DB profile used by RA, which is terminating the DB connection after xx(Idle time) minutes.

Resolution

Check with your DB and alter the profile with the IDLE_TIME set to a higher value or UNLIMITED

Powered by Wolken Software