ORACLE

Cell services automatically start when the cell is started. You can follow the following procedures to start and stop manually. “CELLSRV, MS and RS” services …

  It is possible to reset Rman configurations to default values. You can see “#default” at the end of the unmodified configurations. It is possible …

  In the 12c databases, ORA-39014 ORA-39029 ORA-31671 and ORA-00600 errors can be received during expdp or impdp operation. In such a case, existing processes …

  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 …