How to Deploy Oracle on Kubernetes?

Deploying Oracle on Kubernetes can be a complex but rewarding endeavor. Kubernetes, an open-source container orchestration platform, provides a scalable and flexible environment for running containerized applications. In this article, we'll explore the step-by-step process of deploying Oracle on Kubernetes, covering the essential commands, configurations, and considerations.

Pre-requisites:

Before diving into the deployment process, ensure that you have the following prerequisites in place:

1. Kubernetes Cluster: Set up a Kubernetes cluster with the necessary nodes.

2. kubectl: Install and configure the Kubernetes command-line tool, kubectl, for managing your cluster.

3. Oracle Docker Image: Obtain the Oracle database Docker image suitable for your deployment.

Step 1: Pull Oracle Docker Image

To begin, pull the Oracle database Docker image from the official repository. Use the following command:

docker pull store/oracle/database-enterprise:12.2.0.1

Step 2: Create Persistent Volumes (PVs)

Oracle databases require persistent storage. Create Persistent Volumes to ensure data persistence. Define PV configurations in a YAML file, for example, oracle-pv.yaml:

apiVersion: v1
kind: PersistentVolume
metadata:
  name: oracle-pv
spec:
  capacity:
    storage: 50Gi
  accessModes:
    - ReadWriteOnce
  hostPath:
    path: /path/to/storage

Apply the configuration:

kubectl apply -f oracle-pv.yaml

Step 3: Create Persistent Volume Claims (PVCs)

Define Persistent Volume Claims to match the requirements of Oracle. Use a YAML file, e.g., oracle-pvc.yaml:

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: oracle-pvc
spec:
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 50Gi

Apply the configuration:

kubectl apply -f oracle-pvc.yaml

Step 4: Deploy Oracle Database

Now, create a YAML file for Oracle deployment, e.g., oracle-deployment.yaml. Ensure to set the necessary environment variables like passwords, storage paths, etc.

apiVersion: apps/v1
kind: Deployment
metadata:
  name: oracle-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: oracle
  template:
    metadata:
      labels:
        app: oracle
    spec:
      containers:
      - name: oracle-container
        image: store/oracle/database-enterprise:12.2.0.1
        env:
          - name: ORACLE_SID
            value: ORCL
          - name: ORACLE_PDB
            value: ORCLPDB1
          # Add other necessary environment variables
        ports:
          - containerPort: 1521
        volumeMounts:
          - name: oracle-storage
            mountPath: /opt/oracle/oradata
      volumes:
        - name: oracle-storage
          persistentVolumeClaim:
            claimName: oracle-pvc

Apply the deployment:

kubectl apply -f oracle-deployment.yaml

Step 5: Expose Oracle Service

Expose the Oracle service to enable external access. Create a service YAML file, e.g., oracle-service.yaml:

apiVersion: v1
kind: Service
metadata:
  name: oracle-service
spec:
  selector:
    app: oracle
  ports:
    - protocol: TCP
      port: 1521
      targetPort: 1521
  type: LoadBalancer

Apply the service configuration:

kubectl apply -f oracle-service.yaml

Step 6: Access Oracle Database

Once the service is up and running, obtain the external IP (may take some time) using:

kubectl get services oracle-service

Connect to Oracle using the obtained IP, port 1521, and the provided credentials.

Congratulations! You've successfully deployed Oracle on Kubernetes. Customize the configurations based on your specific requirements.