Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
What is Endian? Endian is the storage method of multi-byte data types in memory. In other words, it determines the byte order of the data. …
Read More »
ORACLE
ORA-01017: invalid username/password error received during connection to standby database
Even if the password (orapwSID) file in the primary database is copied to the standby database side and the you can connect to the primary …
Read More »
Find How Much Time Left For Query Completion Oracle
We can use the information in the v$session_longops view to determine the working time and the remaining time of a transaction in an active session. …
Read More »
How To Compress Data Pump Export
Since Oracle 11g version, Data Pump allows to compress the backup before writing to dump file with “compression” parameter. The Compression parameter takes 4 values. …
Read More »
ORA-27104: system-defined limits for shared memory was misconfigured
In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is not set correctly. The problem …
Read More »
What is ASM Failure Group
ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups. If the …
Read More »
Cannot communicate with crsd
In Oracle RAC databases, for cluster operations, errors can be received because the crsd process is stopped or suspended. In this case, it should check …
Read More »
ORA-00600: internal error code, arguments: [kclantilock_17]
This error can be received from databases in Oracle 12.2 and later. This error causes Instance to restart. This is due to bug 27162390. The …
Read More »
ORA-00600: internal error code, arguments: [kdza_check_eq not in dictionary]
This error can be received when the HCC tables are queried or processed on databases in Oracle database 11.2.0.3 and above. It is seen because …
Read More »
Failed voting file relocation on diskgroup DBFS_DG
If access to cellnodes with voting files is not available, relocation errors can be received as follows, even if access is possible later. This error …
Read More »