Repository navigation
oracle database image size is huge #896
Description
I created a database image using your scripts:
REPOSITORY TAG IMAGE ID CREATED SIZE
oracle/database 12.2.0.1-ee 8adc010e6d91 13 minutes ago 13.2GB
when I check size of files using bash in container: 5.9G
Is it possible to shrink the size of image? I.e. you can merge RUN commands in your script and remove files immediately after install to avoid producing to many layers.
Activity
gvenzl commentedon Jun 20, 2018
Yes, you can use the
--squashoption to produce a smaller image, see: https://geraldonit.com/2017/11/13/how-to-create-small-docker-images/If you look at the Dockerfile you will see that the RUN commands are pretty much already all merged.
The issue is simply with copying in a ZIP file and unzipping it.
Even unzipping and deleting the zip file within a single
RUNinstruction doesn't avoid the extra space being wasted, unfortunately.avindra commentedon Jul 1, 2018
@gvenzl Thanks, the
--squashoption provides a much leaner image:However, as you can see the prebuilt image per the docs doesn't stay lean.
Do you have any recommendations for cutting down the size of the prebuilt image? I'm testing docker-squash as I'm writing this...
avindra commentedon Jul 2, 2018
Update on squashing. the library I linked doesn't work, so I ended up using this instead:
https://github.com/goldmann/docker-squash
result;
So it saves a decent 1/2 GB, but 9GB still seems pretty chunky for a totally empty database...
gvenzl commentedon Jul 2, 2018
The image gets bigger because you have data files in the image now, which come with default sizes. If you want to have a smaller image but still with a pre-built database there is a great blog post on the Mobiliar Database Blog which shows you a couple of tricks to make some data files and tablespaces even smaller.
Their case was for 11g XE but the steps for reducing
SYSAUX,UNDOand so forth remain the same also for 12c.MaxCCC commentedon Jul 24, 2018
The runOracle.sh scripts is a lot different for xe-11 than 12 which makes this nice blog not that useful :/
gvenzl commentedon Jul 24, 2018
The procedure to remove components from the database remains the same.
lvthillo commentedon Jul 25, 2018
@avindra The
--squashoption seems to work pretty good for me. I've just enabled the experimental docker daemon to use it:gvenzl commentedon Jul 25, 2018
Just note that @avindra image is bigger because he keeps a pre-built database inside the image as well (data files, etc). So he won't quite get to the 6GB :)
gvenzl commentedon Sep 14, 2018
We have now also implemented multi-stage builds by default which makes using the
--squashoption redundant. I'll close the issue for now as I believe this to be answered. Please reopen if there are outstanding questions.deusaquilus commentedon Jun 2, 2020
Hi @gvenzl. Thanks for the link!
I'm actually trying to go through the instructions that Alain posted using 18c XE... with mixed success. I can't decrease the size of
system01.dbfviaalter database datafilebecause it claims that 357M has already been exceeded. Do you know if there is a way to overcome this?Also, I can't re-create
sysauxvia his instructions because since in 18c the tables are no longerWRI$_OPTSTAT_...so I don't know which ones to move. Is it a simple matter of finding out which tables end with "HISTORY" and then what all of their indexes are?salob commentedon Feb 6, 2021
I know this is old but I had this problem also and went with this approach which I describe here:
https://www.linkedin.com/posts/sian-o-briain-194a008a_docker-have-you-ever-had-this-problem-activity-6753399399659008000-s_PA
But basically you get rid of the copy instructions by serving up the installers/patches via a local http server (you can do this with one command via python)
That way you can download,extract and delete all in the one RUN instruction.
Hope it helps
salob commentedon Feb 6, 2021
p.s. obviously if you don't need credentials for downloading installers you could just download from a regular file repo (like artifactory) rather than serve them up locally
deusaquilus commentedon Feb 7, 2021
@salob Have a look at this post by Alain Fuhrer and the corresponding repo by @wemu. I managed to get down to a ~2.5GB image by using their approach with —squash.
https://mobiliardbblog.wordpress.com/2020/11/23/optimized-oracle-18c-xe-docker-image-available-on-github/