Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developper 21.4.1 gives IO error while 19.2.1.247 works fine same settings

JiF BrodeurJan 13 2022

Hi, while running on Windows 10(We tried three different Windows machine same issue), the most recent version of SQL Developer can't connect to a remote (on Oracle Cloud DB) database using SQL*Net port 1521.
Status : Failure -Test failed: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.
The exact same setting works fine on 19.2, btw same error on SQL Developer 21.2.1.
SQL Devloper 21.4.1 on macOS works fine on the same network.
Thanks
Jean-François Brodeur

Comments

60437
Answer
The workspace IDs in each database must be identical. The idea is that the host application be "the same" application in terms of its internal object IDs, its application ID, and the containing workspace ID. You can achieve this by exporting the workspace to a file and importing/installing it into the next database in order to prepare for the introduction of "copies of" applications and their components into the "copy of" the workspace.

Scott
Marked as Answer by 647472 · Sep 27 2020
1 - 1

Post Details

Added on Jan 13 2022
23 comments
4,237 views