[Pacemaker] [Help] Pacemaker + Oracle Listener

Wed Jun 6 07:08:03 UTC 2012

Did you configured the tnsnames.ora?

I ask you that because the agent oralsnr does tnsping to monitor the
resource

2012/6/6 Paul Damken <zen.suite at gmail.com>

> Im facing issues with my cluster setup. "N+1"
> Pacemaker Hosting Oracle 11g Instances. Node name "azteca"
>
> I cannot get "oralsnr" to start my DB listener, it refuses on both nodes.
> "Oracle" RA is starting first, after all File systems and VIP starts.
> But no way to get Listener UP.
>
> When I do a manual start from "/oracle/11.2.0/db_1/bin/lsnrctl start" it
> works
> just fine. (Using oracle "user" shell prompt)
>
> CRM Config "Oracle RA"
>
> primitive p_oracle1 ocf:heartbeat:oracle \
> params sid="xib11" home="/oracle/11.2.0/db_1" user="oracle"
> ipcrm="orauser" \
> op start interval="0" timeout="120s" \
> op stop interval="0" timeout="120s" \
> op monitor interval="15s"
> primitive p_oralsnr ocf:heartbeat:oralsnr \
> params sid="xib11" listener="LISTENER" user="oracle"
> home="/oracle/11.2.0/db_1"
> \
> op start interval="0" timeout="30s" \
> op stop interval="0" timeout="30s" \
> op monitor interval="15s"
> group oracle_grp p_oracle1 p_oralsnr \
> meta target-role="Started"
> order o_fs_before_listener inf: oracle_fs oracle_grp
> colocation ora_on_fs inf: oracle_grp oracle_fs
>
>
> >>>>>>>>
> ERROR LOG:
> azteca:/var/log # cat messages | grep p_oralsnr
> Jun  5 17:02:24 azteca crmd: [24262]: info: do_lrm_rsc_op: Performing
> key=20:900:7:8bf8ffb9-cc40-42c5-9dfa-cdb84ec20d97 op=p_oralsnr_monitor_0 )
> Jun  5 17:02:24 azteca lrmd: [24259]: info: rsc:p_oralsnr probe[401] (pid
> 9369)
> Jun  5 17:02:24 azteca lrmd: [24259]: info: operation monitor[401] on
> p_oralsnr
> for client 24262: pid 9369 exited with return code 7
> Jun  5 17:02:24 azteca crmd: [24262]: info: process_lrm_event: LRM
> operation
> p_oralsnr_monitor_0 (call=401, rc=7, cib-update=812, confirmed=true) not
> running
> Jun  5 17:02:34 azteca crmd: [24262]: info: do_lrm_rsc_op: Performing
> key=64:900:0:8bf8ffb9-cc40-42c5-9dfa-cdb84ec20d97 op=p_oralsnr_start_0 )
> Jun  5 17:02:34 azteca lrmd: [24259]: info: rsc:p_oralsnr start[404] (pid
> 11102)
> Jun  5 17:02:34 azteca lrmd: [24259]: info: operation start[404] on
> p_oralsnr
> for client 24262: pid 11102 exited with return code 1
> Jun  5 17:02:34 azteca crmd: [24262]: info: process_lrm_event: LRM
> operation
> p_oralsnr_start_0 (call=404, rc=1, cib-update=814, confirmed=true) unknown
> error
> Jun  5 17:02:34 azteca attrd: [24260]: info: find_hash_entry: Creating
> hash
> entry for fail-count-p_oralsnr
> Jun  5 17:02:34 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: fail-count-p_oralsnr (INFINITY)
> Jun  5 17:02:34 azteca attrd: [24260]: info: attrd_perform_update: Sent
> update
> 4121: fail-count-p_oralsnr=INFINITY
> Jun  5 17:02:34 azteca attrd: [24260]: info: find_hash_entry: Creating
> hash
> entry for last-failure-p_oralsnr
> Jun  5 17:02:34 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: last-failure-p_oralsnr (1338933754)
> Jun  5 17:02:34 azteca attrd: [24260]: info: attrd_perform_update: Sent
> update
> 4124: last-failure-p_oralsnr=1338933754
> Jun  5 17:02:34 azteca crmd: [24262]: info: do_lrm_rsc_op: Performing
> key=17:901:0:8bf8ffb9-cc40-42c5-9dfa-cdb84ec20d97 op=p_oralsnr_stop_0 )
> Jun  5 17:02:34 azteca lrmd: [24259]: info: rsc:p_oralsnr stop[405] (pid
> 11210)
> Jun  5 17:02:34 azteca lrmd: [24259]: info: operation stop[405] on
> p_oralsnr for
> client 24262: pid 11210 exited with return code 0
> Jun  5 17:02:34 azteca crmd: [24262]: info: process_lrm_event: LRM
> operation
> p_oralsnr_stop_0 (call=405, rc=0, cib-update=816, confirmed=true) ok
> Jun  5 17:06:41 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: fail-count-p_oralsnr (<null>)
> Jun  5 17:06:41 azteca attrd: [24260]: info: attrd_perform_update: Sent
> delete
> 4130: node=azteca, attr=fail-count-p_oralsnr, id=<n/a>, set=(null),
> section=status
> Jun  5 17:06:41 azteca attrd: [24260]: info: attrd_perform_update: Sent
> delete
> 4132: node=azteca, attr=fail-count-p_oralsnr, id=<n/a>, set=(null),
> section=status
> Jun  5 17:06:41 azteca attrd: [24260]: info: attrd_perform_update: Sent
> delete
> 4134: node=azteca, attr=fail-count-p_oralsnr, id=<n/a>, set=(null),
> section=status
> Jun  5 17:06:42 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: last-failure-p_oralsnr (1338933754)
> Jun  5 17:06:42 azteca crmd: [24262]: info: do_lrm_invoke: Removing
> resource
> p_oralsnr from the LRM
> Jun  5 17:06:42 azteca crmd: [24262]: info: do_lrm_invoke: Resource
> 'p_oralsnr'
> deleted for 3880_crm_resource on tlg0025
> Jun  5 17:06:42 azteca crmd: [24262]: info: notify_deleted: Notifying
> 3880_crm_resource on tlg0025 that p_oralsnr was deleted
> Jun  5 17:06:42 azteca crmd: [24262]: info: send_direct_ack: ACK'ing
> resource op
> p_oralsnr_delete_60000 from 0:0:crm-resource-3880:
> lrm_invoke-lrmd-1338934002-
> 184
> Jun  5 17:06:42 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: last-failure-p_oralsnr (1338933754)
> Jun  5 17:06:42 azteca attrd: [24260]: info: attrd_trigger_update: Sending
> flush
> op to all hosts for: last-failure-p_oralsnr (1338933754)
> Jun  5 17:06:42 azteca crmd: [24262]: info: do_lrm_rsc_op: Performing
> key=19:906:7:8bf8ffb9-cc40-42c5-9dfa-cdb84ec20d97 op=p_oralsnr_monitor_0 )
> Jun  5 17:06:42 azteca lrmd: [24259]: info: rsc:p_oralsnr probe[421] (pid
> 25778)
> Jun  5 17:06:42 azteca lrmd: [24259]: info: operation monitor[421] on
> p_oralsnr
> for client 24262: pid 25778 exited with return code 7
> Jun  5 17:06:42 azteca crmd: [24262]: info: process_lrm_event: LRM
> operation
> p_oralsnr_monitor_0 (call=421, rc=7, cib-update=841, confirmed=true) not
> running
> >>>>>>>>>>>>END LOG
>
> VERSION:
>
> ============
> Last updated: Tue Jun  5 17:08:48 2012
> Stack: openais
> Current DC: azteca - partition with quorum
> 2 Nodes configured, 2 expected votes
> 19 Resources configured.
> ============
>
> Thanks.
>
> Jorge.
>
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>
>

-- 
esta es mi vida e me la vivo hasta que dios quiera
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120606/086e72ff/attachment.htm>