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

Performance Tuning(How to find database growth on a Monthly wise)

Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,’RRRR’) year, to_char(CREATION_TIME,’MM’) month, round(sum(bytes)/1024/1024/1024) GB from   v$datafile group by  to_char(CREATION_TIME,’RRRR’),   to_char(CREATION_TIME,’MM’) order by   1, 2; YEAR MO              GB —- […]

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

Backup&Recovery(RMAN restore problem)

I took rman backup from RAC server to restore to another (new) RAC server.   This post is about some issues occurs face in RAC environment during the restore. RMAN> restore database; Starting restore at 09-OCT-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1.1 channel ORA_DISK_1.1: sid=108 instance=prod1 devtype=DISK allocated channel: ORA_DISK_2.1 channel ORA_DISK_2.1: sid=107 […]

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

Types of Supplemental logging at Database level

Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]

Read More