List Of All Oracle Error Codes
Contents |
and other oracle error codes list with description troubleshooting information in these books. List of Message Types
Oracle Error Codes And Solution
ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to
Oracle Error Codes Table
ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249
Oracle Error Sqlcode
ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network oracle errors and solutions Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation ora error 12154 Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts oracle error handling Ion Excel-DB Don Burleson Blog
oracle sqlcode values Oracle Error Code List Oracle Database Tips by Burleson Consulting As of Oracle 10g, Oracle has 10,038 distinct Oracle error http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- codes. This is only includes the ORA- prefix error codes: ORA-00056 ORA-00057 ORA-00058 ORA-00059 ORA-00060 ORA-00061 ORA-00062 ORA-00063 ORA-00064 ORA-00065 ORA-00066 ORA-00067 ORA-00068 ORA-00069 ORA-00070 ORA-00071 ORA-00072 ORA-00073 ORA-00074 ORA-00075 ORA-00076 ORA-00077 ORA-00078 ORA-00079 ORA-00080 ORA-00081 ORA-00082 ORA-00083 ORA-00084 ORA-00085 ORA-00086 ORA-00087 ORA-00088 ORA-00089 ORA-00090 ORA-00091 http://www.dba-oracle.com/t_error_code_list.htm ORA-00092 ORA-00093 ORA-00094 ORA-00096 ORA-00097 ORA-00117 ORA-00118 ORA-00119 ORA-00120 ORA-00121 ORA-00122 ORA-00123 ORA-00124 ORA-00125 ORA-00126 ORA-00127 ORA-00128 ORA-00129 ORA-00130 ORA-00131 ORA-00132 ORA-00133 ORA-00134 ORA-00150 ORA-00151 ORA-00152 ORA-00153 ORA-00154 ORA-00155 ORA-00160 ORA-00161 ORA-00162 ORA-00163 ORA-00164 ORA-00165 ORA-00166 ORA-00200 ORA-00201 ORA-00202 ORA-00203 ORA-00204 ORA-00205 ORA-00206 ORA-00207 ORA-00208 ORA-00209 ORA-00210 ORA-00211 ORA-00212 ORA-00213 ORA-00214 ORA-00215 ORA-00216 ORA-00217 ORA-00218 ORA-00219 ORA-00220 ORA-00221 ORA-00222 ORA-00223 ORA-00224 ORA-00225 ORA-00226 ORA-00227 ORA-00228 ORA-00229 ORA-00230 ORA-00231 ORA-00232 ORA-00233 ORA-00234 ORA-00235 ORA-00236 ORA-00237 ORA-00238 ORA-00250 ORA-00251 ORA-00252 ORA-00253 ORA-00254 ORA-00255 ORA-00256 ORA-00257 ORA-00258 ORA-00259 ORA-00260 ORA-00261 ORA-00262 ORA-00263 ORA-00264 ORA-00265 ORA-00266 ORA-00267 ORA-00268 ORA-00269 ORA-00270 ORA-00271 ORA-00272 ORA-00273 ORA-00274 ORA-00275 ORA-00276 ORA-00277 ORA-00278 ORA-00279 ORA-00280 ORA-00281 ORA-00282 ORA-00283 ORA-00284 ORA-00285 ORA-00286 ORA-00287 ORA-00288 ORA-00289 ORA-00290 ORA-00291 ORA-00292 ORA-00293 ORA-00294 ORA-00295 ORA-00296 ORA-00297 ORA-00298 ORA-00299 ORA-00300 ORA-00301 ORA-00302 ORA-00303 ORA-00304 ORA-00305 ORA-00306 ORA-00307 ORA-00308 ORA-00309 ORA-00310 ORA-00311 ORA-00312 ORA-00313 ORA-00314 ORA-00315 ORA-00316 OCode 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 http://psoug.org/oraerror.htm 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: oracle 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 oracle error codes 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_LOCKS setting ORA-00062: D