Open MosesKpas opened 3 months ago
out of memory/opt/oracle/createDB.sh: line 206: 103
Seems like the memory allocated to Database container is not enough. How much memory do you have on the host VM?
Hi, I'm having the same issue in my local environment with 32GiB of memory.
@MosesKpas, I encountered the same issue and resolved it by increasing the limit on open file descriptors. Here’s how you can do it:
Add this to your docker-compose.yml
file
ulimits:
nofile:
soft: 65536
hard: 65536
if you're using docker run: You can set the limit like this:
docker run --ulimit nofile=65536:65536
You can adjust the values based on your specific needs.
ORACLE EDITION: ENTERPRISE
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 18-JUL-2024 23:58:17
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/e46cf119dbad/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 18-JUL-2024 23:58:31 Uptime 0 days 0 hr. 0 min. 14 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/e46cf119dbad/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully library initialization failed - unable to allocate file descriptor table - out of memory/opt/oracle/createDB.sh: line 206: 103 Aborted (core dumped) dbca -silent -createDatabase -enableArchive "$ENABLE_ARCHIVELOG" -archiveLogDest "$ARCHIVELOG_DIR" ${DBCA_CRED_OPTIONS} -responseFile "$ORACLE_BASE"/dbca.rsp cat: /opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log: No such file or directory cat: /opt/oracle/cfgtoollogs/dbca/ORCLCDB.log: No such file or directory