I am trying to set up an Oracle database in Docker, and once the database is up and running, I can exec into sqlplus just fine, but if I try to connect with another application like Oracle SQL Developer or SQuirreL, either it will stall out while trying to connect, or it will manage to connect and then all future queries will stall. What is wrong with this?
Here is how I set up the container: I used the docker image available from Oracle on Docker Hub.
Here is the command I ran to create the container:
docker run --name someName -p 1521:1521 -p 5500:5500 -e ORACLE_SID=SOMESID -e ORACLE_PDB=SOMEPDBNAME -e ORACLE_PWD=12345 -it 12a359cd0528
Here are the commands I ran once the container was up and running:
docker exec -it npsIG /bin/bash sqlplus / as sysdba alter session set "_ORACLE_SCRIPT"=true; create user username identified by 12345; grant dba to username;
At this point, sometimes I can connect on the created user, sometimes it just stalls out. If I manage to connect on the created user, no further queries will process.