Let’s have look on Oracle error ORA-06512 in 12c Cloud. Below we have mentioned the steps which are used to solve this issue.
We got below error while installing OEM 12c Cloud control.
Error:
INFO: oracle.sysman.top.oms:ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1547 INFO: oracle.sysman.top.oms:ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1547 INFO: oracle.sysman.top.oms:Caused by: oracle.sysman.emInternalSDK.core.selfupdate.integration.OperationFailedException: ORA-14400: inserted partition key does not map to any partition INFO: oracle.sysman.top.oms:ORA-06512: at "SYSMAN.EM_SELF_UPDATE", line 1547 INFO: oracle.sysman.top.oms:ORA-06512: at line 1 INFO: oracle.sysman.top.oms: INFO: oracle.sysman.top.oms: at oracle.sysman.emInternalSDK.core.selfupdate.InventoryManager.registerOutOfBoxEntity(InventoryManager.java:847) INFO: oracle.sysman.top.oms: at oracle.sysman.core.selfupdate.EntityInstRegistration.parse(EntityInstRegistration.java:185) INFO: oracle.sysman.top.oms: ... 5 more
Solution:
Login to repository database and execute below commands.
SQL> exec gc_interval_partition_mgr.partition_maintenance; PL/SQL procedure successfully completed. SQL> exec mgmt_audit_admin.add_audit_partition; PL/SQL procedure successfully completed.
Now retry the installation, It should complete successfully.
Please read the Document 1663277.1 for further details.
The agent has been removed successfully.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp