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...
Oracle
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
The ORA-01000 error indicates that the maximum number of open cursors allowed in the database session has been exceeded. This...
4 min read
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires...
2 min read
To check the total, active, and inactive sessions in an Oracle database, you can query the V$SESSION view. Checking Total...
1 min read
PROBLEM : The attempt to create a password file for a 12.2 database failed : $ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle OPW-00029:...
1 min read
This property specifies connection information used to connect to an Oracle database. The Oracle installer generally places a sample tnsnames.ora...
Identify if Grid ASM is Cluster ware or High Availability Solution Check in OS Platform (Oracle /Redhat Linux) if ];then...
2 min read
Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can...
1 min read
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to...
1 min read
cassandra -f ./nodetool status ./nodetool ring ./nodetool -h 192.168.0.101 clean ./nodetool -h 192.168.0.101 info ./nodetool -h 192.168.0.101 compact ./nodetool flush...
3 min read
PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for...
5 min read
To identify the number of diskgroup ,status from below query. select group_number,name from v$asm_diskgroup; select group_number, name, state, type from...
1 min read
Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock),...
2 min read
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE...
