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.
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
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
