This article was written by Skant Gupta and Joel Perez in Oracle OTN. 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/ or Join our LinkedIn group: Oracle Cloud DBaaS In this article we will show you how to access oracle cloud instance in GUI mode. Create […]
Articles Tagged: ORACLE CLOUD
Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using RMAN Cross-Platform Transportable PDB
This article was written by Skant Gupta and Joel Perez in Oracle OTN. 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/ or Join our LinkedIn group: Oracle Cloud DBaaS This method can be used only if the on-premises platform is little endian, and […]
Steps to Apply Database Patch From OEM Cloud Control
Being a Core DBA we have deep knowledge about patching.On the internet we have lots of knowledge is available about patching.This patching is different from the normal one. In this article, we are going to have look on steps which use to Apply Database Patch From OEM Cloud Control. With help of OEM cloud control, […]
Oracle 18c: “Oracle 18c and its impact on DBAs”
This article was written by Skant Gupta and Joel Perez in Oracle OTN. 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/ or Join our LinkedIn group: Oracle Cloud DBaaS “DBAs will be fired.. ? It’s the end of DBAs because of the […]
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:
|
1 2 3 4 5 6 7 8 9 |
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.
|
1 2 3 4 5 6 7 |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[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. |
Go to inventory location, check the permissions on the […]
Add Database As Target Oracle 12c Cloud Control
Today we are going to have look on some steps which are used to Add Database As Target Oracle OEM 12c Cloud Control. Once agents are deployed on the target host, you can add the database and listeners residing on the target host for monitoring by cloud control. If you haven’t deployed Agents yet, click here […]
Blackout Targets In OEM 12c Cloud Control
Let’s have look on the steps used to Blackout Targets In OEM 12c Cloud Control. Keep this point in mind before any planned outage on the target database or hot, we need to create blackout for that target, to avoid incident alerts. Blackouts allow Enterprise Manager Administrators to suspend all data collection activity. ORACLE DATABASE – > […]
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. […]