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:
- 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.
- 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.
- Click SQL+ to open it.
- 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+.
- Click Execute. When
the process
finishes, delete the commands from the top window.
- Repeat these steps for the bootStrap_Oracle.sql file.
- Verify that the tables were
created.