COALESCE Function
The Oracle COALESCE() function accepts a list of arguments and returns the first one that…
Read moreOracle
Check history of Executed queries
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou…
Read moreCASSANDRA-SPARK INSTALLATION AND CONNECTION
Install JDK, PYTHON, SCALA Set path for JDK and Python3 Install & Configure Cassandra Load…
Read moreProtected: Invalid Sys object after applying PSU patch
There is no excerpt because this is a protected post.
Read moreCluster failed to start due to ASM password file Issue (ORA-01017: invalid username/password)
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 :…
Read moreWHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR ORA-20002, ORA-04088, ORA-00604, ORA-20002
ISSUE: – WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line…
Read morePDB went in restricted mode in Oracle 19c
Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494…
Read moreORA-10567: Redo is inconsistent with data block on standby !!
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the…
Read moreExport from 11g and import to 19c
To perform the export/import first we need to create a backup directory at the OS…
Read moreProtected: Fixing a Corrupt Database Home.
There is no excerpt because this is a protected post.
Read moreRecovery using datafile copy – SWITCH DATAFILE TO COPY
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of…
Read moreTrigger – Oracle Database Objects
Overview of Triggers A database trigger is a compiled stored program unit, written in either…
Read moreORA-01000: Maximum Open Cursors Exceeded
The ORA-01000 error indicates that the maximum number of open cursors allowed in the database…
Read moreOracle Database Locking Mechanism – 3
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions…
Read moreHow to check Total, Active and Inactive sessions in Oracle database ?
To check the total, active, and inactive sessions in an Oracle database, you can query…
Read moreOPW-00029: Password complexity failed for SYS !!
PROBLEM : The attempt to create a password file for a 12.2 database failed :…
Read moreConnect String
This property specifies connection information used to connect to an Oracle database. The Oracle installer…
Read moreGrid Restart (HAS) & Clusterware (CRS)
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform…
Read moreChange Archivelog Destination (FRA)
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination…
Read moreORA-01194: file 1 needs more recovery to be consistent
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194:…
Read moreCassandra Commands
cassandra -f ./nodetool status ./nodetool ring ./nodetool -h 192.168.0.101 clean ./nodetool -h 192.168.0.101 info ./nodetool…
Read moreORA-00020: maximum number of processes (3000) exceeded
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to…
Read moreASM Day to Day Life Scripts
To identify the number of diskgroup ,status from below query. Size of ASM Diskgroup Check…
Read moreConnect To Hung Database In Oracle
Oracle hangs only when he is waiting for a resource. It might be a software…
Read more12.2 Index Advanced Compression “High”.
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a…
Read more