Run Oracle Instant Client in Docker container

I have a web application built using .NET 4.8, with a data access layer implemented as a class library (not an API). I have dockerized the application using a Windows container, and now I need to connect it to an Oracle database installed on a separate environment. I know that I need an Oracle client (version 19) to enable communication between the application and the database, but I'm not sure how to set this up in a Docker environment. Can anyone provide steps or guidance on how to do this? I have researched some resources, but have not found clear instructions for my specific setup.

Check the following steps:

1. Install the Oracle client (version 19) on your local machine.
2. Create a Dockerfile that will build the container image for your web application. In the Dockerfile, add the following lines to install the Oracle client:

RUN apt-get update
RUN apt-get install -y oracle-instantclient-19.3

3. Build the container image using the following command:

docker build -t my-app .

4. Create a Dockerfile that will build the container image for the Oracle client. In the Dockerfile, add the following lines to install the Oracle client:

RUN apt-get update
RUN apt-get install -y oracle-instantclient-19.3

5. Build the container image using the following command:

docker build -t oracle-client .

6. Create a docker-compose.yml file that will define the relationship between the two container images. The docker-compose.yml file should look like this:

version: '3'
services:
  my-app:
    image: my-app
    ports:
      - 8080:80
  oracle-client:
    image: oracle-client

7. Run the docker-compose up command to start the two containers.

8. In your web application, you can now use the Oracle client to connect to the Oracle database. The following code shows how to connect to the database:

using (var connection = new OracleConnection("Data Source=localhost:1521/orcl;User Id=my_user;Password=my_password"))
{
connection.Open();
// Do something with the database.
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul3y ago
Check the following steps:

1. Install the Oracle client (version 19) on your local machine.
2. Create a Dockerfile that will build the container image for your web application. In the Dockerfile, add the following lines to install the Oracle client:
```
RUN apt-get update
RUN apt-get install -y oracle-instantclient-19.3
```
3. Build the container image using the following command:
```
docker build -t my-app .
```
4. Create a Dockerfile that will build the container image for the Oracle client. In the Dockerfile, add the following lines to install the Oracle client:
```
RUN apt-get update
RUN apt-get install -y oracle-instantclient-19.3
```
5. Build the container image using the following command:
```
docker build -t oracle-client .
```
6. Create a docker-compose.yml file that will define the relationship between the two container images. The docker-compose.yml file should look like this:
```
version: '3'
services:
  my-app:
    image: my-app
    ports:
      - 8080:80
  oracle-client:
    image: oracle-client
```
7. Run the docker-compose up command to start the two containers.

8. In your web application, you can now use the Oracle client to connect to the Oracle database. The following code shows how to connect to the database:
```
using (var connection = new OracleConnection("Data Source=localhost:1521/orcl;User Id=my_user;Password=my_password"))
{
connection.Open();
// Do something with the database.
}
```
0