Loading....

Applying the July 2019 Database Release Update Patch

This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2. The environment is single instance Multitenant database. Notes 1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1) 2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU […]

How to configure an Oracle 18c read-only Oracle Home

Execute the roohctl -enable command from $ORACLE_HOME/bin directory   [oracle@host02 dbhome_1]$ pwd /u02/app/oracle/product/18.0.0/dbhome_1 [oracle@host02 dbhome_1]$ cd bin [oracle@host02 bin]$ ./roohctl -enable Enabling Read-Only Oracle home. Update orabasetab file to enable Read-Only Oracle home. Orabasetab file has been updated successfully. Create bootstrap directories for Read-Only Oracle home. Bootstrap directories have been created successfully. Bootstrap files have […]

How to install the Oracle 18c RPM-based database software

Download and install the Oracle Pre-installation RPM [oracle@host01 gghome]$ su – Password: [root@host01 ~]# yum install oracle-database-preinstall-18c Loaded plugins: refresh-packagekit, security, ulninfo Setting up Install Process Resolving Dependencies –> Running transaction check —> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el6 will be installed –> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-database-preinstall-18c x86_64 […]

Oratop utility

Oratop is a utility very similar in nature to the ‘top’ unix OS utility. It provides an almost real-time overview of both RAC as well as single-instance database performance and can be used in combination with top to get a more complete overview of system performance and identify and monitor any activity causing bottlenecks. Oratop […]

Trace File Analyzer 18.1.1

Trace File Analyzer Collector also known as TFA is a diagnostic collection utility which greatly simplifies the diagnostic data collection for both Oracle Database as well as Oracle Clusterware/Grid Infrastructure RAC environments. Trace File Analyzer provides a central and single interface for all diagnostic data collection and analysis. When a problem occurs, TFA collects all […]

Speaker at OTN Yathra 2017

I am presenting the following papers at the OTN Yathra tour 2017 which will cover six cities in India – Chennai, Bangalore, Hyderabad, Pune, Mumbai and Delhi.   Oracle Database Multitenant – What’s New in Oracle 12c Release 2 Oracle Database 12c Release 2 presents several new features related to the Multitenant option which was […]

Oracle Database 12c Release 2 New Feature – Create Data Guard Standby Database Using DBCA

One of the real nice new features in Oracle 12c Release 2 (12.2.0.1) is the ability to create an Oracle Data Guard Standby Database using DBCA (Database Configuration Assistant). This really does simplify the process of creating a standby database as well and automates a number of steps in the creation process which were earlier […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?