Tag: Oracle Administration

Oracle 11g Error Codes and Solution Suggestions from ORA-15400 to ORA-15600 ORA-15400: not running on supported ASM appliance Cause: An attempt was made to initialize the server code as an appliance when it was not running a supported appliance configuration. Action: Check the appliance configuration and retry the operation. ORA-15401: command not supported on ASM appliance ‘string‘…

Oracle 11g Error Codes and Solution Suggestions from ORA-15200 to ORA-15400 ORA-15200: initialization parameter string (string) is not a power of two Cause: The value specified for this initialization parameter was not a power of two. Action: Correct the initialization parameter value and restart the instance. ORA-15201: disk string contains a valid RDBMS file Cause: A disk specified in a CREATE DISKGROUP…

Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000 ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user Cause: Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges Action: Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on…

Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700 ORA-14500: LOCAL option not valid without partition name Cause: Incorrect syntax specified Action: Retry the command ORA-14501: object is not partitioned Cause: Table or index is not partitioned. Invalid syntax. Action: Retry the command with correct syntax. ORA-14503: only one partition name can be specified Cause: More than one…

Oracle 11g Error Codes and Solution Suggestions from ORA-14300 to ORA-14500 ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575 Action: Ensure that the partitioning key falls within 1048575 partitions or subpartitions. ORA-14301: table-level attributes must…

Oracle 11g Error Codes and Solution Suggestions from ORA-14200 to ORA-14300 ORA-14201: specified subpartition bound is too long Cause: Length of a linear key representation of a high bound of a table subpartition being added or along which an existing table or index subpartition is being split exceeded the legal limit (4K). Action: Change the representation of…

Oracle 11g Error Codes and Solution Suggestions from ORA-14000 to ORA-14080 ORA-14000: only one LOCAL clause may be specified Cause: CREATE INDEX statement contained more than one LOCAL clause Action: Specify LOCAL option at most once ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause Cause: CREATE INDEX statement contained a GLOBAL clause and a LOCAL clause Action: Specify LOCAL…

Oracle 11g Error Codes and Solution Suggestions from ORA-13900 to ORA-14000 RA-13900: missing or invalid parameter string Cause: A call to SET_THRESHOLD procedure was either missing a parameter, or the parameter was invalid. Action: Specify a valid value for this parameter. ORA-13901: Object string was not found. Cause: An object name was passed to SET_THRESHOLD procedure that did not map to…

Oracle 11g Error Codes and Solution Suggestions from ORA-13700 to ORA-13900 ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order. Cause: The start snapshot id was greater than the end snapshot id. Action: Swap the start and end snapshot ids. ORA-13702: Snapshot IDs specified by the range [string, string] are equal. Cause: The start snapshot id and…

Oracle 11g Error Codes and Solution Suggestions from ORA-13500 to ORA-13700 ORA-13500: SYSAUX DATAFILE clause specified more than once Cause: The CREATE DATABASE command contains more than one SYSAUX DATAFILE clause. Action: Specify at most one SYSAUX DATAFILE clause. ORA-13501: Cannot drop SYSAUX tablespace Cause: Tried to drop SYSAUX tablespace Action: None ORA-13502: Cannot rename SYSAUX tablespace Cause: An attempt…