Oracle 19c - Add start-up script to dockerfile

[vchollati]

So I found a past post that looked like my question too but its for Oracle. Below is the link to the past post.

Create a Docker Image of a sql file

Hi, It’s the first time I am working on docker and I am not sure of how I can create a Docker image for a SQL script. I believe we have to create a docker file for this although I am not sure of I can make it work. Appreciate for any quick response. Thanks in advance

Requirement is to have a docker image that a dev can pull and when spun up, it should have certain PDBs ready and users created. I found a way to do this by mounting a custom_script that runs at startup. Like so…

docker run --name DM -p 1523:1521 -e ORACLE_SID=DM -e ORACLE_PDB=DM1 -e ORACLE_PWD=Xyz1234 -e ORACLE_MEM=4000 -v /home/oracle/scripts:/opt/oracle/scripts/startup --shm-size=1g -d oracle/database:19.3.0-ee

But I’ll have to supply the custom_script to the dev and instruct on where to save it…

What I’m looking to do it to incorporate that into the image itself so I don’t have to supply the file separately. By modifying my dockerfile so it picks up the script and incorporates it into the image built. I don’t want to use the add changes and commit (create new image) route. Below is for mysql and I’m looking for an Oracle equivalent

FROM mysql
ADD sqldump.sql /docker-entrypoint-initdb.d/

ENV MYSQL_ROOT_PASSWORD yourpassword 

thank you