Oracle Db Error Codes
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
Oracle Error Handling
File 2 ORA-00000 to ORA-00832 3 ORA-00910 to ORA-01497 4 ORA-01500 oracle error code 942 to ORA-02098 5 ORA-02140 to ORA-04099 6 ORA-04930 to ORA-07499 7 ORA-09870 to ORA-12100 8 ORA-07500
Ora Errors And Solutions
to ORA-09859 9 ORA-12150 to ORA-12236 10 ORA-12315 to ORA-12354 11 ORA-12400 to ORA-12497 12 ORA-12500 to ORA-12699 13 ORA-12700 to ORA-19380 14 ORA-19400 to ORA-24276 15 https://docs.oracle.com/cd/B28359_01/nav/lookup.htm?id=ERRMG ORA-24280 to ORA-28674 16 ORA-29250 to ORA-32775 17 ORA-32800 to ORA-32848 18 ORA-33000 to ORA-37999 19 ORA-38029 to ORA-39962 20 ORA-40001 to ORA-40322 21 EXP-00000 to EXP-00107 22 IMP-00000 to IMP-00401 23 SQL*Loader-00100 to SQL*Loader-03120 24 KUP-00550 to KUP-11012 25 UDE-00001 to UDE-00053 26 UDI-00001 to UDI-00053 27 DBV-00200 to DBV-00200 28 NID-00001 to NID-00604 https://docs.oracle.com/cd/B19306_01/server.102/b14219/toc.htm 29 DGM-16900 to DGM-17007 30 LCD-00100 to LCD-00219 31 QSM-00501 to QSM-03120 32 OCI-00601 to OCI-31199 33 RMAN-00550 to RMAN-20507 34 LRM-00100 to LRM-00123 35 LFI-00002 to LFI-01523 36 PLS-00049 to PLS-01913 37 PLW-05000 to PLW-07204 38 AMD-00100 to AMD-00160 39 CLSR-00001 to CLSR-06507 40 CLSS-00001 to CLSS-03202 41 PROC-00001 to PROC-00106 42 PROT-00001 to PROT-00807 43 TNS-00000 to TNS-12699 44 NNC-00001 to NNC-00501 45 NNO-00050 to NNO-00854 46 NNL-00001 to NNL-01078 47 NPL-00100 to NPL-00420 48 NNF-00001 to NNF-04009 49 NMP-00001 to NMP-00011 50 NCR-00001 to NCR-04028 51 NZE-28750 to NZE-29249 52 O2F-00301 to O2F-00341 53 O2I-00101 to O2I-00133 54 O2U-00200 to O2U-00212 55 PCB-00001 to PCB-00903 56 PCC-00001 to PCC-01515 57 PCC-02010 to PCC-02451 58 SQL-01075 to SQL-02157 59 AUD-00611 to AUD-00809 60 IMG-00001 to IMG-02014 61 VID-00611 to VID-00721 62 DRG-10000 to DRG-52210 63 LPX-00000 to LPX-00773 64 LSX-00001 to LSX-00344 Index Scripting on this page enhances content navigation, but does not change the content in any way
industry long enough to remember the bad old days, when every developer and DBA had a pile of dusty Oracle user guides on their desks and, every time their database http://allthingsoracle.com/the-40-most-common-oracle-errors/ or application coughed up an error, would thumb through the books with mounting desperation. Fortunately, http://psoug.org/oraerror.htm the times have moved on and we now all outsource our memories to Google and Bing and Baidu. Our desks are clear, but our need for external help whenever we are ambushed by unexpected errors is just as strong. Using tools Google have made available, I have put together a list of the ORA messages we collectively searched oracle error for the most in the first month of 2012. These messages (see a Billboard-style Top 40 Chart at the bottom of this article) are a mix of those generic errors that can mean pretty much anything, the error messages we see most rarely, and those common error numbers that we never seem able to memorise. ORA-12154: TNS:could not resolve the connect identifier specified (#1) Coming in at number 1, and googled more oracle error code than twice as often as any other error message, this error is, almost appropriately, often the very first one you get on trying to establish a connection to your database. Simply put, it means that you have named the database you wish to be connected to and Oracle doesn’t know who the heck you’re talking about. This error is often caused by typos, maybe in your connection string, but possibly in your tnsnames.ora file. It is also possible that the tnsnames.ora file is not accessible or does not even exist. If it does, ensure that it contains the service name you are using; also go over it with a fine toothcomb to make sure it doesn’t have any unpaired parentheses or such. ORA-00600: internal error code, arguments: [%s], [%s],[%s], [%s], [%s] (#2) Coming in at number 2 is a generic error; it means something serious has gone wrong and you are going to need to roll up your sleeves, dig in, and find out what. But you are not without clues. Your alert.log file will contain the path to your trace file. You will want to look in it, as a record is written to the trace file every time an ORA-00600 error occurs. Take the information you get from your trace file and the f
Code Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us We have over 18,000 Oracle Error Codes currently indexed for searching, including error codes for SQL*Loader, RMAN, NNL, TNS, DRG, IMG, PCC, LPX, LSX, and many others. Type the Oracle Error code into the Search box to find the associated error: Or, browse the Oracle Error list below: ORA-00000: Normal, successful completion ORA-00001: Unique constraint (string.string) violated ORA-00017: Session requested to set trace event ORA-00018: Maximum number of sessions exceeded ORA-00019: Maximum number of session licenses exceeded ORA-00020: Maximum number of processes (string) exceeded ORA-00021: Session attached to some other process; cannot ... ORA-00022: Invalid session ID; access denied ORA-00023: Session references process private memory; cann... ORA-00024: Logins from more than one process not allowed i... ORA-00025: Failed to allocate string ORA-00026: Missing or invalid session ID ORA-00027: Cannot kill current session ORA-00028: Your session has been killed ORA-00029: Session is not a user session ORA-00030: User session ID does not exist. ORA-00031: Session marked for kill ORA-00032: Invalid session migration password ORA-00033: Current session has empty migration password ORA-00034: Cannot string in current PL/SQL session ORA-00036: Maximum number of recursive SQL levels (string)... ORA-00037: Cannot switch to a session belonging to a diffe... ORA-00038: Cannot create session: server group belongs to ... ORA-00040: Active time limit exceeded - call aborted ORA-00041: Active time limit exceeded - session terminated ORA-00042: Unknown Service name string ORA-00050: Operating system error occurred while obtaining... ORA-00051: Timeout occurred while waiting for a resource ORA-00052: Maximum number of enqueue resources (string) ex... ORA-00053: Maximum number of enqueues exceeded ORA-00054: Resource busy and acquire with NOWAIT specified ORA-00055: Maximum number of DML locks exceeded ORA-00056: DDL lock on object "string.string" is already h... ORA-00057: Maximum number of temporary table locks exceeded ORA-00058: DB_BLOCK_SIZE must be string to mount this data... ORA-00059: Maximum number of DB_FILES exceeded ORA-00060: Deadlock detected while waiting for resource ORA-00061: Another instance has a different DML_LOC