Tag: database

Running new Oracle DBSAT version 2.1.0 against Autonomous Database

Recently Oracle released the newest version of the “Database Security Assessment Tool” (DBSAT 2.1.0). This version is certified to run against Oracle Cloud DBCS (PaaS) and Autonomous Databases. Also, the Discoverer option can now find sensitive and personal data in…

Read More >

Handling a Cassandra transactional workload

Overview of Cassandra As previously mentioned in my notes on lightweight transactions, Cassandra does not support ACID transactions. Cassandra was built to support a brisk ingest of writes while being distributed for availability. Follow the link to my previous post…

Read More >

Oracle Database 18c schema only accounts

One nice new feature of Oracle Database 18c is that schemas can be created without a password. These are called “Schema Only Accounts“. This new functionality is pretty simple and is a nice step forward that can allow administrators to…

Read More >

Using Oracle Wallets and SEPS with Perl, JDBC, and ODBC

A few years ago I wrote a couple of popular blog articles on using Secure External Password Stores (SEPS) and Credential Wallets to manage passwords used by scripts for database connections: Securing Oracle Monitoring And Backup Scripts Issues With Oracle…

Read More >

Oracle’s Database Security Assessment Tool (DBSAT) Version 2 (2.0.1)

Background Oracle recently released a new version of their Database Security Assessment Tool (DBSAT) – version 2.0.1. This is a welcome update as it’s been a while since the initial release in 2016. In fact, the tool hasn’t been enhanced…

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 >

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 >
Page 1 of 212