search

MaksymBilenko / docker-oracle-xe-11g

:whale: Dockerfile of Oracle Database Express Edition 11g Release 2
Other
196 stars 107 forks source link

ORA-12528, TNS:listener: all appropriate instances are blocking new connections #48

Open Yangyi-miracle opened 6 years ago

Yangyi-miracle commented 6 years ago

Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections

ccarcaci commented 5 years ago

Same for me when I share a volume on host machine:

services:
  ...
  oracledb:
    image: sath89/oracle-xe-11g
    expose:
      - 1521
    ports:
      - 1521:1521
    volumes:
      - /home/claudio/docker-data/oracledb/data:/u01/app/oracle/oradata
dedeparisg commented 5 years ago

Hi, I have the same issue but i fix it connecting with command line directly on my container.

Tell me if it's work for you.

ccarcaci commented 5 years ago

Hi @dedeparisg could you provide more details about? Thanks :)

dedeparisg commented 5 years ago

After more tests, I still have this error as long as the container does not finish initializing. As long as the database is initializing (or working...), no connection is possible.

In order to debug and know when the database is ready, I launch the container like this: 

docker-compose up

and not with the deamon like this:

docker-compose up -d

You should have thos message at the end:

Database ready to use. Enjoy! ;)
ccarcaci commented 5 years ago

I get the point, thus the problem now is why sometimes the database takes a very long time to run up? :thinking: