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 …
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 …
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 …
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. …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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.
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 …
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: …
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 …
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 …
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 …
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 …
ORA-02000: missing SHARED_POOL keyword
You are trying to flush the shared pool, but the SHARED_POOL keyword is missing or misspelled. eg:
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 …
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 …
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 …
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 …
ORA-01912: ROW keyword expected
You are creating a trigger, but forgot or incorrectly specified the ROW keyword:
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 …
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 …
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 …
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 …
DbMotive is an