Ensuring the database is up to PAR (Performance, Availability, Recoverability) has long been the focus of database administrators everywhere. Although this is still true, it is no longer an accurate depiction of the full scope of a DBA’s responsibilities. Modern businesses operate as online data driven machines. The demand and value placed on data, coupled with the current cyber security concerns means that database administrators have to redefine their focus. This blog is intended for DBA’s looking to a add value in a modern IT world. I will mention technology implementations specific to Oracle databases, however the concepts mentioned in this blog post are applicable to any database platform.
Continue reading…Blogs
How To Rename An Oracle PDB
The concept of a multitenant database was introduced in Oracle database 12c. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that houses pluggable databases (PDB).
Continue reading…Flashback An Oracle Data Guard Database
Logical mistake, end of testing cycle, need to rollback database to a previous state? RMAN restore can help, however there’s an easier way: we can address these scenarios with the Flashback technique. In the case of a standalone Oracle database, there is nothing special to take into account when performing flashback. However, performing flashback of a Data Guard environment needs special treatment of the Standby Database to ensure data consistency. This article will show you how to do that:
Continue reading…How The Whole Blogging Thing Is Working Out For Me, Year 3
Why I Started Writing Blogs
In July 2016, I wrote my first blog on RKKoranteng.com. Earlier that year (June 2016), I made a big career decision to jump into independent consulting. I faced alot of challenges, mainly how to secure my first customer and how to market my capabilities. After months of hard work, I eventually landed my first project, however I was still unclear about how to promote my services. Fast forward a few months later, I figured the best way to market my capabilities was to establish my online brand and provide value to my online audience.
Continue reading…Oracle JVM Installation For Oracle 18c Database on RHEL
This blog describes the steps needed to install and configure Oracle JVM for the Oracle 18c Database. The implementation described in this blog is based on a server installation with a minimum resource allocations required by Oracle and can also be used to install Oracle JVM for Oracle Database 11g/12c as well.
Continue reading…I Made 2 Big Mistakes In My Consulting Career
Looking back now, I can see a few big mistakes I made early in my consulting career…well, I mean, I can see a lot, but let’s talk about two.
Continue reading…OEM 13c Silent Installation On RHEL 6
This blog describes silent installation and configuration of Oracle Enterprise Manager Cloud Control 13c (64bit) on RHEL 6. The implementation described in this blog is based on a server installation with a minimum resource allocations required by Oracle.
Continue reading…Disabling Transparent HugePages On RHEL 7
Transparent HugePages (THP) memory is different from standard HugePages memory because the kernel thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime. This dynamic memory allocation of THP can cause memory allocation delays during runtime. To avoid performance issues, Oracle recommends that you disable THP on all Oracle Database servers. Oracle recommends that you instead use standard HugePages for enhanced performance.
Continue reading…Oracle Database 18c Silent Installation On RHEL 7
This blog describes silent installation and configuration of Grid Infrastructure 18c (64bit) and Oracle Database 18c (64bit) on RHEL 7. The implementation described in this blog is based on a server installation with a minimum resource allocations required by Oracle.
Continue reading…I Am Happy AWS Is Leaving Oracle
As you all know, I’m a huge advocate for Oracle’s database technologies and Amazon Web Services IaaS platform. There is no denying that these two corporations have built awesome systems that can be leveraged to support enterprises of all sizes – it’s like a perfect relationship. However, there is trouble in tech paradise. AWS CEO Andy Jassy says Amazon will be off Oracle databases by the end of 2019. What does this breakup really mean and why should you be excited about it?
Continue reading…