Guys
how about creating a shell script
#/bin/ksh
count=1
while [ $count -ne 10 ]
do
oerr ora $count
count="$(($count + 1))"
done
00088, 00000, "command cannot be executed by MTS server "
// *Cause: Debug command issued on MTS server.
// *Action: Reissue the command using a dedicated server.
00089, 00000, "invalid instance number in ORADEBUG command "
// *Cause: An invalid instance number was specified in an OPS ORADEBUG
// command.
// *Action: Reissue the command with valid instance numbers.
the output needs to be parsed and stored into a table.
UNIX shell scripting masters can give me some hints how i can use maybe sed
or awk to break each error output into three variables
step1. first line till line before "*Cause" into first variable
"error_message"
step2. line containing "*Cause" onwards till line before "*Action" into
second variable "error_cause"
step3. line containing "*Action" onwards till end
any hints to start the work would be appreciated. now no RTFM pls..:)
-Mandar
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 8:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:how to store orace errors in database
>
>
> Kaushik,
>
> There is nothing that I know of that does a help_table
> for error messages.
> One can use the selerrm function to return the text of any
> error although it
> does not send back the reason why nor the corrective action.
> I'm not sure about
> NT and oerr. I haven't found it yet there, but then I don't
> use NT as a db
> server platform.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "kaushikdas" <[EMAIL PROTECTED]>
> Date: 3/21/2001 11:35 PM
>
>
>
> Hello I am Kaushik Das from india .I am new to your group.
> I had a query ,i hope some one will reply to this mail.
>
> Just like we can store help of sql commands in HELP table in
> oracle database.In a semilar way can we store ORACLE errors
> in database
>
> for example to see oracle error 0000 in unix we write oerr ora 0000
>
> 1)what command should we write in nt to see the complete info of this
> error.
>
> 2) How to store and retrive complete oracle error messages in oracle
> database.
>
> 3) is there any sql file which dba should run to create such
> table and toad
> data.
>
> Thanks in advance.
>
> regards
>
> kaushik
>
>
>
> --------------------------------------------------------------
> -------------
> --------------------------------------------
> IFFCO's Website Address - www.iffco.nic.in
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: kaushikdas
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Ghosalkar
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
