5 Replies Latest reply on Jan 31, 2019 9:17 AM by Praveen Ch-Oracle

    ORA-00604: Error occurred at recursive SQL Level 1 when DB User is trying to change his expired password. Any suggestions?

    Daniel Moses

      Hi,

       

      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

       

      Daniel