0 registered members (),
6
guests, and
4
spiders. |
Key:
Admin,
Global Mod,
Mod
|
|
|
#12231 - 04/09/19 12:11 PM
Re: EBS R12.2 / RDBMS 12c Upgrade Experiences?
[Re: Bagpuss]
|
Joined: Mar 2005
Posts: 2,120
CT
|
  
Joined: Mar 2005
Posts: 2,120
|
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
hacker
|
hacker
Joined: Jan 2013
Posts: 84
Bath, England
|
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,120
CT
|
  
Joined: Mar 2005
Posts: 2,120
|
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
hacker
|
hacker
Joined: Jan 2013
Posts: 84
Bath, England
|
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...
|
|
|
|
Forums60
Topics2,231
Posts12,042
Members1,319
|
Most Online283 Dec 25th, 2019
|
|
|
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
|
31
|
|
|
|
|
|