Re: Intermittent Oracle client errors

On 14 Oct 2005 11:50:09 -0700, "Oracle Pseudo DBA" <yoramayalon_at_gmail.com> wrote:

>i think you are being a bit unfair to me here. I have actually read the
>manuals plus googled quite a bit!
>
>this is not a firewall issue - all machines are behind a firewall and
>the nature of the problem is very sporadic. %99.99 of the time the
>clients are connecting OK. I took care in my original post to point
>this.
>
>the problem is quite recent and everything pointing to load-based. I
>had network people check the ports and switch and there are no errors
>on ther Ethernet/IP level.
>
>I realize neither you, or no one else, has ANY obligation to help me,
>but if you do answer you could read my post more carefully before
>blasting away.

 all machines are behind a firewall
so it is a firewall issue as sqlnet assigns random ports.

>but if you do answer you could read my post more carefully before
>blasting away.

Well I did read your post carefully, didn't I? Could you please a) look up the word 'random' in a dictionary b) trace your sessions, so you can verify what port numbers are really being used
and
c) apologize

--
Sybrand Bakker, Senior Oracle DBA