Enterprise Manager Cloud Control SNMP and Plug-Ins

Enterprise Manager Cloud Control SNMP and Plug-Ins

Hi, I have been using Oracle Enterprise Manager (OEM or Cloud Control) since it was a client application. (I’m not sure whether it was in the era of Oracle 7 or Oracle 8). In the early stages, OEM was compared to other central monitoring systems (at the time, it was HP OpenView, CA Unicenter, and the like). As a DBA who was responsible for dozens of Oracle databases, I needed a main system like this. Since we had the OEM for “free” as part of a site license, we used it heavily.

read more »
Data Guard Broker

Data Guard Broker

Hi, In an earlier version of Data Guard, when the broker had problems, one of the automatic answers I got from support was to recreate the broker configuration.

read more »
Oracle Open World 2018

Oracle Open World 2018

Hi, This was my third time at Oracle OpenWorld, and still I was thrilled like the first time. Howard Street was dressed in big, red banners everywhere—just take a picture and share it in a social network.

read more »

Orphaned Files in ASM

Hi, In our lab environments we test Data Guard on a daily basis, and we frequently “play” with failover, switchover, and flashback. The output of this playground is that we have some leftovers in the ASM; we call these leftovers orphan files.

read more »
Swingbench Short Cookbook Commands

Swingbench Short Cookbook Commands

In this example, we are using Swingbench 2.6 with the Order Entry stress test using a configuration file (SOE_Server_Side_V2.xml). Connection String The connection will always be defined to the pluggable database (not CDB), if installed.

read more »

Disaster Recovery in a Box – Literally

If you’ve been basing your risk management and business continuity strategy on the premise that it’s impossible to achieve zero data loss (ZDL) in backup-only environments, you may want to reconsider. Axxana’s DR in a Box™ solution provides ZDL recovery for Oracle applications when the disaster recovery strategy is based on backups. It’s the only solution on the market to do so—and comes at a fraction of the cost of traditional solutions based on replication between two data centers.

read more »
Extract Data Guard Commands on Oracle 12.2

Extract Data Guard Commands on Oracle 12.2

  Hi, These days I’m starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard, I posted a blog about Oracle 12c Release 2 New Features for Active Data Guard. One of the big new features I missed is that the internal Data Guard Broker configuration was changed dramatically in 12.2. Last week, I tried to Extract Data Guard Commands and realized it is not working as before, 🙁 so I sat down and adjusted it to work on 12.2. This time, I enhanced the output with some more important information.

read more »