Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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