Oracle DBA – A lifelong learning experience

Agent Process metric errors on HP unix servers

Posted by John Hallas on January 7, 2009

Within Enterprise Manager a number of HP servers were showing Collection Failure errors on the Agent Process Metric. These were all Itanium but I understand that the issue also applies to PA-RISC chips

 

sh: ps: not found. sh: tail: not found. sh: ps: not found. Could not execute ps -ef -o ‘ppid pid vsz sz sz args’: at /app/oracle/product/gc10.2/agent10g/sysman/admin/scripts/emdprocesschars.pl line 210.

 

I was unable to find anything on Google or Metalink to help me answer the problem until I sent out a message to my fellow DBAs and I got two responses back. These were effectively the same thing  but the view was that it was better to change the emdprocessorschars.pl file as that was guaranteed to fix the issue whereas a profile setting might not be picked up

 

Stop the agent before the fix and restart it afterwards

 

FIX 1

 

Amend the .profile to add

 Export UNIX95=””

FIX 2

 

You need to edit /app/oracle/product/gc10.2/agent10g/sysman/admin/scripts/emdprocesschars.pl by changing: –

 # aaitghez 05/29/02 - Creation
#

$stat_offset=2;

sub countFileHandlesOfType {

 

To

 

# aaitghez 05/29/02 - Creation
#

$stat_offset=2;
$ENV{UNIX95} = “XPG4”;

sub countFileHandlesOfType {

 

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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: