OraFAQ Forum: Unix » how to manage errors in unix's scripts for the oracle's connections and procedures calls

Home » Infrastructure » Unix » how to manage errors in unix's scripts for the oracle's connections and procedures calls

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to manage errors in unix's scripts for the oracle's connections and procedures calls [message #200281]

Mon, 30 October 2006 03:43

istruttorenuoto
Messages: 5
Registered: October 2006

Junior Member

hi to everybody!
could anyone tell me if there's a link to find documentation about error's managing in unix's scripts for oracle connections and procedure's calls?
i need examples too.
thank you

Report message to a moderator

Re: how to manage errors in unix's scripts for the oracle's connections and procedures calls [message #200416 is a reply to message #200281]

Mon, 30 October 2006 18:13

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Remember that unix/shell error codes are limited to a single byte.

http://www.oracle.com/oramag/oracle/01-may/o31asktom.html

You can also redirect output to a logfile, then grep for "ORA-", optionally excluding error which are ok.

# find all "ORA-" in the log, exclude 2 OK errors, then count the remainder lines
grep "ORA-" myfile.log | egrep -v "ORA-00000|ORA-00913" | wc -l

[Updated on: Mon, 30 October 2006 18:24]

Report message to a moderator

Re: how to manage errors in unix's scripts for the oracle's connections and procedures calls [message #200489 is a reply to message #200281]

Tue, 31 October 2006 02:01

istruttorenuoto
Messages: 5
Registered: October 2006

Junior Member

thank you very much!!!

Report message to a moderator

Previous Topic:	Daemon Process
Next Topic:	Problem in Crontab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:12:59 CDT 2024