Category: Oracle

Oracle 11g Error Codes and Solution Suggestions from ORA-14000 to ORA-14080

Posted on by Fatih Acar

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

Posted on by Fatih Acar

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

Posted on by Fatih Acar

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

Posted on by Fatih Acar

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…

ORA-00020: maximum number of processes (string) exceeded

Posted on by Fatih Acar

Error: ORA-00020: maximum number of processes (string) exceeded Cause: All process state objects are in use. Action: Increase the value of the PROCESSES initialization parameter. Solution: You have to increase processes parameter value. ORA-00020 is caused by two things: 1- A lot of idle that is not working (zombie) connection. You can kill this connections…

Oracle 11g Error Codes and Solution Suggestions from ORA-13400 to ORA-13500

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-13400 to ORA-13500 ORA-13400: duplicate entry for string in USER_SDO_GEOR_SYSDATA view Cause: The current operation caused a duplicate RASTER_DATA_TABLE and RASTER_ID combination to be inserted into the USER_SDO_GEOR_SYSDATA view. Action: Ensure that the RASTER_DATA_TABLE and RASTER_ID combination to be inserted into the USER_SDO_GEOR_SYSDATA view is unique. ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA…

ORA-00018 maximum number of sessions exceeded

Posted on by Fatih Acar

Error: ORA-00018 maximum number of sessions exceeded Cause: All session state objects are in use. Action: Increase the value of the SESSIONS initialization parameter. Solution: You have to increase processes and depends on this parameter which is sessions, transactions parameters. Calculating amount of sessions and transactions parameter values with below formula. processes=x sessions=x*1.1+5 transactions=sessions*1.1 You…

Oracle 11g Error Codes and Solution Suggestions from ORA-13200 to ORA-13400

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-13200 to ORA-13400 ORA-13200: internal error [string] in spatial indexing. Cause: This is an internal error. Action: Contact Oracle Support Services with the exact error text. ORA-13201: invalid parameters supplied in CREATE INDEX statement Cause: An error was encountered while trying to parse the parameters clause for the spatial CREATE…