ORACLE

  The “alter system flush redo” command, which is used to transfer operations in the redo log files in the primary database to the standby …

In this article, I will tell you to get the create script of an oracle user. First, we will create a file named user.sql that …

  When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in …

enq: TX – row lock contention can be regarded as a row lock conflict wait event in operations. This event indicates that a session is …

  Latch free and library cache: mutex X wait events can be seen for the corresponding SQL statements in intensive delete and insert operations in …

In 12c databases, ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] errors may occur depending on bug 25694206. User operation cannot be completed due to the closing …

  If an oracle user is locked, it is usually caused by an incorrect password entry. In some cases, even if you remove the user’s …

  On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller. INS-35354: The …

  When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem …

With ADRCI, it is possible to delete files such as “log, trace, incident, cdump” created before a certain day. Instead of manually deleting individual files, …