Tag: Oracle

Log Buffer #512: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Upgrade Existing TDE to Use New Unified Key Management in 12c Upgraded Database (non-cdb)

I’m really excited to be writing this post and I’m hoping it serves as helpful content. When reviewing the new unified key management in RDMS 12c, I came across old commands like ‘ALTER SYSTEM’ to manage the TDE keys that are…

Read More >

Automating Password Rotation for Oracle Databases

Password rotation is not the most exciting task in the world, and that’s exactly why it’s a perfect candidate for automation. Automating routine tasks like this are good for everyone – DBAs can work on something that’s more exciting, companies…

Read More >

Log Buffer #511: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server, MySQL.

Read More >

Datascape Podcast Episode 9 – What’s Up with Oracle These Days?

With the hype around cloud and cloud first initiatives, automation, DevOps, and very specialized cloud-based databases, I wondered what was going on with one of the datascape’s old faithful technologies, Oracle Database.

Read More >

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, like myself. This morning I read Steven Chan’s latest blog post about Java Web Start certification with Oracle E-Business Suite and its…

Read More >

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 disk usage, more databases to manage and it won’t stop. In fact, we are pretty sure that this expansion is going…

Read More >

Error ORA-01033 After Doing a Switchover in a 12.1 RAC Environment

The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary, I kept getting the following error: SELECT dest_name,STATUS,error FROM gv$archive_dest_status WHERE dest_id=2;   DEST_NAME ——————————————————————————–…

Read More >

Bushy Join Trees in Oracle 12.2

There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post. First, I’ll create four tables with two indexes: CREATE TABLE t1 AS SELECT rownum n1,…

Read More >

Log Buffer #508: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >
Page 2 of 14712345...10...Last Page »