Category Archives: Database

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

How to replace disks in ASM

Example of script used for replacement ASM disks in database production: 1. Creating the disk with root user – run in one instance: cd /etc/init.d . /oracleasm createdisk ORADT1  /dev/mapper/ORADT1 ./oracleasm scandisks ./oracleasm listdisks 2. After create disks, run scandisks in all instances and verify the new disk: cd /etc/init.d ./oracleasm scandisks ./oracleasm listdisks 3. […]

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