Skip to content

Latest commit

 

History

History
189 lines (150 loc) · 10.2 KB

ImageDetails.md

File metadata and controls

189 lines (150 loc) · 10.2 KB
Raw

Image details

Here you can find a full description of all changes that have been made to the Oracle Database and OS installation for the various image flavors.

Oracle Database 23 Free

Full image flavor (23-full)

The full image provides an Oracle Database FREE installation "as is", meaning as provided by the RPM install file. A couple of modifications have been performed to make the installation more suitable for running inside a container.

Database settings

  • DBMS_XDB.SETLISTENERLOCALACCESS(FALSE)
  • ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS='DIAGNOSTIC+TUNING' (see gvenzl/oci-oracle-xe#112)
  • COMMON_USER_PREFIX=''
  • LOCAL_LISTENER=''
  • CPU_COUNT=2 (see gvenzl/oci-oracle-xe#64 and gvenzl/oci-oracle-xe#107)
  • An OPS$ORACLE externally identified user has been created and granted CONNECT and SELECT_CATALOG_ROLE (this is used for health check and other operations)
  • DISABLE_OOB=ON in sqlnet.ora (see gvenzl/oci-oracle-xe#43)
  • BREAK_POLL_SKIP=1000 in sqlnet.ora (see gvenzl/oci-oracle-xe#43)
  • NLS_LANG=.AL32UTF8 set for oracle user to run client sessions on DB server in UTF-8 (see gvenzl/oci-oracle-xe#109)
  • Unified Auditing is disabled for CDB and all PDBs (NOAUDIT POLICY ...)

Operating system

  • /var/log/lastlog has been cleaned
  • /usr/share/doc/ has been cleaned

Regular image flavor (23)

The regular image strives to balance between the functionality required by most users and image size. It has all customizations that the full image has and removes additional components to further decrease the image size:

Database components

  • Oracle Workspace Manager has been removed
  • Oracle Database Java Packages have been removed
  • Oracle Multimedia files have been removed ($ORACLE_HOME/ord/im)
  • Oracle XDK has been removed ($ORACLE_HOME/xdk)
  • JServer JAVA Virtual Machine has been removed ($ORACLE_HOME/javavm)
  • Java Development Kit has been removed ($ORACLE_HOME/jdk)
  • Oracle SQLcl has been removed ($ORACLE_HOME/sqlcl)
  • Oracle OLAP API has been removed ($ORACLE_HOME/olap)
  • OLAP Analytic Workspace has been removed
  • OPatch utility has been removed ($ORACLE_HOME/OPatch)
  • QOpatch utility has been removed ($ORACLE_HOME/QOpatch)
  • Oracle Database Assistants have been removed ($ORACLE_HOME/assistants)
  • The inventory directory has been removed ($ORACLE_HOME/inventory)
  • JDBC drivers have been removed ($ORACLE_HOME/jdbc, $ORACLE_HOME/jlib)
  • Universal Connection Pool driver has been removed ($ORACLE_HOME/ucp)
  • Intel Math Kernel libraries have been removed ($ORACLE_HOME/lib/libmkl_*)
  • Zip files in lib/ have been removed ($ORACLE_HOME/lib/*.zip)
  • Jar files in lib/ have been removed ($ORACLE_HOME/lib/*.jar)
  • Old timezone files have been removed ($ORACLE_HOME/oracore/zoneinfo/* except the current timezone file)
  • Additional Java libraries have been removed ($ORACLE_HOME/rdbms/jlib)
  • The Cluster Ready Services directory has been removed ($ORACLE_HOME/crs)
  • The Cluster Verification Utility directory has been removed ($ORACLE_HOME/cv)
  • The install directory has been emptied, except orabasetab ($ORACLE_HOME/install)
  • The network/jlib directory has been removed ($ORACLE_HOME/network/jlib)
  • The network/tools directory has been removed ($ORACLE_HOME/network/tools)
  • The Oracle Process Manager and Notification directory has been removed ($ORACLE_HOME/opmn)
  • The Oracle Machine Learning 4 Python directory has been removed ($ORACLE_HOME/oml4py)
  • Python has been removed ($ORACLE_HOME/python)
  • The sdk directory has been removed ($ORACLE_HOME/sdk)
  • Replay Upgrade has been removed (pdb_sync$ table cleaned up in CDB$ROOT)
Database binaries

The following binaries have been removed from the $ORACLE_HOME/bin directory:

  • $ORACLE_HOME/bin/acfs* (ACFS File system components)
  • $ORACLE_HOME/bin/adapters (Protocol Adapters shell script)
  • $ORACLE_HOME/bin/adrci (Automatic Diagnostic Repository Command Interpreter)
  • $ORACLE_HOME/bin/afd* (ASM Filter Drive components)
  • $ORACLE_HOME/bin/agtctl (Multi-Threaded extproc agent control utility)
  • $ORACLE_HOME/bin/ahfctl (Autonomous Health Framework control utility)
  • $ORACLE_HOME/bin/amdu (ASM Disk Utility)
  • $ORACLE_HOME/bin/asm* (ASM command line utility and library)
  • $ORACLE_HOME/bin/bdschecksw (Oracle Big Data Sql CHECK SoftWare utility)
  • $ORACLE_HOME/bin/cluvfy* (Grid Infrastructure cluster verify command)
  • $ORACLE_HOME/bin/CommonSetup.pm (Common Setup scripts)
  • $ORACLE_HOME/bin/commonSetup.sh (Common Setup scripts)
  • $ORACLE_HOME/bin/coraenv (C shell oraenv user environment script)
  • $ORACLE_HOME/bin/dg4* (Database Gateway)
  • $ORACLE_HOME/bin/dgmgrl (Data Guard Manager CLI)
  • $ORACLE_HOME/bin/diskmon (Disk Monitor)
  • $ORACLE_HOME/bin/dumpsga (Dump System Global Area (SGA) utility)
  • $ORACLE_HOME/bin/dbnest* (DataBase NEST)
  • $ORACLE_HOME/bin/lxegen (NLS Calendar Utility)
  • $ORACLE_HOME/bin/mapsga (SGA Dump mapping tool)
  • $ORACLE_HOME/bin/orion (ORacle IO Numbers benchmark tool)
  • $ORACLE_HOME/bin/oms_daemon (Oracle Memory Speed (PMEM support) daemon)
  • $ORACLE_HOME/bin/omsfscmds (Oracle Memory Speed command line utility)
  • $ORACLE_HOME/bin/proc (Pro*C/C++ Precompiler)
  • $ORACLE_HOME/bin/procob (Pro COBOL Precompiler)
  • $ORACLE_HOME/bin/renamedg (Rename Disk Group binary)
  • $ORACLE_HOME/bin/x* (XML related binaries)

The following binaries have been replaced by shell scripts with static output:

  • orabase
  • orabasehome
  • orabaseconfig
Database libraries

The following libraries have been removed from the $ORACLE_HOME/lib directory:

  • $ORACLE_HOME/lib/libopc.so (Oracle Public Cloud)
  • $ORACLE_HOME/lib/libosbws.so (Oracle Secure Backup Cloud Module)
  • $ORACLE_HOME/lib/libra.so (Recovery Appliance)

Database settings

  • The DEFAULT profile has the following set:
    • FAILED_LOGIN_ATTEMPTS=UNLIMITED
    • PASSWORD_LIFE_TIME=UNLIMITED
  • SHARED_SERVERS=0

Operating system

  • The following Linux packages are not installed:
    • glibc-devel
    • glibc-headers
    • kernel-headers
    • libpkgconf
    • libxcrypt-devel
    • pkgconf
    • pkgconf-m4
    • pkgconf-pkg-config
    • util-linux

Slim image flavor (23-slim)

The slim images aims for smallest possible image size with only the Oracle Database relational components. It has all customizations that the regular image has and removes all non-relational components (where possible) to further decrease the image size:

Database components

  • Oracle Multilingual Engine has been disabled and removed ($ORACLE_HOME/lib/libmle.so)
  • Oracle Text has been uninstalled and removed ($ORACLE_HOME/ctx)
  • Oracle Spatial has been uninstalled and removed ($ORACLE_HOME/md)
  • Oracle Locator has been uninstalled and removed ($ORACLE_HOME/md)
  • The demo samples directory has been removed ($ORACLE_HOME/demo)
  • ODBC driver samples have been removed ($ORACLE_HOME/odbc)
  • TNS demo samples have been removed ($ORACLE_HOME/network/admin/samples)
  • NLS LBuilder directory has been removed ($ORACLE_HOME/nls/lbuilder)
  • The hs directory has been removed ($ORACLE_HOME/hs)
  • The precomp directory has been removed ($ORACLE_HOME/precomp)
  • The rdbms/public directory has been removed ($ORACLE_HOME/rdbms/public)
  • The rdbms/xml directory has been removed ($ORACLE_HOME/rdbms/xml)
  • The ord directory has been removed ($ORACLE_HOME/ord)
  • Oracle R has been removed ($ORACLE_HOME/R)
  • The deinstall directory has been removed ($ORACLE_HOME/deinstall)
  • The Oracle Universal installer has been removed ($ORACLE_HOME/oui)
  • Perl has been removed ($ORACLE_HOME/perl)
Database binaries

The following binaries have been removed from the $ORACLE_HOME/bin directory:

  • $ORACLE_HOME/bin/ctx* (Oracle Text binaries)
  • $ORACLE_HOME/bin/cursize (Cursor Size binary)
  • $ORACLE_HOME/bin/dbfs* (DataBase File System)
  • $ORACLE_HOME/bin/ORE (Oracle R Enterprise)
  • $ORACLE_HOME/bin/rman (Oracle Recovery Manager)
  • $ORACLE_HOME/bin/wrap (PL/SQL Wrapper)
Database libraries

The following libraries have been removed from the $ORACLE_HOME/lib directory:

  • $ORACLE_HOME/lib/asm* (Oracle Automatic Storage Management)
  • $ORACLE_HOME/lib/libmle.so (Multilingual Engine)
  • $ORACLE_HOME/lib/libolapapi.so (Oracle OLAP API)
  • $ORACLE_HOME/lib/ore.so (Oracle R Enterprise)

Operating system

  • The following Linux packages are not installed:
    • findutils
    • less
    • vim-minimal

Fast start image flavor (*-faststart)

The *-faststart images contain already expanded database files inside the image. Their aim is to provide a faster container/database startup time by trading off on the image size. These images are larger on disk due to the non-compressed database files inside them. All the functionality provided by them are, however, identical to their non-faststart siblings. It is also important to understand that container images are, in general, always pulled/pushed compressed over the network. The compressed size is of these images is not substantially larger than the non-faststart images as the compression method inside the non-faststart images is fairly similar to the one used by the container runtime. Additionally, these images are based on the non-faststart images, meaning that they only add one additional layer on top of the non-faststart images with expanded database data files. This leads to two benefits:

  1. Only the third/additional layer needs to be pulled if the non-faststart images are already present on the system.
  2. Container runtimes are usually capable to pull multiple layers in parallel, meaning that the third layer will be pulled concurrently with the other layers. If there is enough network bandwidth available, the download time will not significantly increase compared to the non-faststart images.