Oracle Error Codes

Puzzled by an Oracle Error Message? We have an extensive Oracle error code database to get you started

ORA-02096: specified initialization parameter is not modifiable with this option

Though the initialization parameter is modifiable, it cannot be modified using the specified command. For example, you try to change …

Read More

ORA-02095: specified initialization parameter cannot be modified

You are trying to modify a initialization parameter which cannot be modified online. Checking the v$parameter data dictionary view reveals …

Read More

ORA-02085: database link %s connects to %s

This error happens when the database parameter global_names is set to TRUE. When this is the case, the database link …

Read More

ORA-02084: database name is missing a component

You are trying to access data over a database link, but you entered an incorrect name for the database link. …

Read More

ORA-02083: database name has illegal character ‘%s’

You supplied a database name, but it contains characters other than A-Z, 0-9, ‘_’, ‘#’, ‘$’, ‘.’ and ‘@’. This …

Read More

ORA-02078: invalid setting for ALTER SYSTEM FIXED_DATE

You are trying to set the parameter fixed_date to a certain value, but the value is incorrect. Probably it is …

Read More

ORA-02068: Following severe error from %s%s

There was an error when issuing a select over a database link. This error message is normally followed by another …

Read More

ORA-02067: transaction or savepoint rollback required

You call a remote procedure or package over a database link. Now, on the other side (the remote side), there …

Read More

ORA-02065: illegal option for ALTER SYSTEM

You are executing the alter system command, but the syntax you have specified is incorrect, or one of the parameters …

Read More

ORA-02063: preceding %s%s from %s%s

There was an error when issuing a select over a database link. This error message is normally preceded by another …

Read More

ORA-02056: 2PC: %s: bad two-phase command number %s from %s

There was a problem with the two-phase commit protocol error. An automatic recovery of transaction was attempted. Following data dictionary …

Read More

ORA-02055: distributed update operation failed; rollback required

You call a remote procedure or package over a database link. Now, on the other side (the remote side), there …

Read More

ORA-02050: Transaction %s rolled back, some remote DBs may be in-doubt

Network or remote failure in two phase commit. select * from dba_2pc_pending to see if any transaction is failed and …

Read More

ORA-02049: timeout: distributed transaction waiting for lock

exceeded INIT.ORA distributed_lock_timeout seconds waiting for lock. Treat as a deadlock, check dba_2pc_pending and dba_2pc_waiting.

Read More

ORA-02030: can only select from fixed tables/views

You are trying to grant privileges on a system table, but are probably using a synonym instead of the actual …

Read More

ORA-02019: connection description for remote database not found

You are trying to access a remote object (table, procedure, view, …) but are using an unknown database link eg: …

Read More

ORA-02017: integer value required

You are changing a parameter, but did not provide a (positive) integer value: Change the value so it is 0 …

Read More

ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. eg: You should use a different view, or rewrite …

Read More

ORA-02011: Duplicate database link name

The database link you are trying to create already exists on the database: eg: First we create a database link …

Read More

ORA-02002: error while writing to audit trail

You are trying to logon to an Oracle database, but the database was unable to write the logon information to …

Read More

ORA-02000: missing SHARED_POOL keyword

You are trying to flush the shared pool, but the SHARED_POOL keyword is missing or misspelled. eg:

Read More

ORA-01995: error reading password file ‘%s’

The password file you are using is corrupt, or not readable by the Oracle software. You need to check the …

Read More

ORA-01989: role ‘%s’ not authorized by operating system

You were granted a externally protected role and you try to enable it using the set role command. However, the …

Read More

ORA-01979: missing or invalid password for role ‘%s’

You were granted a password protected role and you try to enable it using the set role command. However, you …

Read More

ORA-01918: user ‘%s’ does not exist

You are trying to change the password of a user, but the user in the ALTER USER statement does not …

Read More

ORA-01912: ROW keyword expected

You are creating a trigger, but forgot or incorrectly specified the ROW keyword:

Read More

ORA-01898: too many precision specifiers

While trying to truncate or round dates, extra data was found in the date format picture. You need to correct …

Read More

ORA-01861: Literal does not match format string

You tried to convert a literal using a format string, but the length of the format mask didn’t match the …

Read More

ORA-01860: week of year must be between 1 and 53

A week number outside the range 1 to 53 was specified. Use only a value within the valid range for …

Read More

ORA-01858: A non-numeric character was found where a numeric was expected

You are trying to convert a string to a date using the TO_DATE function, but the string does not match …

Read More

Page 1 of 1212345»10...Last »
Oracle Gold Partner DbMotive is an Oracle Gold Partner