Troubleshooting
Problem
If you use Oracle Database in a Docker Container as the database for the IBM Maximo Health application, shared memory allocation errors can occur that cause runtime errors.
Diagnosing The Problem
As the cluster administrator, log in to the Red Hat OpenShift cluster and view the log file for the <instance_name>-manage-maxinst-<string> pod, which is also known as the maxinst pod.
If Maximo Health is deployed as part of Maximo Manage, the pod is located in the Maximo Manage namespace. If Maximo Health is not deployed as part of Maximo Manage, the pod is located in the Maximo Health namespace.
Shared memory allocation errors will exist in the log file. For example, the following error might appear in the log file:
java.sql.SQLException: ORA-04031: unable to allocate <number> bytes of shared memory ("shared pool", <unknown object>), increase shared memory by running the attached script in Oracle Database container.
Resolving The Problem
To resolve the problem, increase the shared memory.
To increase the memory, download and run the following script: updateDockerSharedMemoryOracle.sh. You can configure shared memory size in the script.
After you run the script, complete the following steps:
- Verify that the maxinst pod job successfully completed without errors.
- Verify that the runtime pod is started in the Red Hat OpenShift cluster. If Maximo Health is deployed as part of Maximo Manage, the pod is located in the Maximo Manage namespace and the name of the pod is <instance_name>-ui-<string>. If Maximo Health is not deployed as part of Maximo Manage, the pod is located in the Maximo Health namespace and the name of the pod is <instance_name>-all-<string>.
- Open Maximo Health in IBM Maximo Application Suite.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000hAePAAU","label":"Maximo Application Suite->Health"},{"code":"a8m3p000000hAeaAAE","label":"Maximo Application Suite->Manage"},{"code":"a8m3p0000006xL0AAI","label":"Maximo Application Suite->Manage->Deployment"},{"code":"a8m0z000000cxN3AAI","label":"Maximo Health"},{"code":"a8m3p000000hB0QAAU","label":"Maximo Manage"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.3.0;8.4.0;8.5.0"}]
Was this topic helpful?
Document Information
Modified date:
30 July 2021
UID
ibm16476067