docker-oracle-19.3.0-container-building-output1

docker-oracle-19.3.0-container-building-output1.txt

~/DOCKER/dockerOracleDB/datafiles19c$ docker run --name oracle19c -p 1621:1521 -p 5500:5500 -e ORACLE_SID=dockor19c -e  ORACLE_PDB=dockor19cPDB -v $HOME/DOCKER/dockerOracleDB/datafiles19c:/opt/oracle/oradata oracle19.3.0:or19c
ORACLE EDITION: STANDARD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-SEP-2022 06:47:56

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/b3c1b4d1c8b0/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                24-SEP-2022 06:47:56
Uptime                    0 days 0 hr. 0 min. 0 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/b3c1b4d1c8b0/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
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/DOCKOR19C.
Database Information:
Global Database Name:DOCKOR19C
System Identifier(SID):DOCKOR19C
Look at the log file "/opt/oracle/cfgtoollogs/dbca/DOCKOR19C/DOCKOR19C.log" for further details.

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 24 07:03:13 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> 
System altered.

SQL> 
System altered.

SQL> 
Pluggable database altered.

SQL> 
PL/SQL procedure successfully completed.

SQL> SQL> 
Session altered.

SQL> 
User created.

SQL> 
Grant succeeded.

SQL> 
Grant succeeded.

SQL> 
Grant succeeded.

SQL> 
User altered.

SQL> SQL> Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
The Oracle base remains unchanged with value /opt/oracle
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
DOCKOR19CPDB(3):ALTER DATABASE DEFAULT TABLESPACE "USERS"
DOCKOR19CPDB(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2022-09-24T07:03:13.139018+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/DOCKOR19C/control01.ctl' SCOPE=SPFILE;
2022-09-24T07:03:13.151870+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
   ALTER PLUGGABLE DATABASE DOCKOR19CPDB SAVE STATE
Completed:    ALTER PLUGGABLE DATABASE DOCKOR19CPDB SAVE STATE

XDB initialized.
2022-09-24T07:12:33.269949+00:00
DOCKOR19CPDB(3):Resize operation completed for file# 10, old size 327680K, new size 337920K
Stopping container.
SIGTERM received, shutting down database!

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 24 07:41:29 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> 2022-09-24T07:41:29.389892+00:00
Shutting down ORACLE instance (immediate) (OS id: 4720)
2022-09-24T07:41:31.616702+00:00
Stopping background process SMCO
2022-09-24T07:41:32.635978+00:00
Shutting down instance: further logons disabled
2022-09-24T07:41:32.677519+00:00
Stopping background process CJQ0
Stopping background process MMNL
2022-09-24T07:41:33.680889+00:00
Stopping background process MMON
2022-09-24T07:41:35.748897+00:00
alter pluggable database all close immediate
2022-09-24T07:41:35.750353+00:00
DOCKOR19CPDB(3):JIT: pid 4720 requesting stop
DOCKOR19CPDB(3):Buffer Cache flush deferred for PDB 3
Pluggable database DOCKOR19CPDB closed
Completed: alter pluggable database all close immediate
PDB$SEED(2):JIT: pid 4720 requesting stop
PDB$SEED(2):Buffer Cache flush deferred for PDB 2
License high water mark = 14
Dispatchers and shared servers shutdown

Data Pump shutdown on PDB: 1 in progress
2022-09-24T07:41:35.924398+00:00
Process termination requested for pid 2986 [source = rdbms], [info = 2] [request issued by pid: 4720, uid: 54321]
2022-09-24T07:41:36.949062+00:00
ALTER DATABASE CLOSE NORMAL
2022-09-24T07:41:36.954872+00:00
Stopping Emon pool
alter pluggable database all close immediate
Completed: alter pluggable database all close immediate
2022-09-24T07:41:37.956439+00:00

IM on ADG: Start of Empty Journal 

IM on ADG: End of Empty Journal 
Stopping Emon pool
stopping change tracking
2022-09-24T07:41:38.025183+00:00
Shutting down archive processes
2022-09-24T07:41:38.025717+00:00
TT00 (PID:2976): Gap Manager exiting
Database closed.
Database dismounted.
~/DOCKER/dockerOracleDB/datafiles19c$