does anyone happen to have a sample of a hacmp monitoring script for oracle? With the process monitoring I seem to be only able to monitor the listener but not oracle itself ?
Not a HACMP-ready script, but should be easy to alter so IIRC HACMP just triggers if the exit code is 0 or not.
When I wrote scripts to check the "alive" status of DB2 or TSM, I usually just checked the return code of a simple SELECT on a system table. By doing this you can bypass checking for processes as this does not tell if they are still working or not.
Let me dig one out... bypass that OV (HP Open View /OMW) stuff and the German gibberish This script was one of many in a self written monitoring construct. The maybe interesting part for you is the bold marked.
Hi
I do a very simple monitoring of our OpenLDAP (runs in cronjob and generate alerts if unsuccessfull)
$ ldapsearch -h hostname.domain -D "cn=monitor_user,ou=People,dc=organisation" -w "password" -b "dc=organisation" -x "(&(cn=monitor_user)(ou=People))" dn | grep -v version
dn:... (4 Replies)
I am planning for building a new database server using AIX 6.1 and Oracle 11.2 using ASM.
As i have learned starting with Oracle 11.2 ASM can only be used in conjunction with Clusterware, which is Oracles HA-software. As is the companies policy we do intend to use PowerHA as HA-solution instead... (1 Reply)
hi,
when I do a failover, hacmp always starts db2 but recently it fails to start db2..noticed the issue is db2nodes.cfg is not modified by hacmp and is still showing primary node..manually changed the node name to secondary after which db2 started immediately..unable to figure out why hacmp is... (4 Replies)
Hello All,
Anybody knows how can I run script on the AIX HACMP offline node, without logon a offline node?
I would like to run a script on the online node and at same time or after the online node on the offline node.
Any IDEA? :confused: (3 Replies)
can anyone provide me with a basic command that can do this? like, is there a one liner command line i can run that will spit out some digits to me. (digits i can write a script to monitor)??? (0 Replies)
Hello,
I was wondering if I have 3 nodes (A, B, C) all configured to startup with HACMP, but I would like to configure HACMP in such a way:
1) Node B should startup first. After the cluster successfully starts up and mounts all the filesystems, then
2) Node A, and Node C should startup !
... (4 Replies)
Hi All,
Is there some kind of cache for the hacmp script? Because I modified the script for sure but the first failover still execute the old script. Only on the succeeding failover is fine.
Anyone who had encounter this with hacmp, I'm using 5.3.
Regards. (1 Reply)