Make Database Security Patching Consistent

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…

Read More >

AutoUpgrade: Plug Noarchive Non-CDB Database as Upgraded PDB

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;…

Read More >

Select vs Assign – How To Assign PL/SQL Variables

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

Read More >

Oracle Service Bus (OSB) 12c LDAP Authorization – HTTP 401 (Unauthorized)

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…

Read More >

Recreate Redo / Standby Logs in a DG Broker Environment

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…

Read More >

How to Clear RMAN Channel Configuration

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…

Read More >

Save Time With This Quick OCI CLI Installation

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…

Read More >

How I Finished a GI OOP Patching From 19.6 to 19.8 After Facing cluutil: No Such File or Directory and clsrsc-740 Errors

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

Read More >

Oracle E-Business Suite Database Upgrade to 19c

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,…

Read More >

How I Finished a Recovery From an Active Duplicate After Facing Errors ORA-19909 and ORA-01110

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ORA-19909: datafile 1 belongs to an orphan incarnation and ORA-01110: data file 1. This post explains how I solved these... Read More >
Page 1 of 2612345...10...Last Page »