ORA-20005 error occurs after a patch or version upgrade of RSA Identity Governance & Lifecycle during migration
Originally Published: 2019-05-22
Last Modified: 2022-06-20
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
Patch or upgrade running long in step ACM-105090.sql in RSA Identity Governance & Lifecycle 91Number of Views After upgrade of the RSA Identity Governance and Lifecycle 7.0.1 IBM Tivoli Identity Manager (ITIM) agent to 7.0.1, the ag… 34Number of Views How to determine the version and patch level of RSA Identity Governance & Lifecycle 48Number of Views Patching to version 7.5.2 P04 and above shows initialization error ORA-31011: XML parsing failed in RSA Governance and Lif… 120Number of Views Upgrade of RSA Governance and Lifecycle from 7.0.0 to 7.0.1 fails with Checking database... Invalid Username/Password 241Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?