[Pacemaker] [Help] Pacemaker + Oracle Listener

[Florian Haas]

On Wed, Jun 6, 2012 at 12:44 AM, Paul Damken <zen.suite at gmail.com> wrote:
> 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

This is just a generic error, so it could theoretically be anything,
but often this is due to an incorrect tnslistener.ora configuration,
where the listener is attempting to bind to an IP address that doesn't
exist on the node where the listener is about to start.

Find that tnslistener.ora file in your ORACLE_HOME, fix it up so the
listener binds to the virtual IP, and you should hopefully be good to
go.

Cheers,
Florian

-- 
Need help with High Availability?
http://www.hastexo.com/now