docker-images
docker-images copied to clipboard
Published
20 hours ago •
oracle
oracle
Cannot start database
Hello,
trying to set up an Oracle DB in the Docker engine. Pulled the image, and made a container, which tries to start, but dies with the following:
cat /home/oracle/setup/log/configDB.log
Fri Sep 3 06:23:44 UTC 2021
Start Docker DB configuration
Call configDBora.sh to configure database
Fri Sep 3 06:23:44 UTC 2021
Configure DB as oracle user
Setup Database directories ...
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:44 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
File created.
SQL> ORACLE instance started.
Total System Global Area 1342177280 bytes
Fixed Size 8792536 bytes
Variable Size 402654760 bytes
Database Buffers 922746880 bytes
Redo Buffers 7983104 bytes
ORA-03113: end-of-file on communication channel
Process ID: 120
Session ID: 301 Serial number: 19782
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
update password
Enter password for SYS:
create pdb : ORCLPDB1
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:51 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected.
SQL> 2 3 4 5 create pluggable database ORCLPDB1 ADMIN USER sys1 identified by "Oradoc_db1"
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database ORCLPDB1 open
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database all save state
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
Reset Database parameters
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:52 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected.
SQL> alter system set encrypt_new_tablespaces=ddl scope=both
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 03-SEP-2021 06:23:53
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/59a2a3a0c369/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 03-SEP-2021 06:23:53
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/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/59a2a3a0c369/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
DONE!
Remove password info
Docker DB configuration is complete !
The output when starting the container is follows:
Setup Oracle Database
Oracle Database 12.2.0.1 Setup
Fri Sep 3 06:23:25 UTC 2021
Check parameters ......
log file is : /home/oracle/setup/log/paramChk.log
paramChk.sh is done at 0 sec
untar DB bits ......
log file is : /home/oracle/setup/log/untarDB.log
untarDB.sh is done at 19 sec
config DB ......
log file is : /home/oracle/setup/log/configDB.log
Fri Sep 3 06:23:44 UTC 2021
Start Docker DB configuration
Call configDBora.sh to configure database
Fri Sep 3 06:23:44 UTC 2021
Configure DB as oracle user
Setup Database directories ...
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:44 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
File created.
SQL> ORACLE instance started.
Total System Global Area 1342177280 bytes
Fixed Size 8792536 bytes
Variable Size 402654760 bytes
Database Buffers 922746880 bytes
Redo Buffers 7983104 bytes
ORA-03113: end-of-file on communication channel
Process ID: 120
Session ID: 301 Serial number: 19782
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
update password
Enter password for SYS:
create pdb : ORCLPDB1
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:51 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected.
SQL> 2 3 4 5 create pluggable database ORCLPDB1 ADMIN USER sys1 identified by "Oradoc_db1"
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database ORCLPDB1 open
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database all save state
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
Reset Database parameters
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 3 06:23:52 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected.
SQL> alter system set encrypt_new_tablespaces=ddl scope=both
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 03-SEP-2021 06:23:53
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/59a2a3a0c369/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 03-SEP-2021 06:23:53
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/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/59a2a3a0c369/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
DONE!
Remove password info
Docker DB configuration is complete !
ERROR : config DB failed, please check log /home/oracle/setup/log/configDB.log for details!
ORA-1092 : opitsk aborting process
2021-09-03T06:23:51.689516+00:00
Dumping diagnostic data in directory=[cdmp_20210903062351], requested by (instance=1, osid=47 (PMON)), summary=[abnormal instance termination].
2021-09-03T06:23:52.731596+00:00
ORA-1092 : opitsk aborting process
2021-09-03T06:23:52.802381+00:00
Instance terminated by PMON, pid = 47
2021-09-03T06:23:52.807211+00:00
Warning: 2 processes are still attach to shmid 3:
(size: 8192 bytes, creator pid: 43, last attach/detach pid: 132)
So it seems something is weird in the scripts for starting and configuring the DB. This was working fine before since we rely on Strap to always pull and set up these databases
