INSTALLATION DOCUMENTS BY RAVI

Friday, December 15, 2017

Steps for preventing Oracle SQL Developer sessions from being killed

In general when we leave the database connection opened for a while in oracle sql developer, It will throw a "connection timeout" message when we tried to run a query next time.
We have to reconnect the connection for running the query.

To keep the database connection alive in sql developer please follow the below steps:

For Oracle SQL Developer 3 Versions:


2. Copy the downloaded jar file to the below location


%SQLDEVELOPER_HOME%\sqldeveloper\extensions





















3. Open sql developer and right click on a connection and go to Keep-Alive and select Active




















4. Enter the user and password details of the connection if it is not already connected




















5. We will get a success keep alive message




















6. Now check again for the session time out issue.

For Oracle SQL Developer 4 Versions:

1. Navigate to %SQLDEVELOPER_HOME%\sqldeveloper\bin

2. Open sqldeveloper.conf file




















3. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.



























4. Open sqldeveloper-nondebug.conf file




















5. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.


























6. Open sql developer and connect to the database and check for session time out


6 comments:

  1. wow great Article, the details you have provided are much clear, easy to understand, if you post some more Article, it will be very much useful for me.
    PL/SQL Training in Chennai

    ReplyDelete
  2. Nice post keep do posting The Info was too good, for more information regarding the technology Click
    Amazon web Services Training
    Devops training

    ReplyDelete
  3. Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. pasaport çeşitleri

    ReplyDelete
  4. And indeed, Iím just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective Iíve had.
    Database Administration Training | Database Administration course in chennai | Database Administration Training in chennai

    ReplyDelete
  5. Are you a web developer? Then give a helping hand to your young ones. Let's grow the world knowledge. Head over to Thinkle Developers and help a seeker please.

    ReplyDelete

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...