EMCA Fails with ORA-01034: ORACLE not available

Hi ,

When upgrading my Database from Oracle 10.2.0.1.0 to 10.2.0.3.0, after running Database Upgrade Assistant, I received the message that Database Control is not configured.


After searching a lot and trying many things which did not worked. I got the solution to this issue.The main reason for this issue is the database has not been cleaned up, need to do some cleaning activity in the database to get it working.

Solution:
Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management
objects:

SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;

Run the following $emca -deconfig dbcontrol db -repos drop
Run the following $emca -config dbcontrol db -repos create

After doing the following tasks it started without any issues.

Reference:
Metalink Note: 560666.1 Dbconsole Creation Fails with an 'ORA-01034: ORACLE not available

Cheers
Aashish