July 2022 - ASRblogger

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 Oracle COALESCE() function: COALESCE(e1, e2,…

asrblogger July 27, 2022No Comments

Oracle

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 all from it. Below are some…

asrblogger July 27, 2022No Comments

Oracle

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 test INSTALLATION OF JAVA ON CENTOS…

asrblogger July 27, 2022No Comments

Oracle

Protected: Invalid Sys object after applying PSU patch

This content is password protected. To view it please go to the post page and enter the password.

asrblogger July 26, 2022

ASM Oracle

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 04:06:51.055 [OCSSD(62652)]CRS-1612:…

asrblogger July 26, 2022No Comments

Oracle

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 string buffer-> Error at…

asrblogger July 26, 2022No Comments

Oracle

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…

asrblogger July 26, 2022No Comments

DataGuard Oracle

ORA-10567: Redo is inconsistent with data block on standby !!

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 (incident=360771): ORA-00600: internal error code, arguments: [3020], [408], [671265], [1711947297],…

asrblogger July 26, 2022No Comments

Oracle

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 steps. Create a backup directory $mkdir…

asrblogger July 19, 2022No Comments

Oracle RAC

Protected: Fixing a Corrupt Database Home.

This content is password protected. To view it please go to the post page and enter the password.

asrblogger July 18, 2022

COALESCE Function

Check history of Executed queries

CASSANDRA-SPARK INSTALLATION AND CONNECTION

Protected: Invalid Sys object after applying PSU patch

Cluster failed to start due to ASM password file Issue (ORA-01017: invalid username/password)

WHILE RUNNING DATAPATCH VERBOSE WE ARE GETTING FOLLOWING ERROR ORA-20002, ORA-04088, ORA-00604, ORA-20002

PDB went in restricted mode in Oracle 19c

ORA-10567: Redo is inconsistent with data block on standby !!

Export from 11g and import to 19c

Protected: Fixing a Corrupt Database Home.

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!