AppSync: Oracle recovery is failing because of the value of the initiation parameter SGA_TARGET

Summary: AppSync: Oracle recovery is failing because of the value of the initiation parameter SGA_TARGET

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms



Oracle recovery is failing because of exceeding the specified value under SGA_TARGET
 
From Agent logs:
 
2019-02-01 18:51:57.613 acp.py[115]:main() Command: startupMountDb
2019-02-01 18:51:58.699 oracle.py[4050]:_execSql() SQLresult: SQL> SQL> ORA-01078: failure in processing system parameters
2019-02-01 18:51:58.700 oracle.py[4050]:_execSql() SQLresult: ORA-00821: Specified value of sga_target 40960M is too small, needs to be at least 82432M
2019-02-01 18:51:58.700 oracle.py[4050]:_execSql() SQLresult: Disconnected

Cause

Here, user specified the SGA_TARGET as 40GB, however the following other values that make up the SGA_TARGET need to be able to fit in SGA_TARGET, and they were not reduced along with the reduced SGA_TARGET.
 
These variables added up need to fit into SGA_TARGET:
 
Buffer cache (DB_CACHE_SIZE)
Shared pool (SHARED_POOL_SIZE)
Large pool (LARGE_POOL_SIZE)
Java pool (JAVA_POOL_SIZE)
Streams pool (STREAMS_POOL_SIZE)
 
If the above are set on Source, then they also may need to be reduced along with SGA_TARGET.
The following is based on info in this link: https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams193.htm#REFRN10256


Resolution

Setting the variables to zero, allows Oracle to automatically size the them to be able to fit in SGA_TARGET.
Providing over-rides in AppSync for these additional variables resolves the issue. 
 
large_pool_size=0
shared_pool_size=0
java_pool_size=0
db_cache_size=0

Setting the variables to proper values to collectively fit within SGA_TARGET should also resolve.

Additional Information

This content is translated in other languages: 

https://downloads.dell.com/TranslatedPDF/PT-BR_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/ZH-CN_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/AR-EG_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/DE_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/ES_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/FR_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/KO_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/JA_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/IT_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/NL_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/PT_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/RU_KB531038.pdf
https://downloads.dell.com/TranslatedPDF/SV_KB531038.pdf

Affected Products

AppSync

Products

AppSync
Article Properties
Article Number: 000168545
Article Type: Solution
Last Modified: 18 Sept 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.