Open in app

Sign in

Write

Sign in

Minimal Oracle installation (and Docker image)

Franck Pachot
3 min readDec 11, 2018

--

A new blog post on the Databases at CERN blog about some research on the minimal Oracle Database installation: https://db-blog.web.cern.ch/blog/franck-pachot/2018-12-minimal-oracle

And a bonus here: the Dockerfile which builds this minimal image. You need to build the Oracle XE image (oracle/database:18.4.0-xe) with the buildfiles provided by Oracle (https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles/18.4.0) and this Dockerfile will copy only the necessary:

FROM oraclelinux:7-slim
 ENV ORACLE_BASE /opt/oracle
 ENV ORACLE_HOME ${ORACLE_BASE}/product/18c/dbhomeXE
 ENV ORACLE_SID=XS
 #TODO# do something lighter than preinstall
 RUN yum install -y oracle-database-preinstall-18c strace ; rm -rf /var/cache/yum
 RUN mkdir -p ${ORACLE_BASE} ${ORACLE_HOME} ; chown -R oracle:oinstall ${ORACLE_BASE} ${ORACLE_HOME}
 USER oracle
 WORKDIR ${ORACLE_HOME}
 ################################################################################################################
 # sqlplus
 ################################################################################################################
 RUN mkdir -p bin
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/bin/sqlplus\
  bin/
 RUN mkdir -p lib
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/lib/libsqlplus.so\
  ${ORACLE_HOME}/lib/libclntsh.so.18.1\
  ${ORACLE_HOME}/lib/libclntshcore.so.18.1\
  ${ORACLE_HOME}/lib/libmql1.so\
  ${ORACLE_HOME}/lib/libipc1.so\
  ${ORACLE_HOME}/lib/libnnz18.so\
  ${ORACLE_HOME}/lib/libons.so\
  lib/
 RUN mkdir -p sqlplus/mesg
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/sqlplus/mesg/sp1us.msb\
  ${ORACLE_HOME}/sqlplus/mesg/sp2us.msb\
  sqlplus/mesg/
 RUN mkdir -p rdbms/mesg
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/rdbms/mesg/ocius.msb\
  ${ORACLE_HOME}/rdbms/mesg/oraus.msb\
  ${ORACLE_HOME}/rdbms/mesg/diaus.msb\
  rdbms/mesg/
 RUN mkdir -p oracore/zoneinfo
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/oracore/zoneinfo/*.dat\
  oracore/zoneinfo/
 RUN du -h ${ORACLE_BASE} | sort -u
 ################################################################################################################
 # oracle core
 ################################################################################################################
 #TODO# move audit and dbs (rooh)
 RUN mkdir -p rdbms/audit dbs log rdbms/log
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/bin/oracle\
  bin/
 #RUN strip --remove-section=.comment ${ORACLE_HOME}/bin/oracle
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/lib/libodm18.so\
  ${ORACLE_HOME}/lib/libofs.so\
  ${ORACLE_HOME}/lib/libcell18.so\
  ${ORACLE_HOME}/lib/libskgxp18.so\
  ${ORACLE_HOME}/lib/libskjcx18.so\
  ${ORACLE_HOME}/lib/libclsra18.so\
  ${ORACLE_HOME}/lib/libdbcfg18.so\
  ${ORACLE_HOME}/lib/libhasgen18.so\
  ${ORACLE_HOME}/lib/libskgxn2.so\
  ${ORACLE_HOME}/lib/libocr18.so\
  ${ORACLE_HOME}/lib/libocrb18.so\
  ${ORACLE_HOME}/lib/libocrutl18.so\
  ${ORACLE_HOME}/lib/libmkl_rt.so\
  ${ORACLE_HOME}/lib/libasmclntsh18.so\
  lib/
 RUN mkdir -p oracore/mesg
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/oracore/mesg/lrmus.msb\
  oracore/mesg
 RUN echo -e 'db_name=XS' > ${ORACLE_HOME}/dbs/initXS.ora
 ################################################################################################################
 # oracle rdbms
 ################################################################################################################
 RUN mkdir -p ldap/mesg
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/ldap/mesg/ldapus.msb\
  ldap/mesg/
 RUN mkdir -p network/mesg
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/network/mesg/tnsus.msb\
  network/mesg
 RUN mkdir -p nls/data
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/nls/data\
  nls/data
 RUN mkdir -p rdbms/admin
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/rdbms/admin/sql.bsq\
  ${ORACLE_HOME}/rdbms/admin/dcore.bsq\
  ${ORACLE_HOME}/rdbms/admin/dsqlddl.bsq\
  ${ORACLE_HOME}/rdbms/admin/dmanage.bsq\
  ${ORACLE_HOME}/rdbms/admin/dplsql.bsq\
  ${ORACLE_HOME}/rdbms/admin/dtxnspc.bsq\
  ${ORACLE_HOME}/rdbms/admin/dfmap.bsq\
  ${ORACLE_HOME}/rdbms/admin/denv.bsq\
  ${ORACLE_HOME}/rdbms/admin/drac.bsq\
  ${ORACLE_HOME}/rdbms/admin/dsec.bsq\
  ${ORACLE_HOME}/rdbms/admin/doptim.bsq\
  ${ORACLE_HOME}/rdbms/admin/dobj.bsq\
  ${ORACLE_HOME}/rdbms/admin/djava.bsq\
  ${ORACLE_HOME}/rdbms/admin/dpart.bsq\
  ${ORACLE_HOME}/rdbms/admin/drep.bsq\
  ${ORACLE_HOME}/rdbms/admin/daw.bsq\
  ${ORACLE_HOME}/rdbms/admin/dsummgt.bsq\
  ${ORACLE_HOME}/rdbms/admin/dtools.bsq\
  ${ORACLE_HOME}/rdbms/admin/dexttab.bsq\
  ${ORACLE_HOME}/rdbms/admin/ddm.bsq\
  ${ORACLE_HOME}/rdbms/admin/dlmnr.bsq\
  ${ORACLE_HOME}/rdbms/admin/ddst.bsq\
  ${ORACLE_HOME}/rdbms/admin/dfba.bsq\
  ${ORACLE_HOME}/rdbms/admin/dpstdy.bsq\
  ${ORACLE_HOME}/rdbms/admin/drupg.bsq\
  ${ORACLE_HOME}/rdbms/admin/dtlog.bsq\
  ${ORACLE_HOME}/rdbms/admin/dmisc.bsq\
  ${ORACLE_HOME}/rdbms/admin/dhcs.bsq\
  rdbms/admin/
 RUN du -h ${ORACLE_HOME} | sort -h
 RUN echo -e 'alias "sqlplus=cd ${ORACLE_BASE}/diag/rdbms/*/${ORACLE_SID}/trace ; cd - ; ${ORACLE_HOME}/bin/sqlplus"' > ~/.bashrc
 RUN echo -e 'whenever sqlerror exit failure;\n startup nomount;\n create database;\ncreate spfile from pfile;' | ORACLE_BASE=${ORACLE_BASE} LD_LIBRARY_PATH=${ORACLE_HO
ME}/lib ORACLE_HOME=${ORACLE_HOME} ORACLE_SID=${ORACLE_SID} ${ORACLE_HOME}/bin/sqlplus / as sysdba
 ################################################################################################################
 # oracle catalog
 ################################################################################################################
 # simpler to take all files, that's only 20MB more than the required ones
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/rdbms/admin/*.sql\
  ${ORACLE_HOME}/rdbms/admin/*.plb\
  rdbms/admin/
 RUN echo -e 'startup;\n set echo on termout off\n spool /var/tmp/catalog.lst\n @?/rdbms/admin/catalog' | ORACLE_BASE=${ORACLE_BASE} LD_LIBRARY_PATH=${ORACLE_HOME}/lib
ORACLE_HOME=${ORACLE_HOME} ORACLE_SID=${ORACLE_SID} ${ORACLE_HOME}/bin/sqlplus / as sysdba
 RUN du -h ${ORACLE_BASE} | sort -u
 ################################################################################################################
 # oracle catproc
 ################################################################################################################
 RUN mkdir -p rdbms/xml
 # prvt_emx.register_files(TRUE) needs rdbms/xml
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/rdbms/xml\
  rdbms/xml
 RUN echo -e 'startup;\n set echo on termout off\n spool /var/tmp/catproc.lst\n @?/rdbms/admin/catproc' | ORACLE_BASE=${ORACLE_BASE} LD_LIBRARY_PATH=${ORACLE_HOME}/lib
ORACLE_HOME=${ORACLE_HOME} ORACLE_SID=${ORACLE_SID} ${ORACLE_HOME}/bin/sqlplus / as sysdba
 RUN du -h ${ORACLE_BASE} | sort -u
 ################################################################################################################
 # listener
 ################################################################################################################
 RUN mkdir -p bin
 COPY --from=oracle/database:18.4.0-xe --chown=oracle:oinstall\
  ${ORACLE_HOME}/bin/lsnrctl\
  ${ORACLE_HOME}/bin/tnslsnr\
  bin/
 #TODO# if we add an external volume, need to move all ?/dbs to it at start (and symlink). clonedb may help to have onlyy sparse files
 CMD ${ORACLE_HOME}/bin/lsnrctl start ; echo startup | ${ORACLE_HOME}/bin/sqlplus / as sysdba ; ${ORACLE_HOME}/bin/lsnrctl status ; tail -F ${ORACLE_BASE}/diag/*/*/*/al
ert/log.xml
 EXPOSE 1521

Of course, only limited SQL statements can be done with this. Doing more than this you will encounter an error and will have to add more files. This one, with catproc, brings the image to more than 1GB.

Minimal Oracle - 1

The Oracle Database software is large, several gigabytes in Oracle Home for the part that is deployed on the operating…

db-blog.web.cern.ch

Oracle
Docker
Small

--

--

Franck Pachot
Franck Pachot

Written by Franck Pachot

717 Followers
15 Following

Developer Advocate for YugabyteDB (Open-Source, PostgreSQL-compatible Distributed SQL Database. Oracle Certified Master and AWS Data Hero.

Responses (3)

Help

Status

About

Careers

Press

Blog

Privacy

Terms

Text to speech

Teams