Monthly Archives: July 2022
COALESCE Function
The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value.
The following illustrates the syntax of the...
Check history of Executed queries
The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou have privileges to query this view, you can check...
CASSANDRA-SPARK INSTALLATION AND CONNECTION
Install JDK, PYTHON, SCALASet path for JDK and Python3Install & Configure CassandraLoad Data In CassandraInstall & Configure SparkSet Path for SparkSetup Cassandra-spark connector and...
Protected: Invalid Sys object after applying PSU patch
Invalid Sys object after applying PSU patch
SQL> select comp_name,version,status from dba_registry;
COMP_NAMEVERSIONSTATUSOracle Database Catalog Views19.0.0.0.0VALIDOracle Database Packages and Types19.0.0.0.0INVALIDOracle Real Application Clusters19.0.0.0.0VALIDOracle Workspace Manager19.0.0.0.0VALIDOracle...
Cluster 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 : olsnodes -nserver1 1server2 2server3 3
DB Alert Log:
/u01/oracle/product/diag/crs/server3/crs/trace/alert.log
String containing event: 2022-07-09...
WHILE 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 255138: script md/admin/sdordfm.plb- ORA-20002: ORA-06502: PL/SQL: numeric or value error: character...
PDB 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
$ORACLE_HOME/OPatch/datapatch -verbose
If you get INVALID object error, run the utlrp as below
cd $ORACLE_HOME/rdbms/admin$ORACLE_HOME/perl/bin/perl...
ORA-10567: Redo is inconsistent with data block on standby
ORA-10567: Redo is inconsistent with data block on standby
Issues:
ORA-10567: Redo is inconsistent with data block on standby
Error:
Thu May 21 18:24:10 2022Errors in file...
Export from 11g and import to 19c
To perform the export/import first we need to create a backup directory at the OS level as well as Database level using the following...
Protected: Fixing a Corrupt Database Home.
In situations where the 19c database home is found to be corrupt, the steps below can be used to replace certain files or replace...
Recovery using datafile copy – SWITCH DATAFILE TO COPY
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available on disk. In the...
Trigger – Oracle Database Objects
Overview of Triggers
A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle Database invokes ("fires") automatically in...
Physical Standby Configuration with ASM.
DataGuard_Conf_Primary-_with-ASMDownload
DataGuard_Conf_Standby_with-ASMDownload