ORACLE

We can display the cause of an error that we received and troubleshooting suggestions, with the OERR Utility. It is located under the $ORACLE_HOME/bin directory. …

  The database instances can be closed with an “ASMB terminating” error due to a bug. The error codes are ORA-15064 and ORA-03113. Possible errors …

  Rman creates a control file snapshot file or a consistent control file image in the control file backups. While a rman process taking a …

  We can see the locks on Library cache objects in V$ACCESS (GV$ACCESS on RAC systems). The dependency on objects is managed by library locks. …

  In RAC databases, serious cluster wait events are seen, usually due to the low speed of interconnect interfaces. Therefore, after the installation, faster hardware interfaces …

  ORA-00313 error can be received depending on any problem in redo log files in standby database. The possible error message will be as follows. …

  The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …

  Result Cache is the memory space in the shared pool area within the Shared Global Area (SGA). In this memory area, the database query …

  We can also display the execution plan with sqlplus. For this we can use the explain plan tool with sqlplus. To use the Explain …

  When you try to get a backup with Expdp, if the process ends with error ORA-01426: numeric overflow, there are some alternative solutions. During …