RefreshFromMetalink Job

Pra4444
Pra4444 used Ask the Experts™
on
I am trying to set up my test database (oracle version 10.2.0.1 on win server 2003) to download patches from metalink..
I went to setup and patching setup and configured the metalink username and password and thereafter i wanted to run the refreshfrommetalink job..but however while running this job i am getting this error...

Output Log
 
Checking Oracle MetaLink authorization.

 MetaLink Username: *********
 MetaLink Password: **********
  Patch Search URL: http://updates.oracle.com
 
Updating OEM repository with latest release table data from Oracle MetaLink.
 
 - Exception trying to access the repository. java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ARU_PRODUCTS"."PRODUCT_NAME" (actual: 59, maximum: 50)

 How should i fix this??

Thanks

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
ok..i logged on as sys in my database and went to the table MGMT_ARU_PRODUCTS and increase the column size of PRODUCT_NAME...
Now how do i get to the job that i created in the first place through enterprise manager grid control that failed???

Author

Commented:
I created a new job and tried again, however..i go a different error this time..
any ideas???

Updating OEM repository with latest release table data from Oracle MetaLink.
 
 - Exception trying to access the repository. java.sql.SQLException: ORA-02291: integrity constraint (SYSMAN.MGMT_ARU_PRD_RLS_RLS_FK) violated - parent key not found

 
 

Commented:
Well i was able to solve the issue..I downloaded the patchset to upgrade my test database to 10.2.0.4 and then tried running the RefreshFromMetalink job and it worked like a charm...so i would like this question to be closed !!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial