Oracle EBS (E-Business Suite) customers have always been left a little behind by technological innovations happening at Oracle. Since 18c, Oracle Database has offered a new feature called Read-Only Oracle home (OH). However I haven’t noticed much traction for this…

The Database AutoUpgrade utility has been slowly developing its capability to cover all possibilities of database upgrades. Recently I’ve tested an upgrade of a database running in NOARCHIVELOG mode using this utility. I added more complications with this testing phase;…

When writing PL/SQL, should you use ‘select from dual’ to assign variable values? The answer may surprise you.

Oracle Service Bus 12.2 and onwards is available to download on Oracle Support. As you might expect, the new version brings some changes for middleware admins and new features to developers when configuring an installation from scratch. Among them, on…

While increasing the redo log file size for my production environment, I came across a requirement I’d like to share with you. The process should be quite straightforward as we can add / drop redo log files online. However, since…

I’m glad to get back to blog writing and, after a bit of a break, I’m starting with a brief post. We DBAs have probably come across the RMAN (Recovery Manager) utility many times in our lives. We are also…

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. We originally published today’s post on April 15, 2019. This is more of a personal…

Note: This was originally published on rene-ace.com.

Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We’ve been seeing an uptick in customer requests to upgrade their E-Business Suite (EBS) database to 19c. Multiple factors seem to be driving this increase,…