Setting up the Repository

Attention: You do not have to run an additional script to set up a separate repository for the Oracle Performance Pack. However, if you installed the Performance Pack after running the SMPCRE.SQL script, you need to run the SMPEVDRP.SQL script, followed by the SMPEVCRE.SQL script to install the predefined events. If you have already set up event registrations with the Event system of Oracle Enterprise Manager, the registrations will be deleted when you run the scripts.

A separate repository must be created for each user wishing to use Oracle Enterprise Manager. For this reason, the setup scripts must be run for each Console user account.

Note: Oracle Enterprise Manager requires unique usernames across all repositories whether or not the repositories are in different databases. Identical users can cause problems with agent notifications. The intelligent agents use the unique username when tracking jobs and events. The username is associated with the Console location when creating a return address for notifications.

Before running the setup script, an Oracle user account with the necessary permissions to access the repository tables and configuration files must exist in the database.

Attention: If you have installed the optional Oracle Performance Pack, see "Setting up Oracle Expert" for additional considerations for Oracle Expert.

Using a Local NT Database

1. Go to Control Panel->Services and verify that the OracleService is started

2. Startup the local NT Oracle database.

Creating the Repository

To set up the Oracle Enterprise Manager repository:

1. Double-click on the SQL Worksheet icon in the Oracle Enterprise Manager program group.

2. Use the Login Information box to connect to the database that will be used as the repository. You also need to log to the user account where you want to create the repository. This account will be used when logging into Enterprise Manager. The user must be granted the same privileges as the user SYSTEM. For information on using the Login Information box, see "Login Information" .

1. 2.1 If you already have created a valid user account where you want to create the repository, log into that account.

1. 2.2 If you need to create a new user account in the database for the Oracle Enterprise Manager repository, log in as any user with SYSTEM privileges.

CREATE username IDENTIFIED BY password;

Note: The output of the SQL statement appears in the upper pane of the SQL Worksheet screen.

2.2.2 Grant SYSTEM privileges to the user. In the lower pane of the SQL Worksheet screen, enter the following statement and press CTRL-ENTER to execute the statement.

GRANT CONNECT, RESOURCE, DBA to username IDENTIFIED BY password;

2.2.3 Log into the new user account that you created. In the lower pane of the SQL Worksheet screen, enter the following statement and press CTRL-ENTER to execute the statement.

CONNECT username/password;

3. Run the SMPCRE.SQL script to build the repository tables and views required by the Oracle Enterprise Manager and its components.

1. 3.1 Select the Worksheet menu.

1. 3.2 Select Run Script from the Worksheet menu.

1. 3.3 Use the Run Script file selection box to locate the desired script in the \ORANT\SYSMAN\ADMIN directory. Note ORANT is default directory of the Oracle Enterprise Manager installation program. If you chose to override the default, substitute the name of the directory that you used.

1. 3.4 Select the SMPCRE.SQL script and click the OK button to run the script.

4. Exit SQL Worksheet.