Author Archives:
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-29250 to ORA-32775
ORA-29250 to ORA-32775 ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Action: Correct the index value by modifying your PL/SQL program and try the bind_array call again. ORA-29251: Index1 is […]
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 […]