SQL Pro tips : Oracle XE Quick Start

#sql #oracle #bigdata #database

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 !

Hands-on debugging session: instrument, monitor, and fix

Join Lazar for a hands-on session where you’ll build it, break it, debug it, and fix it. You’ll set up Sentry, track errors, use Session Replay and Tracing, and leverage some good ol’ AI to find and fix issues fast.

RSVP here →