Metric collection error on storage cell Exadata

Run below on all db nodes from agent Home

emctl control agent runCollection xxxcel01.hxx.local:oracle_exadata Response
emctl control agent runCollection xxxcel02.hxx.local:oracle_exadata Response
emctl control agent runCollection xxxcel03.hxx.local:oracle_exadata Response
emctl control agent runCollection xxxcel04.hxx.local:oracle_exadata Response

Failed to execute_exadata_response.pl



Set up SSH connectivity by following Enterprise Manager Exadata Management Getting Started Guide, Chapter 8 Troubleshooting, Section 8.1 Establish SSH Connectivity.



Basically go to /home/oracle/.ssh on db node where agent home exists

see if id_dsa and id_dsa.pub exists

if not

ssh-keygen -t dsa -f id_dsa


The above commands will create those pub files

cat id_dsa.pub

copy the text for that particular node

for example

ssh-dss AAAAB3NzaC1kc3MAAACBAKoOgGt4Ewz9rbgDz6/ChbLJ+yMEmezgLvr/bbOp+UztDtpZiIP5NTKLNyn1kFdZpQCxxssdewdsdsjFyX+Qg6vWaMqnnqtvIgXMMHnv7omiMmg735PsBQYGP8xXRn8eUMv/2+gdInRiA9kysyZVJtMma7IFisZV4oTVSr8qwww0kafBAAAAFQCfDGhPXVVtZ/UEHZdhzgd9g5iJKQAAAIAZ0ZKbgXAzk4w1I5KsUEvhOiDYPh6idFp+J6Fe2lLYHmTCwkAPejSXDh3JWNEXuVU2zq58GaAJ+ta8Kb+ous819sZgRsgHNrcZ6n3aq+XrVgm3wpjdAp5R6dQ5CyDnuOIeNUFYKcQLSHlJ+LDV/UBoi0n6/UXx4+5RdBAe4y/ZWQAsssIB+pQocF+nsQjschcZThyJNNrOqM1Sj24+G/rAe/91jn/crgE3pRanvkWW/YkPE9Kpbqw5U84gH76Hv8jGwHwu55Q6iCsPdwC7iSxA0W7mU9YWuD+YIyBZ38qIarMbno56sGY4yfFRQNVgq/G0yL2h/K4qz3b/u6ihc5EZKAriV3w== oracle@xxx.hxx.local

Open the following location as root on the storage cell server

/home/cellmonitor/.ssh

see if authorized_keys file is present.

vi authorized_keys

Paste the above key from all the db servers and save it.

Once its done wait for some time and metric error will be gone on storage cells