Re: Time out error

Hello,

You could increase value for parameter CONNECT_TIMEOUT_LISTENER in listener.ora to 30 seconds or more. eg: Add a line CONNECT_TIMEOUT_LISTENER=30
to your listener.ora file.

If the error still occurs get client and listener trace at level 16. Listener trace can be obtained as follows : Listener tracing can ONLY be configured in the listener.ora file. Add the lines below to the listener.ora file:

    trace_level_listener=16
    trace_file_listener=listener
    trace_directory_listener=/xxx

This will define FULL listener tracing to the file /xxx/listener.trc. You can enable this tracing by either:
lsnrctl reload OR (lsnrctl stop followed by lsnrctl start)

I think one needs to set similar parameters in sqlnet.ora on the client side.

Regards
Bhooshan

"sriram" <sriram.ck_at_sisl.co.in> wrote in message news:<aaqn2k$2fc$1_at_news.mch.sbs.de>...
> Dear all,
>
> My application uses ADO thru VC++ to connect to Oracle 8i.
> In worst cases if the oracle server is in different domain of Win NT and
> the client application is in different domain or if the network is slow (10
> MBPS or less), I randomly get a 'Connection Time out' error from oracle,
> while executing SQL statements from the client application.
>
> Is there anyway I can configure the 'Connection Time Out' to me much more in
> such cases ?? if so where should I do ?
> Or how should I handle this situation ?
>
> Thanks in advance.
>
> Cheers,
> Sriram C.K
Received on Thu May 02 2002 - 06:28:27 CDT