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.47k stars 5.41k forks source link

run 19c #2716

Open TSYMQMYST opened 9 months ago

TSYMQMYST commented 9 months ago

Hi

I have a problem

i run a docker-compose was wrong

` version: '3'

services: oracle: restart: always image: registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c container_name: oracle privileged: true volumes:

The following is the docker's error record

Attaching to oracle19c oracle19c | ORACLE EDITION: ENTERPRISE oracle19c | ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: HgntLg26U3c=1 oracle19c | oracle19c | LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-OCT-2023 15:23:25 oracle19c | oracle19c | Copyright (c) 1991, 2019, Oracle. All rights reserved. oracle19c | oracle19c | Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait... oracle19c | oracle19c | TNSLSNR for Linux: Version 19.0.0.0.0 - Production oracle19c | System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora oracle19c | Log messages written to /opt/oracle/diag/tnslsnr/2f8417df0c34/listener/alert/log.xml oracle19c | Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) oracle19c | Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) oracle19c | oracle19c | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) oracle19c | STATUS of the LISTENER oracle19c | ------------------------ oracle19c | Alias LISTENER oracle19c | Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production oracle19c | Start Date 13-OCT-2023 15:23:25 oracle19c | Uptime 0 days 0 hr. 0 min. 0 sec oracle19c | Trace Level off oracle19c | Security ON: Local OS Authentication oracle19c | SNMP OFF oracle19c | Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora oracle19c | Listener Log File /opt/oracle/diag/tnslsnr/2f8417df0c34/listener/alert/log.xml oracle19c | Listening Endpoints Summary... oracle19c | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) oracle19c | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) oracle19c | The listener supports no services oracle19c | The command completed successfully oracle19c | library initialization failed - unable to allocate file descriptor table - out of memory/opt/oracle/createDB.sh: line 65: 37 Aborted (core dumped) dbca -silent -createDatabase -responseFile $ORACLE_BASE/dbca.rsp oracle19c | cat: /opt/oracle/cfgtoollogs/dbca/ORCL/ORCL.log: No such file or directory oracle19c | cat: /opt/oracle/cfgtoollogs/dbca/ORCL.log: No such file or directory oracle19c | mkdir: cannot create directory '/opt/oracle/oradata/dbconfig': Permission denied oracle19c | mv: cannot stat '/opt/oracle/product/19c/dbhome_1/dbs/spfileORCL.ora': No such file or directory oracle19c | mv: cannot stat '/opt/oracle/product/19c/dbhome_1/dbs/orapwORCL': No such file or directory oracle19c | mv: cannot move '/opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora' to '/opt/oracle/oradata/dbconfig/ORCL/': No such file or directory oracle19c | mv: cannot move '/opt/oracle/product/19c/dbhome_1/network/admin/listener.ora' to '/opt/oracle/oradata/dbconfig/ORCL/': No such file or directory oracle19c | mv: cannot stat '/opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora': No such file or directory oracle19c | mv: cannot move '/opt/oracle/product/19c/dbhome_1/install/.docker_enterprise' to '/opt/oracle/oradata/dbconfig/ORCL/': No such file or directory oracle19c | cp: cannot create regular file '/opt/oracle/oradata/dbconfig/ORCL/': No such file or directory oracle19c | ln: failed to create symbolic link '/opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora': File exists oracle19c | ln: failed to create symbolic link '/opt/oracle/product/19c/dbhome_1/network/admin/listener.ora': File exists oracle19c | cp: cannot stat '/opt/oracle/oradata/dbconfig/ORCL/oratab': No such file or directory oracle19c | ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set since this oracle19c | information is not available for the current user ID . oracle19c | You can set ORACLE_BASE manually if it is required. oracle19c | Resetting ORACLE_BASE to its previous value or ORACLE_HOME oracle19c | The Oracle base remains unchanged with value /opt/oracle oracle19c | /opt/oracle/checkDBStatus.sh: line 26: sqlplus: command not found oracle19c | ##################################### oracle19c | ########### E R R O R ############### oracle19c | DATABASE SETUP WAS NOT SUCCESSFUL! oracle19c | Please check output for further info! oracle19c | ########### E R R O R ############### oracle19c | ##################################### oracle19c | The following output is now a tail of the alert.log: oracle19c | tail: cannot open '/opt/oracle/diag/rdbms///trace/alert*.log' for reading: No such file or directory oracle19c | tail: no files remaining oracle19c exited with code 1

TSYMQMYST commented 9 months ago
image image
TSYMQMYST commented 9 months ago

There should be 24 GB of free memory

ArminBeda commented 9 months ago

I have the same problem, although I have more than 24 GB of free memory:

image

docker info: image

Error message upon docker-compose up:

image image

Any ideas?

amritaramnauth commented 2 months ago

The problem is twofold:

  1. To address the out-of-memory issue, "library initialization failed - unable to allocate file descriptor table - out of memory/opt/oracle/createDB.sh: ", try specifying --ulimit nofile=1024:65536, see docker compose syntax here: https://docs.docker.com/compose/compose-file/build/#ulimits

  2. To fix the permission issue, on the host machine change ownership of your folder (/oracle/data) to oracle (uid: 54321), do: chown -R 54321:54321 /oracle/data