Using Oracle Enterprise Manager Database Control, you can perform administrative tasks such as creating schema objects (tables, views, indexes, and so on), managing user security, managing database memory and storage, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database.

Here’s an example of how to rebuild the database control repository for myinstance.

Both configuration files and repository objects can be deleted using a single command

# su - oracle
% emca -deconfig dbcontrol db -repos drop
------------------------------ cut here ------------------------------
Database SID: myinstance
Listener port number: 1521
Password for SYS user: password
Password for SYSMAN user: password
------------------------------ cut here ------------------------------

Create the Database Control repository objects and configuration files

# su - oracle
% emca -config dbcontrol db -repos create	
------------------------------ cut here ------------------------------
Database SID: myinstance
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.3.0/dbhome_1 ]:
Password for SYS user: password
Password for DBSNMP user: password
Password for SYSMAN user: password
Email address for notifications (optional): user@domain.com
Outgoing Mail (SMTP) server for notifications (optional): localhost
------------------------------ cut here ------------------------------