Creating the database for assets in Oracle

This section includes instructions for manually creating 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:

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.
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.
Use the server setup application to populate the database. To learn more about the server setup application, see Installing Rational Asset Manager server by using Installation Manager.

What to do next

If you do not already have an existing Rational Team Concert server create the database for lifecycle management. To do so, see Creating databases for asset lifecycles in Oracle.
If you already have Rational Team Concert:
If you are using WebSphere Application Server:

If you have not deployed the server setup application, deploy it to your server or cluster. To do so, see deploying to a server or deploying to a cluster.
Restriction: To create and use a cluster of application servers, you must have IBM WebSphere Application Server Network Deployment (ND).

If you are installing to a WebSphere Application Server cluster and you need to install Rational Team Concert™, you will also have to create a single application server instance for Rational Team Concert.

Then, use the server setup application to configure WebSphere Application Server to connect to your databases. If you have deployed the server setup application to your server or cluster, see Deploying and configuring application files by using the server setup application.

If you are using Apache Tomcat:

Configure Apache Tomcat and deploy the Rational Asset Manager application files. See Deploying the Rational Asset Manager server applications on Tomcat 6 or 7.

Feedback