[ root@ip-172-31-16-23 ~ ]# docker logs 775704abbfa3
ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: l8fKXiT7Lu0=1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 01-JAN-2024 23:50:36
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.3.0/db100/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is
/u01/app/oracle/product/19.3.0/db100/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/775704abbfa3/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 01-JAN-2024 23:50:36
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/19.3.0/db100/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/775704abbfa3/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
[WARNING] [DBT-11209] Current available memory is less than the required available
memory (2,048MB) for creating the database.
CAUSE: Following nodes do not have required available memory :
Node:775704abbfa3 Available memory:354.3203MB (362824.0KB)
Prepare for db operation
8% complete
Copying database files
9% complete
[WARNING] ORA-27104: system-defined limits for shared memory was misconfigured
[FATAL] ORA-01034: ORACLE not available
31% complete
100% complete
[FATAL] ORA-01034: ORACLE not available
8% complete
0% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for
further details.
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
mv: cannot stat '/u01/app/oracle/product/19.3.0/db100/dbs/spfileORCLCDB.ora': No
such file or directory
mv: cannot stat '/u01/app/oracle/product/19.3.0/db100/dbs/orapwORCLCDB': No such
file or directory
ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set
since this
information is not available for the current user ID .
You can set ORACLE_BASE manually if it is required.
Resetting ORACLE_BASE to its previous value or ORACLE_HOME
The Oracle base remains unchanged with value /u01/app/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
/u01/app/oracle/checkDBStatus.sh: line 26: sqlplus: command not found
2024-01-01T23:51:08.057244+00:00
Starting ORACLE instance (normal) (OS id: 483)
2024-01-01T23:51:08.069390+00:00
System cannot support SGA size of 1536 MB.
2024-01-01T23:51:08.069497+00:00
Total system memory configured is 767 MB.
2024-01-01T23:51:08.069595+00:00
Instance maximum shared memory size should be less than 691 MB.