Removing HPOM nodes

The HP recommended way to delete a node in HPOM:

• Modify all policies that reference the node that you will delete.
  
• Delete applications that reference the node that you will delete.
  
• Acknowledge all messages for the node you will delete. You can use command to acknowledge

  opcack -s

• Use the Admin GUI to delete the node.
  
• Perform a history download: /opt/OV/bin/OpC/opchistdwn -older 0s -node nodename
  
• Run the Node Reference report (in the GUI: Actions -> Utilities -> reports) and check if there are any references still remaining for the node: delete them if they exist.
  
• Remove node from OPC datadate

  #opcnode -del_node node_name=< node name > net_type=NETWORK_IP

• Remove agent from the node, if necessary using the command

  /opt/OV/bin/OpC/install/opc_inst.sh -r  

NEWS CONTENTS

• 20120203 : How to delete the nodes no longer used from the HPOM Database. ( Feb 03, 2012 )
• 20120202 : Removal of node from HPOM ( Removal of node from HPOM, Feb 02, 2012 )
• 20120202 : IT Resource Center forums - Changed Node Names - This thread has been closed ( IT Resource Center forums - Changed Node Names - This thread has been closed, )

Old News ;-)

[Feb 03, 2012] How to delete the nodes no longer used from the HPOM Database.

Old, use with caution

Here is the procedure:

The correct and HP supported way for deleting a node from within ITO is as follows:

1. Modify all templates that reference the node that will be deleted.
2. Delete applications that reference the node that will be deleted.
3. Acknowledge all messages for the node that will be deleted.

   Note: When deleting this node, also acknowledge the messages, but only if the messages are not matched by an

   external node.

4. Use the GUI to delete the node.
5. Perform a history download:

   /opt/OV/bin/OpC/opchistdwn -older 0s -file 

6. Call the 'opcdbidx' utility to remove unused opc_node_names entries:

   /opt/OV/bin/OpC/opcdbidx -orphan

   Check to see if the 'opc_node_names' entry still exists. If the 'opc_node_names' entry does not exist:

A. Add the node again.

B. Repeat procedure.

C. Check for applications and templates.

Here is a list of the tables that could still contain entries for deleted nodes (Verify the accuracy of the table names in "Reporting and Database Schema " and/or "Database Entity Relationship Diagrams" before proceeding!) :

• opc_op.opc_node_names
• opc_op.opc_nodehier_layout
• opc_op.opc_nodes
• opc_op.opc_nodes_in_group
• opc_op.opc_node_config

Below is how one would go about the SQL statements if the entries were to be removed manually.

This is an unsupported procedure, back up the Database as inconsistencies can result from these statements!

Please talk with a DBA before proceeding!

******************

FIRST EXAMPLE

******************

In this example, the node "nodename.domain.com" will manually be removed from the DB:

===============================================

1- FIND THE NODE ID for nodename.domain.com :

===============================================

SQL> select node_id,node_name from opc_op.opc_node_names

2 where node_name ='nodename.domain.com';

NODE_ID

--------------

NODE_NAME

--------------

d0d51180-6965-71d4-172b-0f11bb100000

nodename.domain.com

===============================================

2-DELETE the references from the tables :

===============================================

SQL> delete from opc_op.opc_node_names

2 where node_id like 'd0d51180-6965-71d4-172b-0f11bb100000'

3 ;

1 row deleted.

SQL> delete from opc_op.opc_nodehier_layout

2 where node_id like 'd0d51180-6965-71d4-172b-0f11bb100000'

3 ;

2 rows deleted.

SQL>

SQL> delete from opc_op.opc_nodes

2 where node_id like 'd0d51180-6965-71d4-172b-0f11bb100000'

3 ;

1 row deleted.

SQL>

SQL> delete from opc_op.opc_nodes_in_group

2 where node_id like 'd0d51180-6965-71d4-172b-0f11bb100000'

3 ;

0 rows deleted.

SQL> delete from opc_op.opc_node_config

2 where node_id like 'd0d51180-6965-71d4-172b-0f11bb100000'

3 ;

0 rows deleted.

**************

SECOND EXAMPLE

**************

In this example, the node "node_name1" will be removed from the DB:

===============================================

HERE ARE THE COMMANDS TYPED

===============================================

select node_id,node_name from opc_op.opc_node_names

where node_name like 'node_name1%';

delete from opc_op.opc_node_names where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f11bb100000';

delete from opc_op.opc_nodehier_layout where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f11bb100000';

delete from opc_op.opc_nodes where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f11bb100000';

delete from opc_op.opc_nodes_in_group where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f11bb100000';

delete from opc_op.opc_node_config where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f11bb100000';

===============================================

HERE IS THE COMPLETE OUTPUT

===============================================

SQL*Plus: Release 8.0.5.0.0 - Production on Wed Jun 6 14:55:40 2001

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connected to:

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production

With the Partitioning and Objects options

PL/SQL Release 8.0.5.0.0 - Production

SQL> select node_id,node_name from opc_op.opc_node_names

2 where node_name like 'node_name1%';

NODE_ID

------------------------------------

NODE_NAME

----------------------------------------------------------------------------

----

6a5fcf64-50dc-71d3-1fcf-0f11bb100000

node_name1.atl.hp.com

SQL> delete from opc_op.opc_node_names where node_id like

'6a5fcf64-50dc-71d3-1f

cf-0f11bb100000';

1 row deleted.

SQL> delete from opc_op.opc_nodehier_layout where node_id like

'6a5fcf64-50dc-71

d3-1fcf-0f11bb100000';

2 rows deleted.

SQL> delete from opc_op.opc_nodes where node_id like

'6a5fcf64-50dc-71d3-1fcf-0f

11bb100000';

1 row deleted.

SQL> delete from opc_op.opc_nodes_in_group where node_id like

'6a5fcf64-50dc-71d

3-1fcf-0f11bb100000';

0 rows deleted.

SQL> delete from opc_op.opc_node_config where node_id like

'6a5fcf64-50dc-71d3-1

fcf-0f11bb100000';

0 rows deleted.

SQL>exit

[Feb 02, 2012] Removal of node from HPOM

Today, I am going to post how to remove a node from HPOM monitoring

A. On Managed node
1. If PATH environment variable is not set, navigate to below path
UNIX :

/opt/OV/bin/OpC/install										

2. Execute manual removal command

#./opc_inst.sh -r   

3. Once removed, you can delete the HP OpenView directory, if needed.

B. On Management server

1. Acknowledge all active messages related to the node either by Java or Motif GUI.
You can also use command to acknowledge

opcack -s

Input will be prompted against number of options like severity, application, object, node name. You can give node name against node name/server name option.

It will prompt for confirmation. Once confirmed, it will acknowledge all the active messages related to that node and will synchronise all running GUIs.

Note: Acknowledgement may take few minutes, depending upon number of messages to be acknowledged.

2. Download all history messages related to the node.

opchistdwn -older 0s -node node_name -file file_name

where 0s denoting zero seconds, < node name > is the name of node, < file name > is the name of the file with path, where downloaded messages need to be kept.

3. Remove the node from HPOM database

opcnode -del_node node_name=node_name  net_type=NETWORK_IP

4. If node is present if /etc/hosts you can either comment the node out or delete the corresponding line.

IT Resource Center forums - Changed Node Names - This thread has been closed

Etc

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotes :  Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce :  Bernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOS :  Programming Languages History : PL/1 : Simula 67 : C : History of GCC development :  Scripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-Month :  How to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Last modified: March 12, 2019