Skip to Main Content

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

Daniel MosesNov 5 2018 — edited Jan 31 2019


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


Post Details
Added on Nov 5 2018