Recreate Enterprise Manager Repository

16 Sep

This is useful if you have problems with accessing the Enterprise manager repository through dbconsole (and not through the grid).

set ORACLE_SID=XXX

emca -config dbcontrol db -repos recreate

If you have trouble – restart the server and try the above command again

Some useful thread:

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28viewingMode=1143&bmDocTitle=EMCA%20Fails%20With%20Error%20%27ORA-01031:%20insufficient%20privileges%27%20When%20Database%20Password%20File%20Is%20Not%20Configured&bmDocID=358201.1&from=BOOKMARK&bmDocType=PROBLEM&bmDocDsrc=KB%29%29

http://forums.oracle.com/forums/thread.jspa?threadID=1055904

http://kr.forums.oracle.com/forums/thread.jspa?threadID=903111

http://www.articles.freemegazone.com/oracle-sysman-account-locked.php?ref=2 (reset sysman password)

http://how-to.wikia.com/wiki/Oracle_HOWTO:_create_Enterprise_Manager_repository_on_Windows

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: