Oracle Team Productivity Center (OTPC) – Team Server part

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

Overview

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 11.1.1.1.0)
• MS Project Server (since 11.1.1.1.0)
• Bugzilla (new in 11.1.1.2.0)

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

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

Create database schema

Area

Description

Putty

login as: oracle oracle@192.168.234.140's password: Last login: Mon Aug  3 21:47:45 2009 from 192.168.234.1 [oracle@telde ~]$ [oracle@telde ~]$ . ./setDb1Env.sh 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 11.1.0.7.0 - 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 11.1.0.7.0 - 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; Connected. SQL> disconnect; Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit; [oracle@telde ~]$

Install OTPC Server Component

Area	Description
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 ~]$ . ./setFusionDomainEnv.sh /home/oracle Aktuelle Oracle Umgebung: $WLS_DOMAIN:               fusion_domain $WLS_DOMAIN_HOME(=$DH): /u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/fusion_domain $MW_HOME:                  /u01/app/oracle/product/11.1.1.2/middleware $JAVA_HOME:                /u01/app/oracle/product/11.1.1.2/middleware/jrockit_160_14_R27.6.5-32 [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	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/11.1.1.2/middleware/user_projects/domains/fusion_domain/autodeploy 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	wait…..
	Choose: Close
Putty/Start WebLogic	Start the WebLogic server [oracle@telde tmp]$cd $DOMAIN_HOME [oracle@telde fusion_domain]./startWebLogic.sh ... [EL Info]: 2009-11-05 07:47:00.511--ServerSession(41694633)--zip:/u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/base_domain/servers/AdminServer/tmp/_WL_user/_appsdir_otpc_war/sfdu2u/war/WEB-INF/lib/_wl_cls_gen.jar!/-otpc login successful
Browser/Verify OTPC is running

Upgrade notes

Test the connection to OTPC from JDeveloper

Area	Description
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...

Observations

• 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

• Installation Guide OTPC
• Introducing Oracle Team Productivity Center by Susan Duncan
• OBE: Getting Started With Oracle Team Productivity Center
• TELDE - Installation OTPC (german)