Print Thread
Debugger hangs
#64803 09/25/23 07:33 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
I am using version 15.0.2.2054 of PL/SQL Developer
When I start the debugger to debug a procedure in a package the debugger appears to start, it says "executing" at the bottom, but none of the buttons are active. I can not step into procedure.
What PRIVS are required to run the debugger?
System hangs as well.. Only resolution is to kill PL/SQL Developer and restart it.

Last edited by dgs!; 09/25/23 07:39 PM.
Re: Debugger hangs
dgs! #64804 09/26/23 01:28 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
Member
Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Is it RAC DB?

Re: Debugger hangs
dgs! #64806 09/26/23 12:02 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
12c

Re: Debugger hangs
dgs! #64807 09/26/23 12:06 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
SQL> select* from v$version;

BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
PL/SQL Release 12.2.0.1.0 - Production 0
CORE 12.2.0.1.0 Production 0
TNS for Linux: Version 12.2.0.1.0 - Production 0
NLSRTL Version 12.2.0.1.0 - Production 0

Re: Debugger hangs
dgs! #64808 09/26/23 07:26 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
I had our DBA group issue DEBUG CONNECT SESSION to my Oracle User but that did not help

Re: Debugger hangs
dgs! #64813 09/27/23 07:12 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
Attached picture shows PL/SQL Developer attempting to debug a procedure. It says 'Executing" at the bottom, but none of the debug icons are active.

Attached Files
debug.jpg (36.41 KB, 44 downloads)
Re: Debugger hangs
dgs! #64819 10/02/23 11:59 AM
Joined: May 2007
Posts: 102
Tiel, The Netherlands
M
Member
Offline
Member
M
Joined: May 2007
Posts: 102
Tiel, The Netherlands
It is still not clear if your database is part of a RAC cluster. The description of the problem suggests this.

To be certain, can you run the following query and if this query returns more than one row your database is part of a RAC cluster:

select * from gv$instance;

Re: Debugger hangs
dgs! #64820 10/02/23 01:03 PM
Joined: Feb 2010
Posts: 129
Shallotte NC
dgs! Offline OP
Member
OP Offline
Member
Joined: Feb 2010
Posts: 129
Shallotte NC
Yes it is RAC. What do I need to do on a RAC system to get the debugger to work?

Re: Debugger hangs
dgs! #64822 10/03/23 12:19 PM
Joined: May 2007
Posts: 102
Tiel, The Netherlands
M
Member
Offline
Member
M
Joined: May 2007
Posts: 102
Tiel, The Netherlands
Ok, if you want to debug on a RAC cluster you have to make connection from the test/debug window in PL/SQL Developer to 1 node/service of the cluster. Which node does not matter.

To be able to connect to 1 specific node in a RAC cluster you have to use a connect string which specifies the instance name or have a DBA setup node specific services. So, e.g. in the tnsnames.ora file you need to have an entry that specifies the instance name via instance_name="name of the instance"


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.037s Queries: 16 (0.012s) Memory: 2.5323 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 01:52:53 UTC
Valid HTML 5 and Valid CSS