Home Blog
yellow scrabble tiles

ORA-08104, ORA-08106, ORA-14411

0
ORA-08104: this index object is being online built or rebuilt ORA-08106: cannot create journal table SCHEMA.SYS_JOURNAL_% ORA-14411: The DDL cannot be run concurrently with other DDLs The...
KSC-20161117-PH-SWW01_0001

Protected: Basic Administration 12c/19c – Imp!!

0
Basic-Administration-1Download Hope it worked !! :)
electrician fixing an opened switchboard

Dataguard Configuration with DG Broker using Active Duplicate in Oracle !!

0
Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)
gray scale photo of gears

Step by Step ASM/ Grid Installation in Oracle

0
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
gray scale photo of gears

How To Purge The UNIFIED AUDIT TRAIL ?

0
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  sqlplus / as sysdba SQL> ...
a detective turning the switch of a vintage recorder

Patching !!

0
In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single Patch, can you use opatch utility? Yes, you can use Opatch incase...
black room divider with geometric design on white surface

Overview

0
Splunk is a big data platform that simplifies the task of collecting and managing massive volumes of machine-generated data and searching for information within...

Roles in Splunk

0
There are 3 different roles in Splunk in order it is Users, Power User & Admin. 1) User : This is the lowest role in...

Modes of Searches

0
Splunk provides you with 3 different modes of Splunk searches i.e. Fast, Smart & Verbose. Modes of searches can be selected as per your...

Meta-Data’s

0
The Meta-data is generally the first command of the search. As a best practice, we should include 4 fields always in the first line...

SQL Developer

0
SQL Developer is a convenient way for database developers to edit and develop basic tasks using SQL*Plus. SQL Developer is a graphical version of SQL*Plus,...

Parameter Files in Oracle

0
To start a database instance, Oracle Database must read either a server parameter file, which is recommended, or a text initialization parameter file, which...
silhouette photo of person holding door knob

Running nohup commands

0
The nohup command runs the command specified by the Command parameter and any related Arg parameters, ignoring all hang up signals (SIGHUP) or modifies...
an artist s illustration of artificial intelligence ai this image represents how machine learning is inspired by neuroscience and the human brain it was created by novoto studio as par

Split Brain Syndrome in RAC

0
Where two or more instances attempt to control a cluster database. Each node in this cluster are interconnected through private interconnect and end...
white ruled notebook

About Oracle Database Release Numbers

0
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for "Cloud". Previous releases (e.g....
crop unrecognizable man inserting flashcard into laptop slot

How INSERT Statement get executed in Oracle??

0
1. As a laymen, consider a user/application requests a connection request to the Oracle database through his login credential. 2. This login credential is accepted...
set of various folders for documents

What Are Root.sh And OrainstRoot.sh Scripts ?

0
The orainstRoot.sh and root.sh scripts are created in the last phase of installation and stored in the locations /<path to oraInventory>/orainstRoot.sh and $ORACLE_HOME/root.sh. After the...
woman in red clothes with big disk

Voting Disk in Oracle RAC

0
Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members...
set of various folders for documents

Oracle Local Registry (OLR) in RAC

0
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each...
blur bowed stringed instrument classic classical

Oracle Wait Events : ” enq: TM – Contention “

0
Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock that is held by...
blur bowed stringed instrument classic classical

Oracle Wait Event : ” db_file_scattered_read “

0
This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk. In most cases this...
blur bowed stringed instrument classic classical

Oracle Wait Events : ” db_file_sequential_reads “

0
This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for a physical I/O call...
File drawer clipart, furniture vintage

What is Global and Local Inventory in Oracle?

0
Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps all information regarding the products...
blur bowed stringed instrument classic classical

Oracle Wait Events : ” enq: TX – Row Lock Contention “

0
TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code with more frequent and...
man head duplicated

How to Identify and Remove the duplicate rows in a Table?

0
In case if we want to identify duplicates rows of a table and want to remove them from a table.  Below are the command...