M, Check out these two links below. They will explain in painful detail how to enable and use Oracle's snmp implementation. I am also including a zip of the oracle mibs, downloaded from:http://crc.somix.com/mibs/
You may want to check with your Oracle rep to make sure these are the mibs that apply to your db ver etc. The concept is still the same. Just think of oracle as the server rather than the unix macine as the server. You could enable snmp traps on the oracle server, then restart the oracle process, db, or whatever and see what traps are produced. You may want to run snoop on the unix box during this operation so you can be sure that there are traps comming out and that they are headed for WUG. If starting, stopping, or restarting the DB produces a trap to WUG, then you just config WUG to kick off the Win2k service restart routine based on that trap. You can also look throught the mibs, and look for a "flag" of some sort you can poll. You need a variable that tellsyou the db was started, stoppped, restarted, or whatever. You might look for something like DB uptime. Then, in WUG, go to Configure > Monitors and Services > click on the SNMP service > EDIT > Help This is the area to define an snmp value to be polled by WUB. The text of the help section in included below, but you should also refer to the User Guide and the links in the actual help page. That should get you going. Hope this helps. James Defining an SNMP Object to Monitor Once you install the SNMP Monitor Plug-In, you can monitor SNMP objects on a device. Note: The device must be SNMP enabled. You can define the SNMP object (and instance) to monitor. 1 If you are not already in the Monitors/Services dialog box, from the Configure menu, select Monitors & Services. 2 Click the New button. 3 In the Service Name box, enter a name for the definition of the SNMP value check. Examples. 4 In the Service Type box, select SNMP Monitoring. Then, click OK. You now see the options that let you define the parameters for monitoring the SNMP object. Monitor/Service Properties 1 Click the Browse button next to the Object ID box; then, locate and select the appropriate SNMP object in the MIB object tree. Examples. � Enter the instance number and then click OK. The object ID (with the instance number appended) is inserted into the MIB text box. Examples. NOTE: Specify the instance (argument) only once, either here, or at the Edit Device Monitor dialog, but not both places. This will prevent the argument from being appended twice, and thus creating an invalid Object ID. 2 Check it for. Select Constant Value, Range of Values, or Rate of Change in Value. See the following Example. Next, you will want to turn on monitoring of this SNMP object for the devices you want to monitor. Arguments The Argument field (if specified) is appended on to the end of the MIB value. This is particularly useful for specifying the instance ID from a Device Monitor within WhatsUp Gold. 2002 Ipswitch, Inc. http://otn.oracle.com/products/oem/management_partners/snmp_wp.html http://otn.oracle.com/products/oem/management_partners/snmp_fs.html http://lina.cli.di.unipi.it:8000/WG73-doc/net/nwsmp/toc.html http://www.csee.umbc.edu/help/oracle8/server.815/a67822/toc.htm James McGovern Amann Network Technician Lead Georgia State University IST / UCCS 95 Decatur St. Suite 500 Atlanta, GA 30303 PH: 404.651.1574 FX: 404.651.4408 PG: 404.476.7754 [EMAIL PROTECTED] >>> <[EMAIL PROTECTED]> 12/10/02 04:38PM >>> James, I did run your idea by my director(on stopping and starting a service on a reboot) and he wanted to take it a step further.(Figures!) He wants to know if it is possible to stop and start a service on a w2K server when a oracle "database" is taken down then up on our unix server. (not only just on a "reboot" or coldstart on the entire unix server as I requested before). Currently, I am not monitoring any oracle services on the unix device and frankly I do not know how to do that in whatsup. So first I need to know: 1) how to monitor an oracle service and/or database from whatsup 2) how to stop and start a service when the oracle database is taken down then up again.(in other words when the connection is lost and is reestablished) I know some of us here are looking into telneting and going into that route and leaving whatsup out of the loop all together but I am a die hard whatsup fan. Besides that leaving the tasks to one central monitoring system seems more structured to me. But then again we might not have too many choices. Any information coming my way from you would be greatly appreciated. thanks, -Maria Hejna -----Original Message----- From: James Amann [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:58 PM To: [EMAIL PROTECTED] Subject: RE: [WhatsUp Forum] stopping and starting a service in whatsup gold No probem. We have similar functions working so if you need assistance let me know. JMA >>> [EMAIL PROTECTED] 12/09/02 02:52PM >>> thanks James, I will test unix server for SNMP and let you know the results on how it works with WUG! -Maria -----Original Message----- From: James Amann [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [WhatsUp Forum] stopping and starting a service in whatsup gold How about kicking off the service restart after a coldstart trap? Set up the unix box for snmp, have it trap to wug. When wug sees a "coldstart" trap from this device, it knows the unix device has rebooted, restart the service, and done. James McGovern Amann Network Technician Lead Georgia State University IST / UCCS 95 Decatur St. Suite 500 Atlanta, GA 30303 PH: 404.651.1574 FX: 404.651.4408 PG: 404.476.7754 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 12/09/02 10:28AM >>> Thanks for the quick reply Richard. I am having difficulty finding out what the "WUG status would be". On a reboot of a Unix server the alert status is down, then up. I just dont want to setoff the program batch file on a down condition and I dont want to activate it on just an up condtion. The condtion has to be a "reboot", which is down then up. So it might be difficult to find the proper WUG condition for the program notification to activate upon. There aren't any event viewer error codes I can go on either on the W2K side of things. The service on the w2k server remains started as though it doesnt know that the Unix server just rebooted and disconnected it. So what I do now is manually stop the service on the w2k server, then start it again after the Unix administrator tells me he rebooted the database(unix) server. If you find anything or have any ideas, please keep sending them my way and thanks! -----Original Message----- From: Richard Beckmannflay [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:14 AM To: [EMAIL PROTECTED] Subject: RE: [WhatsUp Forum] stopping and starting a service in whatsup go ld You'd best look at the NOTIFICATIONS, setup a PROGRAM Notification, put NETSVC.exe from the Windows Res Kit, which will allow you to remotely start/stop a service based on a WUG status. Richard -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 December 2002 1:22 AM To: [EMAIL PROTECTED] Subject: [WhatsUp Forum] stopping and starting a service in whatsup gold Hello, I am running whatsup gold 7.03 on a windows 2000 platform. My question is: Can I stop and start a service that is running on a windows 2000 server every time our Unix server gets rebooted? I know there must be a script of some sort out there. We have a Unix server that contains an Oracle database. When that server gets rebooted it affects a service that remains started on the windows 2000 application server. So what I do each time is manually stop the service and then start it again on he W2K device. If this can be automated thru whatsup gold all the better!! Please help. Thanks Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
oracle-mibs.zip
Description: Zip compressed data
