So, after an abnormally quiet weekend, I was being paged: Oracle Management Services (OMS) was down! Well, this requires monitoring the monitoring, right? So, how to monitor the monitoring? Oracle Enterprise Manager (OEM) 13c has a feature called Out of…

We often manage services over EC2, this is not news. But when migrating to Amazon RDS, it’s usual for new users to have issues with performing some administrative actions on the database, especially when it’s done via internal Oracle procedures…

Are you manually (or via a script) killing idle sessions on your database? As a consequence, your users are getting error “ORA-00028: your session has been killed” and probably getting angry at you. What about doing it automatically, in a…

Now that we are fully into database upgrades, here is an important item to be aware of: As you may know, the Database Vault (DV) option could be reported as not installed in source when converting non-CDB to PDB, and…

A while back, we had a seasonal technology stack update for one of our client’s R12.1.3 Oracle E-Business Suite instance. One of the changes introduced was Oracle JDK 7 Update 241, which has a lot of known SSL/TLS protocol and…

With the recent CPU patching on Oracle E-Business suite R12.2, many customers faced issues with accessible weblogic admin console from browser. This security enhancement started with the April 2019 CPU via Patch 29524595 using weblogic connection filters. More details on…

If you are one of the folks who have already upgraded the production E-Business Suite database to 19c Certified, then you are a superhero and this post is not for you. The majority of us are still running the good…

I could start this blog the same way I started this one because everything is supposed to be easy and at a 1 click distance in any cloud, so it should be the same for the database backups in Oracle…

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…