Home 2022 July

Monthly Archives: July 2022

COALESCE Function

0
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

0
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...
black blue and red graph illustration

CASSANDRA-SPARK INSTALLATION AND CONNECTION

0
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

0
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)

0
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

0
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

0
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

0
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...
Computer Servers

Export from 11g and import to 19c

0
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...
people space apple industry

Protected: Fixing a Corrupt Database Home.

0
In situations where the 19c database home is found to be corrupt, the steps below can be used to replace certain files or replace...
close up photo of programming of codes

Recovery using datafile copy – SWITCH DATAFILE TO COPY

0
By using Optimized Incremental Backup to disk backup strategy, an up to date copy of the database is always available on disk. In the...
a detective turning the switch of a vintage recorder

Trigger – Oracle Database Objects

0
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...
Landsat Data Continuity Mission Environmental Testing is Underway

Physical Standby Configuration with ASM.

0
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload