Oracle E-Business Suite and Java Web Start. Finally!

Great things always happen overnight. That's probably the case for European Oracle Apps DBAs in the same situation, ...

Replicating users and tablespaces with Oracle GoldenGate

I decided to write this blog post after reading some comments on my older posts and several online discussions where ...

How to patch an exadata (part 5) - troubleshooting

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 5: Troubleshooting In this post I'll be sharing a ...

Parting with ocm.rsp isn't really sweet sorrow...

Context Now that we're well into 2017, let's sit back and ask the question: "What was the best news of 2016 in the ...

A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point. 1) Set the environment to ...

How to patch an exadata (part 6) - timing

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 6: Timing Now that we know how to patch every ...

How to patch an exadata (part 4) - the rollback procedure

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 4: The Rollback Procedure You will most likely never ...

ORA-30926 while using impdp over a database link

Background The other day I was doing an import using impdp in 12.1.0.2, and received the following error:'ORA-30926: ...

Oracle service secrets: group and filter

At the KSCOPE16 conference in Chicago I recorded a two minute tech-tip with Bob Rhubart of OTN about adding services to ...

Simple steps to perform opatch maintenance with Ansible

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more ...

How to patch an exadata (part 3) - grid and database OH patching

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 3.4 Patching the Grid Infrastructure 3.4.0 - ...

Reading execution plans for parallel DML

Introduction: Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post ...

ORA-01156 when adding standy redo log in dataguard configuration

Database version = 11.2.0.3.0 If you get following error while adding a Standby Redo Log (SRL) to a standby database in ...

What's eating my database? Where to focus performance efforts using Oracle AWR

Defining the Gold Standard: Average Active Sessions (AAS) Traditional methods would include looking at CPU, load and ...

ASM 12c : how to rename a Diskgroup

The first time I was asked to rename a diskgroup, I thought that it would be a trivial operation, but what should be an ...

Add space to tablespace - corrective action in OEM 13c

OEM 13c came out with a good new feature as a corrective action to add space to tablespaces. It could be done in OEM ...

AWS DMS tips for Oracle migrations

Investigating IO performance on Amazon EC2

I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

Backup Oracle databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take ...

Cloning Oracle grid infrastructure using Ansible

Sometimes your organization may decide to move to new hardware, to a new data center, and you, as an Oracle DBA, would ...

Enabling achivelog mode in 12c RAC database

Distinguish real SQL execution plans from fake ones!

As an Oracle DBA, one of our daily tasks is to optimize bad SQL statements that are affecting the system and causing ...

How to Install a brand new Exadata X5 (part 2)

Now that all the prerequisites have been performed in Part 1, we can now jump in the Exadata installation procedure ...

Investigating IO performance on Amazon RDS for Oracle

I've recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when dealing ...

Bushy join trees in Oracle 12.2

Context There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the ...

How to install a brand new Exadata X5 (Part 1)

When you buy an Exadata machine, you can ask Oracle to proceed with the installation or let some brilliant DBAs like ...