Cannot connect with Oracle SQL Developer

[KevinBurton]

I did the following steps:

• docker pull sath89/oracle-12c
• docker run -d -p 8080:8080 -p 1521:1521 -v C:/oracle/data:/u01/app/oracle -e DBCA_TOL_MEMORY=1024 sath89/oracle-12c

Then I did docker ps -a to makesure the container was running

cpp> docker ps -a
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS
                             NAMES
a3295b6c3c01        sath89/oracle-12c   "/entrypoint.sh "   8 seconds ago       Up 6 seconds       0.0.0.0:1521->1521
cp, 0.0.0.0:8080->8080/tcp   wizardly_jennings

When I bring up SQL Developer and try to connect I get:

[ramsiCampus]

I get the same error when trying to connect with TOAD for Oracle. The only difference i got, is that my run arguments differ from the original issue. Mine would be: docker run -d --name oracle12.1 -p 8080:8080 -p 49161:1521 sath89/oracle-12c

[drognisep]

@KevinBurton I think this might be due to the long startup time for the DB. Since the container starting and the DB being ready are two different things, run this commend to tail the log and check the status of your instance.

docker logs -f your_db_container_name_or_hash

You should see something similar to what is shown in the README video.

[greghodgkinson]

I had the same issue - thanks @drognisep your comment helped, the database was still starting up.

[hemanth22]

Hello Instead of using localhost.

Use IP address of your system or swarm bridge IP Address as shown below it will conect to database.

To get ip address use below command.

docker inspect lpl6j1h1puit | grep IP

instead of lpl6j1h1puit replace with docker network id.