DEV Community

hexfloor
hexfloor

Posted on

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
Enter fullscreen mode Exit fullscreen mode

Image description

  • 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
Enter fullscreen mode Exit fullscreen mode

Image description

  • install dbeaver
  • setup connection in DBeaver :

Image description

  • open SQL editor in DBeaver and start writing SQL :

Image description

Enjoy !

Top comments (0)