Re: RAC patch 10.2.0.4 with lib/lib32/bin differences
From: Martin Bach <development_at_the-playground.de>
Date: Wed, 02 Apr 2008 19:53:23 +0200
Message-ID: <47F3C813.9030809@the-playground.de>
>
> Please have another look on my post:
>
> Clarification: There has been no single error or warning message, all
> went optically perfectly well.
>
> In the meantime, we are experiencing problems we did not have in
> 10.2.0.3: Using a DB link from this RAC to other databases out ouf
> php5/oci application, causing truble when using SELECT * FROM clauses.
> Queries with dedicated filed lists are not affected. Using SQL*PLUS
> avoids this.
> SELECT* FROM does not cause trouble for local objects.
> I am stumped.
>
> Regards
> Martin Klier
Date: Wed, 02 Apr 2008 19:53:23 +0200
Message-ID: <47F3C813.9030809@the-playground.de>
Hi Martin!
I realised I had forgotten that you mentioned the OUI logfile when I clicked on the send button.
I have since then applied patch 10.2.0.4 on a 32 bit SE RAC installation and compared $ORACLE_HOME/lib, $ORACLE_HOME/bin on both hosts. I also checked some directories in the cluterware home. All libraries and binaries except for a few (8) xxxO binaries which are generated as backups have identical sizes and timestamps, but again, that's been the Linux 32bit patch. Sorry but I can't be of more help.
Just out of curiosity: you don't have another Oracle software release on the same machine?
Best regards,
Martin
Martin Klier wrote:
> Hi Martin,
>
> Martin Bach schrieb:
>> Did the propagation fail for CRS _and_ the database/asm or was it >> limited to either of the two? Is there any indication of problems in the >> OUI log? Sometimes time differences on the nodes can cause issues.
>
> Please have another look on my post:
>>> recently I patched one of my 2-node-RACs on Linux x86_64 10.2.0.3 to >>> 10.2.0.4. The patch on Node1 and the propagating of the patch to Node2 >>> did not show any error, as well as the DB instance patching script (does >>> not matter for this case).
>
> Clarification: There has been no single error or warning message, all
> went optically perfectly well.
>
> In the meantime, we are experiencing problems we did not have in
> 10.2.0.3: Using a DB link from this RAC to other databases out ouf
> php5/oci application, causing truble when using SELECT * FROM clauses.
> Queries with dedicated filed lists are not affected. Using SQL*PLUS
> avoids this.
> SELECT* FROM does not cause trouble for local objects.
> I am stumped.
>
> Regards
> Martin Klier
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 02 2008 - 12:53:23 CDT