RE: how to store orace errors in database (UNIX scripting challen

From: Mandar Ghosalkar <MandarG_at_gsr-inc.com>
Date: Fri, 23 Mar 2001 18:37:59 -0800
Message-ID: <F001.002D6F20.20010323183040@fatcity.com>

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: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> 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" <kaushikdas/iffco_at_iffco.nic.in>
> 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: kaushikdas/iffco_at_iffco.nic.in
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  INET: MandarG_at_gsr-inc.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 Fri Mar 23 2001 - 20:37:59 CST