{"id":1988,"date":"2016-05-15T14:51:51","date_gmt":"2016-05-15T11:51:51","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1988"},"modified":"2016-11-02T14:53:47","modified_gmt":"2016-11-02T11:53:47","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-20000-to-ora-22000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-20000-to-ora-22000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000<\/strong><\/p>\n

\n
ORA-20000:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The stored procedure ‘raise_application_error’ was called which causes this error to be generated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem as described in the error message or contact the application administrator or DBA for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21300: objects option not installed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The objects option is not installed at this site. object types and other object features are, therefore, unavailable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Install the objects option. The objects option is not part of the Oracle Server product and must be purchased separately. Contact an Oracle sales representative if the objects option needs to be purchased.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21301: not initialized in object mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This function requires the OCI process to be initialized in object mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify OCI_OBJECT mode when calling OCIInitialize().<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21500: internal error code, arguments: [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>], [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is the generic error number for the OCI environment (client-side) internal errors. This indicates that the OCI environment has encountered an exceptional condition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report as a bug – the first argument is the internal error number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21501: program could not allocate memory<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The operating system has run out of memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Take action to make more memory available to the program.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21503: program terminated by fatal error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A program is in an unrecoverable error state.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report as a bug.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21520: database server driver not installed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to access a database server through an object-mode OCI environment but the necessary driver for supporting such access to the database server is not installed or linked in.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check if the driver corresponding to the database server has been installed\/linked in and entered in the server driver table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21521: exceeded maximum number of connections in OCI (object mode only)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User exceeded the maximum number of connections (255) that can be supported by an OCI environment in object mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Close some of existing and unused connections before opening more connections.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21522: attempted to use an invalid connection in OCI (object mode only)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to use an invalid connection or a connection that has been terminated in an OCI environment (object mode), or user attempted to dereference a REF obtained from a connection which has been terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the connection exists and is still valid.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21523: functionality not supported by the server (object mode only)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to use a functionality that the server does not support.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Upgrade the server<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21524: object type mismatch<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object type of the object is different from what is specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the type of the object and correct it.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-21525: attribute number or (collection element at index)\u00a0string<\/i>\u00a0violated its constraints<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attribute value or collection element value violated its constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the value of the attribute or collection element such that it meets its constraints. The constraints are specified as part of the attribute or collection element’s schema information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21526: initialization failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The initialization sequence failed. This can happen, for example, if an environment variable such as NLS_DATE_FORMAT is set to an invalid value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that all NLS environment variables are well-formed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21527: internal OMS driver error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A process has encountered an exceptional condition. This is the generic internal error number for Oracle object management services exceptions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report this as a bug to Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21528: internal error, image could not be understood<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The format of the image passed to the pickler is incorrect and cannot be understood.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21560: argument\u00a0string<\/i>\u00a0is null, invalid, or out of range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The argument is expecting a non-null, valid value but the argument value passed in is null, invalid, or out of range. Examples include when the LOB\/FILE positional or size argument has a value outside the range 1 through (4GB – 1), or when an invalid open mode is used to open a file, etc.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your program and correct the caller of the routine to not pass a null, invalid or out-of-range argument value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21561: OID generation failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The handles passed in may not be valid<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the validity of the env, svc handles<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21600: path expression too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The path expression that is supplied by the user is too long. The path expression is used to specify the position of an attribute in an object. This error occurs when one of the intermediate elements in the path expression refers to an attribute of a built-in type. Thus, the OCI function cannot proceed on to process the rest of the elements in the path expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should pass in the correct path expression to locate the attribute.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21601: attribute is not an object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user attempts to perform an operation (that is valid only for an object) to an attribute of a built-in type. An example of such an illegal operation is to dynamically set a null structure to an attribute of a built-in type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should avoid performing such operation to an attribute of built-in type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21602: operation does not support the specified typecode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user attempts to perform an operation that does not support the specified typecode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should use the range of valid typecodes that are supported by this operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21603: property id [string<\/i>] is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified property id is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should specify a valid property id. Valid property ids are enumerated by OCIObjectPropId.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21604: property [string<\/i>] is not a property of transient or value instances<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to get a property which applies only to persistent objects.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should check the lifetime and only get this property for persistent objects.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21605: property [string<\/i>] is not a property of value instances<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to get a property which applies only to persistent and transient objects.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should check the lifetime and only get this property for persistent and transient objects.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21606: can not free this object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to free an object that is persistent and dirty and the OCI_OBJECTFREE_FORCE flag is not specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either flush the persistent object or set the flag to OCI_OBJECTFREE_FORCE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21607: memory cartridge service handle not initialized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use the handle without initializing it.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Initialize the memory cartridge service handle.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21608: duration is invalid for this function<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use a duration not valid for this function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a valid duration – a previously created user duration or OCI_DURATION_STATEMENT or OCI_DURATION_SESSION. For callout duration or external procedure duration, use OCIExtProcAllocCallMemory.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21609: memory being resized without being allocated first<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to resize memory without allocating it first.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Allocate the memory first before resizing it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21610: size [string<\/i>] is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to resize memory with invalid size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass in a valid size (must be a positive integer).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21611: key length [string<\/i>] is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use an invalid key length.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Key length is invalid and valid range is 0 to 64<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21612: key is already being used<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use a key that is already used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a new key that is not yet being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21613: key does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to use a non-existent key<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a key that already exists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21614: constraint violation for attribute number [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Constraints on the attribute were violated<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the value (of the attribute) so that it satisfies constraints<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21615: copy of an OTS (named or simple) instance failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0see following message<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that no attribute value violates constraints.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21700: object does not exist or is marked for delete<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to perform an inappropriate operation to an object that is non-existent or marked for delete. Operations such as pinning, deleting and updating cannot be applied to an object that is non-existent or marked for delete.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User needs to re-initialize the reference to reference an existent object or the user needs to unmark the object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21701: attempt to flush objects to different servers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to flush objects to different servers in one function call. These objects are obtained by calling a callback functions provided by the program.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should avoid performing such operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21702: object is not instantiated or has been de-instantiated in cache<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to perform an inappropriate operation to a transient object that is not instantiated in the object cache. Operations that cannot be applied to a not-instantiated transient object include deleting or pinning such an object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should check their code to see if they are performing such an operation without instantiating the object first, or performing such an operation after the allocation duration of the object has expired.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21703: cannot flush an object that is not modified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0See the error message.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The object should not be flushed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21704: cannot terminate cache or connection without flushing first<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0See the error message.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The transaction should be aborted or committed before terminating the cache or connection.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21705: service context is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The service context that is supplied by the user is not valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User needs to establish the service context.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21706: duration does not exist or is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The duration number that is supplied by the user is not valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User needs to establish the duration or use a correct predefined duration.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21707: pin duration is longer than allocation duration<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pin duration supplied by the user is longer than the allocation duration. This affects operations such as pinning and setting default parameters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should use a shorter pin duration or use the null duration.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21708: inappropriate operation on a transient object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to perform an inappropriate operation on a transient object. Operations that cannot be applied to a transient object include flushing and locking.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should avoid performing such operation on a transient object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21709: cannot refresh an object that has been modified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to refresh an object that has been marked for delete, update or insert (new).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should unmark the object before refreshing it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21710: argument is expecting a valid memory address of an object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object memory address that is supplied by the user is invalid. The user may have passed in a bad memory address to a function that is expecting a valid memory address of an object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should pass in a valid memory address of an object to the function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21779: duration not active<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User is trying to use a duration that has been terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should avoid performing such operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-21780: Maximum number of object durations exceeded.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This typically happens if there is infinite recursion in the PL\/SQL function that is being executed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0User should alter the recursion condition in order to prevent infinite recursion.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000 ORA-20000:\u00a0string Cause:\u00a0The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Action:\u00a0Correct the problem as described in the error message or contact the application administrator or DBA for more information. ORA-21300: objects option not installed Cause:\u00a0The objects option is not installed…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1988","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-w4","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1988"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1988\/revisions"}],"predecessor-version":[{"id":1989,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1988\/revisions\/1989"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1988"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}