Error: [crayon-67411a57181e5539075038/] Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. Solution: It should be set as follows. ORACLE_UNQN average = XXXX …

  If you want to make a change in more than one session database at the same time, the control to prevent sessions from adversely …

  You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …

  Lock Compatibility provides the necessary control when multiple transactions have the same lock request (row, page). If the resource is previously locked by a …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …

  The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors …

  We can use Backup Restore for many operations. Below you can find the most common reasons for using it. 1. To get a regular …

Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * …

  Before you read this article, you need to know what the concept of partition is and how can we create partition for  a table. …