Who's Online Now
0 registered members (), 0 guests, and 17 spiders.
Key: Admin, Global Mod, Mod
Newest Members
dpf6jbez9, hcmconfig, Christine, BBH, vjnanda
1290 Registered Users
Recent Posts
IR35 Legislation
by delboy. 03/09/19 09:37 AM
Top Posters(30 Days)
CT 4
delboy 2
Popular Topics(Views)
484,790 PAYE RTI
58,246 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12229 - 02/09/19 08:57 AM EBS R12.2 / RDBMS 12c Upgrade Experiences?  
Joined: Jan 2013
Posts: 84
Bagpuss Offline
hacker
Bagpuss  Offline
hacker

Joined: Jan 2013
Posts: 84
Bath, England
We're currently running EBS 12.1.3 (Payroll with some HR aspects) on an 11.2 database.

Planning the database and application upgrades, whether that be together or database in 2020 and app in 2021.

Looking through the details, EBS changes appear relatively moderate aside from the introduction of online patching and its obvious storage impact. The database upgrade doesn't feel me with dread either with many case studies suggesting performance (negatively or positively) being the most common impact. Appears there's quite a few outstanding bugs which is a concern, so hoping 19c is more stable should it be certified with EBS in time. Otherwise, we'll aim for 12c Release 2.

So I thought I'd seek some real-world experiences of either upgrade, especially if anyone has done both together? I've got Oracle on the hook but a nice independent take on things is always welcome!

#12231 - 04/09/19 12:11 PM Re: EBS R12.2 / RDBMS 12c Upgrade Experiences? [Re: Bagpuss]  
Joined: Mar 2005
Posts: 2,107
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,107
Hello sir!

A while ago now, and my absence from the game for nigh-on 18 months has exacerbated the sketchiness of my memory, but:

The main headaches where around customisations, including custom reports involving run result values. I believe that the non-creation of null run result values - which used to be 'optional' but with 12.2 became the default (and non-configurable!) position - meant that any custom queries looking for such rows needed to handle the possibility of a missing row rather than just 'ignoring the nulls'.

The other major issue (there were more, but my memory is really bad!) was around custom tables, and was primarily to do with this hot-patching thing. Where I previously worked there were hundreds of custom tables, all with their respective build scripts for the table, indexes, synonyms and grants etc. There was a wholesale need to change pretty much all of them so that having created/altered the table, the Oracle process had to be run to create the special views needed to facilitate hot patching. The name of the view type escapes my addled brain at this time. The synonym creation scripts then needed to change so that they pointed to the special view of the table rather than the base table.

Finally, while the 2 brain cells are colliding randomly in my head - when you come to do testing of concurrent programs, I seem to recall there was a problem around seeing log/outputs, but that may have been some nonsense with Windows-10 security on web pages. Hopefully someone else can flesh out that ridiculously sparse account of the problem.

Hope it all goes well!

Cheers,


CT
#12232 - 04/09/19 12:40 PM Re: EBS R12.2 / RDBMS 12c Upgrade Experiences? [Re: CT]  
Joined: Jan 2013
Posts: 84
Bagpuss Offline
hacker
Bagpuss  Offline
hacker

Joined: Jan 2013
Posts: 84
Bath, England
Originally Posted by CT
Hello sir!

A while ago now, and my absence from the game for nigh-on 18 months has exacerbated the sketchiness of my memory, but:

The main headaches where around customisations, including custom reports involving run result values. I believe that the non-creation of null run result values - which used to be 'optional' but with 12.2 became the default (and non-configurable!) position - meant that any custom queries looking for such rows needed to handle the possibility of a missing row rather than just 'ignoring the nulls'.

The other major issue (there were more, but my memory is really bad!) was around custom tables, and was primarily to do with this hot-patching thing. Where I previously worked there were hundreds of custom tables, all with their respective build scripts for the table, indexes, synonyms and grants etc. There was a wholesale need to change pretty much all of them so that having created/altered the table, the Oracle process had to be run to create the special views needed to facilitate hot patching. The name of the view type escapes my addled brain at this time. The synonym creation scripts then needed to change so that they pointed to the special view of the table rather than the base table.

Finally, while the 2 brain cells are colliding randomly in my head - when you come to do testing of concurrent programs, I seem to recall there was a problem around seeing log/outputs, but that may have been some nonsense with Windows-10 security on web pages. Hopefully someone else can flesh out that ridiculously sparse account of the problem.

Hope it all goes well!

Cheers,



Afternoon CT! That's very useful to know, think I brushed past something on those pesky custom tables but the NULL run results thing didn't come up, so that's very useful.

I'll dig around for more and include in my impact summary - thanks for the pointers!

Sad to hear about your memory loss and general degradation of faculties. By the way, you owe me £1,000 for that,er, thing I sold you...

#12233 - 05/09/19 09:41 AM Re: EBS R12.2 / RDBMS 12c Upgrade Experiences? [Re: Bagpuss]  
Joined: Mar 2005
Posts: 2,107
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,107
Originally Posted by Bagpuss


Afternoon CT! That's very useful to know, think I brushed past something on those pesky custom tables but the NULL run results thing didn't come up, so that's very useful.

I'll dig around for more and include in my impact summary - thanks for the pointers!

Sad to hear about your memory loss and general degradation of faculties. By the way, you owe me £1,000 for that,er, thing I sold you...


Given that your organisation and this other place where I worked down in Gosport are both sides of the same government service (ahem), I feel it would profit you greatly if some senior manager type at your end had a conversation with their equivalent down there to see if more detailed info could be made available on their upgrade. Just tell him or her to say the magic word 'MTR' and hopefully doors will open!

Oh and as for the £1,000 I still owe you, yes I think you're probably right. If only I could remember where I put my cheque book...


CT
#12234 - 05/09/19 10:13 AM Re: EBS R12.2 / RDBMS 12c Upgrade Experiences? [Re: CT]  
Joined: Jan 2013
Posts: 84
Bagpuss Offline
hacker
Bagpuss  Offline
hacker

Joined: Jan 2013
Posts: 84
Bath, England
Originally Posted by CT
Originally Posted by Bagpuss


Afternoon CT! That's very useful to know, think I brushed past something on those pesky custom tables but the NULL run results thing didn't come up, so that's very useful.

I'll dig around for more and include in my impact summary - thanks for the pointers!

Sad to hear about your memory loss and general degradation of faculties. By the way, you owe me £1,000 for that,er, thing I sold you...


Given that your organisation and this other place where I worked down in Gosport are both sides of the same government service (ahem), I feel it would profit you greatly if some senior manager type at your end had a conversation with their equivalent down there to see if more detailed info could be made available on their upgrade. Just tell him or her to say the magic word 'MTR' and hopefully doors will open!

Oh and as for the £1,000 I still owe you, yes I think you're probably right. If only I could remember where I put my cheque book...


I've suggested the very same in my upgrade strategy doc but useful to know that you were referring to that particular tech refresh - would be foolish not harvest some lessons learned!

Your cheque book is in your pink handbag...

#12235 - 05/09/19 11:48 AM Re: EBS R12.2 / RDBMS 12c Upgrade Experiences? [Re: Bagpuss]  
Joined: Mar 2005
Posts: 2,107
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,107
Originally Posted by Bagpuss


Your cheque book is in your pink handbag...


I sold that, and a kidney, on eBay. In fact I put the kidney in the bag for safe keeping.

Any road up, I think we both know I already paid you that money to expedite the release of the trunk full of £30M sitting in that vault in Nigeria. Still waiting for that, by the way... that was you wasn't it!


CT

Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,224
Posts12,007
Members1,291
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,107
delboy 1,299
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
September
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.026s Queries: 15 (0.005s) Memory: 2.7770 MB (Peak: 2.9458 MB) Zlib disabled. Server Time: 2019-09-17 23:23:01 UTC