Softpanorama

May the source be with you, but remember the KISS principle ;-)
Home Switchboard Unix Administration Red Hat TCP/IP Networks Neoliberalism Toxic Managers
(slightly skeptical) Educational society promoting "Back to basics" movement against IT overcomplexity and  bastardization of classic Unix

Removing HPOM nodes

News HPOM agents Recommended Links opcnode command Adding nodes Deinstallation of agent Troubleshooting
        History Humor Etc

The HP recommended way to delete a node in HPOM:

When using command ./opc_inst.sh -r to remove agent make sure that you on the target node not on HPOM server. Otherwise you inflict of yourself a lot of troubles

Top Visited
Switchboard
Latest
Past week
Past month

NEWS CONTENTS

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!) :

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 quotesSomerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose BierceBernard 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 DOSProgramming Languages History : PL/1 : Simula 67 : C : History of GCC developmentScripting 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-MonthHow 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


Copyright © 1996-2021 by Softpanorama Society. www.softpanorama.org was initially created as a service to the (now defunct) UN Sustainable Development Networking Programme (SDNP) without any remuneration. This document is an industrial compilation designed and created exclusively for educational use and is distributed under the Softpanorama Content License. Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.

FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available to advance understanding of computer science, IT technology, economic, scientific, and social issues. We believe this constitutes a 'fair use' of any such copyrighted material as provided by section 107 of the US Copyright Law according to which such material can be distributed without profit exclusively for research and educational purposes.

This is a Spartan WHYFF (We Help You For Free) site written by people for whom English is not a native language. Grammar and spelling errors should be expected. The site contain some broken links as it develops like a living tree...

You can use PayPal to to buy a cup of coffee for authors of this site

Disclaimer:

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