After some try-and-error, I found a simple solution.

At the .env file, just add this

_PIP_ADDITIONAL_REQUIREMENTS=apache-airflow-providers-oracle 

and run the

docker compose up -d 

command will do.