Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows: 2017-09-23 04:24:41: s_run_as_user2: Running /bin/su oracle -c ‘ /oracle/product/11.2.0/db/OPatch/opatch napply /software_dump/latestpatch/18706472/18522509 -local -silent -ocmrf /home/grid/responsefile/file.rsp -oh /oracle/product/11.2.0/db -invPtrLoc /oracle/product/11.2.0/db/oraInst.loc ‘ 2017-09-23 04:24:42: Removing file /tmp/filexagz0g 2017-09-23 04:24:42: Successfully removed file: /tmp/filexagz0g 2014-09-23 04:24:42: /bin/su exited with rc=135 2017-09-23 04:24:42: […]
Category: ORACLE DATABASE
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 […]
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, […]
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. [oracle@localhost ~]$ cd /home/oracle/sqlt/install [oracle@localhost install]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 14 04:31:10 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. […]
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, […]
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 […]
Determine the process which is locking an Oracle account with incorrect password
As we know all that in the world of technology we have to fill ups user and password name multiple times . We must know what is actually happens while we enter incorrect password. First few lines give some basic idea about the Authentication. Authentication is a process in which the credentials provided are compared to those […]
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 […]
Database Design(Software Selection)
Today we are going to talk about most important part of the Database. As a fresher, we all have a dream to do something different and we choose DBA as a profession. As my personal experience as a fresher I wanted to be Oracle DBA and today I feel proud to work as DBA. Let’s have look at […]
Killable Processes in Oracle Database
A multiprocess Oracle database uses some additional processes called background processes. The background processes perform maintenance tasks required to operate the database and to maximize performance for multiple users. Mandatory Background Processes Optional Background Processes Slave Processes There are few processes which we can kill without terminating the instance. Killable: ARCn: Redo log archivers CJQn: Job […]