Lets set up an Oracle Database instance for development purpose using Docker is very easy. And it also runs in WSL2 over Windows.
Let's use the oracleinanutshell/oracle-xe-11g image. https://hub.docker.com/r/oracleinanutshell/oracle-xe-11g
Table Of Contents
- Running Oracle Database On Docker
- Set Up a New User and Configure the Tablespace
- Connect Using SQL Developer
Running Oracle Database on Docker
Run the following commands in your terminal.
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
docker exec -it 82 bash
sqlplus to open SQLPlus in the terminal.
Connect using the username and password below.
Database Information hostname: localhost internal port: 49161 sid: xe username: system password: oracle
Run the following commands to set up the new user and tablespace.
Then run the necessary grants.
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