How to Set Up Out Of Band Notifications in OEM 13C

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…

Read More >

AWS’s Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

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…

Read More >

How to Automate Killing Inactive Sessions with Resource Manager

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…

Read More >

Why you should not uninstall Database Vault from a CDB

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…

Read More >

Custom fix required for txkCfgOC4JApp.pl when using latest JDK with Oracle E-Business Suite R12.1.3

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…

Read More >

How to fix EBS weblogic admin console when not accessible after CPU patching

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…

Read More >

Oracle E-Business Suite and 12cR1 database in Extended support – What to do?

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…

Read More >

Troubleshooting Oracle Cloud Infrastructure Automatic Backups

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…

Read More >

Exadata Smart Scan: A Quick Overview

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…

Read More >

How to manage Oracle Flashback Log size

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…

Read More >
Page 1 of 2212345...10...Last Page »