golden gate monitoring script

[Roshan]

Oracle DB 12.1.0.2

Solaris 11.4

 

Hello Erman,

 

I would like some help on golden gate monitoring script. I have configured mail on my Solaris server where golden gate is running. Sendmail is working fine. The script is executing without any errors but email is not being sent. I tested on a Linux server and I am getting email notification when I stop replicat.

I have attached the script. Could you please advise what can be wrong?
script.txt

Regards,

Roshan

[ErmanArslansOracleBlog]

Your sendmail works fine and you tested it? So you can send emails from Solaris and your script runs fines?So your submit.cf and sendmail.cf files are configured properly?

This is an easy script. It finds and sets its environment variables, execute ggsci commands and lastly checks the log and decides if there is a need for an email or not.

As the logic is easy, the debugging should be easy too..
If your script runs fine, then please debug it.
Check that log file your commands populate.. Does that log contains the problematic entry after the execution?
Use print/echo commands in the critical sections (between the lines which take real actions) of your script.. Especially the suspicious ones.. Try to see if the  commands in those lines are executed or not.. Try to see the path that the script follows during that exection, concantrate on them, point out the problem and fix :)

It is not an efficient method to get a comment on this kind of an issue remotely. It is more of a hands-on work.. but ofcourse, still I m trying to help you.

[Roshan]

Thanks it is working now.

Script is working now.

The lag was 10 minutes in script I should have waited for 10 minutes :)

[ErmanArslansOracleBlog]

Good :)