Oracle Error Message Guide
Contents |
Operating System-Specific Messages Accuracy of Messages Message Format Recognizing Variable Text in Messages Message Stacks Contacting Oracle Support Services Oracle Exception Messages Trace Files The Alert File 2 ACFS-00501 to ACFS-11111 3 ACFSK-00004 to ACFSK-00091 4 oracle sql error codes list ADVM-00501 to ADVM-11111 5 ADVMK-00001 to ADVMK-00028 6 AMDU-00200 to AMDU-00503 7
Oracle Error Codes List With Description
ASMCMD-08001 to ASMCMD-09529 8 AUD-00611 to AUD-00809 9 CLSCH-01001 to CLSCH-03718 10 CLSDNSSD-00000 to CLSDNSSD-03999 11 CLSGN-00000 to CLSGN-32767 12
Oracle Database Errors And Solutions
CLSMDNS-00000 to CLSMDNS-02255 13 CLSNS-00000 to CLSNS-00035 14 CLSR-00001 to CLSR-06507 15 CLSRSC-00001 to CLSRSC-04015 16 CLSS-00001 to CLSS-03202 17 CLST-01101 to CLST-03203 18 CLSU-00100 to CLSU-00912 19 CLSW-00001 to CLSW-01000
Oracle Common Errors And Solutions
20 CRS-00001 to CRS-29006 21 DBV-00200 to DBV-00201 22 DGM-16900 to DGM-17032 23 DIA-48001 to DIA-51705 24 DRG-10000 to DRG-52403 25 EVM-00001 to EVM-00901 26 EXP-00000 to EXP-00114 27 GIPC-00000 to GIPC-00020 28 IMG-00001 to IMG-02014 29 IMP-00000 to IMP-00402 30 JMS-00101 to JMS-00256 31 JMS-00400 to JMS-00448 32 KFED-00400 to KFED-00403 33 KFNDG-00200 to KFNDG-00701 34 KFOD-00316 to KFOD-00403 35 KUP-00552 to KUP-11602 oracle error codes and solution 36 LCD-00100 to LCD-00219 37 LFI-00002 to LFI-01525 38 LPX-00000 to LPX-01160 39 LRM-00100 to LRM-00123 40 LSX-00001 to LSX-00345 41 MGTCA-01001 to MGTCA-01117 42 NCR-00001 to NCR-04028 43 NID-00001 to NID-00604 44 NDFN-00020 to NDFN-00025 45 NMP-00001 to NMP-00011 46 NNC-00001 to NNC-00501 47 NNF-00001 to NNF-04009 48 NNL-00001 to NNL-01078 49 NNO-00050 to NNO-00854 50 NPL-00100 to NPL-00420 51 NZE-28750 to NZE-29249 52 NZE-43000 to NZE-43021 53 O2F-00301 to O2F-00341 54 O2I-00101 to O2I-00133 55 O2U-00200 to O2U-00212 56 OCI-00601 to OCI-31199 57 OKSK-00000 to OKSK-00029 58 ORA-00000 to ORA-00877 59 ORA-00900 to ORA-01499 60 ORA-01500 to ORA-02098 61 ORA-02100 to ORA-04099 62 ORA-04930 to ORA-07499 63 ORA-07500 to ORA-09859 64 ORA-09870 to ORA-12100 65 ORA-12150 to ORA-12236 66 ORA-12315 to ORA-12354 67 ORA-12400 to ORA-12498 68 ORA-12500 to ORA-12699 69 ORA-12700 to ORA-19400 70 ORA-19500 to ORA-19997 71 ORA-19999 to ORA-24279 72 ORA-24280 to ORA-28709 73 ORA-29250 to ORA-32799 74 ORA-32800 to ORA-32857 75 ORA-33000 to ORA-37999 76 ORA-38001 to ORA-39965 77 ORA-40001 to ORA-40570 78 ORA-41001 to ORA-42804 79 ORA-43750 to ORA-45907 80 ORA-46000 to ORA-46900 81 ORA-47000 to ORA-47999 82 ORA-48001 to ORA-51705 83 ORA-53000
release and press the "find Oracle error" button. Oracle Error Lookup 8i 9i 10g 9iAS AS10g
configuration, and use of SQL*Net will go smoothly, and you will have no problems. However, inevitably errors will occur. All the error messages you may receive when using Oracle networking products are https://www.bnl.gov/phobos/Detectors/Computing/Orant/doc/network.804/a48385/apc.htm described in the Oracle Network Products Troubleshooting Guide. However, for your convenience, this appendix describes seven of the most common error messages in detail. They are: ORA-12154 ``TNS:could not resolve service name" ORA-12198 ``TNS:could not find path to destination" ORA-12203 ``TNS:unable to connect to destination" ORA-12500 ``TNS:listener failed to start a dedicated server process" ORA-12533 ``TNS:illegal ADDRESS parameters" ORA-12545 ``TNS:name lookup oracle error failure" ORA-12560 ``TNS:protocol adapter error" For information on other error messages, and to learn more about error logging and the trace facility, see the Oracle Network Products Troubleshooting Guide. Common Sources of Error: Configuration Files The most common cause of problems in making a SQL*Net connection is in the structure or location of the configuration files. Syntax Errors The syntax of the oracle error codes files must be followed precisely. If you create the files using Network Manager, syntax errors should not occur. However, if you create or edit them by hand, check them carefully to see that all the appropriate parentheses are in place, that the lines are indented to show their logical structure, and that there are no typographical errors. See Appendix B, "Syntax Rules for Configuration Files," for details on the syntax of these files. Be sure that all service names are mapped to connect descriptors in the TNSNAMES. ORA file. Location Errors The TNSNAMES.ORA file must be distributed so that it is available to all nodes that make connections using SQL*Net version 2 (unless Oracle Names is being used on the network). A unique LISTENER.ORA file must be distributed to each node that includes one or more databases. In a network that includes one or more Interchanges, a unique TNSNAV.ORA file must be available to all the clients which have similar navigation requirements. Every node with an Interchange must have an INTCHG.ORA, a TNSNET.ORA, and a TNSNAV.ORA file. See the Oracle operating sys