Make connection with outside from Oracle docker with Oracle Container Registry

We pulled a Docker image from Oracle Container Registry having Oracle Database. We can make connection from outside with Oracle Database. We need to mention the -p port or ORACLE_PWD for password. So first we start the docker image as shown below.

First Start a docker from the image.

docker run -d --name ORCL2 -p 1521 -p 5500 -e ORACLE_PWD=sys123 container-registry.oracle.com/database/express:21.3.0-xe

Note: -d for background check docker comes in health state with docker ps

sunny@Oracle1:~$ docker ps

\CONTAINER ID   IMAGE                                                      COMMAND                  CREATED       STATUS                 PORTS                                                                                      NAMES

888dacf84e76   container-registry.oracle.com/database/express:21.3.0-xe   "/bin/sh -c 'exec $O…"   3 hours ago   Up 3 hours (healthy)   0.0.0.0:32771->1521/tcp, :::32771->1521/tcp, 0.0.0.0:32770->5500/tcp, :::32770->5500/tcp   ORCL2

Check with SQLPLUS from docker command that database is working:

For connectivity from docker image we need to check the mapped port:

unny@Oracle1:~$ docker port ORCL2

1521/tcp -> 0.0.0.0:32771

1521/tcp -> :::32771

5500/tcp -> 0.0.0.0:32770

5500/tcp -> :::32770

Now we can see that 1521 port mapped with 32771 as localhost. Make connection in dbeaver as follows:

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply