Oracle database connection fails. ORA-00604 & ORA-30511

book

Article ID: 49384

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

Description:

In cases where the Scheduler connection fails with the following errors:
Oracle Logon Error: ORA-65535 and ORA-00001

and attempts to logon to the database using the CA Workload Automation AutoSys database user fails with the following errors:
ORA-00604: error occurred at recursive SQL level 1
ORA-30511: invalid DDL operation in system triggers

Solution:

Disabling or purging the Oracle recycle bin will resolve the problem. For more information, see Oracle technical document:

Logon Trigger Fails with ORA-30511 [ID 742698.1]

Environment

Release: ATSAGE99000-11.3-Workload Automation AE-Remote Agent
Component: