ORA Error
ORA errors show problems that can occur in the Oracle Database, such as failures in configuration, performance or query execution. Resolving these errors quickly guarantees the stability of the environment.
In this category, you’ll learn how to diagnose and correct the most common ORA errors with practical tutorials. Discover the causes of these problems, see how to avoid them and apply efficient solutions. We explain how to interpret error messages, use troubleshooting tools and resolve situations in real environments.
When applying the datapatch, the following error was encountered ORA-01400: cannot insert NULL into…
When trying to view the Java version, using a query in the database, the error ORA-29548 is reported.Here’s how to quickly solve this…
Here’s a quick tip on how to resolve the error: ORA-01623: log 12 is current log for instance UNNAMED_INSTANCE_2 (thread 2) –…
Problem: When trying to execute opatchauto outofplace, the execution failed with the error below: Solution: Clear checkpoint file(s) from a…
Ao tentar conectar-se com sqlplus / as sysdba é apresentado o erro de ORA-12547: TNS:lost contact. Abaixo apresento algumas formas de correção…
After completing a database upgrade, difficulties arose in starting the database via srvctl. To fix this, you have to tell srvctl the new home…
When creating a simple table, an insufficient privileges error occurred:ERROR at line 1: ORA-01031: insufficient privileges.This happened…
I needed to assign the DBA privilege to a user and came across the error: The error is due to the entries option that is used to create the…
When trying to create a SPFILE in an ASM instance, I got the following error: ORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0…