Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2962
  • Last Modified:

Timing out problem on the client

I have installed Oracle 8i standard edition (8.1.7) on
a WINDOWS NT Server.

I have also installed oracle client software on a client.

Although I can connect to the database on the server on quite a few occasions I am getting timing out problems
on entering user id /password either in DBA Studio or SQL*Plus userid/password sign-on screen.

I need to resolve this. Would appreciate if anybody can help me. Thanks

Regards
Makarand
0
mlelej
Asked:
mlelej
1 Solution
 
dbalaskiCommented:
Hi,


This is usually caused by the server having a timeout too short for the connection to complete.
The parameter is set on the server's listener.ora file

CONNECT_TIMEOUT
Purpose: Determines the amount of time in seconds the listener waits for a valid connection request after a connection has been   started.   The complete handshaking between the server & client must complete before the Default has been reached (default is   10 seconds )  otherwise the  listener drops the connection if the timeout is reached.
if you set it to zero,  ie:
CONNECT_TIMEOUT_LISTENER = 0

this tells the listener wait and never timeout..


Hope this helps,
sincerely,
dBalaski

0
 
mlelejAuthor Commented:
I have tried what you said

Edited the listener.ora file sitting in
d:\oracle\ora81\network\admin directory and added the line
CONNECT_TIMEOUT_LISTENER = 0 at the end. Saved the file.

I then stop and restarted the ORACLETNSLISTNER service.

I then checked my client - it still gives me timeout
adhoc.

Any further clues??

Regards
Makarand

0
 
dbalaskiCommented:
Can you post up example error messages you are getting
(cut & paste)??

THis would be a little more helpful.

sincerely
dB
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
WadhwaCommented:
May be you are getting the error beacuse of profile attached with user having idle time. Exact massage will help us to solve the problem

Sam
0
 
mlelejAuthor Commented:
Guys,

I sorted the problem. I replaced the server name in tnsnames.ora with the ip address of the server and that has made real difference in terms of connectivity.

So far; this morning no timing out problems.

Thanks for your help.

Regards
Makarand
0
 
MindphaserCommented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now