{"id":2223,"date":"2016-09-15T09:12:11","date_gmt":"2016-09-15T06:12:11","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2223"},"modified":"2017-02-09T09:13:30","modified_gmt":"2017-02-09T06:13:30","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-13900-to-ora-14000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-13900-to-ora-14000\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13900 to ORA-14000"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13700 to ORA-13900<\/strong><\/p>\n

\n
ORA-13900: missing or invalid parameter\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A call to SET_THRESHOLD procedure was either missing a parameter, or the parameter was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid value for this parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13901: Object\u00a0string<\/i>\u00a0was not found.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An object name was passed to SET_THRESHOLD procedure that did not map to a valid object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid object name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13902: The specified file\u00a0string<\/i>\u00a0is not a data file.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The object name was passed to a SET_THRESHOLD procedure that did not map to a valid data file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid data file name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13903: Invalid combination of\u00a0string<\/i>\u00a0threshold value and operator.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A non-positive number was used for “Blocked User Session Count” metrics while operator contains equal.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number for the threshold value or use “greater than” operator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13904: The file has been dropped and recreated during the procedure call.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The file on which threshold is specified was dropped and recreated during the procedure call.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry this operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13905: Critical or warning threshold have incorrect values<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The tablespace threshold values can be in the range 0 to 100 only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the threshold values<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-13906: The tablespace is not of the right type.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to set a threshold on dictionary-managed tablespaces.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the tablespace type and reissue the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13907: Threshold value is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an invalid value for critical or warning thresholds.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use non-negative integers only for threshold values.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13908: Invalid combination of metrics id and object type parameters.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an invalid combination of metrics id \/\/ and object type parameters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid combination of metrics id and object type parameters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13909: Invalid combination of threshold value and operator.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify an invalid combination of threshold value and operator.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the operator and threshold values and reissue statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13910: Parameter\u00a0string<\/i>\u00a0cannot be NULL.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to call GET_THRESHOLD procedure without a required parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid value for this parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13911: Threshold not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The threshold did not exist with the specified threshold key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13912: Critical threshold value is less than warning threshold value.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to call SET_THRESHOLD procedure with the critical threshold value less than the warning threshold value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the threshold values and reissue the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13913: The threshold cannot be set when SYSAUX is offline.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SET_THRESHOLD procedure was called when SYSAUX tablespace was offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Call SET_THRESHOLD procedure when SYSAUX is online.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13914: Threshold notification failed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred when sending notification for this threshold.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that you have enough space on SYSAUX tablespace and retry this operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13915: Critical byte based free space threshold value is greater than warning threshold value.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to call SET_THRESHOLD procedure with the bytes based critical threshold value greater than the warning threshold value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the threshold values and reissue the statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13916: Invalid value “string<\/i>” specified for parameter “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid value was specified for the the given parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the value being specified for the parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13917: Posting system alert with reason_id\u00a0string<\/i>\u00a0failed with code [string<\/i>] [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Connection to the database is dead, or invalid parameter to alert routine.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If this condition repeats, please contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13918: Updating system alert with reason_id\u00a0string<\/i>\u00a0failed; previous alert not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0System Error: An attempt to update a system alert failed. The alert was improperly cleared from WRI$_ALERT_OUTSTANDING.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not delete from WRI$_ALERT_OUTSTANDING. If this condition repeats, please contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13919: Cannot specify values for parameter “string<\/i>” and for parameter “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Can only specify a value for one or the other.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Pass just one of the parameters.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13920: Threshold cannot be set when database is in read-only mode.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SET_THRESHOLD procedure was called when database was open in read-only mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Call SET_THRESHOLD procedure when database is open in read\/write mode.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13951: MMON sub-action time limit exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0MMON sub-action did not complete within the system specified time frame.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-13970: Invalid name of “string<\/i>” given<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Passed an invalid component, report, or transformation name to the framework. Names must be alphanumeric and can contain the underscore (_) character.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try again with a valid name<\/span><\/span><\/p>\n

\n
<\/a> ORA-13971: Unknown\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Passed an unknown component, report, or transformation to the framework.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Give a different name<\/span><\/span><\/p>\n

\n
<\/a> ORA-13972: Unknown\u00a0string<\/i>\u00a0for this\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An object with the first name is unknown within the naming scope of the second name<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the parameters passed in or register the proper object<\/span><\/span><\/p>\n

\n
<\/a> ORA-13973: Unknown\u00a0string<\/i>\u00a0for this\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An object is unknown within the given naming scope<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the parameters passed in or register the proper object<\/span><\/span><\/p>\n

\n
<\/a> ORA-13974:\u00a0string<\/i>\u00a0with name “string<\/i>” already exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An object with the given name already exists<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Give a different name<\/span><\/span><\/p>\n

\n
<\/a> ORA-13975:\u00a0string<\/i>\u00a0with name “string<\/i>” already exists for\u00a0string<\/i>\u00a0“string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An object with the first name already exists within the naming scope of the second name<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Give a different name<\/span><\/span><\/p>\n

\n
<\/a> ORA-13976: Improperly-formed report tag<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The top-level report tag was not built properly.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the report tag is built using the common tag library function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13977: Invalid content type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid content type was passed to the register format API<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct your code to use the values in dbmsrep.sql<\/span><\/span><\/p>\n

\n
<\/a> ORA-13978: Invalid reference string parameter or value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid parameter\/value was passed to a dbms_report API<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the parameter names and values are alphanumeric.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13979: Filename too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid file name was passed to STORE_FILE<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the filename is less than 500 bytes<\/span><\/span><\/p>\n

\n
<\/a> ORA-13980: Invalid file URL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A URL with invalid syntax was provided, either directly to the function or via an XML IMPORT or INCLUDE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the URL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13981: Invalid file URL or path prefix<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a URL or path prefix with invalid syntax was provided.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the URL<\/span><\/span><\/p>\n

\n
<\/a> ORA-13982: Could not find file at URL provided<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The file requested could not be found in the given location.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the URL provided.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13983: Missing\u00a0body<\/i>\u00a0tag from HTML<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An HTML document was passed to the function missing its\u00a0body<\/i>\u00a0tag.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the HTML source.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13984: Invalid reference string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The given reference string could not be parsed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the reference string syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13985: Invalid URL provided to servlet<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid URL was provided to the servlet.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the URL.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13986: Error \\string<\/i>\u00a0received from XPath engine<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was received from the xpath library during an xpath operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check xmlerr.h to understand the cause of the error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13987: Invalid input to build common <string<\/i>> tag<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Invalid input was given when attempting to build a common tag.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the function input to ensure that all necessary information is given.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13988: Invalid input given to variable argument list report function.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid parameter was provided to one of the report framework variable argument list functions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the function input and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13989: Invalid input given to structured argument list report function.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid parameter was provided to one of the report framework structured argument list functions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the function input and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13990: Invalid tag name given to common tag callout function.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid tag name was provided to the report framework common tag callout function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the function input and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13991: failed to stop report capture on all instances<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is an internal Server Manageability Error<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services<\/span><\/span><\/p>\n

\n
<\/a> ORA-14000: only one LOCAL clause may be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0CREATE INDEX statement contained more than one LOCAL clause<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify LOCAL option at most once<\/span><\/span><\/p>\n

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13700 to ORA-13900 ORA-13900: missing or invalid parameter\u00a0string Cause:\u00a0A call to SET_THRESHOLD procedure was either missing a parameter, or the parameter was invalid. Action:\u00a0Specify a valid value for this parameter. ORA-13901: Object\u00a0string\u00a0was not found. Cause:\u00a0An object name was passed to SET_THRESHOLD procedure that did not map…<\/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":[54],"class_list":["post-2223","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-zR","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2223","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=2223"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"predecessor-version":[{"id":2224,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2223\/revisions\/2224"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}