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
RSA-2021-03: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities 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 How to download RSA Web Threat Detection patches and version upgrades on RSA Link Number of Views Upgrade of RSA Identity Governance and Lifecycle from earlier versions to 7.0.2 fails during WildFly configuration phase. Number of Views RSA-2023-03: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
