Setting up Oracle Database for development in docker is very easy - it also runs in WSL2.
Let's use the oracleinanutshell/oracle-xe-11g image. https://hub.docker.com/r/oracleinanutshell/oracle-xe-11g
Running Oracle Database on Docker
Run the following commands in your terminal.
#pulls the images from docker hub docker pull oracleinanutshell/oracle-xe-11g #runs the image using port forwarding docker run -d -p 49161:1521 oracleinanutshell/oracle-xe-11g Pull and Run Oracle XE 11g
The output should be something like this.
Set up a new user and configure the tablespace
With the Application running in the background let's create a new Oracle User and set up the appropriate tablespace and grants.
Get the running container Id and attach it running bash.
docker exec -it 82 bash Type sqlplus to open SQLPlus in the terminal.
sqlplus Connect using the username and password below.
Database Information hostname: localhost internal port: 49161 sid: xe username: system password: oracle 
Connected at SQLPlus
Run the following commands to set up the new user and tablespace.
CREATE TABLESPACE TSD_USERDB LOGGING DATAFILE 'TSD_USERDB.DBF' SIZE 200M AUTOEXTEND ON NEXT 200M MAXSIZE 400M; CREATE TABLESPACE TSI_USERDB LOGGING DATAFILE 'TSI_USERDB.DBF' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE 400M; CREATE USER USERDB IDENTIFIED BY PASSWORD DEFAULT TABLESPACE TSI_USERDB QUOTA UNLIMITED ON TSD_USERDB QUOTA UNLIMITED ON TSI_USERDB; Setup tablespace
Then run the necessary grants.
GRANT CREATE SESSION TO USERDB; GRANT CREATE PROCEDURE TO USERDB; GRANT CREATE VIEW TO USERDB; GRANT CREATE TABLE TO USERDB; GRANT CREATE SEQUENCE TO USERDB; GRANT CREATE TRIGGER TO USERDB; Setup permissions
Connect using SQL Developer
Connect using the recently created user to manage your database.
Database Information hostname: localhost port: 49161 sid: xe username: USERDB password: PASSWORD 
All done here. If you like it subscribe for more content.
Top comments (0)
Some comments may only be visible to logged-in visitors. Sign in to view all comments.