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 More