Creating and populating the database for assets in Oracle

This section includes instructions for manually creating and populating tables for IBM® Rational® Asset Manager in Oracle.

Before you begin

Oracle must already be installed and running. Also, make sure that you know the location of the SQL scripts (typically, path_to_installation_media \db_scripts\Oracle).

Procedure

To create the database tables:

  1. Using the Oracle Database Configuration Assistant, follow the steps in the wizard to create a database.
    1. Use global database name ramdb_your_domain, and a system identifier (SID) ramdb.
    2. On the Custom Scripts tab, do not run the SQL scripts that are mentioned in the later steps. You must create a user account first.
    3. On the Character Sets page, select Use Unicode (AL32UTF8).
    4. Also on the Character Sets page, for National Character Set, select UTF8 - Unicode 3.0 UTF-8.
    5. Complete the other pages in the wizard, accepting the default values.
  2. Create a database user:
    1. Open Database Control.
    2. Navigate to the Users page. (In Oracle 10.2(g), click Administration, then Users; in Oracle 11(g), click Server, then in the Security section click Users.)
    3. Create a user named RAMSCHEMA that meets these qualifications:
      • The user must be named RAMSCHEMA. Rational Asset Manager requires a schema named RAMSCHEMA, and in Oracle schemas are owned by a database user and share the name of that user. You cannot use a different name.
      • The user has the RESOURCE and CONNECT roles.
      • The user must have the CREATE VIEW privilege: GRANT CREATE VIEW TO RAMSCHEMA
      • The quota setting for the user is unlimited.
      • For tablespace, you can use any default tablespace except for Temp that meets the access level requirements for the user that you created.
      Tip: Oracle provides a default user named "Scott" that has the appropriate permissions. You can use this default user as the basis for your new user account; however, you still must name the user RAMSCHEMA.
  3. Run the scripts that populate the database. This step is not necessary if you are using the server setup application; the server setup application runs the scripts for you.
    1. Click SQL+ to open it.
    2. Open the RAMSCHEMA_Oracle.sql file in the sqlscripts/oracle folder. Highlight the entire contents of the file, copy them (right-click, and then Copy), and then paste them into the top of the SQL+.
    3. Click Execute. When the process finishes, delete the commands from the top window.
    4. Repeat these steps for the bootStrap_Oracle.sql file.
  4. Verify that the tables were created.

What to do next


Feedback