1 min read
The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. The following...
Month: July 2022
1 min read
1 min read
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou have privileges to query this...
4 min read
Install JDK, PYTHON, SCALASet path for JDK and Python3Install & Configure CassandraLoad Data In CassandraInstall & Configure SparkSet Path for...
5 min read
This content is password protected. To view it please enter your password below: Password:
3 min read
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3...
3 min read
ISSUE: - WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR -> Error at line 255138: script md/admin/sdordfm.plb- ORA-20002: ORA-06502:...
1 min read
Issue: PDB went into restricted mode Investigation su - oracle export ORACLE_HOME=/u01/oracle/product/19/db export ORACLE_SID= cp9494 $ORACLE_HOME/OPatch/datapatch -verbose If you get...
1 min read
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Thu May 21 18:24:10 2022 Errors in file /u02/diag/rdbms/prod/prod1/trace/prod1_pr0s_12697.trc...
1 min read
To perform the export/import first we need to create a backup directory at the OS level as well as Database...
3 min read
This content is password protected. To view it please enter your password below: Password:
5 min read
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available...
5 min read
Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle...
1 min read
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
