The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. In this syntax, the COALESCE() function returns the first non-null expression in the list. It requires at least two expressions. In case all expressions evaluate to null, the function returns null. The following example returns one because it is … Read more
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 usefulqueries for you to do on this view. Get latest query select sql_text from v$sql where first_load_time=(select max(first_load_time) from v$sql); Sort executed queries by load … Read more
Install JDK, PYTHON, SCALA Set path for JDK and Python3 Install & Configure Cassandra Load Data In Cassandra Install & Configure Spark Set Path for Spark Setup Cassandra-spark connector and test INSTALLATION OF JAVA ON CENTOS 7 ISSUE RESOLUTION RELATED TO SUDOERS FILE: [root@cass-1 ~]# usermod -aG wheel cass [root@cass-1 ~]# su – cass [cass@cass-1 … Read more
There is no excerpt because this is a protected post.
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: Network communication with node server2 (2) has been missing for 50% of the timeout interval. If this persists, removal of this node from cluster will … Read more
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 line 255182: script md/admin/sdordfb.plb- ORA-04088: error during execution of trigger ‘SYS.SERVER_ERROR_TO_ALERT’-> Error at line 255183: script md/admin/sdordfb.plb- ORA-00604: error occurred at recursive SQL level 1-> … Read more
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 catcon.pl -n 1 -e -c P327 -b utlrp -d ”’.”’ utlrp.sql There is a chance that the PDB will still be in restricted mode even … Read more
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the primary site, take a backup of the datafile: 2) Transfer the file to the standby site using an operating system utility such as scp, NFS, ftp etc 3) At the standby site, catalog the backup piece and confirm it’s available … Read more
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 Take Full Export from 11g Database Check tablespaces Before importing the above data in Oracle 19c you must check the existing tablespaces detail in the Oracle … Read more