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

Document ID : KB000049384
Last Modified Date : 14/02/2018
Show Technical Document Details

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]