Re: 11.2.0.4.10 on Windows Memory Leak

  • From: Jeff Chirco <backseatdba@xxxxxxxxx>
  • To: Lars Dohn <LDO@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Mar 2015 11:32:20 -0700

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.
>
>
>
>
>
>
>
>
>
>
>

Other related posts: