Saturday, December 12, 2009

Oracle Team Productivity Center (OTPC) – Team Server part

Status: resolved
Oracle Team Productivity Center:
Oracle WebLogic Server: 10.3.2
Environment: TELDE


We want to use Oracles solution for Applpication Lifecycle Management (ALM) called Oracle Team Productivity Center. OTPC enables software development teams to collaborate and work productively together when developing applications using JDeveloper.

OTPC consist of several component from which we will cover the server side ones in this blog post. That are the Team Server which is connected to databased repository and some specific ALM connectors. Currently there are implementations for

  • JIRA (since
  • MS Project Server (since
  • Bugzilla (new in

The following figures gives an overview of the involved components:


The Team Server component is a WAR exposing some WebServices which are cosumed by the JDeveloper TPC Extension counterpart. The deployement is currently supported either on a WebLogic Server or Apache Tomcat.

Quick Outline of this post

  1. Download OTPC Server Component
  2. Create Database Schema for OTPC
  3. Install  OTPC Server Component on WebLogic Server 10.3.2
  4. Install JDeveloper OTPC extension
  5. Test the OTPC connection.

Download Products

  Oracle® Team Productivity Center Server Component + Connectors
Download from OTN

Create database schema


login as: oracle
oracle@'s password:
Last login: Mon Aug  3 21:47:45 2009 from

[oracle@telde ~]$

[oracle@telde ~]$ . ./

Aktuelle Oracle Umgebung:

Oracle-Home: /u01/app/oracle/product/11.1.0/db_1

Oracle-SID:  orcl

[oracle@telde ~]$ sqlplus / as sysdba

SQL*Plus: Release - Production on Thu Nov 5 07:40:04 2009

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user ofm_tpc identified by ofm_tpc;

User created.

SQL> grant connect, resource to ofm_tpc;

Grant succeeded.

SQL> connect ofm_tpc/ofm_tpc;


SQL> disconnect;

Disconnected from Oracle Database 11g Enterprise Edition Release - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit;

[oracle@telde ~]$

Install OTPC Server Component

Client Start Xming!
WinSCP Copy downloaded tpcinstaller.jar to /u01/product/oracle/middleware/11.1.1/tpc
Putty / set java env

Login as oracle

[oracle@telde ~]$ . ./


Aktuelle Oracle Umgebung:

$WLS_DOMAIN:               fusion_domain

$WLS_DOMAIN_HOME(=$DH): /u01/app/oracle/product/

$MW_HOME:                  /u01/app/oracle/product/

$JAVA_HOME:                /u01/app/oracle/product/

[oracle@telde ~]$ java -version

java version "1.6.0_14"

Java(TM) SE Runtime Environment (build 1.6.0_14-b08)

BEA JRockit(R) (build R27.6.5-32_o-121899-1.6.0_14-20091001-2113-linux-ia32, compiled mode)

[oracle@telde ~]$ cd /u01/product/oracle/middleware/11.1.1/tpc/ [oracle@telde tpc]$ java -jar tpcinstaller.jar

Installer image
Choose: Next

Input JDBC: jdbc:oracle:thin:@database.telde.local:1521:orcl
Input Username: ofm_tpc
Input Password: ofm_tpc
Choose: Next

Select: Server
Select: Connectors
Choose: Next
Input: /u01/app/oracle/product/
Choose: Next

Choose File Name: <whatever connector you want to additionally be installed>
Choose: Next

Input Username: tpcadmin
Input Password: welcome1
Input Confirm Password: welcome1
Choose: Next
View Summary, Verify your made selections!
Choose: Finish
Installation in progress image
Choose: Close
Putty/Start WebLogic

Start the WebLogic server

[oracle@telde tmp]$cd $DOMAIN_HOME

[oracle@telde fusion_domain]./


[EL Info]: 2009-11-05 07:47:00.511--ServerSession(41694633)--zip:/u01/app/oracle/product/!/-otpc login successful

Browser/Verify OTPC is running image

Upgrade notes

Test the connection to OTPC from JDeveloper


Start and Use Help>Check for updates to install the team productivity center extension, plus required client connectors.

Select the Team Navigator tab or Open it by menu (View>Team>Team Navigator)
Click: Connect To Team Server

Input Team Server: telde.local
Input Port: 7001
Input Username: tpcadmin
Input Passwort: welcome1
Choose: Connect
JDeveloper/Team Administration Now you can reach the Team Administration as follows
Now you are able to create user, assign team repositories and so on...


  • Calling the Test Server Page (<host>:<port>/otpc) you just get a simple message “Oracle Team Productivity Center” Request to Oracle: Please display some more information: Version, active connectors, etc.....!!! At the moment this does not look enterprise production ready!! Sorry. It looks like a prototyp so far……
  • Do I really have to create all the users into the OTPC repository by hand? Can’t I connect to an LDAP-Server? This also looks not enterprise production ready. Sorry.

Further Information


  1. Hola. muy bueno tu post, me está prestando mucha ayuda.
    ( yo lo estoy instalando en windows vista, con oracle xe y jdev 11g.)
    tuve un porblema, con la localización de el autodeploy para el server, pero ya la tengo resuelta. "crear un nuevo domain llamado base_domain".

  2. I am sorry I do not understand to much spanish...