Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Developer Connection to ADW Timeout

edited Jan 17, 2019 9:33AM in Autonomous Database 1 comment

Summary

SQL Developer 18.3, ADW, Connection Timeout

Content

SQL Developer 18.3 connection to ADW timeout with ORA-03113.

ADW instance with 4 OCPU and 1 TB storage.

When run a long-time query, the query will fail with following err info:

Status
DONE (ERROR) ORA-03113: 通信通道的文件结尾
Execution started
01/17/2019 08:55:19
Last refresh time
01/17/2019 09:00:14
Execution ID
83886080
User
ADMIN@HFNMYRXSOF57OIU_DBALEX20190117
Consumer group
HIGH
 
Then I changed the "Run Query run time"  from 0 to 1200 seconds
in Resource Management tab, the problem keeps the same.
Disable laptop firewall the problem keeps the same;
From ADW service console, the failed SQL run time duration
varies from 5 minutes to 11 minutes;
 

Any hints for this?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!