Home » Infrastructure » Unix » how to manage errors in unix's scripts for the oracle's connections and procedures calls
how to manage errors in unix's scripts for the oracle's connections and procedures calls [message #200281] Mon, 30 October 2006 03:43 Go to next message
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
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 Go to previous messageGo to next message
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 Go to previous message
istruttorenuoto
Messages: 5
Registered: October 2006
Junior Member
thank you very much!!!
Previous Topic: Daemon Process
Next Topic: Problem in Crontab
Goto Forum:
  


Current Time: Tue Dec 06 04:31:15 CST 2016

Total time taken to generate the page: 0.22911 seconds