Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ORA-30683, Oracle Error
murugu
post Apr 16 2012, 09:11 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 18-August 11
Member No.: 45,740



Hi All,

I tried to debug the procedure in Oracle SQL Developer and got the below error,

Connecting to the database TEST.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '****', '4000' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database TEST.

Here,

TEST is my database name,
**** is IP address of my local machine
4000 is the port number, also I have set the debug port range as 4000 - 4999 in SQL DEVELOPER.
firewall is not enabled in my machine.

Kindly help me to fix this issue.

Thanks in Advance.

Go to the top of the page
 
+Quote Post
burleson
post Apr 16 2012, 02:11 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,623
Joined: 26-January 04
Member No.: 13



Hi Murugu,


I made this page just for your question:

http://www.dba-oracle.com/t_ora_30683_fail...to_debugger.htm

Please let us know which option solves your problem.

ORA-30683: failure establishing connection to debugger
Cause: An error was indicated when trying to establish a connection to a debugger. Usually a TNS error will display along with this message to further explain the problem, although this TNS error will likely be hidden if you choose to trap the error.Action: Correct the indicated parameter value and try again.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
murugu
post Apr 21 2012, 12:51 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 18-August 11
Member No.: 45,740



Hi Burleson,

Thanks a lot for your reply. The issues has been fixed, the cause for the issue is network blocking and I have contacted the n/w team for the required changes in the security policy.

Regards,
Murugu
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th October 2014 - 07:17 PM