- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ORA-00604: Error occurred at recursive SQL Level 1 when DB User is trying to change his expired pass
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.