Blogs

Keeping Your Database Up To PAR Isn’t Enough In 2019

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.

How To Rename An Oracle PDB

June 11, 2019 Richard Koranteng Blogs Technology

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).

Flashback An Oracle Data Guard Database

June 10, 2019 Richard Koranteng Blogs Technology

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:

How The Whole Blogging Thing Is Working Out For Me, Year 3

May 27, 2019 Richard Koranteng Blogs Career

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.

Oracle JVM Installation For Oracle 18c Database on RHEL

May 21, 2019 Richard Koranteng Blogs Technology

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.

I Made 2 Big Mistakes In My Consulting Career

May 3, 2019 Richard Koranteng Blogs Career Consulting

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.

OEM 13c Silent Installation On RHEL 6

April 25, 2019 Richard Koranteng Blogs Technology

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.

Disabling Transparent HugePages On RHEL 7

April 16, 2019 Richard Koranteng Blogs Technology

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.

Oracle Database 18c Silent Installation On RHEL 7

March 24, 2019 Richard Koranteng Blogs Technology

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.