ORA-04031: unable to allocate adautoconfig.sh dbTier txkcreateACL.sh exiting with status 1

ERROR

Checking for existence of the ACL ….

DECLARE

*

ERROR at line 1:

ORA-04031: unable to allocate 2032 bytes of shared memory (“shared

pool”,”XDbD/PLZ01TcHgNAgAIIegtw==”,”qmxlu subheap”,”qmichdlArrayImg”)

ORA-06512: at line 16

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

txkcreateACL.sh: exiting with status 1

 

SOLUTION

Step 1. Increase the shared_pool size in database to atleast 1000 MBΒ 

Step 2. Bounce The database

Step 3. Now, Re-run autoconfig

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

EBS_Latest_Configurations

(EJCPUC)EBS Java Critical Patch Update Checker OCT-2024

(EJCPUC)EBS Java Critical Patch Update Checker OCT-2024 Introduction A new utility, Oracle E-Business Suite Java …

Leave a Reply