Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trying to recreate OEM repository

RE: Trying to recreate OEM repository

From: Sweetser, Joe <Joe.Sweetser_at_infocrossing.com>
Date: Tue, 14 Nov 2006 16:37:10 -0700
Message-ID: <5CF4A34EE1FEA144B7474DC97E2F73A90165FD78@MAPI.iconnection.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Tuesday, November 14, 2006 3:53 PM To: Allen, Brandon; oracle-l_at_freelists.org 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_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
Received on Tue Nov 14 2006 - 17:37:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US