Re: Effect of listener on existing connections?

<groups.broberg_at_gmail.com> wrote in message news:a8f8b4b1-adbb-4916-9b23-8d72f6d221ba_at_f36g2000hsa.googlegroups.com... Writes:

>> Oracle support is not giving us satisfactory results. Perhaps you can
>> give some answers?
>>
>> We've recently upgraded our system to Oracle 10.2.0.3.0, running on
>> Solaris (sparc) 10 inside a ZFS zone (our previous system was Oracle
>> 9.2.0.4.0 running on sparc Solaris 8, and was running on that for the
>> last 5 years). Since the upgrade 6 weeks ago, we've had two instances
>> where our applications (running in the same O/S environment on a
>> different node on the cluster) have locked up - existing connections
>> to Oracle become unresponsive when executing SQL (with no error
>> message - they just block), and attempts to create new connections are
>> met with the error:
>> "ORA-03135: connection lost contact".

How hard would it be to eliminate the zoning..? I dont think this is related nor ZFS but if you could test w/o these changes then youd know for sure.

I dont know why you would do this in the first place. Zones are appropriate for some things and you generally get better throughput from ZFS over UFS but zones just stir up the pot for me.

Dedicate the box(es) to Oracle only - dont even make a special project for it - just use default. Keep things simple as possible.

Maybe you have reasons for all this fancy overhead but so far I see none : > Received on Fri Jun 13 2008 - 21:32:52 CDT