$ podman-compose up using podman version: podman version 3.4.0 podman pod create --name=oracle --share net -p 5503:5500 -p 1521:1521 d6724d9c9ca939011e5c0af21b97731906d77bd8379c9d3aefaeba0e94a186a2 0 podman create --name=oracle_db --pod=oracle --label io.podman.compose.config-hash=123 --label io.podman.compose.project=oracle --label io.podman.compose.version=0.0.1 --label com.docker.compose.container-number=1 --label com.docker.compose.service=oracle --add-host oracle:127.0.0.1 --add-host oracle_db:127.0.0.1 store/oracle/database-enterprise:12.2.0.1-slim f950d59538e4ae303053ecdd4f9ea379cfed0552efb9ceaad141409341ab9c09 0 podman start -a oracle_db Setup Oracle Database Oracle Database 12.2.0.1 Setup Mon Oct 11 19:35:48 UTC 2021 Check parameters ...... log file is : /home/oracle/setup/log/paramChk.log paramChk.sh is done at 0 sec untar DB bits ...... log file is : /home/oracle/setup/log/untarDB.log untarDB.sh is done at 18 sec config DB ...... log file is : /home/oracle/setup/log/configDB.log Mon Oct 11 19:36:06 UTC 2021 Start Docker DB configuration Call configDBora.sh to configure database Mon Oct 11 19:36:06 UTC 2021 Configure DB as oracle user Setup Database directories ... SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 11 19:36:06 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> File created. SQL> ORACLE instance started. Total System Global Area 1342177280 bytes Fixed Size 8792536 bytes Variable Size 402654760 bytes Database Buffers 922746880 bytes Redo Buffers 7983104 bytes Database mounted. Database opened. SQL> Database altered. SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/12.2.0 /dbhome_1/dbs/spfileORCLCDB.or a SQL> NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ encrypt_new_tablespaces string CLOUD_ONLY SQL> User altered. SQL> User altered. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production update password Enter password for SYS: create pdb : ORCLPDB1 SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 11 19:36:45 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> 2 3 4 5 Pluggable database created. SQL> Pluggable database altered. SQL> Pluggable database altered. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Reset Database parameters SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 11 19:37:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> System altered. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-OCT-2021 19:37:15 Copyright (c) 1991, 2016, Oracle. All rights reserved. Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/f950d59538e4/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 11-OCT-2021 19:37:27 Uptime 0 days 0 hr. 0 min. 12 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/f950d59538e4/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully DONE! Remove password info Docker DB configuration is complete ! configDB.sh is done at 103 sec Done ! The database is ready for use . # =========================================================================== # == Add below entries to your tnsnames.ora to access this database server == # ====================== from external host ================================= ORCLCDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCLCDB.localdomain))) ORCLPDB1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCLPDB1.localdomain))) # #ip-address : IP address of the host where the container is running. #port : Host Port that is mapped to the port 1521 of the container. # # The mapped port can be obtained from running "docker port " # =========================================================================== ORCLPDB1(3):Database Characterset for ORCLPDB1 is WE8DEC ORCLPDB1(3):Opatch validation is skipped for PDB ORCLPDB1 (con_id=0) 2021-10-11T19:37:03.561632+00:00 ORCLPDB1(3):Opening pdb with no Resource Manager plan active Pluggable database ORCLPDB1 opened read write Completed: alter pluggable database ORCLPDB1 open alter pluggable database all save state Completed: alter pluggable database all save state 2021-10-11T19:37:11.654773+00:00 ALTER SYSTEM SET encrypt_new_tablespaces='DDL' SCOPE=BOTH; 2021-10-11T19:37:43.399927+00:00 TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P1427 (4302) VALUES LESS THAN (TO_DATE(' 2021-10-12 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P1428 (4302) VALUES LESS THAN (TO_DATE(' 2021-10-12 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P1431 (4301) VALUES LESS THAN (TO_DATE(' 2021-10-11 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 2021-10-11T19:46:45.008424+00:00 ORCLPDB1(3):Resize operation completed for file# 20, old size 434448K, new size 453712K 2021-10-11T19:46:45.015400+00:00 Resize operation completed for file# 3, old size 795456K, new size 800896K 2021-10-11T19:46:45.213413+00:00 Thread 1 advanced to log sequence 15 (LGWR switch) Current log# 3 seq# 15 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T19:51:43.686096+00:00 Thread 1 advanced to log sequence 16 (LGWR switch) Current log# 1 seq# 16 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T19:56:47.470442+00:00 Resize operation completed for file# 3, old size 800896K, new size 803072K 2021-10-11T20:06:44.850344+00:00 WARNING: too many parse errors, count=100 SQL hash=0x750004bb PARSE ERROR: ospid=915, error=933 for statement: 2021-10-11T20:06:44.850552+00:00 DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name Additional information: hd=0x623b62d0 phd=0x62310a38 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0 2021-10-11T20:06:44.850876+00:00 ----- PL/SQL Call Stack ----- object line object handle number name 0x62b42128 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION 0x641c2958 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK 0x641c2958 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS 0x629c2908 1 anonymous block 2021-10-11T20:06:56.127255+00:00 Thread 1 advanced to log sequence 17 (LGWR switch) Current log# 2 seq# 17 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:06:56.553005+00:00 Thread 1 advanced to log sequence 18 (LGWR switch) Current log# 3 seq# 18 mem# 0: /u04/app/oracle/redo/redo03.dbf Thread 1 cannot allocate new log, sequence 19 Checkpoint not complete Current log# 3 seq# 18 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:02.032083+00:00 Thread 1 advanced to log sequence 19 (LGWR switch) Current log# 1 seq# 19 mem# 0: /u04/app/oracle/redo/redo01.dbf Thread 1 cannot allocate new log, sequence 20 Checkpoint not complete Current log# 1 seq# 19 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:05.382221+00:00 Thread 1 advanced to log sequence 20 (LGWR switch) Current log# 2 seq# 20 mem# 0: /u04/app/oracle/redo/redo02.dbf Thread 1 cannot allocate new log, sequence 21 Checkpoint not complete Current log# 2 seq# 20 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:08.960851+00:00 Thread 1 advanced to log sequence 21 (LGWR switch) Current log# 3 seq# 21 mem# 0: /u04/app/oracle/redo/redo03.dbf Thread 1 cannot allocate new log, sequence 22 Checkpoint not complete Current log# 3 seq# 21 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:12.791911+00:00 Thread 1 advanced to log sequence 22 (LGWR switch) Current log# 1 seq# 22 mem# 0: /u04/app/oracle/redo/redo01.dbf Thread 1 cannot allocate new log, sequence 23 Checkpoint not complete Current log# 1 seq# 22 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:16.499872+00:00 Thread 1 advanced to log sequence 23 (LGWR switch) Current log# 2 seq# 23 mem# 0: /u04/app/oracle/redo/redo02.dbf Thread 1 cannot allocate new log, sequence 24 Checkpoint not complete Current log# 2 seq# 23 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:20.343144+00:00 Thread 1 advanced to log sequence 24 (LGWR switch) Current log# 3 seq# 24 mem# 0: /u04/app/oracle/redo/redo03.dbf Thread 1 cannot allocate new log, sequence 25 Checkpoint not complete Current log# 3 seq# 24 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:24.041358+00:00 Thread 1 advanced to log sequence 25 (LGWR switch) Current log# 1 seq# 25 mem# 0: /u04/app/oracle/redo/redo01.dbf Thread 1 cannot allocate new log, sequence 26 Checkpoint not complete Current log# 1 seq# 25 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:27.370425+00:00 Thread 1 advanced to log sequence 26 (LGWR switch) Current log# 2 seq# 26 mem# 0: /u04/app/oracle/redo/redo02.dbf Thread 1 cannot allocate new log, sequence 27 Checkpoint not complete Current log# 2 seq# 26 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:30.557171+00:00 Thread 1 advanced to log sequence 27 (LGWR switch) Current log# 3 seq# 27 mem# 0: /u04/app/oracle/redo/redo03.dbf Thread 1 cannot allocate new log, sequence 28 Checkpoint not complete Current log# 3 seq# 27 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:33.868146+00:00 Thread 1 advanced to log sequence 28 (LGWR switch) Current log# 1 seq# 28 mem# 0: /u04/app/oracle/redo/redo01.dbf Thread 1 cannot allocate new log, sequence 29 Checkpoint not complete Current log# 1 seq# 28 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:37.338417+00:00 Thread 1 advanced to log sequence 29 (LGWR switch) Current log# 2 seq# 29 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:37.452034+00:00 Resize operation completed for file# 2, old size 55296K, new size 56320K Resize operation completed for file# 2, old size 56320K, new size 57344K Resize operation completed for file# 2, old size 57344K, new size 58368K 2021-10-11T20:07:37.803284+00:00 Thread 1 cannot allocate new log, sequence 30 Checkpoint not complete Current log# 2 seq# 29 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:40.616150+00:00 Thread 1 advanced to log sequence 30 (LGWR switch) Current log# 3 seq# 30 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:40.724215+00:00 Resize operation completed for file# 2, old size 58368K, new size 59392K Resize operation completed for file# 2, old size 59392K, new size 60416K Resize operation completed for file# 2, old size 60416K, new size 61440K 2021-10-11T20:07:41.079588+00:00 Thread 1 cannot allocate new log, sequence 31 Checkpoint not complete Current log# 3 seq# 30 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:43.853095+00:00 Thread 1 advanced to log sequence 31 (LGWR switch) Current log# 1 seq# 31 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:43.958770+00:00 Resize operation completed for file# 2, old size 61440K, new size 62464K Resize operation completed for file# 2, old size 62464K, new size 63488K Resize operation completed for file# 2, old size 63488K, new size 64512K 2021-10-11T20:07:44.307902+00:00 Thread 1 cannot allocate new log, sequence 32 Checkpoint not complete Current log# 1 seq# 31 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:47.124655+00:00 Thread 1 advanced to log sequence 32 (LGWR switch) Current log# 2 seq# 32 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:47.203455+00:00 Resize operation completed for file# 2, old size 64512K, new size 65536K Resize operation completed for file# 2, old size 65536K, new size 66560K Resize operation completed for file# 2, old size 66560K, new size 67584K Resize operation completed for file# 2, old size 67584K, new size 68608K 2021-10-11T20:07:47.670103+00:00 Thread 1 cannot allocate new log, sequence 33 Checkpoint not complete Current log# 2 seq# 32 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:50.339973+00:00 Thread 1 advanced to log sequence 33 (LGWR switch) Current log# 3 seq# 33 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:50.491586+00:00 Resize operation completed for file# 2, old size 68608K, new size 69632K Resize operation completed for file# 2, old size 69632K, new size 70656K Resize operation completed for file# 2, old size 70656K, new size 71680K 2021-10-11T20:07:50.808103+00:00 Thread 1 cannot allocate new log, sequence 34 Checkpoint not complete Current log# 3 seq# 33 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:07:53.893430+00:00 Thread 1 advanced to log sequence 34 (LGWR switch) Current log# 1 seq# 34 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:54.033950+00:00 Resize operation completed for file# 2, old size 71680K, new size 72704K Resize operation completed for file# 2, old size 72704K, new size 73728K Resize operation completed for file# 2, old size 73728K, new size 74752K 2021-10-11T20:07:54.390852+00:00 Thread 1 cannot allocate new log, sequence 35 Checkpoint not complete Current log# 1 seq# 34 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:07:57.174541+00:00 Thread 1 advanced to log sequence 35 (LGWR switch) Current log# 2 seq# 35 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:07:57.314514+00:00 Resize operation completed for file# 2, old size 74752K, new size 75776K Resize operation completed for file# 2, old size 75776K, new size 76800K Resize operation completed for file# 2, old size 76800K, new size 77824K 2021-10-11T20:07:57.659439+00:00 Thread 1 cannot allocate new log, sequence 36 Checkpoint not complete Current log# 2 seq# 35 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:08:00.498689+00:00 Thread 1 advanced to log sequence 36 (LGWR switch) Current log# 3 seq# 36 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:08:00.665936+00:00 Resize operation completed for file# 2, old size 77824K, new size 78848K Resize operation completed for file# 2, old size 78848K, new size 79872K Resize operation completed for file# 2, old size 79872K, new size 80896K 2021-10-11T20:08:00.990688+00:00 Thread 1 cannot allocate new log, sequence 37 Checkpoint not complete Current log# 3 seq# 36 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:08:03.989742+00:00 Thread 1 advanced to log sequence 37 (LGWR switch) Current log# 1 seq# 37 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:08:04.113784+00:00 Resize operation completed for file# 2, old size 80896K, new size 81920K Resize operation completed for file# 2, old size 81920K, new size 82944K Resize operation completed for file# 2, old size 82944K, new size 83968K 2021-10-11T20:08:04.444475+00:00 Thread 1 cannot allocate new log, sequence 38 Checkpoint not complete Current log# 1 seq# 37 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:08:07.346103+00:00 Thread 1 advanced to log sequence 38 (LGWR switch) Current log# 2 seq# 38 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:08:07.448043+00:00 Resize operation completed for file# 2, old size 83968K, new size 84992K Resize operation completed for file# 2, old size 84992K, new size 86016K Resize operation completed for file# 2, old size 86016K, new size 87040K Resize operation completed for file# 2, old size 87040K, new size 88064K 2021-10-11T20:08:07.947934+00:00 Thread 1 cannot allocate new log, sequence 39 Checkpoint not complete Current log# 2 seq# 38 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:08:10.778503+00:00 Thread 1 advanced to log sequence 39 (LGWR switch) Current log# 3 seq# 39 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:08:10.900990+00:00 Resize operation completed for file# 2, old size 88064K, new size 89088K Resize operation completed for file# 2, old size 89088K, new size 90112K 2021-10-11T20:08:11.212844+00:00 Thread 1 cannot allocate new log, sequence 40 Checkpoint not complete Current log# 3 seq# 39 mem# 0: /u04/app/oracle/redo/redo03.dbf 2021-10-11T20:08:14.139066+00:00 Thread 1 advanced to log sequence 40 (LGWR switch) Current log# 1 seq# 40 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:08:14.247217+00:00 Resize operation completed for file# 2, old size 90112K, new size 91136K Resize operation completed for file# 2, old size 91136K, new size 92160K Resize operation completed for file# 2, old size 92160K, new size 93184K Resize operation completed for file# 2, old size 93184K, new size 94208K 2021-10-11T20:08:14.758580+00:00 Thread 1 cannot allocate new log, sequence 41 Checkpoint not complete Current log# 1 seq# 40 mem# 0: /u04/app/oracle/redo/redo01.dbf 2021-10-11T20:08:17.939337+00:00 Thread 1 advanced to log sequence 41 (LGWR switch) Current log# 2 seq# 41 mem# 0: /u04/app/oracle/redo/redo02.dbf 2021-10-11T20:08:18.104072+00:00 Resize operation completed for file# 2, old size 94208K, new size 95232K Resize operation completed for file# 2, old size 95232K, new size 96256K 2021-10-11T20:08:52.172189+00:00 Shared IO Pool defaulting to 64MB. Trying to get it from Buffer Cache for process 955.