Troubleshooting
Problem
The Tivoli Workload Scheduler (TWS) MAKEPLAN job goes to the abend state if there is a failure when objects cannot be loaded from the database. There are specific symptoms when there is insufficient shared memory allocated in Oracle.
Symptom
MAKEPLAN joblog:
AWSJPL006E An internal error has occurred. A database object 'workstation' cannot be loaded from the database.
WebSphere SystemOut.log:
AWSJDB801E An internal error has been found while accessing the database. The internal error message is: "ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select MPR_NAME, MPR_VALUE f...","sga heap(1,0)","kglsim object batch")".
[{"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Oracle","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.6;9.1;9.2;9.3","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21682839