docker-images icon indicating copy to clipboard operation
docker-images copied to clipboard

Oracle Free docker images start up failure!

Open Haibarapink opened this issue 11 months ago • 2 comments

I follew these steps:

  1. sudo docker pull container-registry.oracle.com/database/free:latest
sudo docker run -d \
 -p 1521:1521 \
 -p 5500:5500 \
 -e ORACLE_PWD=123456 \
 --name oracle-free \
 container-registry.oracle.com/database/free:latest
  1. sudo docker exec -it --user root 6c5f5d21bd1d bash
  2. sqlplus sys/123456@//localhost:1521/FREEPDB1 as sysdba

and this is what happend on terminal:


SQL*Plus: Release 23.0.0.0.0 - Production on Mon May 12 07:19:02 2025
Version 23.8.0.25.04

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

ERROR:
ORA-12514: Cannot connect to database. Service FREEPDB1 is not registered with
the listener at host 127.0.0.1 port 1521.
(CONNECTION_ID=NOwhYZm6GTngYwMAEaxk1Q==)
Help: https://docs.oracle.com/error-help/db/ora-12514/

Docker log

  • status: unhealthy

cat: /sys/fs/cgroup/memory.max: No such file or directory Starting Oracle Net Listener. Oracle Net Listener started. Starting Oracle Database instance FREE. Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle

SQL*Plus: Release 23.0.0.0.0 - Production on Mon May 12 03:09:34 2025 Version 23.8.0.25.04

Copyright (c) 1982, 2025, Oracle. All rights reserved.

Connected to an idle instance.

SQL> ALTER USER SYS IDENTIFIED BY "123456" * ERROR at line 1: ORA-01034: The Oracle instance is not available for use. Start the instance. Process ID: 0 Session ID: 0 Serial number: 0 Help: https://docs.oracle.com/error-help/db/ora-01034/

SQL> ALTER USER SYSTEM IDENTIFIED BY "123456" * ERROR at line 1: ORA-01034: The Oracle instance is not available for use. Start the instance. Process ID: 0 Session ID: 0 Serial number: 0 Help: https://docs.oracle.com/error-help/db/ora-01034/

SQL> ALTER SESSION SET CONTAINER=FREEPDB1 * ERROR at line 1: ORA-01034: The Oracle instance is not available for use. Start the instance. Process ID: 0 Session ID: 0 Serial number: 0 Help: https://docs.oracle.com/error-help/db/ora-01034/

SQL> ALTER USER PDBADMIN IDENTIFIED BY "123456" * ERROR at line 1: ORA-01034: The Oracle instance is not available for use. Start the instance. Process ID: 0 Session ID: 0 Serial number: 0 Help: https://docs.oracle.com/error-help/db/ora-01034/

SQL> Disconnected The Oracle base remains unchanged with value /opt/oracle ##################################### ########### E R R O R ############### DATABASE SETUP WAS NOT SUCCESSFUL! Please check output for further info! ########### E R R O R ############### ##################################### The following output is now a tail of the alert.log: db_name = "FREE" open_cursors = 300 pga_aggregate_target = 512M diagnostic_dest = "/opt/oracle" enable_pluggable_database= TRUE 2025-05-12T03:09:34.390926+00:00 Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_36.trc: ORA-27180: failed to create memory protection key Linux-x86_64 Error: 1: Operation not permitted Additional information: 16736

Haibarapink avatar May 12 '25 07:05 Haibarapink

@Haibarapink there is a known issue with the Free image that causes the following error

Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_36.trc: ORA-27180: failed to create memory protection key Linux-x86_64 Error: 1: Operation not permitted

A fix will be released soon

Please try the free lite image

container-registry.oracle.com/database/free:latest-lite

yunus-qureshi avatar May 29 '25 13:05 yunus-qureshi

@Haibarapink paste the output of "docker info" from your env

yunus-qureshi avatar Jun 05 '25 04:06 yunus-qureshi

I have the same issue with free:latest (a.k.a. 23.8.0.0) image a06de2558e27 (on same machine where 23.7.0.0 works fine

"compose.yml":

services:
  oracle-free:
    container_name: oracle-free-latest
    image: container-registry.oracle.com/database/free:latest
    environment:
      ORACLE_PWD: ${ORACLE_PWD}
    ports:
      - "1522:1521"
    restart: always

result of "podman-compose up -d":

['podman', '--version', '']
using podman version: 4.3.1
** excluding:  set()
['podman', 'network', 'exists', 'oracle-free-latest_default']
podman run --name=oracle-free-latest -d --label io.podman.compose.config-hash=123 --label io.podman.compose.project=oracle-free-latest --label io.podman.compose.version=0.0.1 --label com.docker.compose.project=oracle-free-latest --label com.docker.compose.project.working_dir=/home/roman/pod/oracle-free-latest --label com.docker.compose.project.config_files=compose.yml --label com.docker.compose.container-number=1 --label com.docker.compose.service=oracle-free -e ORACLE_PWD=O0r5acle4Fr5e4e4 --net oracle-free-latest_default --network-alias oracle-free -p 1522:1521 --restart always container-registry.oracle.com/database/free:latest
125e8089e228843f7075518ca4e714ababd3c72904b56ed94fec5afda0ac27d8
exit code: 0
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle

SQL*Plus: Release 23.0.0.0.0 - Production on Wed Jun 18 14:31:41 2025
Version 23.8.0.25.04

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>       ALTER USER SYS IDENTIFIED BY "password"
*
ERROR at line 1:
ORA-01034: The Oracle instance is not available for use. Start the instance.
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01034/


SQL>       ALTER USER SYSTEM IDENTIFIED BY "password"
*
ERROR at line 1:
ORA-01034: The Oracle instance is not available for use. Start the instance.
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01034/


SQL>       ALTER SESSION SET CONTAINER=FREEPDB1
*
ERROR at line 1:
ORA-01034: The Oracle instance is not available for use. Start the instance.
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01034/


SQL>       ALTER USER PDBADMIN IDENTIFIED BY "password"
*
ERROR at line 1:
ORA-01034: The Oracle instance is not available for use. Start the instance.
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01034/


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_51.trc  (incident=9611) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [], [], [], [], []
ORA-27302: failure occurred at: sskgm_mga_at
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_9611/FREE_ora_51_i9611.trc
2025-06-18T14:31:41.150011+00:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
--ATTENTION--
USER(prelim) (ospid: 51): terminating the instance due to ORA error 27781
Instance terminated by USER(prelim), PID = 51

content of /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_XX.trc

Trace file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_49.trc
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.8.0.25.04
Build label:    RDBMS_23.8.0.25.04DBRU_LINUX.ARM64_250423
ORACLE_HOME:    /opt/oracle/product/23ai/dbhomeFree
System name:    Linux
Node name:      3c6472c470ca
Release:        6.12.25+rpt-rpi-v8
Version:        #1 SMP PREEMPT Debian 1:6.12.25-1+rpt1 (2025-04-30)
Machine:        aarch64
Storage:        ?
CLID:   U
Instance name: FREE
Instance number: 0 <none>
Database name: N/A
Database unique name: N/A
Database id: N/A
Database role: N/A
Redo thread mounted by this instance: 0 <none>
Oracle binary inode:    <none>
Oracle process number: 0
Unix process pid:       49
             created:   2025-06-18T14:40:51.127000+00:00
             image:


*** 2025-06-18T14:40:52.510533+00:00
SGA (id: 1) creation time at startup: 1 ms
sksxp_get_netcaps: no CI IPs
2025-06-18 14:40:52.535 : [    GPNP][    GPNP]  clsgpnp_Init init failed. Error: CLSGPNP_ERR (1) .
2025-06-18 14:40:52.538 : [ CLSINET][ CLSINET]  Failed to initialize clsgpnp context grv 1
2025-06-18 14:40:52.540 : [    GPNP][    GPNP]  clsgpnp_Init init failed. Error: CLSGPNP_ERR (1) .
2025-06-18 14:40:52.542 : [ CLSINET][ CLSINET]  Failed to initialize clsgpnp context grv 1
sksxp_get_netcaps: no KGGPNP IPs
Lockdown sysfs /sys/kernel/security/lockdown doesn't exist. Set to default KSCXCAPTYPEKERNELSEC_NONE
KSIPC: KSIPC SERVICE ENV 0x0
KSIPC SERVICE MASK MGAON:[INETOFF]:[IPCLWON]:[GRPAM]:[PRON]:[TOPOON]:[DLLON]:[KSGLOFF][RSTFWOFF]:[RDMAPINGON]:[SHREGON]:MEMCBON:[STATSFWON]:[SNOFF]:[DGOFF]:[ORDNFY]:[RDSTCPBSON][SHREGODPON]:[SIGSAFEON]:[THRPOOLON]:[VNICOFF]
2025-06-18 14:40:52.628906 : fsd_notify_cb: FsDirect not implemented
KSNMON: Initial Config: enable=0x7fffffff, maxflow=65535, minstsint=5000
KSNMON: Runtime Config: service enabled=0x3ff
kcrlnfy: Enable RFS client   [kcrlc.c:609]
kcrfwy: minimum sleep (disk) is 1054 usecs (overhead is 54 usecs)
init table done
Running with 1 strand for Non-Enterprise Edition
Running without dynamic strands for Non-Enterprise Edition
NOTE: Cluster configuration type = NONE [2]
KSTRCB: Initializing MGA.
failed : OER--1 errno 12 mmap sskgm_mga_at
failed: OER--1 errno 12 mmap sskgm_mga_at
2025-06-18T14:40:52.825127+00:00
Incident 11219 created, dump file: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_11219/FREE_ora_49_i11219.trc
ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [], [], [], [], []
ORA-27302: failure occurred at: sskgm_mga_at


*** 2025-06-18T14:40:54.350871+00:00 (CDB$ROOT(1))
USER(prelim) (ospid: 49): terminating the instance due to ORA error 27781
Instance terminated by USER(prelim), pid = 49KJHA:2phase 010 opi_error:27781

result of "podman info"

host:
  arch: arm64
  buildahVersion: 1.28.2
  cgroupControllers:
  - cpu
  - memory
  - pids
  cgroupManager: systemd
  cgroupVersion: v2
  conmon:
    package: conmon_2.1.6+ds1-1_arm64
    path: /usr/bin/conmon
    version: 'conmon version 2.1.6, commit: unknown'
  cpuUtilization:
    idlePercent: 99.14
    systemPercent: 0.27
    userPercent: 0.59
  cpus: 4
  distribution:
    codename: bookworm
    distribution: debian
    version: "12"
  eventLogger: journald
  hostname: raspberry
  idMappings:
    gidmap:
    - container_id: 0
      host_id: 1000
      size: 1
    - container_id: 1
      host_id: 100000
      size: 65536
    uidmap:
    - container_id: 0
      host_id: 1000
      size: 1
    - container_id: 1
      host_id: 100000
      size: 65536
  kernel: 6.12.25+rpt-rpi-v8
  linkmode: dynamic
  logDriver: journald
  memFree: 2474729472
  memTotal: 16781901824
  networkBackend: netavark
  ociRuntime:
    name: crun
    package: crun_1.8.1-1+deb12u1_arm64
    path: /usr/bin/crun
    version: |-
      crun version 1.8.1
      commit: f8a096be060b22ccd3d5f3ebe44108517fbf6c30
      rundir: /run/user/1000/crun
      spec: 1.0.0
      +SYSTEMD +SELINUX +APPARMOR +CAP +SECCOMP +EBPF +YAJL
  os: linux
  remoteSocket:
    path: /run/user/1000/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.0-1_arm64
    version: |-
      slirp4netns version 1.2.0
      commit: 656041d45cfca7a4176f6b7eed9e4fe6c11e8383
      libslirp: 4.7.0
      SLIRP_CONFIG_VERSION_MAX: 4
      libseccomp: 2.5.4
  swapFree: 536342528
  swapTotal: 536866816
  uptime: 2h 34m 28.00s (Approximately 0.08 days)
plugins:
  authorization: null
  log:
  - k8s-file
  - none
  - passthrough
  - journald
  network:
  - bridge
  - macvlan
  volume:
  - local
registries: {}
store:
  configFile: /home/user/.config/containers/storage.conf
  containerStore:
    number: 1
    paused: 0
    running: 0
    stopped: 1
  graphDriverName: overlay
  graphOptions: {}
  graphRoot: /home/user/.local/share/containers/storage
  graphRootAllocated: 251552567296
  graphRootUsed: 81519652864
  graphStatus:
    Backing Filesystem: extfs
    Native Overlay Diff: "true"
    Supports d_type: "true"
    Using metacopy: "false"
  imageCopyTmpDir: /var/tmp
  imageStore:
    number: 25
  runRoot: /run/user/1000/containers
  volumePath: /home/user/.local/share/containers/storage/volumes
version:
  APIVersion: 4.3.1
  Built: 0
  BuiltTime: Thu Jan  1 01:00:00 1970
  GitCommit: ""
  GoVersion: go1.19.8
  Os: linux
  OsArch: linux/arm64
  Version: 4.3.1

roman-lautenschlager avatar Jun 18 '25 14:06 roman-lautenschlager

Please try with 26ai Free

yunus-qureshi avatar Nov 11 '25 07:11 yunus-qureshi