RE: probe database using OEM event or job

2003-09-30 Thread Reardon, Bruce (CALBBAY)
Hi, Can you just use the built in OEM event "Database UpDown" - though perhaps this only comes with the Diagnostics Pack for OEM. As for a user defined test - You could just do something like "select user from dual" and hope it comes back if it can't connect - I haven't tried this. However, I th

Re: probe database using OEM event or job

2003-09-30 Thread Tanel Poder
Title: probe database using OEM event or job On unix you could do:   while true; do tnsping ALIAS > out || mail [EMAIL PROTECTED] < out; sleep 300; done;   (obviously you have to replace ALIAS and e-mail address there) It will send you the tnsping output if it happens to fail. (you&#x

probe database using OEM event or job

2003-09-30 Thread Baylis, John
Title: probe database using OEM event or job Can someone help me with this? Running Oracle 9.2.0.3 under win2000 I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting. I