Configure WebSphere Process Server with an Oracle database

Level: Intermediate

Simon Kapadia , Technical Team Lead, IBM

24 May 2006

	Get the download

This article explains how to configure IBM WebSphere Process Server V6.0.1 to work with an Oracle database. It covers only the database-specific configuration and assumes some experience with WebSphere Process Server.

Introduction

IBM® WebSphere® Process Server Version 6.0.1 (hereafter called Process Server) requires a Relational Database system (RDBMS) such as IBM Cloudscape™, IBM DB2® Universal Database (DB2 UDB) or Oracle® Corporation’s Oracle Database Server (hereafter called Oracle). The default configuration for Process Server uses Cloudscape, which is a full-featured, robust, small-footprint database server that is simple to deploy and available with a no-charge license from IBM. You can also install using an existing RDBMS, such as Oracle.

This article explains how to configure Process Server with a real production implementation of Oracle. In a production environment, the person or team installing Process Server will often not have SYSTEM access to the Oracle server. This article does not assume that the user installing Process Server has SYSTEM level access to the Oracle Database being used.

Download

Description	Name	Size	Download method
Article in PDF format	0605_kapadia-config-oracle-wps.pdf	879KB	FTP|HTTP

	Information about download methods			Get Adobe® Reader®

Resources

• Basic steps for clustering WebSphere Process Server
  
  
• WebSphere Process Server security overview
  
  
• WebSphere Install Factory
  
  
• Configuring and using XA distributed transactions in WebSphere Studio
  
  
• Exception occurs during recovery of Oracle database transactions
  
  
• WebSphere Business Integration zone
  
  
• WebSphere Process Server and WebSphere Integration Developer resources
  
  
• developerWorks podcasts
  
  
• developerWorks blogs
  
  
• IBM WebSphere Developer Technical Journal
  
  
• WebSphere Business Integration New to
  
  

• WebSphere Process Server product site

About the author

		Simon Kapadia is the Security Lead for IBM Software Services for WebSphere (ISSW) in EMEA (Europe, Middle East, Africa). He works on designing and implementing large distributed computer systems for IBM customers. Simon holds a Bachelor’s degree in English and Drama, and a Master’s in Computer Science. He has owned a computer since six years of age, and has turned a lifelong hobby into a career. Prior to joining IBM, Simon developed software for digital exchanges at Bell Laboratories, managed networks and Web applications at a Polish ISP, and supported and consulted on DCE, DFS and Encina for Transarc Corporation. You can reach Simon at simon.kapadia@uk.ibm.com or via his public Web site at http://www.kapadia.pl.

Rate this content

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top