ORA-20005 error occurs after a patch or version upgrade of RSA Identity Governance & Lifecycle during migration
Originally Published: 2019-05-22
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.0, 7.1.0, 7.1.1
Issue
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 17079
ORA-06512: at "AVUSER.STATISTIC_OPERATIONS", line 281
ORA-06512: at "AVUSER.DATABASE_STATISTICS", line 345
ORA-06512: at line 2
Cause
Resolution
- Login to SQL*Plus as avuser and run the following query:
EXEC DBMS_STATS.unlock_schema_stats('AVUSER');
- Once this is done, you may need to restart the RSA Identity Governance & Lifecycle application:
acm restart
Related Articles
How to update a Windows Web Express 1.2.1 to the latest patches Number of Views Simple migration from RSA Authentication Manager 7.1 to version 8.1 or higher Number of Views Upgrade to RSA Identity Governance & Lifecycle 7.0.2 fails with message "Error occurred when determining the version of th… Number of Views Can an upgraded RSA SecurID Access Identity Router be rolled back to a previous version? Number of Views How to determine which firmware version is on an RSA SecurID SID800 authenticator Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
