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.
- Use global database name ramdb_your_domain,
and a system identifier (SID) ramdb.
- 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.
- On the Character Sets page, select Use Unicode
(AL32UTF8).
- Also on the Character Sets page, for National Character
Set, select UTF8 - Unicode 3.0 UTF-8.
- Complete the other pages in the wizard, accepting the
default values.
- Create a database user:
- Open Database Control.
- 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.)
- 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.