Home » RDBMS Server » Enterprise Manager » OEM Console Not Creating
icon4.gif  OEM Console Not Creating [message #282208] Wed, 21 November 2007 03:16 Go to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
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
Re: OEM Console Not Creating [message #282230 is a reply to message #282224] Wed, 21 November 2007 03:54 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous message
babuknb
Messages: 1734
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

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


Current Time: Sat Dec 03 00:51:06 CST 2016

Total time taken to generate the page: 0.08501 seconds