Category Archives: ERROR

Error unable to allocate 4160 bytes of shared memory

This note apply to Oracle Database Enterprise Edition – Version 11.2.0.1 to 11.2.0.3 Symptoms: The system appears to be running very slowly and defunct processes can appear. Errors are seen in the alert log or Trace log : 1. ORA-04031 ORA-04031: unable to allocate 4160 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”modification “) Incident […]

How to test Multicast CLUSTER INTERCONNECT on Oracle Database 11g R2

This note apply to Oracle Database 11.2.0.2.0 .   Sometimes the Interconnect latency is high. If one instance is down and when try to restart this instance, the CSS daemon can’t start, and when ran the “crsctl stat res -t -init” the status showed forever “starting”. The error of CSSD : 2010-09-16 23:13:15.839: [ CSSD][1087465792]clssnmvDHBValidateNCopy: […]

Error Messages ORA-24280 to ORA-28674

ORA-24280 to ORA-28674   ORA-24280: invalid input value for parameter string Cause: The parameter has been provided a negative, out of range, or NULL input value. Action: Correct the input value such that it is valid, and is within the range as specified in the documentation. ORA-24281: invalid access past the maximum size of LOB […]

Error Messages ORA-19400 to ORA-24276

ORA-19400 to ORA-24276   ORA-19400: System type conflict with object SYS.string Cause: The user had an object with the same name as one of the system types. The system types were not initialized properly. Action: Remove the conflicting object and rerun migration. ORA-19500: device block size string is invalid Cause: the device block size returned […]

Error Messages ORA-12700 to ORA-19380

ORA-12700 to ORA-19380   ORA-12700: invalid NLS parameter value (string) Cause: An invalid or unknown NLS configuration parameter was specified. Action: none ORA-12701: CREATE DATABASE character set is not known Cause: The character set specified when creating the database is unknown. Action: none ORA-12702: invalid NLS parameter string used in SQL function Cause: An unknown […]

Error Messages ORA-12500 to ORA-12699

ORA-12500 to ORA-12699 ORA-12500: TNS:listener failed to start a dedicated server process Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly. Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable […]

Error Messages ORA-12400 to ORA-12497

ORA-12400 to ORA-12497 ORA-12400: invalid argument to facility error handling Cause: An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product/facility. Action: Specify a valid facility error handling parameter value. ORA-12401: invalid label string: string Cause: The policy could not convert the label string to a valid […]

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