Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
SQL Developer Connection to ADW Timeout — Cloud Customer Connect
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

Received Response
15
Views
1
Comments
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
[email protected]_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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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