Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: list of events

RE: list of events

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 15 May 2002 06:48:25 -0800
Message-ID: <F001.0046117C.20020515064825@fatcity.com>

I find it under C:\OWRWIN95\RDBMS80\oraus.msg

Readable using WORDPAD.

If you go to your "My Computer" icon, right click, and pick "Explore", then choose "Tools" - "Find" - "Files and Folders" and enter a search for *.msg starting from the Oracle_Home you'll find lots of Oracle Error Message files including tnsus.msq for SQL*Net error messages. The msb files are binary and are not easily readable.

                                                                                           
                    Rachel_Carmic                                                          
                    hael                 To:     Multiple recipients of list ORACLE-L      
                    @Sonymusic.co        <ORACLE-L_at_fatcity.com>                            
                    m                    cc:                                               
                    Sent by: root        Subject:     RE: list of events                   
                                                                                           
                                                                                           
                    05/15/2002                                                             
                    09:48 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L                                                               
                                                                                           
                                                                                           






You can use the oerr facility on Unix to look at the events... I don't know if
that file exists under Windows, I vaguely recall a conversation on the list a
while ago where people were saying it didn't. I know that I downloaded the file
from my Unix box to my PC so I'd have a copy.

Anyone out there with a Windows installation who can check this please?

And, in any case, the file just tells you what the event name is:

bash$ oerr ora 10053
10053, 00000, "CBO Enable optimizer trace" // *Cause:
// *Action:
bash$ oerr ora 10046
10046, 00000, "enable SQL statement timing" // *Cause:
// *Action:

and doesn't give you much other information. I'd love to see an Oracle doc just
on these events....

Rachel

|--------+--------------------------->

| | |
| | |
| | Rajendra.Jamadagn|
| | i_at_espn.com |
| | |
| | 05/14/2002 05:43 |
| | PM |
| | Please respond to|
| | ORACLE-L |
| | |
|--------+---------------------------> >----------------------------------------------------| | | | To: ORACLE-L_at_fatcity.com | | cc: (bcc: Rachel Carmichael) | | Subject: RE: list of events | >----------------------------------------------------|

Rachel,

Actually, error messages between 10000 and 10999 are events (i.e. 10046, 10053 etc). In 9i there are some new events in the 297xx range as well.

Raj


Rajendra Jamadagni                  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
[mailto:Rachel_Carmichael_at_Sonymusic.com] Sent: Tuesday, May 14, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L

actually that's the list of error messages, not events

and it's not under the admin directory in any case the path to the error messages is:

$ORACLE_HOME/rdbms/mesg/roaus.msg
(See attached file: ESPN_Disclaimer.txt)

<< Attachment Removed : ESPN_Disclaimer.txt >>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  INET: tday6_at_csc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed May 15 2002 - 09:48:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US