How does one create a repository?

For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

  • Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space.

  • Create an Oracle user who would own this repository. Assign DBA, SNMPAgent, Exp_Full_database, Imp_Full_database roles to this user. Lets
    call this user Dummy_user. Assign Dummy_Space as the default tablespace.

  • Create an operating system user with the same name as the Oracle username. I.e. Dummy_User. Add `Log on as a batch job' under advanced
    rights in User manager.

  • Fire up Enterprise manager and log in as Dummy_User and enter the password. This would trigger the creation of the repository. From now on,
    Enterprise manager is ready to accept jobs.