ORACLE CLOUD Archives - Page 3 of 7

ORA-06512: At “SYSMAN.EM_SELF_UPDATE” While Installation 12c Cloud Control

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

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.

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 […]

Agent Clone Failed Exit Code:1 in Oracle OEM

When we talk about cloud we face issues. In this article we are going have a look at issue during deploying agent in one of the target server for OEM 12c cloud control, got error like Agent Clone Failed Exit Code:1. Solution: Get the inventory location

[oracle@bt-tstdev-1]/export/home/oracle/bsstdba# opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/oracle/product/12.1.0
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.1.0/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /oracle/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2015-10-28_16-54-51PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/12.1.0/cfgtoollogs/opatch/lsinv/lsinventory2015-10-28_16-54-51PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@bt-tstdev-1]/export/home/oracle/bsstdba# opatch lsinventory

Oracle Interim Patch Installer version 12.1.0.1.0

Oracle Home : /oracle/app/oracle/product/12.1.0

Central Inventory : /oracle/app/oraInventory

from : /oracle/app/oracle/product/12.1.0/oraInst.loc

OPatch version : 12.1.0.1.0

OUI version : 12.1.0.1.0

Log file location : /oracle/app/oracle/product/12.1.0/cfgtoollogs/opatch/opatch2015-10-28_16-54-51PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/12.1.0/cfgtoollogs/opatch/lsinv/lsinventory2015-10-28_16-54-51PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.1.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

Go to inventory location, check the permissions on the […]

Naming Convention for Oracle 18c

Below is the schedule and pertinent support information for currently released Oracle Database base releases and patch sets. A patch set is only added once it is released on the base platform, so no future patch sets are shown. The table below represents the most accurate information Oracle can provide, and is updated frequently. Unless […]

Creating and Deleting Database backupsets on Oracle Cloud DBAAS

This article was written by Skant Gupta and Joel Perez in Oracle OTN. By backing up your Oracle Database Cloud Service database deployments, you can protect the software, configuration and database against loss if a failure occurs. By restoring from a backup, you can restore the deployment’s software, configuration, and database to their state at the time of the backup. […]

Basic about Docker in the Oracle

Oracle announced that it is collaborating with Docker to release its flagship databases, middleware and developer tools into the Docker Store marketplace via the Docker Certification Program. Together, Oracle and Docker enable developers to quickly build cloud-native applications using Docker Enterprise Edition as their container platform and Oracle’s databases and developer tools immediately available as […]

Migrating Databases to Oracle Cloud Using RMAN Backup

This article was written by Skant Gupta and Joel Perez in Oracle OTN. This method is based on the traditional backup/restore/recover database. It has been one of the methods most effective to migrate/move an Oracle Database from one host to another host or even in the same host. The advantages of this method are several, one of them is that […]

Oracle Cloud (DBaaS): Move PDB with exporting the TDE master Key in Oracle 12.2

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud. Security has many layers, areas, sections and more. When we work with databases “On-Prem”, security in many […]

Oracle Cloud (DBaaS): Using dbaascli Utility for Reinstating Operations on Oracle Data Guard

This article was written by Skant Gupta and Joel Perez in Oracle OTN. At the last part of this article we performed Switchover & Failover Operations on Oracle Data Guard using the dbaascli utility. You can read it here: Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard Now in this this article we […]

Articles Tagged: ORACLE CLOUD