Docker - Run Oracle DB image and execute init script

Question

Somewhat surprisingly, I have been unable to find an answer to this, which I feel is a common situation.

So, I am trying to write a docker file in which I would initialize an oracle database and then run a script with SQL queries.

In my folder, I have the following files: dockerfile, dbInit.sql

My dockerfile looks like this:

FROM store/oracle/database-enterprise:12.2.0.1-slim
ADD dbModelAndInit.sql /docker-entrypoint-initdb.d/
EXPOSE 1521

After building and running the image, a database is running, but the file is not executed.

Any help would be greatly appreciated.

have you checked the user permission on this file ? or checked the container logs ? Note that you need to create a new container during the test i think this will be executed one time only — Mostafa Hussein
– Mostafa Hussein, Commented Feb 25, 2019 at 11:32
The permissions are fine. The container logs report nothing regarding the sql queries that should be executed, it seems like they are not being executed at all. — Dragan
– Dragan, Commented Feb 25, 2019 at 12:04
What about the entrypoint itself, can you check it to confirm ? Does it support this feature in specific ? I mean might be a new version of the container is needed which provides a support for it but worth checking anyway — Mostafa Hussein
– Mostafa Hussein, Commented Feb 25, 2019 at 12:09
The command "ADD dbModelAndInit.sql /docker-entrypoint-initdb.d/" simply add a file to an image. Who execute it? — bdn02
– bdn02, Commented Feb 25, 2019 at 12:12

Miguel Ángel García · Accepted Answer · 2019-02-26 11:15:21Z

1

I have the same problem and as far as I know, files in "docker-entrypoint-initdb.d" are executed automatically, is that right? But I'm not sure that is this particular image "store/oracle/database-enterprise:12.2.0.1-slim" the scripts placed in this path are executed automatically.

answered Feb 26, 2019 at 11:15

Miguel Ángel García

1131 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dragan Over a year ago

This was it, I changed the image used and it started working normally. Thanks.

ThomasDC Over a year ago

@Dragan which image did you use then?

Vmav · Accepted Answer · 2024-02-01 11:25:57Z

In my case, I've had to tell the DB configuration script directly to run my .sql scripts.

Run the container.
Copy the configuration script from home/oracle/setup/configDBora.sh.

Modify the script by adding the following snippet just before the ## db network set # sqlnet.ora block:

# Custom scripts on start up
echo "====> Checking for custom scripts on startup..."
if [ ! "$(ls -A /home/oracle/setup/your_scripts/*.sql)" ]; then
    echo "/home/oracle/setup/your_scripts is empty!"
else
    echo "/home/oracle/setup/your_scripts is not empty"
    for filename in /home/oracle/setup/your_scripts/*.sql; do
        echo "Executing file $filename..."
        sqlplus / as sysdba 2>&1 <<EOF
              @$filename;
              exit;
EOF
    done
fi

Rebuild the image replacing the configuration file.
Any all the .sql scripts that you put in that folder will run now when creating the container.

Collectives™ on Stack Overflow

Docker - Run Oracle DB image and execute init script

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related