{"id":1930,"date":"2016-04-28T10:18:44","date_gmt":"2016-04-28T07:18:44","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1930"},"modified":"2016-10-26T10:20:14","modified_gmt":"2016-10-26T07:20:14","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-15600-to-ora-16000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-15600-to-ora-16000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-15600 to ORA-16000"},"content":{"rendered":"

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

\n
ORA-15601: Invalid value specified for parameter “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid value was specified for the given parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the value being specified for the parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15602: Parameter “string<\/i>” cannot be NULL.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to call a procedure without a required parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid value for this parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15603: Action cannot be performed when database is in read-only mode.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A procedure in DBMS_AUTO_TASK_ADMIN package was invoked when database was open in read-only mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry when database is open in read\/write mode.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15604: Initialization parameters prevent client from being enabled.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to enable a client that was disabled for automatic execution by an initialization parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the related client parameters and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15605: “string<\/i>” is not a Maintenance Window<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Window name passed to DBMS_AUTO_TASK_ADMIN.ENABLE procedure must be a member of the MAINTENANCE_WINDOW_GROUP.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make the window a member of the MAINTENANCE_WINDOW_GROUP and retry the call.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15700: SQL limit already reached by prior task execution<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to resume the execution of a task when the prior execution already reached the SQL limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Task execution is complete. Examine the report to review Advisor’s recommendations.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15701: All “SQL Tuning Set(s)” with name like “string<\/i>” and owner like “string<\/i>” are empty<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to pack one or more SQL Tuning Sets, none<\/span><\/span><\/span><\/dd>\n
* of which contained any statements.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the input and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15702: duplicate values for plan line ID in input collection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid input was provided containing duplicate values for plan line IDs causing the load of the statement to fail.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the input and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15703: invalid version number “number<\/i>” for SQL tuning set staging table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid version number was provided for a staging table used to pack a SQL tuning set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the input and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15739: invalid name “string<\/i>” for SQL Performance Analyzer task<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid SQL Performance Analyzer task name was used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the name of the SQL Performance Analyzer task to ensure that it is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15740: parameter “string<\/i>” not set for SQL Performance Analyzer task “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not find the specified parameter name for the SQL Performance Analyzer task.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the specified parameter exists for the SQL Performance Analyzer task so that the parameter is set.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15741: no COMPARE_PERFORMANCE execution exists for SQL Performance Analyzer task “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not find an execution of type COMPARE_PERFORMANCE for specified SQL Performance Analyzer task.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the given SQL Performance Analyzer task has at least one execution of type COMPARE_PERFORMANCE.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-15742: specified execution name “string<\/i>” is not a valid COMPARE_PERFORMANCE execution for SQL Performance Analyzer task “string<\/i>“.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified execution name was not a valid execution of type COMPARE_PERFORMANCE for the SQL Performance Analyzer task.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that a valid COMPARE_PERFORMANCE execution name is used for the SQL Performance Analyzer task.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15743: need to specify the object ID if the tuning task is on a SQL set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There could be multiple objects in the SQL tuning task. Specify which one.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add object ID to the interface.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15744: The directory name is null.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The directory name for finding the SQL traces was null.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the directory.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15745: The plan type is not valid.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified plan type was not valid<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the existing plan types and specify the right one.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15746: Missing EXECUTE privilege on DBMS_AUTO_SQLTUNE.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current user was missing the necessary privileges to execute the API.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Grant the privilege and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15747: The previous Oracle Data Masking job is unfinished. “string<\/i>” table is not empty.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The previously executed Oracle Data masking job was not successfully completed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Execute Oracle Data masking cleanup.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16000: database open for read-only access<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database was opened for read-only access. Attempts to modify the database using DML or DDL statements generate this error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0In order to modify the database, it must first be shut down and reopened for read\/write access.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-15600 to ORA-16000 ORA-15601: Invalid value specified for parameter “string“ Cause:\u00a0An invalid value was specified for the given parameter. Action:\u00a0Correct the value being specified for the parameter. ORA-15602: Parameter “string” cannot be NULL. Cause:\u00a0An attempt was made to call a procedure without a required parameter. Action:\u00a0Specify a…<\/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":true,"_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-1930","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-v8","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1930","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=1930"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1930\/revisions"}],"predecessor-version":[{"id":1932,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1930\/revisions\/1932"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1930"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}