Deploying an Oracle Enterprise Manager (OEM) agent in silent mode is an alternative to deploying it using the “Add Host Targets” Wizard, but it has great advantages. While the “Add Host Targets” Wizard provides GUI-rich interview screens for providing all installation details, the silent mode is the preferred deployment strategy when leveraging automation.
Continue reading…oracle
An Easy Approach To Oracle Database Security Assessment
Performing routine holistic database health checks is a must – good database administrators do more than just keep their database up to PAR . I perform these health checks on a quarterly basis to analyze database capacity/resource utilization, availability, performance, and security. Oracle Database Security Assessment Tool (DBSAT) just made my life alot easier and my health checks more effective. DBSAT is a command line tool focused on identifying how securely the database is configured, who are the users and what are their entitlements, what security policies and controls are in place, and where sensitive data resides with the goal of promoting successful approaches to mitigate potential security risks. DBSAT is a lightweight utility that will not impair system performance in a measurable way.
Continue reading…
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…
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…
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…
Flushing Shared Pool In Production DB
The Oracle Database Server is made up of two main components; the instance and database. The instance consists of memory structures and background processes, whiles the database is a collection of physical database files. If we look at the Oracle Database architecture we can see that there is an organized layout for the memory structures, in which we can find the main memory structure and it’s sub-memory structures.
Continue reading…