Shell Programming and Scripting

Hi,

i am oracle dba and one my duty is to watch this logfile (alert_pindb.log) and oracle errors are start with ORA- error and it will be in this file if something went wrong,

as of now due to some problem ORA-00600 is frequently coming and i am working on that to overcome but apart from this ora-00600 error if any error come i should be notified and this is done by perl script and scheduled in cronjobs for every 30 minutes
$cd11 = "cd /oracle/admin/pindb/bdump";
$cd1 = "grep -v \"ORA-00600\" alert_pindb.log | grep \"ORA-\" alert_pindb.log | wc -l";
$telnet1 -> cmd ($cd11);
@test1 = $telnet1 -> cmd ($cd1);
@arr1 = split(" ",$test1[0]);
$desc =$arr1[0];

if($desc>0)
{
print "SMS Sent";
$text="ORA- error in 172.16.1.13 Server. Plz chk immediately.";

thanks

prakash

Hi,
this will give you erroneous output. you will be counting all instances of ORA- including ORA-00600. try appending a line with ORA-00600 in your logfile and run this command.

--

i have only one instance in this server

Thanks

Prakash

I didnt mean the instance of your db in the box. What i meant is the occurences of ORA- in your logfile. In your modified script, as I said it will count all the occurences of ORA- including your supposedly excluded line(ORA-00600). To check try copying your logfile and append a line or lines that contains the string ORA-00600. Run your command with that file and you will see that it will count the line ORA-00600.

Hope to clear things up. Thanks!