Re: What causes ORA-12547: TNS:lost contact ?

On Fri, 28 Jul 2006 11:38:22 +0000, Stan Brown wrote:

> Last night on an instance that has been up for over 100 days, and on a
> machine with an uptime over 400 days (HP-UX 10.20 and Oracle 7.3.4.5.0,
> I started getting :
>

One of the more obtuse ones I'd seen with HP-UX 10.xx was ... so many instances 'up' that the system started hitting swap-related situations. That is, the swapping was so severe it the system was hitting an undiscovered boundary condition that *caused* corruption in the various SGAs and other intermittent inexplicable errors.

Of course, that only started happening when the customer installed the 13th instance on a 512M RAM machine.

The customer, and their primary consulting partner who advised them to install on that machine (and who also happened to be a major competitor to Oracle, but 'never had a conflict of interest'), hauled me on the carpet to explain why 'Oracle was corrupting their data'.

Since then, my primary advice on HP-UX 10 is: identify your *real* memory requirement and compare that to the actual RAM.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.