Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017October26 - CleanUp > DPA errors when collecting plan information

DPA errors when collecting plan information

Overview

Some customers have experienced problems with the new Ignite Top Plans feature. The symptoms of the problems are errors in the Ignite error log similar to:

Error retrieving Plan Hashes for batch 1: ORA-12152: TNS:unable to send break message

Other errors may accompany this problem and trace files may also be generated.

Environment

All versions of DPA

Resolution

The workaround for this problem is to setup a logon trigger on the monitored database for the Ignite user to set a session level variable.

1. Pause the automatic monitor restart feature in the Ignite GUI. To do this, click the “Scheduler” button in the Ignite toolbar and change the “Repository Scheduling Status” setting to “Paused”.

2. Stop the Ignite monitor for the database

3. Log into the monitored database as SYSTEM (or some DBA user) and create the trigger with the code below.

4. Restart the monitor for the database and re-enable the automatic scheduler (opposite of Step 1).

Trigger Code

CREATE OR REPLACE TRIGGER ignite_logon_trg
AFTER LOGON ON DATABASE
BEGIN
IF UPPER(USER) = UPPER(‘&IgniteUser’) THEN
EXECUTE IMMEDIATE ‘ALTER SESSION SET “_cursor_plan_unparse_enabled” = FALSE’;
END IF;
END;
/

Cause

The cause of the problem is Oracle Bug 6356566 that affects STATSPACK and other tools along with Ignite.

 

Last modified

Tags

Classifications

Public