Posts by Inbaraj Asirvatham

How to install Trace File Analyzer (TFA)

Description: 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…

Read More

How to apply SSL/HTTPS vendor certificate for apex application deployed on apache tomcat

Description: This article shows how to enable HTTPS for Tomcat. It uses a Third party vendor certificate for wildcard SSL and It should be format of certificate  .jks or .pem.…

Read More

ASM Instance cloning using RMAN in same host

Description: In this article step by step Cloning the asm instance in same host.Earlier we use to clone database using rman backup. After adding the database service entry and restore…

Read More

How to Create Manual Database in Oracle ASM File-system using Cloud Instance

Description: The recommended method of creating your database is to use database configuration assistant (dbca). however, if you create your database manually using the create database statement, then oracle asm enables you…

Read More

Silent mode Installation of Grid and database in oracle cloud (19C)

Description: The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities.Oracle…

Read More

Migrating a Normal disk group to flex disk group in ASM oracle cloud (19C)

Description: Flex Diskgroups are the new features in oracle 12c R2 for quotas, cloning and filegroups. Oracle ASM provides two-way mirroring by default for newly-created flex disk groups. We can…

Read More

Oracle 19c Database Upgrade From 11.2.0.4 to 19.0.0.0 Using DBUA

Description:- There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: Database Upgrade Assistant (DBUA) Manual…

Read More

High Water Mark management in Oracle Database

Description: Each table is made up of extents and each extent is made up of oracle blocks – a common block size is 8k. So you have a table with 10 extents (80K). When any table creates the…

Read More

Query(Row) Level Export data pump and Import data pump

Description:- Allows you to specify a query clause that is used to filter the data that gets export and import.When the query is to be applied to a specific table,…

Read More

Schema Level Export data pump and Import data pump

Description:– Performing the import of Schemas of your database is as simple as exporting them. Similar to expdp Schema export, we use SCHEMAS parameter to perform the import of the…

Read More