Hi,
When I create connection in SQL Developer using Connection Type=Basic and SID (not Service Name) then everything is fine.https://i.stack.imgur.com/cvJz6.jpg
If only is the connection changed to use Basic+Service_Name or TNSNAMES then "funny" things start to happen.
"Funny" means that the connection works perfectly fine when running short statements (running less than 7 seconds). However, when the statement is longer then I get:
Error report - IO Error: An existing connection was forcibly closed by the remote host
Error report - 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
For example I have a large package to compile (ca. 330KB). Package definition compiles fine, but package body compiles only if not exceeding certain size (ca. 50KB of code and 7 seconds compilation time).
I'm using latest SQL Developer (19.2.1) and latest Java (11.0.5) connecting to 12.2 RDBMS with encryption and checksums in SQLNET.ORA on the server:
SQLNET.ENCRYPTION_SERVER = required SQLNET.ENCRYPTION_TYPES_SERVER = (AES256) SQLNET.CRYPTO_CHECKSUM_SERVER = required SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256, SHA1) SQLNET.ENCRYPTION_CLIENT = required SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256) SQLNET.CRYPTO_CHECKSUM_CLIENT = required SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256, SHA1)
Does anyone have any clue what I'm experiencing here?
SQ
LNET.ORA on the server:
SQLNET.ENCRYPTION_SERVER = required SQLNET.ENCRYPTION_TYPES_SERVER = (AES256) SQLNET.CRYPTO_CHECKSUM_SERVER = required SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256, SHA1) SQLNET.ENCRYPTION_CLIENT = required SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256) SQLNET.CRYPTO_CHECKSUM_CLIENT = required SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256, SHA1)