And now looking "back" one more log file, I see the same error I'm getting in there, too. I have now tried Note:278100.1, emca, and the RepManager script. All have the same result. I have opened an SR with Oracle but would still appreciate any ideas. I also tried to stop and drop the queue that exists but the database sez it doesn't exist. Sigh, -joe ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sweetser, Joe Sent: Tuesday, November 14, 2006 3:53 PM To: Allen, Brandon; oracle-l@xxxxxxxxxxxxx Subject: RE: Trying to recreate OEM repository Yes. I got the following error in the log file and that is why I went to the more brute force method. Truth be known, this database was inherited and has had OEM issues from the get go. -joe Check if repos user already exists. old 6: WHERE username=UPPER('&EM_REPOS_USER'); new 6: WHERE username=UPPER('SYSMAN'); old 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN new 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN old 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..'); new 11: raise_application_error(-20000, 'SYSMAN does not exists..'); old 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN new 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN old 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..'); new 17: raise_application_error(-20001, 'SYSMAN already exists..'); old 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE'); new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS'); DECLARE * ERROR at line 1: ORA-20001: SYSMAN already exists.. ORA-06512: at line 17 > -----Original Message----- > From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx] > Sent: Tuesday, November 14, 2006 3:49 PM > To: Sweetser, Joe; oracle-l@xxxxxxxxxxxxx > Subject: RE: Trying to recreate OEM repository > > Did you try doing it with emca, e.g. per Metalink 330976.1: > > emca -config dbcontrol db -repos recreate > > Regards, > Brandon > > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do > not consent to Internet email for messages of this kind. Opinions, > conclusions and other information in this message that do not relate to > the official business of this company shall be understood as neither given > nor endorsed by it.