Installing Oracle XE using Docker

1. Download the Oracle XE Docker image

docker pull gvenzl/oracle-xe:latest

2. Running the container

docker run -d --name oracle-xe \
  -p 1521:1521 -p 8080:8080 \
  -e ORACLE_PASSWORD=YOUR_PASSWORD \
  gvenzl/oracle-xe

3. Connect to Database

import cx_Oracle

dsn = cx_Oracle.makedsn("127.0.0.1", 1521, service_name="XE")
connection = cx_Oracle.connect("system", "YOUR_PASSWORD", dsn)

print("Database version:", connection.version)
connection.close()