I have my oracle database set up as a container with the following command:
docker run --name oracledb -p 1521:1521 -e ORACLE_PWD='test23' free:23.3.0.0
I had the container working without any issues. Last week I had to delete my containers and recreate them. Since then I have been having issues with this container. I am using Rancher client.
On the first docker run, it connects for a while and I was able to create tables etc, but then the container status becomes unhealthy and no longer able to access. This is the error message I get
"No more data to read from socket"
The docker logs doesn’t give any information (this is after i stopped and started the service since it stopped working the first time):
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_FREE))) The
command completed successfully Starting Oracle Net Listener. Oracle
Net Listener started. Starting Oracle Database instance FREE. Starting
Oracle Net Listener. Oracle Net Listener started. Starting Oracle
Database instance FREE.
The log doesn’t show Database started like it did the first time, I believe that is the issue but don’t know how to fix it.
Can some body help in figuring out this issue, I have been on google for the last two days trying to understand this, there were some posts similar to this issue but many of them were related to the application issue but here I am trying to connect via SQL developer.