Repotools unable to connect to Oracle RAC database

Technote (troubleshooting)


Problem(Abstract)

This technote provides a solution to an issue that can occur in an Oracle RAC environment when using Repotools to create tables for the IBM Rational Quality Manager server

Symptom

When running Repotools at command line, an error similar to the following is displayed:


    C:\IBM\RQM20\server>repotools -createTables logFile=e:\tmp\reptools.log
    Repo Tools

    Jazz Foundation Server, Version 1.0 (I20090618-1753)
    Rational Quality Manager, Version 2.0 (I20090713_1659)

    Provisioning using "C:\IBM\RQM20\server\conf\jazz\provision_profiles".
    Rational Jazz Team Server (RQM) - Enterprise

    CRJAZ1363I Loading configuration from "
    file:conf/jazz/teamserver.properties "
    CRJAZ1365I Attempting Initial Database Connection Using
    Db Name/Location: thin:xxxxxxxx/xxxxxxxx@// 192.1.2.3:1521/dev33

    CRJAZ0503I Failed to connect to the database: "Listener refused the connection with the following error:

    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

    The Connection descriptor used by the client was:
    // 192.1.2.3:1521/dev33

Cause

The Oracle host/port number and Oracle SID as defined in the teamserver.properties file are not be interpreted properly by the Oracle TNS listener.

Resolving the problem

In Rational Quality Manager server teamserver.properties file, change the location line for the vendor database to include a fully qualified domain name of the Oracle host and SID id.

Original

com.ibm.team.repository.db.vendor = ORACLE

com.ibm.team.repository.db.jdbc.location=thin:RQMuser/{password}@//192.1.2.3:1521/dev3

com.ibm.team.repository.db.jdbc.password=password

Modified

com.ibm.team.repository.db.vendor = ORACLE

com.ibm.team.repository.db.jdbc.location=thin:RQMuser/{password}@/ Oracle-test.host.ibm.com:1521/dev3.host.ibm.com

com.ibm.team.repository.db.jdbc.password=password

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Quality Manager
RQM Server

Software version:

2.0, 2.0.0.1

Operating system(s):

Linux, Windows

Software edition:

Standard

Reference #:

1418642

Modified date:

2010-10-27

Translate my page

Machine Translation

Content navigation