Print Thread
10.0.4: Export hangs if db goes down
#47261 06/10/13 02:56 PM
Joined: Feb 2007
Posts: 134
Bulgaria
braykov Offline OP
Member
OP Offline
Member
Joined: Feb 2007
Posts: 134
Bulgaria
I have the latest version - 10.0.4 of PLSQL Developer.
I started Extract User Objects, but in the middle of the process colleague restarted the database.
As a result PLSQLDEV shows it is extracting. It doesn't tell me there is a problem.
Also I cannot "Break" the process.
I cannot close the window, nor can I close the whole app.

Re: 10.0.4: Export hangs if db goes down
braykov #47269 06/11/13 09:21 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll check it out.


Marco Kalter
Allround Automations
Re: 10.0.4: Export hangs if db goes down
Marco Kalter #47274 06/11/13 01:48 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
I experience similar problems when the network link to the target system fails for some reason ( and not only for compare user objects) The only "way out" is to use the task manager to kill PLSD, of course by this loosing the unsaved window contents.

Re: 10.0.4: Export hangs if db goes down
Dezsoe Kados #47492 07/19/13 08:13 PM
Joined: Aug 2007
Posts: 53
Phoenix
J
Member
Offline
Member
J
Joined: Aug 2007
Posts: 53
Phoenix
I've had a similar problem. Check your TNS definition - if it has something like "(RETRIES = 180)(DELAY = 5)", it can be contributing to your issue. (Why Oracle seems to like "RETRIES = 180" is beyond me; this causes programs (like PL/SQL Developer) to retry 180 times (with a delay of 5 seconds) when there is a connection issue.)

180*5 means that connections will seem to hang for at least 15 minutes trying to communicate with Oracle. If you leave PL/SQL Developer sit for 20-40 minutes, it will eventually time out. (You can also try disconnecting the network connection on your PC, which seems to allow SQL*Net to give up without retrying the full 180 times.)

I've changed my TNS definitions to use RETRIES=2, and I no longer have this issue.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.079s Queries: 15 (0.043s) Memory: 2.5101 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-16 12:31:13 UTC
Valid HTML 5 and Valid CSS