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
After upgrade of the RSA Identity Governance and Lifecycle 7.0.1 IBM Tivoli Identity Manager (ITIM) agent to 7.0.1, the ag… 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 Cannot log on to Microsoft Windows 8.1 with RSA Authentication Agent 7.3.x for Windows after Windows update is applied usi… Number of Views RSA Authentication Agent 7.3.3 for Windows prompt does not appear after the first reboot of Windows 10 when McAfee SafeBoo… Number of Views Edit, Restart CM, Reboot Appliance and Shutdown Appliance buttons under the Admin > System > Appliance tab are deprecated … Number of Views
Trending Articles
RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Upgrade Internal SHA-1 Certificates to SHA-256 in Authentication Manager Using rsautil RSA Authentication Manager 8.9 Setup and Configuration Guide RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows
Don't see what you're looking for?
