350.000 Alarms in Prime Infrastructure

At a recent project at a customer I noticed that the customer didn’t handle their alarms in Cisco Prime Infrastructure as there were to many.

The customer had enabled all categories and wasn’t using auto-clear. The result: 354.177 Alarms in the alarm view. Must I say that the PI was a bit slow?

The customer asked me if we could delete all the alarms and start over. Deleting alarms from the GUI can be done in 500 at a time and was not an option.

The solution? Delete directly from the database.

Disclaimer: Don’t try this at home! Touching the Prime Infrastructure database might kill your Prime Infrastructure.

First of all: You administrator user must be named admin. If not you can’t do sudo su -.

//Enter Password twice//

Enter shell access password :

// We will need to be root //
ade# sudo su -


// We need the database password //
ade # /opt/CSCOlumos/bin/getDatabaseParams.sh 

// We need Oracle env //
ade # su - oracle
[oracle@xxxxxxxx01v ~]$ source oracleenv

// Lets connect to the DB //
[oracle@xxxxxxxx01v ~]$sqlplus wcsdba/bbTkkfj299dkf

SQL*Plus: Release Production on Fri Feb 12 10:36:34 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

// Lets delete all alarms //

SQL>delete from alarm;

351911 rows deleted


Disconnected from Oracle Database 11g Enterprise Edition Release - 64bit Production




One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s