Tag Archives: ORA ERROR

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-40001 to ORA-40322

ORA-40001 to ORA-40322   ORA-40001: value for string must be greater than zero Cause: The input parameter in question has a value of zero or less. Action: Provide a value greater than zero for the relevant parameter. ORA-40002: wordsize must be string or greater Cause: The input wordsize is less than the prescribed limit for […]

Error Messages ORA-38029 to ORA-39962

ORA-38029 to ORA-39962   ORA-38029: object statistics are locked Cause: An attept was made to modify optimizer statistics of the object. Action: Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS procedure on base table(s). Retry the operation if it is okay to update statistics. ORA-38101: Invalid column in the INSERT VALUES Clause: string Cause: INSERT VALUES clause refers […]

Error Messages ORA-33000 to ORA-37999

ORA-33000 to ORA-37999   ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string. Cause: The AGGMAP was already compiled by a more recent version of the product than was being used to execute this command. Action: Recompile the AGGMAP in the current version. ORA-33002: (XSAGDNGL00) […]

Error Messages ORA-32800 to ORA-32848

ORA-32800 to ORA-32848   ORA-32800: internal error string Cause: An unexpected error occurred. Action: Contact Oracle Support Services. ORA-32801: invalid value string for string Cause: An invalid value was specified for a parameter. Action: Specify a valid value for the parameter. ORA-32802: value for string must be string Cause: An invalid value was specified for […]

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