Oracle Autonomous Data Warehouse – What is it?

Oracle Autonomous Data Warehouse (ADW) is one of the so-called DB as a Service (DBaaS) or probably we should call it Data Warehouse as a Service (DWaaS) with the difference that this service is completely automatic and autonomous.   This service is comprised by an Oracle Database (of course) already pre-configured for analytics, data lakes… Continue reading Oracle Autonomous Data Warehouse – What is it?

2017 April PSU – OEM sending tablespace related alerts every collection schedule

I noticed that several alerts related to tablespace full were sent from OEM every collection schedule. At first sight I thought this may be related to OEM itself but after spending some significant time in MOS found a bug note stating that the 2017 April PSU patch was responsible.The issue is that dba_tablespace_usage_metrics is not accounting… Continue reading 2017 April PSU – OEM sending tablespace related alerts every collection schedule

OMS responded illegally [ERROR- Failed to Update Target Type Metadata] in 13c R2

I want to discuss about this OMS error coming from the agent’s heartbeat status. The agent shows with an unreachable status but is actually up and running.$: emctl status agentOracle Enterprise Manager Cloud Control 13c Release 2Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.---------------------------------------------------------------Agent Version          : 13.2.0.0.0OMS Version            : (unknown)…Last Reload            : (none)Last successful… Continue reading OMS responded illegally [ERROR- Failed to Update Target Type Metadata] in 13c R2

Upgrade OPatch for OEM 13c R2 Agents

Opatch utility has to be updated often as Oracle delivers regular updates to it. I was used to version 12 and it only required an overwrite of the OPatch directory. Well, not anymore with version 13c R2.I will walk you through an OPatch upgrade from 13.8 to 13.9 version.First export your agent ORACLE_HOME: $: export… Continue reading Upgrade OPatch for OEM 13c R2 Agents

OEM 13c New Features – System Broadcast

I can’t finish the year without a post about OEM 13c. I finally had some time to install it and from first hand go through its new features.  I find this “System Broadcast” feature so useful, especially when you have tons of users using OEM. You can try to email users, give them a call… Continue reading OEM 13c New Features – System Broadcast

ORA-01555 query duration 0 seconds with Dataguard

How many times we have calls from users complaining about their process that failed due to an ORA-01555 error?We know that if the queries are not well tuned and they modify a lot of data, the image held in the UNDO Tablespace could not be consistent with the real data. But have you ever seen… Continue reading ORA-01555 query duration 0 seconds with Dataguard

CRS-2632: There are no more servers to try to place resource ‘resource_name’ on that would satisfy its placement policy

I just got this error from CRS while trying to start a database using srvctl. I find this error kind of missleading as the error doesn’t tell what is really happening with the resource.I suggest you to manually check the logs of the resource. In this case it had to do with a cluster database… Continue reading CRS-2632: There are no more servers to try to place resource ‘resource_name’ on that would satisfy its placement policy

WAIT_FOR_GAP. How to restore missing archivelogs from backup?

In a Dataguard configuration, Oracle’s RFS (Remote File Server) writes redo data to the standby. When for any reason it can’t write this data, MRP (Managed Recovery Process) will wait for the archivelog to be applied and have the status “WAIT_FOR_LOG”. This will lead the standby to be out-of-sync with the primary database.Sometimes some archivelogs… Continue reading WAIT_FOR_GAP. How to restore missing archivelogs from backup?