Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Issues with latest Oracle CPU

From: Hanna, Christopher A CTR (2014-08-08 12:31)

All,
I just want to pass along a word of caution to any of you out there running Maximo against Oracle 11gR2. The latest critical patch update from Oracle has the potential to break/corrupt all the text indexes. The effect of this is that any object that has any attributes with the search type set to TEXT will be rendered useless (can't INSERT or UPDATE). Fortunately we caught this issue in our DEV environment so the damage is minimal.
Our DBA is currently working with Oracle support to try and get a fix for this.
I do not know if this affects all Maximo installations, or if there is something specific to our DB configuration that caused this patch to fail. Simply wanted to caution all to apply this patch in a non-prod environment and test thoroughly and have a fallback plan ready.
Thanks!
Chris A Hanna, CTR
Application Programmer
Digital Management Inc.
US Coast Guard Operations Systems Center
christopher.a.hanna@uscg.mil
(304)433-3234


From: babalex6000 (2014-08-11 05:43)

Here is IBM recommendation for Oracle patch
Thanks
Bobby


From: swkim (2014-08-11 15:15)

What is the IBM recommendation for the Oracle patch?
Our DBA says this is in our test database. How do we test if the patch is having adverse affects?


From: Hanna, Christopher A CTR (2014-08-12 11:39)

The issue is that all the text indexes become corrupted. Any attributes with the search type set to text become unusable.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Monday, August 11, 2014 6:16 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Issues with latest Oracle CPU

What is the IBM recommendation for the Oracle patch?
Our DBA says this is in our test database. How do we test if the patch is having adverse affects?


From: swkim (2014-08-12 16:12)

We tested in our dev environment and did not see any text corruption. I created four new work orders, waited 15 minutes for the text indexes to refresh, and performed a description search. All four of those new work orders appeared in the search result. So, for our environment, we are unable to reproduce the issue.
Did you apply the security patches, CPU patches, or BOTH?

Perhaps we need to try some other steps?

Is this issue resolved on your end? If so, what steps did you take?

The DBA is going to apply the patch to production on Wednesday night. They have a backout plan, but wanted to see if we could reproduce the issue in our dev environment before applying any patches in production.


From: Hanna, Christopher A CTR (2014-08-13 11:17)

Sorry, I'm not a DBA so my details are a little vague. Wouldn't surprise me if this issue doesn't affect everyone (or maybe anyone else). Could be something about the tight controls on our DB that the patch breaks.
We had to back the patch off our dev environment. Had to drop and rebuild all the text indexes too. Our DBA has been actively working with Oracle support for almost three weeks now without resolution. IBM support has also been informed.
-----Original Message-----
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, August 12, 2014 7:12 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Issues with latest Oracle CPU

We tested in our dev environment and did not see any text corruption. I created four new work orders, waited 15 minutes for the text indexes to refresh, and performed a description search. All four of those new work orders appeared in the search result. So, for our environment, we are unable to reproduce the issue.
Did you apply the security patches, CPU patches, or BOTH?
Perhaps we need to try some other steps?
Is this issue resolved on your end? If so, what steps did you take?
The DBA is going to apply the patch to production on Wednesday night. They have a backout plan, but wanted to see if we could reproduce the issue in our dev environment before applying any patches in production.


From: Gopinath Manickam (2014-08-14 11:07)

Chris,
Thanks for sharing this information, one of our Maximo 7.5 customer also
facing this issue.
Thanks,
Gopinath Manickam
On Fri, Aug 8, 2014 at 8:31 AM, 'Hanna, Christopher A CTR'
christopher.a.hanna@uscg.mil [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> All,
> I just want to pass along a word of caution to any of you out there
> running Maximo against Oracle 11gR2. The latest critical patch update from
> Oracle has the potential to break/corrupt all the text indexes. The effect
> of this is that any object that has any attributes with the search type set
> to TEXT will be rendered useless (can't INSERT or UPDATE). Fortunately we
> caught this issue in our DEV environment so the damage is minimal.
>
> Our DBA is currently working with Oracle support to try and get a fix for
> this.
>
> I do not know if this affects all Maximo installations, or if there is
> something specific to our DB configuration that caused this patch to fail.
> Simply wanted to caution all to apply this patch in a non-prod environment
> and test thoroughly and have a fallback plan ready.
>
> Thanks!
>
> Chris A Hanna, CTR
> Application Programmer
> Digital Management Inc.
> US Coast Guard Operations Systems Center
> christopher.a.hanna@uscg.mil
> (304)433-3234
>
>
>