Latest version (23.10.2.3) fails to 'docker compose up'

[edoardodavini]

Hi everyone, I've a simple docker compose

version: "3"
services:
  database:
    container_name: retraced.oracledb-2130-atp
    image: ghcr.io/oracle/adb-free:latest
    environment:
      - MY_ATP_ADMIN_PASSWORD=my_nice_atp_pw
      - MY_ADW_ADMIN_PASSWORD=my_nice_adw_pw
      - MY_ADB_WALLET_PASSWORD=my_nice_wallet_pw
    ports:
      - 1521:1521 # TLS
      - 1522:1522 # mTLS
      - 8443:8443 # HTTPS for ORDS/APEX
      - 27017:27017 # Mongo API
    hostname: localhost
    cap_add: 
      - SYS_ADMIN

As you can see, I'm getting this error

retraced.oracledb-2130-atp  |   inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_sysaux_lsccg3wz_.dbf  
retraced.oracledb-2130-atp  |   inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_data_lsccg3y1_.dbf  
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E10A174E5A0408DE0636402000A759D/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E10A174E5A0408DE0636402000A759D/datafile/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/onlinelog/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E1099BA25FC3D75E0636402000ADF30/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E1099BA25FC3D75E0636402000ADF30/datafile/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E10A7FCACD24110E0636402000AF7B6/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/0E10A7FCACD24110E0636402000AF7B6/datafile/
retraced.oracledb-2130-atp  |    creating: /u01/app/oracle/oradata/POD1/controlfile/
retraced.oracledb-2130-atp  |   inflating: /u01/app/oracle/oradata/POD1/controlfile/o1_mf_lscctrtj_.ctl  
retraced.oracledb-2130-atp  | TIME ELAPSED Unzipping /u01/POD1.zip: 0 minutes and 31 seconds elapsed
retraced.oracledb-2130-atp  | User input JSON not found
retraced.oracledb-2130-atp  | Traceback (most recent call last):
retraced.oracledb-2130-atp  |   File "/u01/scripts/user_input.py", line 89, in <module>
retraced.oracledb-2130-atp  |     generate_default_input_json()
retraced.oracledb-2130-atp  |   File "/u01/scripts/user_input.py", line 64, in generate_default_input_json
retraced.oracledb-2130-atp  |     workload_type = os.getenv("WORKLOAD_TYPE").upper()
retraced.oracledb-2130-atp  | AttributeError: 'NoneType' object has no attribute 'upper'
retraced.oracledb-2130-atp exited with code 1

Reverting to v23.10.2.2 fixes the issue

Just noticed that v23.10.2.2 is 2.01GB and 23.10.2.3 is 1.3GB

Pretty big difference huh?

[aosingh]

Hi @edoardodavini

Thanks for reporting the issue. Starting with version 23.10.2.3, the environment variables for startup are simplified.

You can start the container with environment variable WORKLOAD_TYPE=ATP or WORKLOAD_TYPE=ADW

The passwords are called ADMIN_PASSWORD and WALLET_PASSWORD.

Please try the below docker-compose configuration.

version: "3"
services:
  database:
    container_name: retraced.oracledb-2130-atp
    image: ghcr.io/oracle/adb-free:latest
    environment:
      - WORKLOAD_TYPE=ATP
      - ADMIN_PASSWORD=my_nice_atp_pw
      - WALLET_PASSWORD=my_nice_wallet_pw
    ports:
      - 1521:1521 # TLS
      - 1522:1522 # mTLS
      - 8443:8443 # HTTPS for ORDS/APEX
      - 27017:27017 # Mongo API
    hostname: localhost
    cap_add: 
      - SYS_ADMIN

[edoardodavini]

Oh. I didn't checked documentation. My fault. Wasn't expecting that many changes. This is amazing! Will try tomorrow morning (CET) Thanks

[edoardodavini]

thank you very much. Everything's working smoothly.

I'll let you close the ticket with just one question: any idea to have the fastest boot on ATP for CI usage? (like testing our services) Thank you mate!

[aosingh]

Sure @edoardodavini

I know, it would be ideal to have the fastest boot, database containers are meant to be lightweight. We are working towards it and I will keep you posted on this thread :)

[edoardodavini]

Let me close this issue anyway :) This is not an issue at all :)