{"id":1856,"date":"2016-04-06T12:06:39","date_gmt":"2016-04-06T09:06:39","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1856"},"modified":"2016-10-24T12:08:08","modified_gmt":"2016-10-24T09:08:08","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12400-to-ora-12500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12400-to-ora-12500\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12400 to ORA-12500"},"content":{"rendered":"

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

\n
ORA-12400: invalid argument to facility error handling<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product\/facility.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid facility error handling parameter value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12401: invalid label string:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy could not convert the label string to a valid internal label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the syntax of the label string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12402: invalid format string:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The format string is not supported by the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the syntax of the format string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12403: invalid internal label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An internal label could not be converted to a valid label for the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Analyze any additional messages on the error stack and consult the policy documentation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12404: invalid privilege string:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy could not interpret the privilege string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a privilege string that is supported by the policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12405: invalid label list<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy determined that the label list was invalid for its intended use.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the policy constraints on the specific list of labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12406: unauthorized SQL statement for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy did not authorize the database session to perform the requested SQL statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Grant the user or program unit the necessary policy privilege or additional authorizations.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12407: unauthorized operation for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy did not authorize the database session to perform the requested operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Grant the user or program unit the necessary policy privilege or additional authorizations.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12408: unsupported operation:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified policy does not support the requested operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult the policy documentation to determine the supported access mediation operations.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12409: policy startup failure for\u00a0string<\/i>\u00a0policy<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy encountered an error during startup processing; access to the data protected by the policy is prohibited.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the alert log for additional information, correct the policy error, and restart the instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12410: internal policy error for policy:\u00a0string<\/i>\u00a0Error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy enforcement encountered an internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult the policy documentation for details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12411: invalid label value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified label value does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the data dictionary views for the policy to identify valid labels.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12412: policy package\u00a0string<\/i>\u00a0is not installed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy package does not exist in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the policy package name is correct or install the required policy package.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12413: labels do not belong to the same policy<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The labels being compared belong to different policies.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only compare labels that belong to the same policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12414: internal LBAC error:\u00a0string<\/i>\u00a0Error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An internal label policy framework error occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12415: A column of another datatype exists on the specified table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The datatype of the column present in the table is different from the datatype set for the policy column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the column on the table or change the datatype for policy column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12416: policy\u00a0string<\/i>\u00a0not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified policy does not exist in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter the correct policy name or create the policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12417: database object “string<\/i>” not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified object was not in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter the correct name for the database object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12418: user\u00a0string<\/i>\u00a0not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified user does not exist in the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the user name or create the user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12419: null binary label value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A null value was provided for a binary label operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a valid binary label for the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12420: required procedures and functions not in policy package “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy package did not contain all of the procedures and functions necessary to enforce the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult the label framework documentation for a list of required procedures and functions for a policy package.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12421: different size binary labels<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The label sizes for the binary label operation were not equal.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide binary labels with the same lengths for the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12422: max policies exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to create a new policy, but the maximum number of policies for the instance had already been created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Increase the size of the MAX_LABEL_POLICIES initialization parameter and restart the server.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12423: invalid position specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The position specified for a binary label operation was invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a position that is within the label size limits.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12424: length exceeds binary label size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The length specified for a binary label operation exceeded the the size of the binary label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a bit or byte length that is within the label size limits.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12425: cannot apply policies or set authorizations for system schemas<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to either apply a policy to the SYS, SYSTEM, or LBACSYS schema or to set user labels\/privileges for the SYS, SYSTEM, or LBACSYS user.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Apply policies and set authorizations only for non-system users.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12426: invalid audit option<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The option specified was not a valid audit option for the specified policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a correct audit option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12427: invalid input value for\u00a0string<\/i>\u00a0parameter<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An input parameter was specified incorrectly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the parameter value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12429: label list range exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified index value was not between 1 and 6.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the index value for the label list operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12430: invalid privilege number<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified privilege number was not between 1 and 32.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the privilege number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12431: invalid audit action<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified audit action was not a valid audit action.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the audit action number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12432: LBAC error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0LBAC enforcement resulted in an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem identified in the error message.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12433: create trigger failed, policy not applied<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy could not be applied due to errors during the creation of a DML trigger.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the SQL syntax of the label function specification.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12434: invalid audit type:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The audit type must be BY ACCESS or BY SESSION.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the audit type value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12435: invalid audit success:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The audit success parameter must be SUCCESSFUL or NOT SUCCESSFUL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the audit success value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12436: no policy options specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A NULL option string was specified, but no default schema or policy option string was found.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a valid option string, or alter the schema or policy to have a valid default option string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12437: invalid policy option:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A value that was not a valid policy option was entered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the policy option value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12438: repeated policy option:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A policy option was entered more than once in the option string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate policy option value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12439: invalid combination of policy options<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A set of contradictory policy options was entered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a set of compatible policy options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12440: insufficient authorization for the SYSDBA package<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The use of the SYSDBA package requires the LBAC_DBA role.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Grant the LBAC_DBA role to the database user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12441: policy\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to create a policy with the same name as an existing one.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different name or drop the existing policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12442: policy column “string<\/i>” already used by an existing policy<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to create a policy with the same policy column name as an existing policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different name for the policy column or drop the existing policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12443: policy not applied to some tables in schema<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You applied a policy to a schema, and some of the tables in the schema already had the policy applied.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action necessary; the policy was applied to the remaining tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12444: policy already applied to table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to apply a policy to a table that was already protected by the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To change the policy options, predicate, or label function, remove the policy from the table and re-apply it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12445: cannot change HIDDEN property of column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to specify a different HIDE option for a table with an existing policy column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the column from the table and reapply the policy with the new HIDE option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12446: Insufficient authorization for administration of policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to perform an administrative function for a policy, but you have not been granted the <policy>_DBA role.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Grant the user the <policy>_DBA role for the specified policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12447: policy role already exists for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The role named <policy>_DBA already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the policy name or delete the existing policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12448: policy\u00a0string<\/i>\u00a0not applied to schema\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to alter a schema policy that was not applied.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the policy name or schema name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12449: Labels specified for user must be of type USER<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to set labels for a user, but the labels in the list were not all designated as USER labels.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Alter the labels to be USER labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12450: LOB datatype disabled in LBAC initialization file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to specify a LOB datatype for a column or attribute, but the use of the LOB datatype has been disabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the LBAC initialization file to allow the creation of LOB columns and attributes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12451: label not designated as USER or DATA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A label is either a DATA label, a USER label, or both DATA and USER.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter TRUE for at least DATA or USER.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12452: label tag\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The label tag value you entered is already in use for another label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a different value for the label tag.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12453: label\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The label value you entered already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action necessary; alter the label to change its tag or type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12454: label\u00a0string<\/i>\u00a0does not exist for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The label tag or value you entered did not identify a label for the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a label value or tag that is in use by the policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12455: internal error in Label Security MMON cleanup task<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An internal error occurred in the Label Security MMON cleanup task.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12456: label security startup in progress<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to connect to the database before the Oracle Label Security component was fully initialized.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the database is fully open before attempting to connect.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12457: security label exceeded maximum allowable length<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An operation attempted to materialize a security label greater than 4000 bytes in length.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult the Oracle Label Security documentation for information on how the length of a security label is calculated. Re-submit the operation once the problem has been corrected.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12461: undefined level\u00a0string<\/i>\u00a0for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified level is not defined for the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the level identifier value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12462: undefined compartment\u00a0string<\/i>\u00a0for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified compartment is not defined for the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the compartment identifier value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12463: undefined group\u00a0string<\/i>\u00a0for policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified group is not defined for the policy.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the group identifier value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12464: invalid characters in label component\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Label components can contain only alphanumeric characters, blanks, and underscores.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct syntax of the label component.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12465: Not authorized for read or write on specified groups or compartments<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You included groups or compartments that are not in the user’s list of groups and compartments authorized for read or write access.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Include read access when authorizing groups or compartments for write access.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12466: default level is greater than the user’s maximum<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The default level cannot be greater than the user’s maximum.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter an authorized level.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12467: minimum label can contain a level only<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You included compartments or groups in the minimum label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter only an authorized minimum level as the label.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12468: max write level does not equal max read level<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The level in the max write label must equal the level in the max read label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter max read and max write labels with the same level component.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12469: no user levels found for user\u00a0string<\/i>\u00a0and policy\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No levels have been specified for the user.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter the maximum and minimum labels for the user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12470: NULL or invalid user label:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The label entered is NULL or not within the user’s authorizations.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter the authorized labels for the user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12471: Specified compartment or group is not authorized for user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified compartment or group is not in user’s authorizations or the user does not have read on compartment or group specified for write.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter an authorized compartment or group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12472: policy\u00a0string<\/i>\u00a0is being used<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The policy which was being dropped due to event propagation from OID was applied to some table or schema.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop a policy in OID only if it is not used in any of the databases using the policy.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12473: The procedure is disabled when Label Security is used with OID.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Using Label Security with OID disabled this procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use OID with Label Security if this procedure is required to function.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12476: least upper bound resulted in an invalid OS label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to do an operation that generated a least upper bound (LUB) label which is not a valid label on your operating system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult your OS label management documentation for information on invalid label generation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12477: greatest lower bound resulted in an invalid OS label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You tried to do an operation that generated a greatest lower bound (GLB) label which is not a valid label on your operating system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Consult your OS label management documentation for information on invalid label generation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12479: file label\u00a0string<\/i>\u00a0must equal DBHIGH\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A database file had an OS label that did not match DBHIGH. Either DBHIGH was altered or the OS file was relabeled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Relabel the file so that its label matches DBHIGH, or alter DBHIGH so that it matches the label on the file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12480: specified clearance labels not within the effective clearance<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You specified a clearance range that was not within your authorized clearance; you can only specify clearance ranges that are within your clearance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify clearance labels that are within your own clearance range.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12481: effective label not within program unit clearance range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The effective label when the program unit was invoked was not within the range authorized for the program unit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Modify the program unit clearance range or invoke the program unit from a session with an authorized effective clearance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12482: internal MLS error:\u00a0string<\/i>\u00a0Error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An internal MLS policy error occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact Oracle Customer Support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12483: label not in OS system accreditation range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified label is above the OS maximum label or below the OS minimum label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a label that is within the accreditation range for the host OS.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12484: invalid OS label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified label does not exist in the OS host’s label definition file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the OS label management tools to define the label.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12485: new effective label not within effective clearance<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for an effective label that did not dominate the effective min label or was not dominated by the effective max label.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a value between the min and the max labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12486: effective max labels and min labels cannot be changed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for an effective min label or effective max label, but these labels cannot be changed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter NULL values for the effective minimum and maximum labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12487: clearance labels not between DBHIGH and DBLOW<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for a clearance label that was not dominated by DBHIGH or did not dominate DBLOW.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter clearance label values between DBHIGH and DBLOW.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12488: maximum label does not dominate minimum label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for a clearance label that did not preserve the dominance relationship between the minimum and maximum labels.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter label values that preserves the dominance relationship between the minimum and maximum.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12489: default label not within clearance range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for a default label that did not dominate the minimum clearance or was not dominated by the maximum clearance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a default label value within the clearance range.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12490: DBHIGH cannot be lowered<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for DBHIGH that did not dominate the existing value of DBHIGH.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a value for DBHIGH that dominates the old value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12491: DBHIGH value does not dominate DBLOW<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to enter a value for DBHIGH that did not dominate DBLOW.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a value for DBHIGH that dominates DBLOW.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12492: DBLOW cannot be changed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to change the value of DBLOW after it had been set to any initial value. DBLOW can only be set once after initial database creation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To change DBLOW, you have to create a new database, set DBLOW to the new value, and import your data into the new database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12493: invalid MLS binary label<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The MLS binary label contained an invalid value, was not the correct size, or contained a level, category, or release category that was not enabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the DBA_MLS_LABELS view for the valid MLS labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12494: cannot insert or delete a level, category, or release category<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to insert or delete a level, category, or release category definition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the label definition is no longer valid, change its name to one that identifies it as invalid. When any labels are converted to character strings, the new label definition will be used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12495: cannot disable an enabled level, category, or release category<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to disable a level, category, or release category that had previously been enabled. An enabled label definition may be exist in some database label, so cannot be disabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the label definition is no longer valid, change its name to one that identifies it as invalid. When any labels are converted to character strings, the new label definition will be used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12496: cannot change existing level, category, or release numbers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to change the number assigned to level, category or releasability category.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the character string representations, not the numbers.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12497: maximum combined categories exceeds\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The maximum number of descriptive categories plus release categories supported by the MLS policy was exceeded.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter numbers that do not add up to more than the maximum.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12400 to ORA-12500 ORA-12400: invalid argument to facility error handling Cause:\u00a0An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product\/facility. Action:\u00a0Specify a valid facility error handling parameter value. ORA-12401: invalid label string:\u00a0string Cause:\u00a0The policy could not convert the label…<\/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-1856","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-tW","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1856","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=1856"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1856\/revisions"}],"predecessor-version":[{"id":1857,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1856\/revisions\/1857"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1856"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}