DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2000
    which table in oracle contains the error messages which we get. I think i saw it here but couldnt fish it out.

  2. #2
    Join Date
    Jan 2000
    Silver Spring MD USA
    I don't know how to do this in NT but in Unix, you can use 'oerr'.

    If you get the error ORA-12541:TNS: no listener
    You can get the full description by typing this at the UNIX command line:

    oerr ORA 12541

    Then you will see the following:

    12541, 00000, "TNS:no listener"
    // *Cause: The connection request could not be completed because the listener
    // is not running.
    // *Action: Ensure that the supplied destination address matches one of
    // the addresses used by the listener - compare the TNSNAMES.ORA entry with
    // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
    // go by way of an Interchange). Start the listener on the remote machine.

    So type "oerr", the three letters in the beginning of the error message then the error number.

  3. #3
    Join Date
    Oct 2000
    select * from user_errors;

  4. #4
    Join Date
    Dec 2000
    i think its a x$ table, which contains the error_msg and error code for the errors oracle pops us.this was discussed here some time ago.
    the oerr is new to me, thanks.
    thx for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.