Category Archives: ERROR

Error Messages ORA-09870 to ORA-12100

ORA-09870 to ORA-12100   ORA-09870: spini: failure initializing maximum number of open files. Cause: ulimit system call returned an error. Action: Check errno. ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf. Cause: Failure of sltln(?/tasdef@.dbf) while creating test and set pages. Action: Check additional return error for more information. ORA-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf. […]

Error Messages ORA-04930 to ORA-07499

ORA-04930 to ORA-07499   ORA-04930: open sequence number failed or initial state is valid Cause: Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may have occurred or a previous instance was not shut down properly. Action: Verify that there are no background or foreground Oracle processes from a […]

Error Messages ORA-02140 to ORA-04099

ORA-02140 to ORA-04099   ORA-02140: invalid tablespace name Cause: An identifier does not follow ALTER TABLESPACE. Action: Specify a tablespace name following ALTER TABLESPACE. ORA-02141: invalid OFFLINE option Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE. Action: The user must either specify no option following OFFLINE or one of the options NORMAL or […]

Error Messages ORA-01500 to ORA-02098

ORA-01500 to ORA-02098   ORA-01500: failure in getting date/time Cause: During create database or alter tablespace, there was a failure in getting the date and time. Action: Contact your customer support representative. ORA-01501: CREATE DATABASE failed Cause: An error occurred during create database Action: See accompanying errors. ORA-01502: index “string.string” or partition of such index […]

Error Messages ORA-00910 to ORA-01497

ORA-00910 to ORA-01497   ORA-00910: specified length too long for its datatype Cause: for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000. Action: use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2, LONG CHAR, or LONG RAW ORA-00911: […]

Error Messages ORA-00000 to ORA-00832

ORA-00000 to ORA-00832   ORA-00000: normal, successful completion Cause: Normal exit. Action: None. ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. Action: Either remove […]