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

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

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

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

 

 

Environment

Workload Automation AE

Resolution

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]