Follow these instructions to configure an Oracle 10 GB database for use with IBM® Rational® Quality Manager.

Points to consider:

• Oracle can be installed on a dedicated database server or on the same machine where Rational Quality Manager is installed.
• To ensure proper handling of Unicode content, the database character set must use UTF-8 encoding.
• The person who performs the configuration must have system administration authority on the Oracle database.

Create an Oracle database

1. On the Oracle server machine, start the Database Configuration Assistant and create a new database.
2. To improve database performance, create an Oracle table space of at least 1 GB at an appropriate location on the Oracle server (see Listing 1).

CREATE BIGFILE TABLESPACE oracle_tbs DATAFILE 
’c:\oracle_tbs\oracle_tbs.dbf
Size 1 GB AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE

3. Create a special Oracle database user for Rational Quality Manager (see Listing 2).

CREATE USER RQMDBUser IDENTIFIED BY RQMDBpswd DEFAULT TABLESPACE oracle_tbs

In the example in Listing 2, the user name is RQMDBUser and the password (identified in Oracle terms), is RQMDBpswd.

4. After you create RQMDBUser, grant the user the system permissions necessary to perform the following actions:
   1. Create a session.
   2. Create, alter, and drop tables and indexes.
   3. Insert, update, and delete from the tables created.
   4. Create sequence, procedure, and trigger

5. Copy the ojdbc14.jar file from the Oracle machine to the Rational Quality Manager server machine.
6. Navigate to <installation_dir>/RQM/server, and create a directory called oracle.
7. Copy the ojdbc14.jar file into the Oracle directory (C:\Program Files\IBM\RQM\server) and then create a directory called oracle (see Figure 1).

8. Copy the ojdbc14.jar file to the Oracle folder (see Figure 2).

9. Find the teamserver.oracle.properties file in this path: C:\Program Files\IBM\RQM\server (see Figure 3).

Click to enlarge

10. Open the teamserver.oracle.properties file, and configure the Oracle properties for either non-local host or local host, as Listing 3 shows, where:
    • RQMDBUSER is a user with appropriate database access rights.
    • RQMDB is the name of the Oracle database.
    • rqm01kn02:1521 is the IP address and port number of the Oracle server.
    • RQMDB123 is the password of the Oracle user.

# Oracle configuration
# Comment out above lines, uncomment the following three lines and customize 
  the example location to use Oracle
com.ibm.team.repository.db.vendor = ORACLE
# localhost connection strings should not include preceding //
com.ibm.team.repository.db.jdbc.location=
thin:RQMDBUSER/{password}@rqm01kn02:1521/RQMDB
# non-localhost connection strings MUST include preceding //
com.ibm.team.repository.db.jdbc.location=
thin:RQMDBUSER/{password}@//rqm01kn02:1521/RQMDB
com.ibm.team.repository.db.jdbc.password=RQMDB123

11. Rename the teamserver.properties file located in <installation_dir>/RQM/server (Figure 4) to teamserver.properties.BAK.

12. Rename the teamserver.oracle.properties file (Figure 5) to teamserver.properties.

13. The repotools.bat utility file is located in the Rational Quality Manager server subdirectory: <installation_dir>/RQM/server (see Figure 6).

Example: C:\Program Files\IBM\RQM\server

14. Run the repotools.bat file for creating tables in Oracle database server as Figure 7 shows. For example:
    C:\Program Files\IBM\RQM\server>repotools -createTables

After the repotools.bat file runs successfully, log files will be generated and display this message: ”The database tables were created successfully.”

C:\Program Files\IBM\RQM\server>repotools -createTables
Repo Tools, Version 1.0.1 - I20090211-1339
Provisioning using "C:\Program Files\IBM\RQM\server\\provision_profiles".
Rational Jazz Team Server (RQM) - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
  Db Name/Location: thin:xxxxxxxx/xxxxxxxx@// rqm01kn02:1521/ RQMDB
Initial database connection successful
  Db Product Name: Oracle
  Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
- 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
  Db URL: jdbc:oracle:thin: RQMDBUSER/ RQMDB123@// rqm01kn02:1521/ RQMDB
  Jdbc Driver Name: Oracle JDBC driver
  Jdbc Driver Version: 10.2.0.1.0
Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@// 
rqm01kn02:1521/ RQMDB " with indices.
The database tables were created successfully.

Resources

Learn

• Check the Rational Quality Manager page on IBM® developerWorks® for links to product documentation, articles, tutorials, courses, downloads, and other useful areas.
  
  
• Explore the Rational Quality Manager Information Center for technical guidance.
  
  
• Learn about other applications in the IBM Rational Software Delivery Platform, including collaboration tools for parallel development and geographically dispersed teams, plus specialized software for architecture management, asset management, change and release management, integrated requirements management, process and portfolio management, and quality management.
  
  
• Visit the Rational software area on developerWorks for technical resources and best practices for Rational Software Delivery Platform products.
  
  
• Explore Rational computer-based, Web-based, and instructor-led online courses. Hone your skills and learn more about Rational tools with these courses, which range from introductory to advanced. The courses on this catalog are available for purchase through computer-based training or Web-based training. Additionally, some "Getting Started" courses are available free of charge.
  
  
• Subscribe to the Rational Edge newsletter for articles on the concepts behind effective software development.
  
  
• Subscribe to the IBM developerWorks newsletter, a weekly update on the best of developerWorks tutorials, articles, downloads, community activities, webcasts and events.
  
  
• Browse the technology bookstore for books on these and other technical topics.
  
  

Get products and technologies

• Download the free trial version of Rational Quality Manager.
  
  
• Download these IBM product evaluation versions and get your hands on application development tools and middleware products from Rational®, DB2®, Lotus®, Tivoli®, and WebSphere®.
  
  

Discuss

• Join the Rational Quality Manager forum, which also includes discussions about Rational Test Lab Manager.
  
  
• Check out developerWorks blogs and get involved in the developerWorks community.
  
  

About the author

Manesh Kaniti is a senior software engineer at IBM, India. He has more than seven years of experience in testing and extensive experience with IBM Rational software, including Rational Quality Manager, Rational Functional Tester, Rational Performance Tester for SOA Quality, Rational Clear Quest, and Rational ClearCase.

Comments (Undergoing maintenance)

Back to top

Trademarks  |  My developerWorks terms and conditions

Table of contents

• Create an Oracle database
• Resources
• About the author
• Comments

Next steps from IBM

• Try: Rational Quality Manager
• Demo: Video: Quality management in 3 minutes
• Webcast: Reduce cost and speed time to market with quality management and asset management
• Briefing: Quality driven software delivery
• Buy: Rational Quality Manager

My developerWorks community

Dig deeper into Rational on developerWorks

Rate a product. Write a review.

Write a review for Rational products today!

Special offers