SQL Pro tips : Oracle XE Quick Start

Introduction

In this article you will see how to setup Oracle XE database in a matter of half an hour maximum using docker, Oracle XE docker image and DBeaver.

Setup

From zero to hero :

• install docker
• go to oracle xe quickstart
• find oracle xe image in the registry
• pull from the registry, I have set the password to password, feel free set it to your password, the command at the moment when the article is being written :

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

• check the connection by running the command from the container which is named oracle-db in my setup and the password set to password, type exit to exit

docker exec -it oracle-db sqlplus sys/password@//localhost:1521/XE as sysdba

• install dbeaver
• setup connection in DBeaver :

• open SQL editor in DBeaver and start writing SQL :

Enjoy !