Re: What's net got do with it

From: Bob Jones <email_at_me.not>
Date: Fri, 1 Feb 2008 20:38:43 -0600
Message-ID: <PIQoj.10109$>

"JMoo" <> wrote in message
> On Jan 29, 7:58 pm, "Bob Jones" <em..._at_me.not> wrote:
>> > I am somewhat familiar with the TNS stack. I have read through the
>> > documentation and can not find anything pertinent to my question. For
>> > example, the Oracle9i Net Services Administrator's Guide says:
>> > "The primary function of Oracle Net is to establish and maintain
>> > connections between a client application and an Oracle database
>> > server."
>> > But I am not calling FROM a client TO the database server. I am
>> > calling FROM the database server ( which is functioning as a client)
>> > to a NON TNS application, namely an apache web server.
>> > So, I'm still at a loss for why TNS should come into play when the
>> > target server knows nothing about TNS. Could it be that Oracle
>> > Network (TNS) is behaving as a proxy?
>> Your TNS error came from the client not the web server. The client did
>> not
>> receive a response after a specified amount of time.
> Bob,
> If I understand you correctly, when I give the HTTPURITYPE.createuri
> command, I am in essence telling Oracle Net to make an outbound HTTP
> connection. I'll buy that, but there is still something I don't
> understand which is ...
> why is it taking about 4 minutes to time out and what can I do to
> shorten the length of time. We need to have the timeout happen in
> about 5 seconds. Basically, if the Apache server is not reachable,
> wait 5 seconds, log the error, and move on. I thought that
> UTL_HTTP.set_transfer_timeout (5); would do that for me, but my
> experience shows me that it only works sometimes.
> My GUESS is that it goes like this:
> If connection to target server succeds, but target server does not
> reply THEN
> wait UTL_HTTP.set_transfer_timeout (5); and raise UTL_HTTP error
> connection does not succeed (i e. cant even find the server)
> wait some TNS defined interval and raise TNS time out error;
> If my above GUESS is true, then how can I make the TNS outbound HTTP
> connection time our more quickly?
> regards,
> Mike

I have never played with this before, but have you tried setting the timeout parameters in sqlnet.ora and listener.ora? Received on Fri Feb 01 2008 - 20:38:43 CST

Original text of this message