I Enterprise Manager Java Console

Database Version Requirements for the Standalone Repository

The following database releases are supported for the standalone repository:

• Enterprise Edition or Standard Edition Release 10.1.x

• Enterprise Edition or Standard Edition Release 9.2.x

• Enterprise Edition or Standard Edition Release 9.0.1.x

You must ensure that the database in which the repository will be placed has object support. If it does not, repository creation fails. Either select another database that has object support, or install and enable object support on the chosen database.

Create a Tablespace for the Standalone Repository

Create a tablespace with the following attributes:

• Type: Permanent

• Storage attributes: for Extent Management, use Locally managed

• Datafile attributes:

  • Size:

    • For 2 Kb blocks: 16 MB

    • For 4 Kb blocks: 24 MB

    • For 8 Kb blocks: 32 MB

    • For sizes above 8 KB: 64 MB

  • Reuse Existing File: Yes

  • AUTOEXTEND: Yes

  • AUTOEXTEND increment: 5MB

  • AUTOEXTEND maximum: 2000MB

To create a tablespace for the standalone repository, first select the database in which you want to place the standalone repository, ensuring it meets the requirements outlined. Then, follow the procedure described in this section:

1. Start the Oracle Enterprise Manager Java Console.

   You can start the standalone console from the command line using the command:

   oemapp console
   
   

2. Click the + next to Databases to display the list of databases.

3. Double-click the database node in the Navigator and connect to the database as a user with the NORMAL privileges.

4. Choose Create from the Object menu. The Create Object List dialog appears.

5. Expand the database node in the Create Object List dialog and select Tablespace, then click Create. The Create Tablespace property sheet appears.

6. In the Create Tablespace Property Sheet's General page,

   • Enter the name of the new tablespace, OEM_REPOSITORY.

   • Specify that the tablespace will be used to hold permanent database objects.

7. In the Datafile section, enter the size of the new datafile. The File Name and File Directory columns should already contain default entries. The datafile is called OEM_REPOSITORY.dbf or OEM_REPOSITORY.ora depending on the version of the database.

8. Right-click the + next to OEM_REPOSITORY.dbf and choose Edit. The Create Datafile property sheet appears.

9. In the Create Datafile's General page, select the Reuse Existing File box.

10. In the Create Datafile's Storage page, fill the appropriate attributes:

    1. Select the Automatically extend datafile when full (AUTOEXTEND) option so that the datafile automatically increases in size when more space is needed in the database.

    2. Specify 5 MB as the Increment.

    3. Specify 2000 MB as the Maximum Size.

11. Click OK in the Create Datafile property sheet.

12. In the Create Tablespace Property Sheet's Storage page, select the Locally Managed option as the method of space management.

13. Click Create in the Create Tablespace Property Sheet.

Create a Database user for Standalone Repository

A standalone repository is owned by a database user. A database user, in other words, a repository schema user, who will own the repository must be created before the standalone repository can be created by Enterprise Manager.

To create a database user who will own the standalone repository, follow the procedure described below:

1. Start the standalone Console.

2. Double-click the database node in the Navigator and connect to the database as a user with the NORMAL role.

3. Choose Create from the Object menu. The Create Object List dialog appears. Expand the database node in the Create Object List dialog and select User, then click Create. The Create User property sheet appears.

4. In the General page, provide the name of the user and its password, and select OEM_REPOSITORY as the default tablespace and TEMP as the temporary tablespace.

5. In the System Privileges page, grant the CREATE PROCEDURE, CREATE TRIGGER, CREATE TYPE, EXECUTE ANY PROCEDURE, EXECUTE ANY TYPE, SELECT ANY DICTIONARY (for 9i), and SELECT ANY TABLE roles to the repository user.

6. In the Quota page, specify unlimited for OEM_REPOSITORY and TEMP.

7. Click Create in the Create User property sheet.

Once you have a tablespace and a repository user, start a standalone application that requires a standalone repository.

When the dialog appears informing you that certain features of Enterprise Manager require a standalone repository and you must create a new database user to own the standalone repository schema, click OK to close the dialog since you have already created the user.

Supply the user's user name and password for the repository login and click OK. The standalone application automatically creates the standalone repository for you.