docker-oracle-xe icon indicating copy to clipboard operation
docker-oracle-xe copied to clipboard

Installation fails due to sga_target being too small

Open jurgenhaas opened this issue 5 years ago • 2 comments

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?

jurgenhaas avatar Nov 06 '19 16:11 jurgenhaas

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?

kalee avatar Feb 27 '20 03:02 kalee

Just in case someone lands here from Google: https://github.com/oracle/docker-images/issues/1522#issuecomment-585321667

visit1985 avatar Sep 02 '20 10:09 visit1985