11 Replies Latest reply on Aug 22, 2007 12:39 PM by Laurent Schneider

    Oracle Error in a Data Dictionary

    581168
      Is there a data dictionary or table that contains all Oracle errors and it's description?
        • 1. Re: Oracle Error in a Data Dictionary
          584412
          No, but google is your friend :)
          • 2. Re: Oracle Error in a Data Dictionary
            581168
            I know where I can find the list of Oracle errors. They are in http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525/toc.htm for 9i and http://download.oracle.com/docs/cd/B12037_01/server.101/b10744/toc.htm for 10g. The reason I want to know if there is a table that contains the Oracle errors is for easier exporting to a csv file and upload it to my website that will allow to enter error code and retrieve the details of the error.

            If you know an easier method to do this, please let me know.
            • 3. Re: Oracle Error in a Data Dictionary
              584412
              if you know an easier method to do this, please let me know.
              I would say that it would be easier to search the documentation than to go to the hassle of getting the errors from the documentation, loading them into your website and then searching your website. but maybe that's just me.
              • 4. Re: Oracle Error in a Data Dictionary
                581168
                Thanks! I guess I have to developed a parser and convert it to tab delimited csv since there are thousands of error codes.
                • 5. Re: Oracle Error in a Data Dictionary
                  MichaelS
                  Maybe the package UTL_LMS is of interest for you.
                  • 6. Re: Oracle Error in a Data Dictionary
                    581168
                    Thanks that saves me a lot.
                    • 7. Re: Oracle Error in a Data Dictionary
                      593457
                      Is this Legal to use the content / documentation of oracle errors and placing it into other websites as it is ???
                      • 8. Re: Oracle Error in a Data Dictionary
                        BluShadow
                        Or there's always the ORA-CODE.COM site...

                        http://ora-00000.ora-code.com/

                        Just replace the first part of the url with the oracle error code you are getting.

                        e.g.

                        http://ora-01950.ora-code.com/

                        ;)
                        • 9. Re: Oracle Error in a Data Dictionary
                          593457
                          i just checked this site, they are simply displaying what is there in oracle documentation as it is.........

                          hmmm does it allowed, if so i can also start a site :))
                          • 10. Re: Oracle Error in a Data Dictionary
                            BluShadow
                            hmmm does it allowed, if so i can also start a site
                            :))
                            Erm, use some logic here.

                            There's already an established site. Why waste your time creating another?

                            Plus you'll have to keep up with all the latest oracle releases. Surely you have better things to do than that.
                            • 11. Re: Oracle Error in a Data Dictionary
                              Laurent Schneider
                              or sqlerrm
                              begin
                                for i in 1..100 loop
                                  if (sqlerrm(-i) not like '%Message % not found%') then
                                    dbms_output.put_line(sqlerrm(-i));
                                  end if;
                                end loop;
                              end;
                              /
                              
                              ORA-00001: unique constraint (.) 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 () exceeded
                              ORA-00021: session attached to some other process; cannot switch session
                              ORA-00022: invalid session ID; access denied
                              ORA-00023: session references process private memory; cannot detach session
                              ORA-00024: logins from more than one process not allowed in single-process mode
                              ORA-00025: failed to allocate
                              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  in current PL/SQL session
                              ORA-00035: LICENSE_MAX_USERS cannot be less than current number of users
                              ORA-00036: maximum number of recursive SQL levels () exceeded
                              ORA-00037: cannot switch to a session belonging to a different server group
                              ORA-00038: Cannot create session: server group belongs to another user
                              ORA-00040: active time limit exceeded - call aborted
                              ORA-00041: active time limit exceeded - session terminated
                              ORA-00042: Unknown Service name
                              ORA-00050: operating system error occurred while obtaining an enqueue
                              ORA-00051: timeout occurred while waiting for a resource
                              ORA-00052: maximum number of enqueue resources () exceeded
                              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 '.' is already held in an incompatible mode
                              ORA-00057: maximum number of temporary table locks exceeded
                              ORA-00058: DB_BLOCK_SIZE must be  to mount this database (not )
                              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: DML full-table lock cannot be acquired; DML_LOCKS is 0
                              ORA-00063: maximum number of log files exceeded
                              ORA-00064: object is too large to allocate on this O/S (,)
                              ORA-00065: initialization of FIXED_DATE failed
                              ORA-00067: invalid value  for parameter ; must be at least
                              ORA-00068: invalid value  for parameter , must be between  and
                              ORA-00069: cannot acquire lock -- table locks disabled for
                              ORA-00070: command  is not valid
                              ORA-00071: process number must be between 1 and
                              ORA-00072: process "" is not active
                              ORA-00073: command  takes between  and  argument(s)
                              ORA-00074: no process has been specified
                              ORA-00075: process "" not found in this instance
                              ORA-00076: dump  not found
                              ORA-00077: dump  is not valid
                              ORA-00078: cannot dump variables by name
                              ORA-00079: variable  not found
                              ORA-00080: invalid global area specified by level
                              ORA-00081: address range [, ) is not readable
                              ORA-00082: memory size of  is not in valid set of [1], [2], [4]
                              ORA-00083: warning: possibly corrupt SGA mapped
                              ORA-00084: global area must be PGA, SGA, or UGA
                              ORA-00085: current call does not exist
                              ORA-00086: user call does not exist
                              ORA-00087: command cannot be executed on remote instance
                              ORA-00088: command cannot be executed by shared server
                              ORA-00089: invalid instance number in ORADEBUG command
                              ORA-00090: failed to allocate memory for cluster database ORADEBUG command
                              ORA-00091: LARGE_POOL_SIZE must be at least
                              ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
                              ORA-00093:  must be between  and
                              ORA-00094:  requires an integer value
                              ORA-00096: invalid value  for parameter , must be from among
                              ORA-00097: use of Oracle SQL feature not in SQL92  Level
                              ORA-00100: no data found