Not able to upload to em grid oms repository from agents

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Not able to upload to em grid oms repository from agents





./emctl upload agent Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0. Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD upload error: Failed to upload file B0000214.xml: HTTP error. Response received: ERROR-400|ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error ORA-06512: at "SYSMAN.EM_POLICY", line 2176 ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 791 ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'


Log files:
emoms.trc
010-07-22 13:19:52,415 Thread-464 ERROR upload: Failed to upload file B0000214.xml: HTTP error.
Response received: ERROR-400|ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at "SYSMAN.EM_POLICY", line 2176
ORA-06512: at "SYSMAN.EM_VIOLATION_CHECKS", line 791
ORA-04088: error during execution of trigger 'SYSMAN.EM_VIOLATION_CHECKS'

Solution:



Hanging policy upload int he repository
Remove the hanging policy manually

1. Check if you have Patch 8538082 installed for your Grid Control.
This patch is also part of the PSU patchsets.
Please see:
Note.1139563.1 Ext/Pub 10.2.0.5.4 Grid Control Patch Set Update (PSU) for the newest patchset.

2. 1. Stop the OMS: emctl stop oms

2. Update the <>/sysman/config/emoms.properties for the OMS(s) and add the following line:
em.loader.enableMetadataCache=FALSE

3. Login as user sysman with sqlplus and run:
SELECT DISTINCT target_type, START_TYPE_META_VER
FROM mgmt_policies
WHERE POLICY_GUID = HEXTORAW('C733EA1CFA96377F492528E305462C9D');

with the data from the last query run:
DELETE FROM mgmt_metadata_sets
WHERE where table_name='MGMT_POLICIES'
AND target_type=
AND type_meta_ver=

4. Start the OMS: emctl start oms

5. execute the following fro the agent:
stop the agent
rm the file /sysman/emd/lastupld.xml
start the agent
emctl upload




References:

Note.1139563.1 Ext/Pub 10.2.0.5.4 Grid Control Patch Set Update

Get Oracle Certifications for all Exams
Free Online Exams.com