Yes I discovered that as well. It also breaks a dblink to a base 11.2.0.4 database. So I have to patch all 11.2.0.4 databases. Looking at doing it this Friday. Jeff On Mon, Mar 16, 2015 at 4:28 AM, Lars Dohn <LDO@xxxxxx> wrote: > Hi Jess. > > > > Just a little warning : > > Patching your database to 11.2.0.4.14, breaks db link connections to > 11.2.0.4.10. > > 11.2.0.4.10 has been the most shitty patch ever done by oracle. > > > > ;-) Lars > > > > _____________ > > *Lars Dohn* > > *Oracle specialist* > > > > *Statistics Denmark* > > > *Sejrøgade 11 2100 København Ø* > > > > *Fra:* Lars Dohn > *Sendt:* 10. marts 2015 23:05 > *Til:* 'Jeff Chirco' > *Emne:* SV: 11.2.0.4.10 on Windows Memory Leak > > > > Just remember to put c:\windows\system32; in the PATH variable. > > Otherwise datapatch fails (just found out). > > > > Regards > > Lars > > > > _____________ > > *Lars Dohn* > > *Oracle specialist* > > > > *Statistics Denmark* > > > *Sejrøgade 11 2100 København Ø* > > > > *Fra:* Jeff Chirco [mailto:backseatdba@xxxxxxxxx <backseatdba@xxxxxxxxx>] > *Sendt:* 10. marts 2015 22:54 > *Til:* Lars Dohn > *Emne:* Re: 11.2.0.4.10 on Windows Memory Leak > > > > Gotcha. Yeah I ran into the dblink issue between a .10 database and my > test .14 database as well as a base 11.2.0.4 database and a 11.2.0.4.14. I > am planning updating all of them at the same time but luckily I only have 7 > to do. > > I haven't yet installed a 12c database but plan on setting one up this > year to play with. > > Jeff > > > > > > On Tue, Mar 10, 2015 at 3:24 AM, Lars Dohn <LDO@xxxxxx> wrote: > > Hi Jeff. > > > > I have +30 databases on 11.2.0.4.10 and need to patch to .14 due to the > connection issues between 11 and 12. > > > https://support.oracle.com/epmos/faces/DocumentDisplay?id=1970666.1&displayIndex=6 > > > > I can’t just patch up, need maintenance window. So I did a test restore on > another server. > > > > And I have ~5 databases on 12.1.0.2.0. > > When you patch to 12.1.0.2.1 or .2, you need to run “datapatch”. > > Catbundle has been deprecated, it does not do anything (exept some java). > > > > D:\>cd %ORACLE_HOME%\opatch > > D:\oracle\product\12.1.0.2\OPatch>datapatch > > SQL Patching tool version 12.2.0.0.0 on Tue Mar 10 08:32:59 2015 > > Copyright (c) 2014, Oracle. All rights reserved. > > > > Connecting to database...OK > > catcon: ALL catcon-related output will be written to > C:\Users\oracle\AppData\Local\Temp/sqlpatch_catcon__catcon_11476.lst > > catcon: See C:\Users\oracle\AppData\Local\Temp/sqlpatch_catcon_*.log files > for output generated by scripts > > catcon: See C:\Users\oracle\AppData\Local\Temp/sqlpatch_catcon__*.lst > files for spool files, if any > > open2: IO::Pipe: Can't spawn-NOWAIT: No such file or directory at > D:\oracle\product\12.1.0.2\\rdbms\admin/catcon.pm line 470 > > D:\oracle\product\12.1.0.2\OPatch> > > > > Don’t we just love unix-made perl scripts on windows J > > > > Regards > > Lars > > > > _____________ > > *Lars Dohn* > > *Oracle specialist* > > > > *Statistics Denmark* > > > *Sejrøgade 11 2100 København Ø* > > > > *Fra:* Jeff C [mailto:backseatdba@xxxxxxxxx] > *Sendt:* 6. marts 2015 17:44 > *Til:* Lars Dohn > *Cc:* oracle-l@xxxxxxxxxxxxx > > > *Emne:* Re: 11.2.0.4.10 on Windows Memory Leak > > > > Hi Lars, > > Why did you have to restore your database before you patched to 14? Or > was that just for testing? So are you now running 12c? > > I have not heard of "datapatch" > > > > On Thu, Mar 5, 2015 at 11:17 PM, Lars Dohn <LDO@xxxxxx> wrote: > > Hi Jeff. > > > > Confirmed too. > > I had a SR open for +3 month on this. > > > > Restored a 2TB 11.2.0.4.10 and patched it to 11.2.0.4.14. > > Created a 12.1.0.2.2 and used 16 parallel network connections to clone it > using impdp. > > Worked. > > > > By the way, can you run “datapatch” on windows ? > > I does not work on 12.1 se1 and 12.1 EE. > > > > Regards > > Lars Dohn > > > > _____________ > > *Lars Dohn* > > *Oracle specialist* > > > > *Statistics Denmark* > > > *Sejrøgade 11 2100 København Ø* > > > > *Fra:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > *På vegne af *Jeff C > *Sendt:* 6. marts 2015 00:09 > *Til:* Jithin Sarath > *Cc:* oracle-l@xxxxxxxxxxxxx; Paul Drake > *Emne:* Re: 11.2.0.4.10 on Windows Memory Leak > > > > Ok yeah I just got confirmation that there shouldn't be a dblink issues in > BP14 and it is my understanding that the memory leak issues has been > resolved in BP11 so 14 should be good to go. > > > > On Wed, Mar 4, 2015 at 9:04 PM, Jeff C <backseatdba@xxxxxxxxx> wrote: > > Wait are you saying the dblink bug is not an issue on BP14? And that the > memory leak is fixed? > > > > On Wed, Mar 4, 2015 at 6:21 PM, Jithin Sarath <jithinsarath@xxxxxxxxx> > wrote: > > On the dblink issue, we applied BP14 on a test ORacle home and opatch > lsinventory shows 18973907. SR confirmed that even though it is listed in > opatch output, the patch has been pulled out. > > On Mar 4, 2015 7:02 PM, "Jeff C" <backseatdba@xxxxxxxxx> wrote: > > I was just told through my SR that Bug 17890099 is not included in > 20502905 Patch 14. > > > > On Wed, Mar 4, 2015 at 8:21 AM, Paul Drake <bdbafh@xxxxxxxxx> wrote: > > Patch 20502905 is out but a quick check of the readme.HTML came up empty. > Researching further. > > On Mar 3, 2015 3:03 PM, "Jeff C" <backseatdba@xxxxxxxxx> wrote: > > The majority of you are probably not running on Windows but here is a > little PSA. Don't apply bundle patch 10 for 11.2.0.4 on Windows. There is a > major memory leak problem with it for the oracle.exe process. See Note > 1952786.1. In fact don't apply patch 10 -13 as there is also problems with > database links in 11-13. See note 1970666.1 > > I am waiting to see if patch 14 coming out soon will have the fix for > both. I am so frustrated with the lack of support and testing for systems > on Windows. > > > > > > > > > > >