Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 23 December 2012

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 session is located at: /u01/R12dbase_PREPROD/appsutil/log/PREPROD_erptest01/12161247/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/R12dbase_PREPROD
        Classpath                   : :/u01/R12dbase_PREPROD/jdbc/lib/ojdbc5.jar:/u01/R12dbase_PREPROD/appsutil/java/xmlparserv2.jar:/u01/R12dbase_PREPROD/appsutil/java:/u01/R12dbase_PREPROD/jlib/netcfg.jar:/u01/R12dbase_PREPROD/jlib/ldapjclnt11.jar

        Using Context file          : /u01/R12dbase_PREPROD/appsutil/PREPROD_erptest01.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
bash-3.00$


 Thanks for reading.

regards,
X A H E E R 



1 comment:

Blogger said...

Searching for the Ultimate Dating Site? Create an account to find your perfect match.