error table in oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: error table in oracle

  1. #1
    Join Date
    Dec 2000
    Posts
    138
    which table in oracle contains the error messages which we get. I think i saw it here but couldnt fish it out.
    thanks
    dharma

  2. #2
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    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
    Posts
    211
    select * from user_errors;

  4. #4
    Join Date
    Dec 2000
    Posts
    138
    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.
    -dharma

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