search

gvenzl / oci-oracle-free

Build scripts for Oracle Database FREE container/docker images
Apache License 2.0
127 stars 32 forks source link

Update to full image fails #54

Closed DlouhyDavid closed 1 month ago

DlouhyDavid commented 2 months ago

I encountered an issue when switching from gvenzl/oracle-free:23-slim to gvenzl/oracle-free:23-full in my docker-compose.yml. The gvenzl/oracle-free:23 image works fine, but when using gvenzl/oracle-free:23-full, the following issue occurs during startup:

Contianer Logs

oracle-db  | CONTAINER: starting up...
oracle-db  | CONTAINER: database already initialized.
oracle-db  | CONTAINER: starting up Oracle Database...
oracle-db  | 
oracle-db  | LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 15-JUL-2024 09:12:41
oracle-db  | 
oracle-db  | Copyright (c) 1991, 2024, Oracle.  All rights reserved.
oracle-db  | 
oracle-db  | Starting /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr: please wait...
oracle-db  | 
oracle-db  | TNSLSNR for Linux: Version 23.0.0.0.0 - Production
oracle-db  | System parameter file is /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
oracle-db  | Log messages written to /opt/oracle/diag/tnslsnr/05af75365663/listener/alert/log.xml
oracle-db  | Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))
oracle-db  | Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
oracle-db  | 
oracle-db  | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_FREE)))
oracle-db  | STATUS of the LISTENER
oracle-db  | ------------------------
oracle-db  | Alias                     LISTENER
oracle-db  | Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - Production
oracle-db  | Start Date                15-JUL-2024 09:12:43
oracle-db  | Uptime                    0 days 0 hr. 0 min. 0 sec
oracle-db  | Trace Level               off
oracle-db  | Security                  ON: Local OS Authentication
oracle-db  | SNMP                      OFF
oracle-db  | Default Service           FREE
oracle-db  | Listener Parameter File   /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
oracle-db  | Listener Log File         /opt/oracle/diag/tnslsnr/05af75365663/listener/alert/log.xml
oracle-db  | Listening Endpoints Summary...
oracle-db  |   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))
oracle-db  |   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
oracle-db  | The listener supports no services
oracle-db  | The command completed successfully
oracle-db  | ORA-00443: background process "OFSD" did not start

Listener Log

<msg time='2024-07-15T09:12:19.157+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>
LISTENER for Linux: Version 23.0.0.0.0 - Production 
Version 23.4.0.24.5

 </txt>
</msg>
<msg time='2024-07-15T09:12:19.158+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>System parameter file is /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.158+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Log messages written to /opt/oracle/diag/tnslsnr/05af75365663/listener/alert/log.xml
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.158+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Trace information written to /opt/oracle/diag/tnslsnr/05af75365663/listener/trace/ora_31_139850192497600.trc
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.158+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Trace level is currently 0
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.158+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.159+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>(PARAMETER LIST)
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.159+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>
    (Default Service for LISTENER=FREE)

 </txt>
</msg>
<msg time='2024-07-15T09:12:19.160+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Listener running inside a container 
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.160+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Started with pid=31
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.162+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_FREE)))
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.162+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.199+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>Listener completed notification to CRS on start
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.200+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.200+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2024-07-15T09:12:19.202+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='05af75365663'
 host_addr='172.18.0.2' pid='31' seclabel='3'>
 <txt>15-JUL-2024 09:12:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=05af75365663)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=385875968)(CONNECTION_ID=HUagLMKvABbgYwIAEqztWQ==)) * status * 0
 </txt>
</msg>

Additional Information

Any help or insights to resolve this issue would be greatly appreciated. Thank you!

gvenzl commented 1 month ago

Hey @DlouhyDavid,

Thanks for using these images!

Hm, it appears a background process doesn't manage to start up. Could you please share the details on which environment you are trying to run the container as well as the output of the alert.log (found in /opt/oracle/diag/rdbms/free/FREE/trace)

DlouhyDavid commented 1 month ago

Hi @gvenzl,

Thanks for your reply. Below are the requested details:

Information about the system

Architecture:        x86_64
CPU op-mode(s):      32-bit, 64-bit
Byte Order:          Little Endian
Address sizes:       45 bits physical, 48 bits virtual
CPU(s):              2
On-line CPU(s) list: 0,1
Thread(s) per core:  1
Core(s) per socket:  1
Socket(s):           2
NUMA node(s):        1
Vendor ID:           GenuineIntel
CPU family:          6
Model:               85
Model name:          Intel(R) Xeon(R) Gold 6254 CPU @ 3.10GHz
Stepping:            7
CPU MHz:             3092.734
BogoMIPS:            6185.46
Hypervisor vendor:   VMware
Virtualization type: full
L1d cache:           32K
L1i cache:           32K
L2 cache:            1024K
L3 cache:            25344K
NUMA node0 CPU(s):   0,1
Flags:               fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch cpuid_fault invpcid_single ssbd ibrs ibpb stibp ibrs_enhanced fsgsbase tsc_adjust bmi1 avx2 smep bmi2 invpcid avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 xsaves arat pku ospke avx512_vnni md_clear flush_l1d arch_capabilities

Contents of the file /opt/oracle/diag/rdbms/free/FREE/trace/alert_FREE.log:

Adjusting the default value of parameter "parallel_max_servers" from 0 to 1.
PARALLEL_MAX_SERVERS (with value 1) is insufficient. This may affect transaction recovery performance.
Stored outlines will be desupported in the next release.
Starting ORACLE instance (normal) (OS id: 27)
2024-07-22T06:09:59.000637+00:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2024-07-22T06:09:59.001719+00:00
**********************************************************************
2024-07-22T06:09:59.001763+00:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2024-07-22T06:09:59.001829+00:00
 Domain name: docker/ff30460460718a614781b132c3a7c3fb55cb6ce31c7c9539a3cfca94f37f6e91
2024-07-22T06:09:59.001868+00:00
 Per process system memlock (soft) limit = 64K
2024-07-22T06:09:59.001924+00:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 1532M
2024-07-22T06:09:59.002001+00:00
 Available system pagesizes:
  4K, 2048K 
2024-07-22T06:09:59.002075+00:00
 Supported system pagesize(s):
2024-07-22T06:09:59.002113+00:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2024-07-22T06:09:59.002153+00:00
        4K       Configured               5           391540        NONE
2024-07-22T06:09:59.002214+00:00
     2048K                0             766                0        NONE
2024-07-22T06:09:59.002253+00:00
RECOMMENDATION:
2024-07-22T06:09:59.002321+00:00
 1. For optimal performance, configure system with expected number 
 of pages for every supported system pagesize prior to the next 
 instance restart operation.
2024-07-22T06:09:59.002431+00:00
 2. Increase per process memlock (soft) limit to at least 1532MB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
2024-07-22T06:09:59.002509+00:00
**********************************************************************
Using an SGA granule size of 16MB
Memory protection keys NOT enabled.
Hugetlbfs Dynamic SGA NOT enabled.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/23ai/dbhomeFree/dbs/arch
.... (PID:): Enable RFS client   [kcrlc.c:609]
Autotune of undo retention is turned on. 
Log buffer boundaries=(0xc0000000, 0xc0452000)
IMODE=BR
ILAT =35
2024-07-22T06:10:22.699597+00:00
NOTE: Using default ASM root directory ASM
2024-07-22T06:10:25.046531+00:00
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05.
ORACLE_HOME:    /opt/oracle/product/23ai/dbhomeFree
System name:    Linux
Node name:      ff3046046071
Release:        4.19.0-26-amd64
Version:        #1 SMP Debian 4.19.304-1 (2024-01-09)
Machine:        x86_64
Using parameter settings in server-side spfile /opt/oracle/product/23ai/dbhomeFree/dbs/spfileFREE.ora
System parameters with non-default values:
  processes                = 200
  cpu_count                = "2"
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  sga_target               = 1536M
  control_files            = "/opt/oracle/oradata/FREE/control01.ctl"
  control_files            = "/opt/oracle/oradata/FREE/control02.ctl"
  db_block_size            = 8192
  compatible               = "23.0.0"
  _instance_recovery_bloom_filter_size= 1048576
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=FREEXDB)"
  shared_servers           = 0
  local_listener           = ""
  job_queue_processes      = 1
  db_name                  = "FREE"
  open_cursors             = 300
  pga_aggregate_target     = 512M
  _dmm_blas_library        = "libora_netlib.so"
  control_management_pack_access= "DIAGNOSTIC+TUNING"
  spatial_vector_acceleration= FALSE
  diagnostic_dest          = "/opt/oracle"
  enable_pluggable_database= TRUE
  common_user_prefix       = ""
  mle_prog_languages       = "OFF"
2024-07-22T06:10:25.902171+00:00
Oracle instance running with ODM in SGA: Oracle File Server ODM Library, Version: 1.0 
Oracle instance running with ODM in SGA: FSDirect ODM Library Version 1.0 
Oracle instance running with ODM in SGA: Object Store ODM Library Version 8.0 
Broadcast on commit is enabled and is using Message mode.
2024-07-22T06:11:16.456988+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_vktm_42.trc  (incident=41) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_41/FREE_vktm_42_i41.trc
--ATTENTION--
The priority of process VKTM cannot be elevated.

Failed to elevate VKTM's priority from 0 to 1, policy 5
Error : Category(-2), Opname(skgdism_create), Loc(sp.c:setpr:1), ErrMsg(Error 0) Dism(16)
2024-07-22T06:14:43.903833+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_gen0_48.trc  (incident=49) (PDBNAME=CDB$ROOT):
ORA-00445: background process "SA00" did not start after 120 seconds
2024-07-22T06:14:52.820180+00:00
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_49/FREE_gen0_48_i49.trc
2024-07-22T06:16:10.675860+00:00
--ATTENTION--
2024-07-22T06:16:55.107659+00:00
Using default pga_aggregate_limit of 2048 MB
2024-07-22T06:17:01.076426+00:00
Time drifted forward by (1043293) micro seconds at 3436684671088 whereas allowed drift is 1000000
2024-07-22T06:17:05.168909+00:00
--ATTENTION--
2024-07-22T06:17:37.177074+00:00
Time drifted forward by (64000000) micro seconds at 1721629023 whereas allowed drift is 5000000
2024-07-22T06:17:38.078129+00:00
--ATTENTION--
2024-07-22T06:17:42.381220+00:00
--ATTENTION--
2024-07-22T06:17:53.831740+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_scmn_70_70.trc  (incident=1602):
ORA-00600: internal error code, arguments: [(DMM) kgslaInitCtx_lazy:library.load.fail], [], [], [], [], [], [], [], [], [], [], []
2024-07-22T06:18:18.749192+00:00
USER (ospid: 27): terminating the instance due to ORA error 443
2024-07-22T06:18:30.041958+00:00
Time drifted forward by (98438387) micro seconds at 3436783109475 whereas allowed drift is 1000000
2024-07-22T06:18:30.069961+00:00
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_1602/FREE_scmn_70_70_i1602.trc
--ATTENTION--
2024-07-22T06:18:33.107146+00:00
Time drifted forward by (49219360) micro seconds at 3436832328835 whereas allowed drift is 1000000
--ATTENTION--
2024-07-22T06:18:37.972956+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_lgwr_82.trc  (incident=153) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LGWR], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
2024-07-22T06:18:38.379101+00:00
Time drifted forward by (3238201) micro seconds at 3436835567036 whereas allowed drift is 1000000
--ATTENTION--
2024-07-22T06:18:39.979978+00:00
Instance terminated by USER, PID = 27
2024-07-22T06:20:49.000961+00:00
Adjusting the default value of parameter "parallel_max_servers" from 0 to 1.
PARALLEL_MAX_SERVERS (with value 1) is insufficient. This may affect transaction recovery performance.
Stored outlines will be desupported in the next release.
Starting ORACLE instance (normal) (OS id: 27)
2024-07-22T06:20:49.187954+00:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2024-07-22T06:20:49.191528+00:00
**********************************************************************
2024-07-22T06:20:49.191595+00:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2024-07-22T06:20:49.191693+00:00
 Domain name: docker/ff30460460718a614781b132c3a7c3fb55cb6ce31c7c9539a3cfca94f37f6e91
2024-07-22T06:20:49.191749+00:00
 Per process system memlock (soft) limit = 64K
2024-07-22T06:20:49.191807+00:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 1532M
2024-07-22T06:20:49.191926+00:00
 Available system pagesizes:
  4K, 2048K 
2024-07-22T06:20:49.192078+00:00
 Supported system pagesize(s):
2024-07-22T06:20:49.192138+00:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2024-07-22T06:20:49.192201+00:00
        4K       Configured               5           391540        NONE
2024-07-22T06:20:49.192310+00:00
     2048K                0             766                0        NONE
2024-07-22T06:20:49.192369+00:00
RECOMMENDATION:
2024-07-22T06:20:49.192430+00:00
 1. For optimal performance, configure system with expected number 
 of pages for every supported system pagesize prior to the next 
 instance restart operation.
2024-07-22T06:20:49.192599+00:00
 2. Increase per process memlock (soft) limit to at least 1532MB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
2024-07-22T06:20:49.192715+00:00
**********************************************************************
Using an SGA granule size of 16MB
Memory protection keys NOT enabled.
Hugetlbfs Dynamic SGA NOT enabled.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/23ai/dbhomeFree/dbs/arch
.... (PID:): Enable RFS client   [kcrlc.c:609]
Autotune of undo retention is turned on. 
Log buffer boundaries=(0xc0000000, 0xc0452000)
IMODE=BR
ILAT =35
2024-07-22T06:20:51.860056+00:00
NOTE: Using default ASM root directory ASM
2024-07-22T06:20:55.066700+00:00
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05.
ORACLE_HOME:    /opt/oracle/product/23ai/dbhomeFree
System name:    Linux
Node name:      ff3046046071
Release:        4.19.0-26-amd64
Version:        #1 SMP Debian 4.19.304-1 (2024-01-09)
Machine:        x86_64
Using parameter settings in server-side spfile /opt/oracle/product/23ai/dbhomeFree/dbs/spfileFREE.ora
System parameters with non-default values:
  processes                = 200
  cpu_count                = "2"
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  sga_target               = 1536M
  control_files            = "/opt/oracle/oradata/FREE/control01.ctl"
  control_files            = "/opt/oracle/oradata/FREE/control02.ctl"
  db_block_size            = 8192
  compatible               = "23.0.0"
  _instance_recovery_bloom_filter_size= 1048576
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=FREEXDB)"
  shared_servers           = 0
  local_listener           = ""
  job_queue_processes      = 1
  db_name                  = "FREE"
  open_cursors             = 300
  pga_aggregate_target     = 512M
  _dmm_blas_library        = "libora_netlib.so"
  control_management_pack_access= "DIAGNOSTIC+TUNING"
  spatial_vector_acceleration= FALSE
  diagnostic_dest          = "/opt/oracle"
  enable_pluggable_database= TRUE
  common_user_prefix       = ""
  mle_prog_languages       = "OFF"
2024-07-22T06:20:58.385458+00:00
Oracle instance running with ODM in SGA: Oracle File Server ODM Library, Version: 1.0 
Oracle instance running with ODM in SGA: FSDirect ODM Library Version 1.0 
Oracle instance running with ODM in SGA: Object Store ODM Library Version 8.0 
2024-07-22T06:21:06.138251+00:00
Broadcast on commit is enabled and is using Message mode.
2024-07-22T06:22:27.155175+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_vktm_42.trc  (incident=1643) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
2024-07-22T06:22:38.260372+00:00
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_1643/FREE_vktm_42_i1643.trc
2024-07-22T06:22:42.140404+00:00
--ATTENTION--
2024-07-22T06:22:51.979876+00:00
The priority of process VKTM cannot be elevated.
2024-07-22T06:22:55.558582+00:00

Failed to elevate VKTM's priority from 0 to 1, policy 5
Error : Category(-2), Opname(skgdism_create), Loc(sp.c:setpr:1), ErrMsg(Error 0) Dism(16)
2024-07-22T06:24:08.530079+00:00
--ATTENTION--
2024-07-22T06:24:10.287695+00:00
PMON (ospid: 30): terminating the instance due to ORA error 12752
Instance terminated by PMON, PID = 30
2024-07-22T06:24:12.269164+00:00
3 processes attached to SGA primary segment
2024-07-22T06:24:13.975904+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_scmn_80_80.trc  (incident=3204):
ORA-00600: internal error code, arguments: [(DMM) kgslaInitCtx_lazy:library.load.fail], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_3204/FREE_scmn_80_80_i3204.trc
2024-07-22T06:24:14.010353+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_scmn_78_78.trc  (incident=3205):
ORA-00600: internal error code, arguments: [(DMM) kgslaInitCtx_lazy:library.load.fail], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_3205/FREE_scmn_78_78_i3205.trc
2024-07-22T06:24:14.023448+00:00
WARNING: Process 78 in 'D' state, still attached to SGA, may NOT be killed by KILL signal
2024-07-22T06:24:14.023541+00:00
Killing process 78 still attached to SGA
2024-07-22T06:24:14.098450+00:00
Killing process 80 still attached to SGA
2024-07-22T06:28:33.715632+00:00
Adjusting the default value of parameter "parallel_max_servers" from 0 to 1.
PARALLEL_MAX_SERVERS (with value 1) is insufficient. This may affect transaction recovery performance.
Stored outlines will be desupported in the next release.
Starting ORACLE instance (normal) (OS id: 34)
2024-07-22T06:28:33.732963+00:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2024-07-22T06:28:33.733790+00:00
**********************************************************************
2024-07-22T06:28:33.733843+00:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

2024-07-22T06:28:33.733917+00:00
 Domain name: docker/ff30460460718a614781b132c3a7c3fb55cb6ce31c7c9539a3cfca94f37f6e91
2024-07-22T06:28:33.733959+00:00
 Per process system memlock (soft) limit = 64K
2024-07-22T06:28:33.734010+00:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 1532M
2024-07-22T06:28:33.734091+00:00
 Available system pagesizes:
  4K, 2048K 
2024-07-22T06:28:33.734168+00:00
 Supported system pagesize(s):
2024-07-22T06:28:33.734207+00:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2024-07-22T06:28:33.734247+00:00
        4K       Configured               5           391540        NONE
2024-07-22T06:28:33.734346+00:00
     2048K                0             766                0        NONE
2024-07-22T06:28:33.734386+00:00
RECOMMENDATION:
2024-07-22T06:28:33.734425+00:00
 1. For optimal performance, configure system with expected number 
 of pages for every supported system pagesize prior to the next 
 instance restart operation.
2024-07-22T06:28:33.734543+00:00
 2. Increase per process memlock (soft) limit to at least 1532MB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
2024-07-22T06:28:33.734622+00:00
**********************************************************************
Using an SGA granule size of 16MB
Memory protection keys NOT enabled.
Hugetlbfs Dynamic SGA NOT enabled.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/23ai/dbhomeFree/dbs/arch
.... (PID:): Enable RFS client   [kcrlc.c:609]
Autotune of undo retention is turned on. 
Log buffer boundaries=(0xc0000000, 0xc0452000)
IMODE=BR
ILAT =35
NOTE: Using default ASM root directory ASM
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05.
ORACLE_HOME:    /opt/oracle/product/23ai/dbhomeFree
System name:    Linux
Node name:      ff3046046071
Release:        4.19.0-26-amd64
Version:        #1 SMP Debian 4.19.304-1 (2024-01-09)
Machine:        x86_64
Using parameter settings in server-side spfile /opt/oracle/product/23ai/dbhomeFree/dbs/spfileFREE.ora
System parameters with non-default values:
  processes                = 200
  cpu_count                = "2"
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  sga_target               = 1536M
  control_files            = "/opt/oracle/oradata/FREE/control01.ctl"
  control_files            = "/opt/oracle/oradata/FREE/control02.ctl"
  db_block_size            = 8192
  compatible               = "23.0.0"
  _instance_recovery_bloom_filter_size= 1048576
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=FREEXDB)"
  shared_servers           = 0
  local_listener           = ""
  job_queue_processes      = 1
  db_name                  = "FREE"
  open_cursors             = 300
  pga_aggregate_target     = 512M
  _dmm_blas_library        = "libora_netlib.so"
  control_management_pack_access= "DIAGNOSTIC+TUNING"
  spatial_vector_acceleration= FALSE
  diagnostic_dest          = "/opt/oracle"
  enable_pluggable_database= TRUE
  common_user_prefix       = ""
  mle_prog_languages       = "OFF"
2024-07-22T06:28:33.969620+00:00
Oracle instance running with ODM in SGA: Oracle File Server ODM Library, Version: 1.0 
Oracle instance running with ODM in SGA: FSDirect ODM Library Version 1.0 
Oracle instance running with ODM in SGA: Object Store ODM Library Version 8.0 
Broadcast on commit is enabled and is using Message mode.
2024-07-22T06:28:34.089150+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_vktm_49.trc  (incident=3246) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_3246/FREE_vktm_49_i3246.trc
--ATTENTION--
The priority of process VKTM cannot be elevated.

Failed to elevate VKTM's priority from 0 to 1, policy 5
Error : Category(-2), Opname(skgdism_create), Loc(sp.c:setpr:1), ErrMsg(Error 0) Dism(16)
Using default pga_aggregate_limit of 2048 MB
2024-07-22T06:28:34.335734+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_scmn_71_71.trc  (incident=4807):
ORA-00600: internal error code, arguments: [(DMM) kgslaInitCtx_lazy:library.load.fail], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_4807/FREE_scmn_71_71_i4807.trc
2024-07-22T06:28:34.367571+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_scmn_73_73.trc  (incident=4808):
ORA-00600: internal error code, arguments: [(DMM) kgslaInitCtx_lazy:library.load.fail], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_4808/FREE_scmn_73_73_i4808.trc
2024-07-22T06:28:34.624652+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_lgwr_89.trc  (incident=3366) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [LGWR], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_3366/FREE_lgwr_89_i3366.trc
--ATTENTION--
The priority of process LGWR cannot be elevated.

Failed to elevate LGWR's priority from 0 to 1, policy 5
Error : Category(-2), Opname(skgdism_create), Loc(sp.c:setpr:1), ErrMsg(Error 0) Dism(16)
2024-07-22T06:28:36.166905+00:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-07-22T06:28:36.189844+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 (ospid: 34): terminating the instance due to ORA error 443
Instance terminated by USER, PID = 34
DlouhyDavid commented 1 month ago

I solved the problem by exporting and importing data between containers.