Skip to content
This repository has been archived by the owner on Sep 26, 2021. It is now read-only.

Installation fails due to sga_target being too small #48

Open
jurgenhaas opened this issue Nov 6, 2019 · 2 comments
Open

Installation fails due to sga_target being too small #48

jurgenhaas opened this issue Nov 6, 2019 · 2 comments

Comments

@jurgenhaas
Copy link

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
Copy link

kalee commented Feb 27, 2020

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
Copy link

Just in case someone lands here from Google: oracle/docker-images#1522 (comment)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants