search

MaksymBilenko / docker-oracle-12c

:whale: Docker image with Oracle Database 12c on board
Apache License 2.0
680 stars 285 forks source link

After inserting too many entries into a table the database is shutting down - ORA-01089 #113

Closed sdoeringNew closed 5 years ago

sdoeringNew commented 6 years ago

The Oracle 12c Docker image is used for an integration test for Oracle database support.

On filling a simple table with test data the database is responding - after a while - with: ORA-01089: immediate shutdown or close in progress - no operations are permitted

This error comes undeterministically after a few 1000 entries. Sometimes after 20.000, sometimes after 45.000.

I'll try to attach a test script later.

sdoeringNew commented 5 years ago

With the latest version I even got an ORA-12528, TNS:listener: all appropriate instances are blocking new connections. That's even worse.

After reading some other issues I stumbled upon the solution that the database might not have been initialized fully before writing to it.

I did the data migration after the database was accessible the first time. On the docker logs I saw that the initialization was only 66% complete.

I solved the problem by waiting until the end of the initialization: Database ready to use.

After that I could easily add hundreds of thousands entries.