Tag: database

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 >

Multi Tb migration Using mydumper

In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, which is a logical backup and restore tool that works in parallel. I will also cover the case where you need…

Read More >

Change of Database Passwords Through OEM

Once in a while passwords for system database accounts should be changed due to different requirements; it is a boring routine task, but it still needs to be completed. However, with the help of OEM it can be automated and…

Read More >

MySQL may return results in non-deterministic order with ‘order by’

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Read More >

Oracle Database 12c: PSUs vs Database Proactive Bundle Patches

Simon Pane, Pythian Database Consultant, compares PSUs and Database Proactive Bundle Patches in Oracle 12c.

Read More >

Errors in a Pluggable Database?

  There might be a situation where executing some DDL in pluggable database may cause the following error: ORA-65040: operation not allowed from within a pluggable database This error could occur if a tablespace is being dropped from within PDB…

Read More >

SQL Server Fast Food

  An environment where you have a high number of databases on one server, or many, can be time consuming to something as simple as adding a user account. You have the option of using the GUI with SQL Server Management…

Read More >

SQL Server: Migrations/Upgrades – 10 Things to Think About

Here at Pythian we have planned and implemented dozens of migrations and upgrades for our customers. In this blog post I am trying to summarize the 10 most important things to consider when migrating or upgrading a SQL Server environment,…

Read More >

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

This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs of the running week.

Read More >

RMAN 11g : How to Restore / Duplicate to a More Recent Patchset

In an Oracle DBA’s life, you’ll be regularly asked to work on applying a new patchset on a database and then you will apply it starting from the development database to the production database and this process can be quite long depending on…

Read More >
Page 1 of 212