Reinstalling DB control

[williey]

I get the following error when trying to reinstall DB Control.
Had to manually remove the below objects when a preview install failed.

drop user sysman cascade;
drop user mgmt_view cascade;
drop role mgmt_user;
Drop all public synonyms on repository objects

ERROR at line 1:
ORA-04063: package body "SYSMAN.MGMT_AUDIT_LOG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYSMAN.MGMT_AUDIT_LOG"

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[LKBrwnDBA]

Try:

emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[williey]

Tried to drop using

emca -deconfig dbcontrol db -repos drop

But I get the following error:

Could not connect to SYS/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=myoracle)(Port=1521))(CONNECT_DATA=(SID=TEST))): ORA-12621: Authentication service failed to initialize (DBD ERROR: OCIServerAttach)

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[williey]

Fixed the ORA-12641 error and trying the drop again.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[williey]

I still get the same error when I try to create the repository.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[williey]

I remember revoking some privileges from PUBLIC user.

After regranting the same privileges, I was able to create the repository. I wonder which of the below privileges is required for creating the repository.


REVOKE CREATE DATABASE LINK FROM connect;
REVOKE EXECUTE ON utl_tcp FROM public;
REVOKE EXECUTE ON utl_smtp FROM public;
REVOKE EXECUTE ON utl_http FROM public;
REVOKE EXECUTE ON utl_mail FROM public;
REVOKE EXECUTE ON utl_inaddr FROM public;
REVOKE EXECUTE ON utl_file FROM public;
REVOKE EXECUTE ON dbms_java FROm public;



------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[LKBrwnDBA]

Maybe the java or db link one?




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb