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 topassword
, typeexit
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 !
Top comments (0)