Solved

oacle connection

Posted on 2008-10-21
2
339 Views
Last Modified: 2013-12-19
i am developing a web and desktop application which connects to the oracle database remotely. it connects ok. But gets disconnected very often with out error, both client and severs is windows 2003 currently.
0
Comment
Question by:EE_Navigator
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:divyeshhdoshi
ID: 22765568
increase connection timeout of connection object.

When u are executing query then check it is in open state
if Yes 1) Execute query
if No 2) Reopen connection and execute query.

0
 
LVL 2

Accepted Solution

by:
barfi earned 500 total points
ID: 22771930
I found this at following link:(I hope it helps)

http://www.dba-oracle.com/t_connect_time_idle_expire_timeout.htmT

he sqlnet.ora inbound_connect_timeout parameter
The sqlnet.ora inbound_connect_timeout parameter is used to limit the time, set in seconds, for a client to connect with the database server and provide the required authentication information.

As we have all seen with recent worm and virus attacks, unauthorized access to a system service such as the Listener or database server can result in denial-of-service attacks. In a denial-of-service attack, an unauthorized client attempts to block the authorized users ability to access the system. Malicious clients or hackers may attempt to flood the Listener or database server with bogus connect requests solely to consume resources, such as connections, processes, or threads.

To minimize the effect of denial-of-service attacks, you should configure limits that constrain the time in which resources can be held prior to authentication. In this way, client attempts to exceed the configured limits will result in connection terminations and an audit trail containing the IP address of the client being logged.

To limit consumption of Oracle 10gs resources by unauthorized users and enable an audit trail, you should set time-limit values for the sqlnet.inbound_connect_timeout parameter described previously. (This parameter does not have default values.)

Bugs
Bug (2441734) which is port-specific to Windows where setting SQLNET.EXPIRE_TIME wastes stack memory reducing the total number of connections which can be achieved. It is fixed in Oracle10i and included in the 9.2.0.3 patchset release. The workaround is to set SQLNET.EXPIRE_TIME = 0 or remove it from sqlnet.ora

0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question