An example to create BPM Enterprise schema using a Kubernetes job on Oracle
Article ID: KB0071641
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 -
-- To view the logs -
kubectl logs <pod_name> -n bpme
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
Issue/Introduction
This article provides an example on how to use Kubernetes to create the BPM Enterprise schema on Oracle database
Environment
All supported Kubernetes platforms
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
Feedback
Yes
No
Powered by
