ORA-00060

ORA-00060 deadlock detected while waiting for resource What causes an ORA-00060 error? Your session and another session are waiting for a resource locked by the other. This condition is known

Read More »

ORA-01017

ORA-01017 What causes an ORA-01017 error? An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as

Read More »

ORA-01555

ORA-01555 What causes an ORA-01555 error? Rollback records needed by a reader for consistent read are overwritten by other writers. How Xynomix can help If in Automatic Undo Management mode,

Read More »

ORA-04031

ORA-04031 unable to allocate string bytes of shared memory (“string”,”string”,”string”,”string”) What causes an ORA-04031 error? More shared memory is needed than was allocated in the shared pool. How Xynomix can

Read More »

ORA-03113

ORA-03113 end-of-file on communication channel What causes an ORA-03113 error? An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software.

Read More »
ORA Codes

ORA-00600

ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] What causes an ORA-00600 error? This is the generic internal error number for Oracle program exceptions. It

Read More »

ORA-12154

ORA-12154: TNS:could not resolve the connect identifier specified What causes an ORA-12154 error? A connection to a database or other service was requested using a connect identifier, and the connect

Read More »

ORA-00910

ORA-00910 specified length too long for its datatype What causes an ORA-00910 error? No size was specified for a character field or the size was invalid. A maximum length must

Read More »

ORA-00909

ORA-00909 invalid number of arguments What causes an ORA-00909 error? An Oracle function was referenced with an incorrect number of arguments. All Oracle functions, except for SYSDATE, require at least

Read More »

ORA-00908

ORA-00908 missing NULL keyword What causes an ORA-00908 error? Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values

Read More »

ORA-00907

ORA-00907 missing right parenthesis What causes an ORA-00907 error? A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses

Read More »

ORA-00905

ORA-00905 Error What causes an ORA-00905 error? A required keyword is missing. How Xynomix can help We can correct the syntax. Contact us for more information. To learn more about

Read More »