My Oracle Support Banner

SQL Developer On Windows Terminal Server - Too Many Tnsping Connections During Startup (Doc ID 3002456.1)

Last updated on FEBRUARY 19, 2024

Applies to:

Oracle SQL Developer - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

SQL Developer is used on Windows Terminal Server app. Since multiple users use the same application, but different profile is created under %APPDATA%, it is observed huge TNSPING is occuring from SQL Developer to the database.

Due to the controlled TCP ports that are limited to the OS, the connection to the database failes when reaching the threshold due to multiple TNSPING from SQL Developer.

Changes

 Using SQL Developer as Windows Terminal Server app and disabled the startup page using below steps

1. Select "Help" -> "Start Page"
2. Scroll to the bottom of the page and uncheck "Show on Startup".

Document 2874810.1 SQL Developer IS Slow To Startup On Some Computers

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.