which table in oracle contains the error messages which we get. I think i saw it here but couldnt fish it out.
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.
select * from user_errors;
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.
Click Here to Expand Forum to Full Width