Tag: oracle database

If you are one of the folks who have already upgraded the production E-Business Suite database to 19c Certified, then you are a superhero and this post is not for you. The majority of us are still running the good…

I decided to write about Exadata Smart Scan feature for this blog post. Why Smart Scan? Well, because it is awesome and I don’t know any other relational database system that has this feature. So what is Smart Scan and…

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Oracle users have had the ability to run database workloads in the cloud for years, but options have always been limited to third-party providers like Amazon Web Services (AWS) – at least, until recently. That’s because Oracle has a second-generation…

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…