search

fuzziebrain / docker-oracle-xe

Docker build for Oracle Database 18c Express Edition (XE). This project is now archived with the release of version 21c.
MIT License
272 stars 127 forks source link

Installation fails due to sga_target being too small #48

Open jurgenhaas opened 5 years ago

jurgenhaas commented 5 years ago

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?

kalee commented 4 years ago

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?

visit1985 commented 4 years ago

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