search

oracle / docker-images

Official source of container configurations, images, and examples for Oracle products and projects
https://developer.oracle.com/use-cases/#containers
Universal Permissive License v1.0
6.45k stars 5.4k forks source link

oracle 19c image doesn't work :LRM-00109: could not open parameter file #2747

Open kronos72it opened 5 months ago

kronos72it commented 5 months ago

I downloaded oracle docker images and created image for 19c se :+1: 1../buildContainerImage.sh -v 19.3.0 -s -i -o --network=host

  1. sudo docker run --name oraclexe18-4 -d -p 1522:1522 -e ORACLE_PWD=welcome1 -e ORACLE_SID=xe18 -v /opt/oracle/oradata oracle/database:19.3.0-se2

Entering on bash : sudo docker exec -it oraclese19 bash

sqlplus / as sysdba

Ok ,the problems :

  1. " connected to an idle instance " , then startup , but :

    ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initoracle.ora

in the dbs folder I see init.oracle , then cp init.ora initoracle.ora

2 second error now is ORA-00845: MEMORY_TARGET not supported on this system

then this image is not usable ???

kronos72it commented 5 months ago

OK, resolve as create contained with SID=ORCL and memory values , very strange .

sudo docker run --name oraclese19 -d -p 1521:1521 -e ORACLE_PWD=welcome1 -e ORACLE_SID=ORCL -v /opt/oracle/oradata -e INIT_SGA_SIZE=3000 -e INIT_PGA_SIZE=1000 oracle/database:19.3.0-se2

Now I can connect and querying thought sqlplus but cant connect via SqlDeveloper