docker-oracle-xe
docker-oracle-xe copied to clipboard
Installation fails due to sga_target being too small
Have tried this repo successfully yesterday on a local Ubuntu 18.04 host and now wanted to replicate on a brand new server host in our production environment.
When running docker run ...
and looking into the logs, we do get the following error message:
[WARNING] ORA-00821: Specified value of sga_target 1536M is too small, needs to be at least 2416M
ORA-01078: failure in processing system parameters
[FATAL] ORA-01034: ORACLE not available
I have tried setting environment variables like SGA_TARGET
or ORA_RMAN_SGA_TARGET
or ORACLE_SGA_TARGET
with much higher values but always get the same error.
Any idea on how I could tell the oracle installer to use a higher value for sga_target?
Same issue on a desktop with 64g of ram. Exact same error message. Tried to update init.ora with a sed command, but either it doesn't work or the timing is off. I thought memory management was automatic with oracle-xe. Also tried adding the --memory==2g to the container run command, but that didn't help either. Not sure how to force sga_target to a lower value?
Just in case someone lands here from Google: https://github.com/oracle/docker-images/issues/1522#issuecomment-585321667