oacle connection

Posted on 2008-10-21
Medium Priority
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.
Question by:EE_Navigator

Expert Comment

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.


Accepted Solution

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


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.)

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 patchset release. The workaround is to set SQLNET.EXPIRE_TIME = 0 or remove it from sqlnet.ora


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

621 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