TNS: operation time out when trying to debug through vs2005 Server Explorer
537644Nov 4 2008 — edited Dec 4 2008using v110621 of ODP.net
I have a valid connection to a oracle 9i DB. if i set a breakpoint on a stored procedure then right click sp within server explorer and "Run debug"
the immeadite window states the following:-
PL/SQL Debugger starts.
PL/SQL Debugger is listening on port 49152.
The database cannot connect to the PL/SQL Debugger.
PL/SQL Debugger ends
i get the following popup error message
Server Explorer
An error occurred while executing the procedure/function:
ORA-30683: failure establishing connection to the debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
so im unsure what i need to be specifying where for the debugger to attach??
found this on cshays blog, but i still dont understand if its something i need to set locally or on the server?
http://cshay.blogspot.com/2006/10/debugging-plsql-from-aspnet-and-visual.html
Any help is greatly appreciated.
Cheers