[Pacemaker] [Help] Pacemaker + Oracle Listener

[emmanuel segura]

I seen your logs from the previous email, if look good the problem it's in
the listener resource
======================================================
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
======================================================

This is because after the cluster started the resource does a tnsping, but
fail

Put the service name in the tnsnames.ora equal to the oracle sid you
defined in your listerner resource

Sorry for my bad english :-)




2012/6/6 emmanuel segura <emi2fast at gmail.com>

> Paul
>
> What happeng if do this command from the oracle user?
>
> tnsping XIB11_HA.WORLD
>
> and remember to specify the ORACLE_SID in your resource parameters
>
> the cluster does a tnsping ORACLE_SID to monitor the instanse
>
>
> 2012/6/6 Paul Damken <zen.suite at gmail.com>
>
>>  Thanks Florian and Emmanuel,
>>
>> Yes I have,
>>
>> "tnsnames.ora" file:
>> --------------------->
>> XIB11_HA.WORLD =
>>   (DESCRIPTION =
>>     (ADDRESS_LIST =
>>       (ADDRESS = (PROTOCOL = TCP)(HOST = aztecavip.domainame)(PORT =
>> 1521))
>>     )
>>     (CONNECT_DATA =
>>       (SID = xib11)
>>     )
>>   )
>> <-------------------
>>
>> "listener.ora" file:
>>
>> -------------------->
>> # listener.ora Network Configuration File:
>> /oracle/10.2.0/db_1/network/admin/listener.ora
>> # Generated by Oracle configuration tools.
>>
>> LISTENER =
>>     (DESCRIPTION =
>>       (ADDRESS = (PROTOCOL = TCP)(HOST =  aztecavip.domainame)(PORT =
>> 1521)(IP=FIRST))
>>     )
>>   )
>> <---------------------
>>
>> It still refuses to work, I guess that I'm missing something important,
>> at Oracle level I mean.
>>
>> Regards,
>>
>>
>>
>> _______________________________________________
>> 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
>



-- 
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/1b11e928/attachment.htm>