OraFAQ Forum: Enterprise Manager » OEM Console Not Creating

Home » RDBMS Server » Enterprise Manager » OEM Console Not Creating

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OEM Console Not Creating [message #282208]

Wed, 21 November 2007 03:16

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

While creating Oracle Enterprise manager in 10g R3. I'm facing the following error message.

Before creating OEM i removed SYSMAN and MGMT_VIEW user. But now I'm facing the below error message.

Please advice me


Check if repos user already exists.

SP2-0310: unable to open file "&EM_SQL_ROOT/core/latest/admin/admin_check_repos_user.sql"

Create SYSMAN user.

SP2-0310: unable to open file "&EM_SQL_ROOT/core/latest/admin/admin_create_repos_user.sql"
BEGIN dbms_registry.loading('EM', 'Oracle Enterprise Manager', null, '&EM_REPOS_USER');
END;

*
ERROR at line 1:
ORA-39706: schema '&EM_REPOS_USER' not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REGISTRY", line 71
ORA-06512: at "SYS.DBMS_REGISTRY", line 406
ORA-06512: at line 1

Babu B

[Updated on: Wed, 21 November 2007 05:23]

Report message to a moderator

Re: OEM Console Not Creating [message #282224 is a reply to message #282208]

Wed, 21 November 2007 03:48

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Replace &EM_SQL_ROOT by its value.

By the way, what is 10gR3?

Regards
Michel

Report message to a moderator

Re: OEM Console Not Creating [message #282230 is a reply to message #282224]

Wed, 21 November 2007 03:54

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Replace &EM_SQL_ROOT by its value.

If i mention exact path. Asking some input's.

>>By the way, what is 10gR3?

Sorry, Mistakenly I mention 10gR3. I'm using only 10gR2.

Babu

[Updated on: Wed, 21 November 2007 03:56]

Report message to a moderator

Re: OEM Console Not Creating [message #282295 is a reply to message #282230]

Wed, 21 November 2007 06:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

Just now i analyzed both SQL file. As per manually created.

But still i can't able to create dbconsole.

Please advice me.

Babu

Report message to a moderator

Previous Topic:	Agent Grid Control on Rac Problem
Next Topic:	what is sysman default password?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 03:53:50 CDT 2024