RE: Trying to recreate OEM repository

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.

Other related posts: