We were recently paged by a client because one node of their Orchestrator setup had crashed. The Orchestrator cluster was set up using the Orchestrator/raft consensus cluster and using a SQLite backend. When looking in the log files this is…

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 bring forward a popular post from the past. We originally published today’s post on December 16, 2019. This is the second of a series of…

With a total of 33 directories for GI (Grid Infrastructure) and DB (database) homes, what’s the easiest method to remove files older than 90 days for all directories? Luckily, Oracle Support does offer purgeLogs; a one-button automation script, which can…

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on September 9, 2019. One method to prepare for a Grid Infrastructure…

Reviewing recurrent issues for database systems is generally a monthly task. If there were only one system and one database, it would be a simple exercise, however, there are many systems and many databases per system. This is where ADRCI…

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on February 13, 2019. This blog post has been on my To…

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on October 29, 2019. It’s no secret to anyone that software release…

There are plenty of database migration options out there, and we love working with clients to help them assess and evaluate which one is best for them. Options include: Bare Metal Solution (BMS) PostgreSQL: On Cloud SQL On GCE (Google…

Sometimes the best way to dispel a myth is to start with a concrete example. Here’s a great example from a client we worked with: QAD Inc. provides enterprise resource planning software and related enterprise software to manufacturing companies. By…