Exadata: Automating Compliance Checks

AHF

I wanted to share a brief summary–a cheat sheet–to highlight the Autonomous Health Framework (AHF) setting and how we use this great tool in database installations. AHF is an out-of-box solution that provides automated monitoring and proactive issues detection. If…

Read More >

OEM 12.5: Tablespace Allocation Metric Not Collected—Agent Is Running but Not Ready

OEM 12.5

I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the “tablespace allocation metric” was not being updated on OEM for a specific database. In this case, the most recent gathering was done…

Read More >

Oracle Exadata ASR General Troubleshooting

oracle exadata asr troubleshooting

Oracle Auto Service Request (ASR) is a secure, scalable, customer-installable software feature of warranty and Oracle Support Services that provides auto-case generation when common hardware component faults occur. I thought I’d share how we monitor the ASR manager process and…

Read More >

Part Five: Deploying High Availability Applications in Oracle Cloud Infrastructure— SSL Certificates and Load Balancer Setup

load balancer

This is the fifth in a series of blog posts that covers setting up the load balancer for a high available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is the fifth of a…

Read More >

Database Upgrade Fails With “unexpected error in validate_credentials”

unexpected error

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If you’re already aware of it, the workaround is trivial. However, when it happened to me during the testing…

Read More >

How to Resize Exadata Grid Disks Without an Outage

exadata grid disk

As you might know, each Exadata cell contains 12 physical disks with a fixed size. If you want to increase the ASM disk group size, you may need to purchase additional cell servers, which is expensive. In this blog, I’ll…

Read More >

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

dev database

One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs stopped running after July 31st, 2021. Both databases were 19c and patched with July 2021 19.12 RU and the parameter job_queue_processes…

Read More >

Statspack vs. AWR: Wrong number of SQL Executions

oracle

This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our clients’ databases. I decided to share it, since its appearance can be misleading. The database in question was an…

Read More >

Part Four: Deploying High Availability Applications in Oracle Cloud Infrastructure—Oracle Enterprise Manager 13.5 Setup

oraclecloud

This is the fourth in a series of blog posts that covers the details to deploy a high available set up of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources.   Recap This is the fourth of a six-part…

Read More >

RAC – Clusterware Intermittently Fails to Start

laptop red post it

While working on a new Grid Infrastructure installation on Red Hat V8.4, we had some issues testing a new cluster: The clusterware failed to come back up after a node reboot… but sometimes it worked. We had the latest 19c…

Read More >
Page 4 of 33« First Page...23456...10...Last Page »