Formerly named Macromedia Flash (now Adobe Flash) player was really popular in the 2000's. I remember learning it to add animation to Web Sites I was developing during my college years. Flash has also been the target of hackers to insert viruses, hence posing several security concerns to enterprises and home users. In the IT… Continue reading Bye Bye Flash!
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?
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
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 : 184.108.40.206.0OMS Version : (unknown)…Last Reload : (none)Last successful… Continue reading OMS responded illegally [ERROR- Failed to Update Target Type Metadata] in 13c R2
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
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
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
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
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?
Today I want to write about Oracle Enterprise Manager (OEM) 12c plug-ins and how to test them. OEM is divided into two logical parts, the EM Platform and the EM Plug-ins. The EM Platform basically consists of the UI console, job system, metrics, EM agent, etc. The EM Plug-ins are modules that you can attach to you… Continue reading OEM Agent Plug-in Testing