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_at_OneNeck.com]

> Sent: Tuesday, November 14, 2006 3:49 PM

> To: Sweetser, Joe; oracle-l_at_freelists.org

> 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.
 

--
http://www.freelists.org/webpage/oracle-l