su command in line 256 of runOracle.sh.orig prevents database from starting on rootless podman

[martin-bach-oracle]

The latest Oracle Database Free image hosted on https://container-registry.oracle.com/ords/ocr/ba/database/free fails to start due to a change in /opt/oracle/runOracle.sh.orig, line 256 unless the container is started as root.

Podman starts containers in rootless mode by default. The su command therefore cannot work by definition. The user is prompted for a password (which is of course unknown) in interactive mode. /etc/init.d/oracle-free-23ai start isn't executed, and all subsequent steps fail since the database isn't available.

Kindly revert the change to allow users to run the image without requiring root privileges.

[martin-bach-oracle]

issue filed against the wrong repository

[yunus-qureshi]

Is the host OS, OL8 or 9?

@martin-bach-oracle paste the output of "podman info" command from your env

[martin-bach-oracle]

Hi @yunus-qureshi I ran a few more tests. I am using Ubuntu 24.04 and Linux Mint 22, and that's where you get the issue.

ubuntu@demohost:~$ podman run --rm -it --name dropme -e ORACLE_PWD=welcome123 container-registry.oracle.com/database/free:latest
Trying to pull container-registry.oracle.com/database/free:latest...
Getting image source signatures
Copying blob 67273d20686c done   | 
Copying blob 3c19df83dc53 done   | 
Copying blob 769e9048b21f done   | 
Copying blob 7ce287ddcf02 done   | 
Copying blob 18c61db4fa1a done   | 
Copying blob fb5a2405efd1 done   | 
Copying blob 60b151ee286c done   | 
Copying blob 2848595a8195 done   | 
Copying blob 7cddbcf7b07f done   | 
Copying blob a723d4eb80ab done   | 
Copying blob 4be01f5508ce done   | 
Copying blob 2b69d3f60317 done   | 
Copying blob c321a0e5c325 done   | 
Copying blob 376386880722 done   | 
Copying blob 11a1c1f55c59 done   | 
Copying blob 09677a4c8b1d done   | 
Copying blob 8324f2f6589b done   | 
Copying blob da1698473041 done   | 
Copying blob 954a67596b3b done   | 
Copying blob 836b5e4a0439 done   | 
Copying blob 1ed5527365e9 done   | 
Copying blob 9339d36e49cd done   | 
Copying config 98201d89c4 done   | 
Writing manifest to image destination
Password: 

Here are the details concerning Podman on Ubuntu 24.04 LTS:

ubuntu@demohost:~$ podman info
host:
  arch: amd64
  buildahVersion: 1.33.7
  cgroupControllers:
  - cpu
  - memory
  - pids
  cgroupManager: systemd
  cgroupVersion: v2
  conmon:
    package: conmon_2.1.10+ds1-1build2_amd64
    path: /usr/bin/conmon
    version: 'conmon version 2.1.10, commit: unknown'
  cpuUtilization:
    idlePercent: 95.42
    systemPercent: 1.4
    userPercent: 3.18
  cpus: 4
  databaseBackend: sqlite
  distribution:
    codename: noble
    distribution: ubuntu
    version: "24.04"
  eventLogger: journald
  freeLocks: 2047
  hostname: demohost
  idMappings:
    gidmap:
    - container_id: 0
      host_id: 1001
      size: 1
    - container_id: 1
      host_id: 165536
      size: 65536
    uidmap:
    - container_id: 0
      host_id: 1001
      size: 1
    - container_id: 1
      host_id: 165536
      size: 65536
  kernel: 6.8.0-1026-oracle
  linkmode: dynamic
  logDriver: journald
  memFree: 22183972864
  memTotal: 33650634752
  networkBackend: netavark
  networkBackendInfo:
    backend: netavark
    dns:
      package: aardvark-dns_1.4.0-5_amd64
      path: /usr/lib/podman/aardvark-dns
      version: aardvark-dns 1.4.0
    package: netavark_1.4.0-4_amd64
    path: /usr/lib/podman/netavark
    version: netavark 1.4.0
  ociRuntime:
    name: crun
    package: crun_1.14.1-1_amd64
    path: /usr/bin/crun
    version: |-
      crun version 1.14.1
      commit: de537a7965bfbe9992e2cfae0baeb56a08128171
      rundir: /run/user/1001/crun
      spec: 1.0.0
      +SYSTEMD +SELINUX +APPARMOR +CAP +SECCOMP +EBPF +WASM:wasmedge +YAJL
  os: linux
  pasta:
    executable: /usr/bin/pasta
    package: passt_0.0~git20240220.1e6f92b-1_amd64
    version: |
      pasta unknown version
      Copyright Red Hat
      GNU General Public License, version 2 or later
        <https://www.gnu.org/licenses/old-licenses/gpl-2.0.html>
      This is free software: you are free to change and redistribute it.
      There is NO WARRANTY, to the extent permitted by law.
  remoteSocket:
    exists: false
    path: /run/user/1001/podman/podman.sock
  security:
    apparmorEnabled: false
    capabilities: CAP_CHOWN,CAP_DAC_OVERRIDE,CAP_FOWNER,CAP_FSETID,CAP_KILL,CAP_NET_BIND_SERVICE,CAP_SETFCAP,CAP_SETGID,CAP_SETPCAP,CAP_SETUID,CAP_SYS_CHROOT
    rootless: true
    seccompEnabled: true
    seccompProfilePath: /usr/share/containers/seccomp.json
    selinuxEnabled: false
  serviceIsRemote: false
  slirp4netns:
    executable: /usr/bin/slirp4netns
    package: slirp4netns_1.2.1-1build2_amd64
    version: |-
      slirp4netns version 1.2.1
      commit: 09e31e92fa3d2a1d3ca261adaeb012c8d75a8194
      libslirp: 4.7.0
      SLIRP_CONFIG_VERSION_MAX: 4
      libseccomp: 2.5.5
  swapFree: 0
  swapTotal: 0
  uptime: 0h 13m 11.00s
  variant: ""
plugins:
  authorization: null
  log:
  - k8s-file
  - none
  - passthrough
  - journald
  network:
  - bridge
  - macvlan
  - ipvlan
  volume:
  - local
registries: {}
store:
  configFile: /home/ubuntu/.config/containers/storage.conf
  containerStore:
    number: 1
    paused: 0
    running: 1
    stopped: 0
  graphDriverName: overlay
  graphOptions: {}
  graphRoot: /home/ubuntu/.local/share/containers/storage
  graphRootAllocated: 258906374144
  graphRootUsed: 11230990336
  graphStatus:
    Backing Filesystem: extfs
    Native Overlay Diff: "true"
    Supports d_type: "true"
    Supports shifting: "false"
    Supports volatile: "true"
    Using metacopy: "false"
  imageCopyTmpDir: /var/tmp
  imageStore:
    number: 1
  runRoot: /run/user/1001/containers
  transientStore: false
  volumePath: /home/ubuntu/.local/share/containers/storage/volumes
version:
  APIVersion: 4.9.3
  Built: 0
  BuiltTime: Thu Jan  1 00:00:00 1970
  GitCommit: ""
  GoVersion: go1.22.2
  Os: linux
  OsArch: linux/amd64
  Version: 4.9.3

[andersnorgaard]

Sounds like the same thing observed in #2925

[yunus-qureshi]

We targeting to fix this for the next drop