run 19c

[TSYMQMYST]

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:
- /etc/localtime:/etc/localtime
- /oracle/data:/opt/oracle/oradata
environment:
- TZ=Asia/Shanghai
- ORALCE_SID=zhjtsmdx
- ORACLE_PDB=system
- ORACLE_PWD=zSdmf*7y%HSK
- ORACLE_EDITION=standard
- ORACLE_CHARACTERSET=AL32UTF8
ports:
- "2521:1521"
- "5550:5500"
`

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]

[TSYMQMYST]

There should be 24 GB of free memory

[ArminBeda]

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

docker info:

Error message upon docker-compose up:

Any ideas?

[amritaramnauth]

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