List Of Oracle Error Numbers
Contents |
Code Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs oracle error handling Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines ora error 12154 Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us oracle sqlcode values 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 https://docs.oracle.com/cd/B28359_01/nav/lookup.htm?id=ERRMG 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 http://psoug.org/oraerror.htm 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 numbe
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp http://www.dba-oracle.com/t_error_code_list.htm Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB http://allthingsoracle.com/the-40-most-common-oracle-errors/ Don Burleson Blog
Oracle Error Code List Oracle Database Tips by Burleson Consulting As of Oracle 10g, Oracle has 10,038 distinct Oracle error codes. This is only includes the oracle error 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 ORA-00092 ORA-00093 ORA-00094 ORA-00096 ORA-00097 ORA-00117 ORA-00118 ORA-00119 ORA-00120 ORA-00121 oracle error codes 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 ORA-00317 ORA-00318 ORA-00319 ORA-00320 ORA-00321 ORA-00322 ORA-00323 ORA-00324 ORA-00325 ORA-00326 ORA-00327 ORA-00328 ORA-00329 ORA-00330 ORA-00331 ORA-00332 ORA-00333 ORA-00334 ORA-00335 ORA-00industry 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 or application coughed up an error, would thumb through the books with mounting desperation. Fortunately, 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 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 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 first argument in the square brackets (the internal message number), and head over to My Oracle Support (Metalink). There you will find a handy ORA-0600 looku