Document ID:        45279.1
Subject:            Initialising the Repository for Oracle Intelligent Agent
Last Modified:      15 Apr 97 
Author:             ASHRIVES


Initialising the Repository
~~~~~~~~~~~~~~~~~~~~~~~~~~~

The repository maintained for Oracle Enterprise Manager is itself an Oracle 
database. The repository must be an Oracle 7.3 database. 

To set up the repository, create the database (ie as you would any normal
database) and do the following steps.

1.  Create a repository owner  (usually named sysman)

    In sqldba/svrmgr:

       CREATE USER username IDENTIFIED by password;

2.  Grant the user dba privileges

    In sqldba/svrmgr: 
  
       GRANT DBA TO username;

3.  Connect as the user created in 1. and run the following scripts:

    a. SMPCRE.SQL
    b. PERFCRE.SQL

    The first script creates the necessary views for the Enterprise Manager
    Applications. 

    The second script creates the views for the Enterprise Manager
    performance pack. Run the second script only if you are licensed for the 
    performance pack. 
   
    These scripts do NOT come on the server installation.
    Look in the c:\orawin95\SYSMAN\ADMIN folder (on the console where
    you installed Enterprise Manager) for these scripts.