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


34 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
  10. shit website too many ads / popups

    ReplyDelete
  11. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. 11 best freelance hire mobile application developer

    ReplyDelete
  12. This valuable appear to be most certainly good. Those very tiny facts are designed implementing a wide variety for experience know-how. That i love the reasoning behind a lot. Smart contract software chennai

    ReplyDelete
  13. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.
    Custom MLM Software jaipur

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. Very good article.Thanks For Sharing!!!Wonderful blog & good post.Its really helpful to me. Once Visit this site and I damn sure you don't miss this opportunity.
    Devops training in Bangalore
    Devops Course in Bangalore

    ReplyDelete
  16. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article..
    TOP MLM Software hyedrabad

    ReplyDelete
  17. you guys are just amazing.. really thank you so much for this kind of valuable content in such a free and easy way.. Always a fan.
    Intelligence is the computational part of the ability to achieve goals in the world. Varying kinds and degrees of intelligence occur in people, many animals and some machines.
    AI Training in Bangalore

    AI Course in Bangalore

    ReplyDelete
  18. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp great deal more around this condition
    Java Training in Bangalore

    Java Course in Bangalore

    ReplyDelete
  19. your post is very good i am empresd.so thankyou so much for your sharing..Smart contract development company mirzapur

    ReplyDelete
  20. Great Post…This Article is very unique. Thanks for sharing and very informative!!!MLM Software Development Company Mumbai

    ReplyDelete
  21. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.
    Ethereum Token Smart Contract Developer in Delhi0

    ReplyDelete
  22. I have been impressed after read this because of some quality work and informative thoughts. I just want to say thanks for the writer and wish you all the best for coming! Your exuberance is refreshing. free porn xxx

    ReplyDelete
  23. Hi,

    Does this solution apply to SQL Developer version 17?

    Thanks

    Jon

    ReplyDelete
  24. Great Post…This Article is very unique. Thanks for sharing and very informative!!gupt rog in Allahabad

    ReplyDelete
  25. fantastic artical.thanks for a sharing and i read this blog..gupt rog doctors in allahabad

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