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


10 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
  6. Call Clavon Showflat Hotline @ +65 6100 9266 / 90261759 for Showflat Appointment, Clavon Showroom Location, Price, Floor plans, E-brochure, VVIP Discount & Site Plans. Clavon Showroom

    ReplyDelete
  7. Thanks a lot for sharing a great blog I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more keep going on it helped me a lot I have gained a lot of knowledge by reading your blog.

    Oracle SOA Training
    Oracle SOA 12c Training
    Oracle soa online training
    Oracle soa course
    oracle soa suite training

    ReplyDelete



  8. Thanks a lot for sharing a great blog I was just browsing through the internet looking for Oracle SOA and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information blogs about Oracle SOA at Oracle SOA Blogs . Bookmarked this page, will come back for more keep going on it helped me a lot I have gained a lot of knowledge by reading your blog.Oracle SOA Training

    ReplyDelete
  9. Great Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...