I have a github actions repository and I would like it to connect with an Oracle database, containerised using Oracle Database Free Container / Docker images image.
I would like to perform additional initialization of the database using a *.sql file under /container-entrypoint-initdb.d, as indicated in the image description.
However, I get the following error when I try to build it. More specifically, I get the error:

Error 45 initializing SQL*Plus

My workflow.yml contains:

services:

      # Oracle service (label used to access the service container)
      oracle:

        # Docker Hub image (feel free to change the tag "latest" to any other available one)
        image: gvenzl/oracle-free:latest

        # Provide passwords and other environment variables to container
        env:
          ORACLE_RANDOM_PASSWORD: true
          APP_USER: my_user
          APP_USER_PASSWORD: password_i_should_change

        # Forward Oracle port
        ports:
          - 1521:1521

        # Provide healthcheck script options for startup
        options: >-
          --health-cmd healthcheck.sh
          --health-interval 10s
          --health-timeout 5s
          --health-retries 10
        volumes:
          - my-init.sql:/container-entrypoint-initdb.d/my-init.sql:ro

As stated in the image documentation.

On the other hand, the file /container-entrypoint-initdb.d/my-init.sql, included in the repository’s root has the following lines:

alter session set container=freepdb1;
CREATE USER TEST IDENTIFIED BY test QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE TO TEST;

I do not find the problem. Any help is welcome.

Thanks

UPDATE. Following the first suggestion given by Azzem, I have tried with:

name: Build and test of Java Project
 
on: [push]
 
jobs:
 build:
   runs-on: ubuntu-latest
   timeout-minutes: 6
   services:

      # Oracle service (label used to access the service container)
      oracle:

        # Docker Hub image (feel free to change the tag "latest" to any other available one)
        image: gvenzl/oracle-free:latest
       
        # Provide passwords and other environment variables to container
        env:
          ORACLE_RANDOM_PASSWORD: true
          APP_USER: my_user
          APP_USER_PASSWORD: password_i_should_change

        # Forward Oracle port
        ports:
          - 1521:1521

        # Provide healthcheck script options for startup
        options: >-
          --name oracle
          --health-cmd healthcheck.sh
          --health-interval 10s
          --health-timeout 5s
          --health-retries 10
        # volumes:
        #   - my-init.sql:/container-entrypoint-initdb.d/my-init.sql:ro
   steps:
     - uses: actions/checkout@v2
     - name: Set up JDK 21
       uses: actions/setup-java@v1
       with:
         java-version: 21
     - name: Setup timezone
       uses: zcong1993/setup-timezone@master
       with:
          timezone: Europe/Madrid
     - name: Restart_container
        # Restart container after volumes have been checked out
       uses: docker://docker
       with:
          args: docker restart oracle
     - name: Create database
       run:  bash ./create_tables.sh
       shell: bash 
     - name: Build with Maven
       run: mvn -B test --file pom.xml

where the first lines of the create_tables.sh filer are:

export ORACLE_SID=FREE
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree
export ORAENV_ASK=NO
export PATH=$ORACLE_HOME/bin
$PATH/sqlplus -S my_user/password_i_should_change <<SQL
whenever sqlerror exit 2;
...

I have tried both with SID FREE and FREEPDB1, but I get the same error message line 5: /opt/oracle/product/23ai/dbhomeFree/bin/sqlplus: No such file or directory. Any idea?
Thanks!

UPDATE 2: following steps at https://github.com/gvenzl/setup-oracle-free:

name: Build and test of Java Project
 
on: [push]
 
jobs:
 test:
  runs-on: ubuntu-latest
  timeout-minutes: 6
  steps:
     - uses: actions/checkout@v4
     - uses: gvenzl/setup-oracle-free@v1
       with:
          app-user: myUser
          app-user-password: myPwd
          startup-scripts: ${{ github.workspace }}/scripts
     - name: Set up JDK 21
       uses: actions/setup-java@v1
       with:
         java-version: 21
     - name: Setup timezone
       uses: zcong1993/setup-timezone@master
       with:
          timezone: Europe/Madrid
     - name: Build with Maven
       run: mvn -B test --file pom.xml

I got the error:

Error: can only create exec sessions on running containers: container state improper

UPDATE3: Thank you very much again. That works with docker. The point is that I need to create a database with concrete tables and, later, connect to it from JDBC. It seems that, after creating a user/password the login is denied, using:

url=jdbc:oracle:thin:@localhost:1521:FREE
user=myUser
password=myPwd

Although I create the user/password in the workflow.yml, it seems that it does not work. I also try to create them in the init.sql file (I have tried both with FREE and FREEPDB1 service names), but with no success:

ALTER SESSION SET CONTAINER=FREE;
CREATE USER myUser IDENTIFIED BY myPwd QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE TO myUser ;
CREATE SCHEMA  AUTHORIZATION myUser ; 
ALTER SESSION SET CURRENT_SCHEMA = myUser;

CREATE TABLE ...

Do you have any idea? Thank you very much