Hi, On Wed, Mar 19, 2008 at 08:40:44PM +0100, [EMAIL PROTECTED] wrote: > I am currently working on a two node active/passive cluster using > heartbeat 2.1.3 to run oracle 10g on it. OS is SLES 10 SP1 x86_64. > I got everything up and running except the oracle resource itself. I > noticed a typo in the RA for the listener as well, but that is not the > source of my problems. > I will post a reviewed version of both the listener RA and the oracle RA > with improved error-handling later on, a colleague of mine is currently > working on that issue.
Thanks for the effort, but please note that there's another set of patches by Hideo Yamauchi in the queue posted two days ago to the list. > The oracle resource is defined within a group that includes all necessary > mountpoints and some other resources, that all do work well so far. > here is the part for the oracle RA: > > <primitive id="oracle" class="ocf" type="oracle" > provider="heartbeat"> > <instance_attributes id="oracle_instance_attrs"> > <attributes> > <nvpair id="96411248-ca89-4c26-8150-ad3fac1da351" > name="sid" value="PROD"/> > <nvpair id="6efbc87d-08fc-4a70-9f86-e5b19f59735f" > name="user" value="oracle"/> > <nvpair id="d7f233dd-2cb5-449b-90a1-88fcf50c79e8" > name="ipcrm" value="orauser"/> > <nvpair id="c2ca0cd9-0cca-42ad-9bbb-67e94f7f9186" > name="home" value="/opt/oracle/product/10.2/db_1"/> > </attributes> > </instance_attributes> > </primitive> > > However if I try to start the resource I get the following entries in the > log File: > > Mar 19 20:45:36 k1286mcs-n1 lrmd: [22492]: info: rsc:oracle: > monitor > Mar 19 20:45:36 k1286mcs-n1 lrmd: [22492]: info: RA output: > (oracle:monitor:stderr) which: no sqlplus in > (/usr/lib64/heartbeat:/usr/sbin:/usr/share/heartbeat:/usr/lib64/heartbeat:/usr/sbin:/usr/share/heartbeat:/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb:/bin) > Mar 19 20:45:36 k1286mcs-n1 oracle[4952]: [4962]: ERROR: Setup > problem: Couldn't find utility sqlplus > Mar 19 20:45:36 k1286mcs-n1 crmd: [22495]: ERROR: > process_lrm_event: LRM operation oracle_monitor_0 (call=208, rc=5) Error > not installed Yes, unfortunately there was a change to all resource agents before 2.1.3 (or even before 2.1.2) which shouldn't have been applied to oracle and oralsnr. This has been fixed in changeset http://hg.linux-ha.org/dev/log/6575926eb46e. If you include this fix you should be OK. Thanks, Dejan > It seems, that the entry for ORACLE_HOME is not passed to the RA at all. > If I hardcode it into the RA it does start without any problem: > > Mar 19 20:50:57 k1286mcs-n1 crmd: [22495]: info: do_lrm_rsc_op: > Performing op=oracle_start_0 > key=53:33:ea56b8bd-201f-4248-b45a-edb54ddf005f) > Mar 19 20:50:57 k1286mcs-n1 lrmd: [22492]: info: rsc:oracle: start > Mar 19 20:50:57 k1286mcs-n1 su: (to oracle) root on none > Mar 19 20:50:57 k1286mcs-n1 haclient: on_event:evt:cib_changed > Mar 19 20:51:06 k1286mcs-n1 su: (to oracle) root on none > Mar 19 20:51:06 k1286mcs-n1 oracle[7119]: [7258]: INFO: Oracle > instance PROD started: ORACLE instance started. Total System Global Area > 4294967296 bytes Fixed Size 2078264 bytes Variable Size > 2634025416 bytes Database Buffers 1644167168 bytes Redo Buffers > 14696448 bytes Database mounted. Database opened. > Mar 19 20:51:06 k1286mcs-n1 crmd: [22495]: info: > process_lrm_event: LRM operation oracle_start_0 (call=260, rc=0) complete > Mar 19 20:51:07 k1286mcs-n1 haclient: on_event:evt:cib_changed > > > Robert K?ppl > System Administration > -------------------------------------------------- > Tel.: +43 3842 805-910 > Fax: +43 3842 805-990 > [EMAIL PROTECTED] > www.KNAPP.com > -------------------------------------------------- > KNAPP Systemintegration GmbH > Waltenbachstra?e 9 > 8700 Leoben, ?sterreich > -------------------------------------------------- > Firmenbuchnummer: FN 138870x > Firmenbuchgericht: Leoben > > The information in this e-mail (including any attachment) is confidential > and intended to be for the use of the addressee(s) only. If you have > received the e-mail by mistake, any disclosure, copy, distribution or use > of the contents of the e-mail is prohibited, and you must delete the > e-mail from your system. As e-mail can be changed electronically KNAPP > assumes no responsibility for any alteration to this e-mail or its > attachments. KNAPP has taken every reasonable precaution to ensure that > any attachment to this e-mail has been swept for virus. However, KNAPP > does not accept any liability for damage sustained as a result of such > attachment being virus infected and strongly recommend that you carry out > your own virus check before opening any attachment. > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems -- Dejan _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
