Skip to main content

Posts

Showing posts with the label shared_pool

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

After configuring new clone in R12.1.3 when i was trying to run adautoconfig.sh script on dbTier then it completing with errors. In autoconfig logfile error stack: Connected. 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   Cause: The configured shared_pool size in initialization parameter file is only 400 MB. Solution: => Increase shared_pool size 1000 MB => Bounce database => Re-run autoconfig This time it should complete successfully. bash-3.00$ adautocfg.sh Enter the APPS user password: The log file for this ses...