Spfile and Pfile in Oracle

Today we are going to have look on the topic of “PFile and SPFile”. This is the most important element of the Oracle database. Being Oracle DBA we must aware about “PFile and SPFile”. This file plays an important role in  Oracle database. Let’s have look at the technical definition of “PFile and SPFile”. It will be […]

Read More


Today we are going to have look at the database security’s phase. In this phase, we are going to have look at Purging AUDIT TRAIL RECORDS The parameterAUDIT_TRAIL_TYPE is specified using one of three constants. DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD: Standard audit trail (AUD$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD: Fine-grained audit trail (FGA_LOG$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD: Both standard and fine-grained audit trails. If you want […]

Read More

Facts about Instance

Today we are going to have look at some more interesting facts about  “Oracle Technology”.  This post about is the  “ASM Instance and Database Instance”. Being an Oracle DBA our  Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]

Read More

OPatch failed with error code 135 – Argument(s) Error… Given ‘ocmrf’ file does not exists

Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows:


Solution Either open the permission of /home/grid path to be 755, eg:

The permission looks like:

Or create a response file under a directory accessible by both grid user and oracle user, for example: […]

Read More

Benchmarking in Oracle Database

After a long time, I am going to write a theoretical topic which adds some different knowledge in our DBA career. I hope it will help our viewers to have deep knowledge about the database. Today I am going to explain about benchmarking in the database. Being a part of IT we have little idea about […]

Read More

SQLT in Oracle

SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, […]

Read More

Drop the SQLT in Oracle Database

Uninstalling SQLT removes the SQLT repository and all SQLTXPLAIN/SQLTXADMIN schema objects. SQLTXPLAIN and SQLTXADMIN users also gets dropped. To uninstall SQLT simply execute sqlt/install/sqdrop.sql connected as SYS.

Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]

Read More

Sosreport on Oracle Linux

The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]

Read More

Database Design – Hardware Requirements

Database Design is the most important part of the IT project. This is the second post regarding Database Design. Normally we just think about software and some basic terms of hardware while we think about the database. Now let’s have deep look at Hardware Requirements. This post explains the technical terms which must keep in mind […]

Read More