Mailing List Archive: [Question] About the change of the oracle resource agent.

[Question] About the change of the oracle resource agent.

renayama19661014 at ybb

Jul 21, 2014, 7:07 PM

Post #1 of 5 (3085 views)

Hi All,

I am going to explain the next change to our user.

* https://github.com/ClusterLabs/resource-agents/pull/367
* https://github.com/ClusterLabs/resource-agents/pull/439

Let me confirm whether it is the next contents that a patch intends.

1) Because it was a problem that OCFMON user was added while the oracle manager did not know it, patch changed it to appoint it explicitly.
2) Patch changed a deadline of OCFMON.(A deadline for password of the default may be 180 days.)
3) Patch kept compatibility with old RA.

Is there the main point of any other patches?

If there is really the problem that occurred, before this change, please teach to me.
I intend to really show the problem that happened to a user.
* For example, a time limit of OCFMON expired and failed in a monitor of oracle

I am going to send a patch later.

Best Regards,
Hideo Yamauchi.
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: [Question] About the change of the oracle resource agent. [ In reply to ]

dejanmm at fastmail

Jul 22, 2014, 2:46 AM

Post #2 of 5 (3026 views)

Permalink

Hi Hideo-san,

On Tue, Jul 22, 2014 at 11:07:29AM +0900, renayama19661014@ybb.ne.jp wrote:
> Hi All,
>
> I am going to explain the next change to our user.
>
> * https://github.com/ClusterLabs/resource-agents/pull/367
> * https://github.com/ClusterLabs/resource-agents/pull/439
>
>
> Let me confirm whether it is the next contents that a patch intends.
>
> 1) Because it was a problem that OCFMON user was added while the oracle manager did not know it, patch changed it to appoint it explicitly.

The OCFMON user and password parameters are optional, hence in
this respect nothing really changed. The user is still created
by the RA. However, it is good that they're now visible in the
meta-data.

> 2) Patch changed a deadline of OCFMON.(A deadline for password of the default may be 180 days.)

That's the problem we had with the previous version. Now there's
a profile created for the monitoring user which has unlimited
password expiry. If the password expired in the meantime, due to
a missing profile, then it is reset.

If the monitor still fails, the RA tries as sysdba again.

> 3) Patch kept compatibility with old RA.

Yes.

> Is there the main point of any other patches?

No.

> If there is really the problem that occurred, before this change, please teach to me.

As mentioned above, the issue was that the password could
expire.

> I intend to really show the problem that happened to a user.
> * For example, a time limit of OCFMON expired and failed in a monitor of oracle

Is that with the latest version?

Cheers,

Dejan

> I am going to send a patch later.
>
> Best Regards,
> Hideo Yamauchi.
> _______________________________________________________
> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> Home Page: http://linux-ha.org/
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: [Question] About the change of the oracle resource agent. [ In reply to ]

renayama19661014 at ybb

Jul 22, 2014, 4:50 AM

Post #3 of 5 (3024 views)

Permalink

Hi Dejan,

All right!!

> Is that with the latest version?

I confirm RA now in Oracle12c.
It is the latest edition of oracle.

Many Thanks!
Hideo Yamauchi.

----- Original Message -----
> From: Dejan Muhamedagic <dejanmm@fastmail.fm>
> To: renayama19661014@ybb.ne.jp; High-Availability Linux Development List <linux-ha-dev@lists.linux-ha.org>
> Cc:
> Date: 2014/7/22, Tue 18:46
> Subject: Re: [Linux-ha-dev] [Question] About the change of the oracle resource agent.
>
> Hi Hideo-san,
>
> On Tue, Jul 22, 2014 at 11:07:29AM +0900, renayama19661014@ybb.ne.jp wrote:
>> Hi All,
>>
>> I am going to explain the next change to our user.
>>
>> * https://github.com/ClusterLabs/resource-agents/pull/367
>> * https://github.com/ClusterLabs/resource-agents/pull/439
>>
>>
>> Let me confirm whether it is the next contents that a patch intends.
>>
>> 1) Because it was a problem that OCFMON user was added while the oracle
> manager did not know it, patch changed it to appoint it explicitly.
>
> The OCFMON user and password parameters are optional, hence in
> this respect nothing really changed. The user is still created
> by the RA. However, it is good that they're now visible in the
> meta-data.
>
>> 2) Patch changed a deadline of OCFMON.(A deadline for password of the
> default may be 180 days.)
>
> That's the problem we had with the previous version. Now there's
> a profile created for the monitoring user which has unlimited
> password expiry. If the password expired in the meantime, due to
> a missing profile, then it is reset.
>
> If the monitor still fails, the RA tries as sysdba again.
>
>> 3) Patch kept compatibility with old RA.
>
> Yes.
>
>> Is there the main point of any other patches?
>
> No.
>
>> If there is really the problem that occurred, before this change, please
> teach to me.
>
> As mentioned above, the issue was that the password could
> expire.
>
>> I intend to really show the problem that happened to a user.
>> * For example, a time limit of OCFMON expired and failed in a monitor of
> oracle
>
> Is that with the latest version?
>
> Cheers,
>
> Dejan
>
>> I am going to send a patch later.
>>
>> Best Regards,
>> Hideo Yamauchi.
>> _______________________________________________________
>> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
>> Home Page: http://linux-ha.org/
>
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: [Question] About the change of the oracle resource agent. [ In reply to ]

renayama19661014 at ybb

Jul 22, 2014, 7:09 PM

Post #4 of 5 (3020 views)

Permalink

Hi Dejan,

I confirmed it in the environment where NLS_LANG was set in Japanese(Japanese_Japan.AL32UTF8).

I changed the expiration date of the OCFMON user and pushed forward the date of the system for one year.
I confirmed that the next processing worked definitely.(...on oracle12c)

Confirmed 1) After OCFMON user became expired (EXPIRED), the monitor processing in the sysdba user succeeds.
Confirmed 2) The grep judgment of the EXPIRED character string is carried out definitely.
Confirmed 3) When we start oracle again after OCFMON user expired, the time limit of the OCFMON user is changed.

>
> 415 if echo "$output" | grep -w "EXPIRED"
>> /dev/null; then
>
> Also, could you verify if common_sql_filter() need modifications?

As a result, the correction of the next grep was not necessary.(Confirmed 2,Confirmed 3)

Best Regards,
Hideo Yamauchi.

----- Original Message -----
> From: "renayama19661014@ybb.ne.jp" <renayama19661014@ybb.ne.jp>
> To: Dejan Muhamedagic <dejanmm@fastmail.fm>; High-Availability Linux Development List <linux-ha-dev@lists.linux-ha.org>
> Cc:
> Date: 2014/7/22, Tue 20:50
> Subject: Re: [Linux-ha-dev] [Question] About the change of the oracle resource agent.
>
> Hi Dejan,
>
> All right!!
>
>> Is that with the latest version?
>
>
> I confirm RA now in Oracle12c.
> It is the latest edition of oracle.
>
> Many Thanks!
> Hideo Yamauchi.
>
>
>
> ----- Original Message -----
>> From: Dejan Muhamedagic <dejanmm@fastmail.fm>
>> To: renayama19661014@ybb.ne.jp; High-Availability Linux Development List
> <linux-ha-dev@lists.linux-ha.org>
>> Cc:
>> Date: 2014/7/22, Tue 18:46
>> Subject: Re: [Linux-ha-dev] [Question] About the change of the oracle
> resource agent.
>>
>> Hi Hideo-san,
>>
>> On Tue, Jul 22, 2014 at 11:07:29AM +0900, renayama19661014@ybb.ne.jp wrote:
>>> Hi All,
>>>
>>> I am going to explain the next change to our user.
>>>
>>> * https://github.com/ClusterLabs/resource-agents/pull/367
>>> * https://github.com/ClusterLabs/resource-agents/pull/439
>>>
>>>
>>> Let me confirm whether it is the next contents that a patch intends.
>>>
>>> 1) Because it was a problem that OCFMON user was added while the
> oracle
>> manager did not know it, patch changed it to appoint it explicitly.
>>
>> The OCFMON user and password parameters are optional, hence in
>> this respect nothing really changed. The user is still created
>> by the RA. However, it is good that they're now visible in the
>> meta-data.
>>
>>> 2) Patch changed a deadline of OCFMON.(A deadline for password of the
>> default may be 180 days.)
>>
>> That's the problem we had with the previous version. Now there's
>> a profile created for the monitoring user which has unlimited
>> password expiry. If the password expired in the meantime, due to
>> a missing profile, then it is reset.
>>
>> If the monitor still fails, the RA tries as sysdba again.
>>
>>> 3) Patch kept compatibility with old RA.
>>
>> Yes.
>>
>>> Is there the main point of any other patches?
>>
>> No.
>>
>>> If there is really the problem that occurred, before this change,
> please
>> teach to me.
>>
>> As mentioned above, the issue was that the password could
>> expire.
>>
>>> I intend to really show the problem that happened to a user.
>>> * For example, a time limit of OCFMON expired and failed in a monitor
> of
>> oracle
>>
>> Is that with the latest version?
>>
>> Cheers,
>>
>> Dejan
>>
>>> I am going to send a patch later.
>>>
>>> Best Regards,
>>> Hideo Yamauchi.
>>> _______________________________________________________
>>> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
>>> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
>>> Home Page: http://linux-ha.org/
>>
> _______________________________________________________
> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> Home Page: http://linux-ha.org/
>
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: [Question] About the change of the oracle resource agent. [ In reply to ]

dejanmm at fastmail

Jul 23, 2014, 1:28 AM

Post #5 of 5 (3023 views)

Permalink

On Wed, Jul 23, 2014 at 11:09:55AM +0900, renayama19661014@ybb.ne.jp wrote:
> Hi Dejan,
>
> I confirmed it in the environment where NLS_LANG was set in Japanese(Japanese_Japan.AL32UTF8).
>
> I changed the expiration date of the OCFMON user and pushed forward the date of the system for one year.
> I confirmed that the next processing worked definitely.(...on oracle12c)
>
> Confirmed 1) After OCFMON user became expired (EXPIRED), the monitor processing in the sysdba user succeeds.
> Confirmed 2) The grep judgment of the EXPIRED character string is carried out definitely.
> Confirmed 3) When we start oracle again after OCFMON user expired, the time limit of the OCFMON user is changed.
>
> >
> > 415 if echo "$output" | grep -w "EXPIRED"
> >> /dev/null; then
> >
> > Also, could you verify if common_sql_filter() need modifications?
>
> As a result, the correction of the next grep was not necessary.(Confirmed 2,Confirmed 3)

Many thanks for the testing and the patch!

Cheers,

Dejan

> Best Regards,
> Hideo Yamauchi.
>
>
>
> ----- Original Message -----
> > From: "renayama19661014@ybb.ne.jp" <renayama19661014@ybb.ne.jp>
> > To: Dejan Muhamedagic <dejanmm@fastmail.fm>; High-Availability Linux Development List <linux-ha-dev@lists.linux-ha.org>
> > Cc:
> > Date: 2014/7/22, Tue 20:50
> > Subject: Re: [Linux-ha-dev] [Question] About the change of the oracle resource agent.
> >
> > Hi Dejan,
> >
> > All right!!
> >
> >> Is that with the latest version?
> >
> >
> > I confirm RA now in Oracle12c.
> > It is the latest edition of oracle.
> >
> > Many Thanks!
> > Hideo Yamauchi.
> >
> >
> >
> > ----- Original Message -----
> >> From: Dejan Muhamedagic <dejanmm@fastmail.fm>
> >> To: renayama19661014@ybb.ne.jp; High-Availability Linux Development List
> > <linux-ha-dev@lists.linux-ha.org>
> >> Cc:
> >> Date: 2014/7/22, Tue 18:46
> >> Subject: Re: [Linux-ha-dev] [Question] About the change of the oracle
> > resource agent.
> >>
> >> Hi Hideo-san,
> >>
> >> On Tue, Jul 22, 2014 at 11:07:29AM +0900, renayama19661014@ybb.ne.jp wrote:
> >>> Hi All,
> >>>
> >>> I am going to explain the next change to our user.
> >>>
> >>> * https://github.com/ClusterLabs/resource-agents/pull/367
> >>> * https://github.com/ClusterLabs/resource-agents/pull/439
> >>>
> >>>
> >>> Let me confirm whether it is the next contents that a patch intends.
> >>>
> >>> 1) Because it was a problem that OCFMON user was added while the
> > oracle
> >> manager did not know it, patch changed it to appoint it explicitly.
> >>
> >> The OCFMON user and password parameters are optional, hence in
> >> this respect nothing really changed. The user is still created
> >> by the RA. However, it is good that they're now visible in the
> >> meta-data.
> >>
> >>> 2) Patch changed a deadline of OCFMON.(A deadline for password of the
> >> default may be 180 days.)
> >>
> >> That's the problem we had with the previous version. Now there's
> >> a profile created for the monitoring user which has unlimited
> >> password expiry. If the password expired in the meantime, due to
> >> a missing profile, then it is reset.
> >>
> >> If the monitor still fails, the RA tries as sysdba again.
> >>
> >>> 3) Patch kept compatibility with old RA.
> >>
> >> Yes.
> >>
> >>> Is there the main point of any other patches?
> >>
> >> No.
> >>
> >>> If there is really the problem that occurred, before this change,
> > please
> >> teach to me.
> >>
> >> As mentioned above, the issue was that the password could
> >> expire.
> >>
> >>> I intend to really show the problem that happened to a user.
> >>> * For example, a time limit of OCFMON expired and failed in a monitor
> > of
> >> oracle
> >>
> >> Is that with the latest version?
> >>
> >> Cheers,
> >>
> >> Dejan
> >>
> >>> I am going to send a patch later.
> >>>
> >>> Best Regards,
> >>> Hideo Yamauchi.
> >>> _______________________________________________________
> >>> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
> >>> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> >>> Home Page: http://linux-ha.org/
> >>
> > _______________________________________________________
> > Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> > Home Page: http://linux-ha.org/
> >
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/