Oracle/PLSQL: ORA-00051 Learn the cause and how to resolve the ORA-00051 error message in Oracle. Description When you encounter an ORA-00051 error, the following error message will appear: ORA-00051: time-out occurred while waiting for resource Cause You were waiting for a resource and you timed out. This may have been caused by an Oracle instance […]
Category: Databases
ORA-00034: cannot COMMIT or ROLLBACK in current PL/SQL session
Oracle/PLSQL: ORA-00034 Learn the cause and how to resolve the error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00034: cannot COMMIT or ROLLBACK in current PL/SQL session Cause You tried to issue a COMMIT or ROLLBACK command from a PLSQL function, procedure, or package. However, COMMIT and ROLLBACK […]
ORA-00028: your session has been killed
Oracle/PLSQL: ORA-00028 Learn the cause and how to resolve the ORA-00028 error message in Oracle. Description When you encounter an ORA-00028 error, the following error message will appear: ORA-00028: your session has been killed Cause Your session has been killed by a privileged user (such as a DBA). Resolution The option(s) to resolve this Oracle […]
ORA-00023: session references process’ private memory; cannot detach session
Oracle/PLSQL: ORA-00023 Learn the cause and how to resolve the ORA-00023 error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00023: session references process’ private memory; cannot detach session Cause You tried to detach a session but it contains references to the process memory (PGA) through any of: an […]
ORA-00020: maximum number of processes num exceeded
Oracle/PLSQL: ORA-00020 Learn the cause and how to resolve the error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00020: maximum number of processes num exceeded Cause You tried to execute a statement that requested a resource. Since the maximum number of processes have been reached, Oracle will not […]
ORA-00017: session requested to sevent et trace
Oracle’s error code: ORA-00017 Description When you encounter an ORA-00017 error, the following error message will appear: ORA-00017: session requested to sevent et trace Cause The current session was requested to set a trace event by another session.. Resolution This is used internally; no action is required.
ORA-00018 maximum number of sessions exceeded
Oracle’s error code: ORA-00018 Description When you encounter an ORA-00018 error, the following error message will appear: ORA-00018 maximum number of sessions exceeded Cause All session state objects are in use. Resolution Increase the value of the SESSIONS initialization parameter.
ORA-00002: error in writing to export file
Oracle’s error code: ORA-00002 Description When you encounter an ORA-00002 error, the following error message will appear: ORA-00002: error in writing to export file Cause Export could not write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system. Resolution Take appropriate […]
ORA-00001: unique constraint (constraint_name) violated
Oracle’s error code: ORA-00001 Description When you encounter an ORA-00001 error, the following error message will appear: ORA-00001: unique constraint (constraint_name) violated Cause You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. Resolution The option(s) to resolve this Oracle error […]
