Tag Archives: Oracle Database

Error Messages ORA-12315 to ORA-12354

ORA-12315 to ORA-12354   ORA-12315: database link type is invalid for the ALTER DATABASE statement Cause: The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a secondary database. Action: Re-issue the ALTER […]

Error Messages ORA-12150 to ORA-12236

ORA-12150 to ORA-12236   ORA-12150: TNS:unable to send data Cause: Unable to send data. Connection probably disconnected. Action: Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12151: TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For further details, turn on […]

Error Messages ORA-07500 to ORA-09859

ORA-07500 to ORA-09859   ORA-07500: scglaa: $cantim unexpected return Cause: VMS system service $CANTIM returned an unexpected value Action: Check for system error message and refer to VMS documentation ORA-07501: scgtoa: $deq unexpected return Cause: VMS system service $DEQ returned an unexpected value Action: Check for system error message and refer to VMS documentation ORA-07502: […]

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 […]