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

[Yangyi-miracle]

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

[ccarcaci]

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]

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]

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

[dedeparisg]

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]

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