COALESCE Function
The Oracle COALESCE() function accepts a list of arguments and returns the first one that…
Read moreJuly 2022
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 morePhysical Standby Configuration with ASM.
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
Read more