Executing SQL Query/Script Raises Error 'Protocol Violation' for DBLinks (Doc ID 2665951.1)

Last updated on SEPTEMBER 28, 2020

Applies to:

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

Symptoms

Execute SQL statement querying the database VIEW with a large set of data, expect to have resulted in the "Query Result" tab.

Scrolling through the results sets(by Default 50 rows is displayed) shows below error.

Followed by Database Connection reset.

Changes

Database upgraded to 12.2.0.1 and SQL using DB links to connect to another database.

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

Execute SQL statement querying the database VIEW with a large set of data, expect to have resulted in the "Query Result" tab.

Scrolling through the results sets(by Default 50 rows is displayed) shows below error.

Followed by Database Connection reset.

Database upgraded to 12.2.0.1 and SQL using DB links to connect to another database.

Multiple Oracle Client Installation exists in the Client Machine and incompatible drivers(ojdbc7.jar) used by default for java.library.path when SQL Developer initiated.

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