An example to create BPM Enterprise schema using a Kubernetes job on Oracle

An example to create BPM Enterprise schema using a Kubernetes job on Oracle

book

Article ID: KB0071641

calendar_today

Updated On:

Products Versions
TIBCO BPM Enterprise (formerly TIBCO ActiveMatrix BPM) 5.3.0

Description

BPM Enterprise (BPME) database schema is created by running the utility image. This can be executed either via a Docker command or a Kubernetes job. Below is an example for Oracle database - 

1. Setup the Oracle database and the BPME database user - 

v5.3.0 - https://docs.tibco.com/pub/bpme/5.3.0/doc/html/Default.htm#installation/create-configure-the-tibco-bpm-enterprise-database-oracle.htm?TocPath=Installation%257CInstalling%2520TIBCO%2520BPM%2520Enterprise%2520on%2520Kubernetes%257CCreating%2520the%2520TIBCO%2520BPM%2520Enterprise%2520Database%257C_____3

2. Create a namespace in Kubernetes - 

For example - 
kubectl create namespace bpme

3. Run the following to create a Kubernetes job - 

===========
cat <<EOF | microk8s kubectl apply -f -
apiVersion: batch/v1
kind: Job
metadata:
  name: utility
  namespace: bpme
spec:
  template:
    spec:
      hostPID: true
      containers:
      - name: utility
        image: tibco/bpm/utility:5.3.0
        command: ["utility", "-dbConfig", "url=jdbc:oracle:thin:@//<DB_hostname>:<DB_port>/<DB_serviceName>", "username=<DB_user>", "password=<DB_pass>", "-setupDatabase", "execute", "--verbose"]
      restartPolicy: Never
EOF
===========

where -
<DB_hostname> is the hostname or IP address of the Oracle database
<DB_port> - is the port number of the Oracle database
<DB_serviceName> - is the database service name that is associated with the pluggable database. 
<DB_user> - is the database user created in step # 1
<DB_pass> - is the database user's password as provided in step # 1

Please note this command only creates the Kubernetes job. If this is successful, the following message is seen - 

 

job.batch/utility created

4. To view result of the utility, the pod logs will need to be accessed - 

-- To know the pod_name created by the job. It is in the format - utility-*. 
kubectl get pods -n bpme

-- To view the logs - 
kubectl logs <pod_name> -n bpme

Environment

All supported Kubernetes platforms

Issue/Introduction

This article provides an example on how to use Kubernetes to create the BPM Enterprise schema on Oracle database

Additional Information

Creating the TIBCO BPM Enterprise Schema - v5.3.0 - https://docs.tibco.com/pub/bpme/5.3.0/doc/html/Default.htm#installation/create-the-tibco-bpm-enterprise-schema.htm?TocPath=Installation%257CInstalling%2520TIBCO%2520BPM%2520Enterprise%2520on%2520Kubernetes%257CCreating%2520the%2520TIBCO%2520BPM%2520Enterprise%2520Database%257C_____5