Forum Stats

  • 3,874,758 Users
  • 2,266,769 Discussions


ORA-00604: Error occurred at recursive SQL Level 1 when DB User is trying to change his expired pass

Daniel Moses
Daniel Moses Member Posts: 10 Red Ribbon
edited Jan 31, 2019 4:17AM in Multitenant


The error accurs on a Pluggable database 12..1 when a user is trying to change his password after it was marked as expired by our security team:

ORA-00604: error occurred at recursive SQL level 1

ORA-06531: Reference to uninitialized collection

ORA-06512: at line 16

it happens on any platform (TOAD, SQL Developer) and command line also.

As DOCID 2232779.1 states , SYSLSBY_EDS_DDL_TRIG  and LOGMNRGGC_TRIGGER  triggers has been desable but the problem remains.

Those triggers are disable in the pluggable databas as well as in the container.

Any suggestions or ideas? Its clear that there is another trigger or procedure that is making noise.

Should any know which it is , please share.

Thank you.

Best regards