Tag: oracle database

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: – I created this cluster based on another existing cluster, so I just followed the same patterns…

I encountered a new problem last week while trying to log in into LDAP-enabled Oracle Database (Enterprise User Security). I entered my SQL*Plus credentials that usually work fine, but received an error ending with ORA-12154. $ sqlplus aprokopjevs@EBSPROD SQL*Plus: Release…

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…

I’ve been looking into how Vagrant and/or Docker can be used to improve the life of DBAs and maybe others, too. I did this mostly to practice using these tools – especially Docker – that are becoming more and more important…

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found here. It’s no surprise that in the last few years things have changed significantly.  Trying to use this service…

We had an AWR Warehouse (AWRW) installation (OEM 12.1.0.5 on Linux) collecting data from +50 databases for a few months. A few days ago we tried to connect and found it was not working, with the AWRW console showing an…

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

Last week I published a blog post titled “Are You Ready For the Leap Second?“, and by looking at the blog statistics I could tell that many of you read it, and that’s good, because you became aware of the…

If you’re not aware of what the leap second is look into it. The fact is, this year the last minute of June 30th will be one second longer and “June 30, 2015 23:59:60” will be a valid and correct time….

We recently received this inquiry from a client: “Can an Oracle database account support two passwords at once so we can roll out updated credentials to application servers gradually rather than having to change them all at the same time?…