podman を用いて Oracle DB 環境を作成した際のメモ

podman を用いて Oracle DB 環境を作成した際のメモを整理します。


  • Oracle 社のリポジトリへアクセスするためのユーザー/パスワードを指定してログインを実施
podman login container-registry.oracle.com
Username: <My Oracle Supportのユーザー名>
Password: <My Oracle Supportのパスワード>


  • Oracle DB コンテナイメージを pull
podman pull container-registry.oracle.com/database/enterprise:19.3.0.0


  • Oracle DB を作成
    (補足) 以下の例の test_oracle やパスワードは自分の環境に合うように変更してください。
podman run --name test_oracle -p 1521:1521 -p 5500:5500 -e ORACLE_PWD=<任意をパスワードを指定> -e ORACLE_EDITION=enterprise container-registry.oracle.com/database/enterprise:19.3.0.0
ORACLE EDITION: ENTERPRISE

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-JUL-2022 23:02:36

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/93b06e918504/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                12-JUL-2022 23:02:37
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/93b06e918504/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-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
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/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 12 23:16:04 2022
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition 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 Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
The Oracle base remains unchanged with value /opt/oracle

Executing user defined scripts
/opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/extensions/setup/savePatchSummary.sh

/opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/extensions/setup/swapLocks.sh
DONE: Executing user defined scripts

The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################

Executing user defined scripts
/opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/extensions/startup/runDatapatch.sh
Datafiles are already patched. Skipping datapatch run.

DONE: Executing user defined scripts

The following output is now a tail of the alert.log:
ORCLPDB1(3):
ORCLPDB1(3):XDB initialized.
2022-07-12T23:16:04.889663+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl' SCOPE=SPFILE;
2022-07-12T23:16:04.897846+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
   ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE
Completed:    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE

XDB initialized.
2022-07-12T23:25:53.405154+00:00
ORCLPDB1(3):Resize operation completed for file# 10, old size 327680K, new size 337920K
2022-07-13T00:01:01.155536+00:00
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P190 (4576) VALUES LESS THAN (TO_DATE(' 2022-07-13 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2022-07-13T00:06:02.219687+00:00
Resize operation completed for file# 3, old size 522240K, new size 532480K
2022-07-13T01:01:15.201398+00:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P191 (4577) VALUES LESS THAN (TO_DATE(' 2022-07-14 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P192 (4577) VALUES LESS THAN (TO_DATE(' 2022-07-14 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2022-07-13T01:06:16.300744+00:00
Resize operation completed for file# 3, old size 532480K, new size 542720K
2022-07-13T05:00:00.005421+00:00
ORCLPDB1(3):Setting Resource Manager plan SCHEDULER[0x4D50]:DEFAULT_MAINTENANCE_PLAN via scheduler window
ORCLPDB1(3):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2022-07-13T05:00:04.575174+00:00
ORCLPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P225 (44754) VALUES LESS THAN (TO_DATE(' 2022-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
ORCLPDB1(3):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P228 (44754) VALUES LESS THAN (TO_DATE(' 2022-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2022-07-13T05:00:13.875028+00:00
Thread 1 advanced to log sequence 9 (LGWR switch)
  Current log# 3 seq# 9 mem# 0: /opt/oracle/oradata/ORCLCDB/redo03.log
2022-07-13T05:07:12.630864+00:00
Resize operation completed for file# 3, old size 542720K, new size 563200K
2022-07-13T05:07:12.631810+00:00
ORCLPDB1(3):Resize operation completed for file# 10, old size 337920K, new size 348160K
2022-07-13T06:07:26.760710+00:00
Resize operation completed for file# 3, old size 563200K, new size 573440K
2022-07-13T09:00:00.125817+00:00
ORCLPDB1(3):Closing scheduler window
ORCLPDB1(3):Closing Resource Manager plan via scheduler window
ORCLPDB1(3):Clearing Resource Manager plan via parameter
2022-07-13T09:00:07.668816+00:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P195 (44754) VALUES LESS THAN (TO_DATE(' 2022-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P198 (44754) VALUES LESS THAN (TO_DATE(' 2022-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))


  • 別の端末から Oracle DB のシャットダウンを実施した際のログメッセージ
2022-07-13T11:05:51.784908+00:00
Shutting down ORACLE instance (normal) (OS id: 26438)
Stopping background process SMCO
2022-07-13T11:05:53.050505+00:00
Shutting down instance: further logons disabled
2022-07-13T11:05:53.131450+00:00
Stopping background process CJQ0
Stopping background process MMNL
2022-07-13T11:05:54.157173+00:00
Stopping background process MMON
2022-07-13T11:05:56.205966+00:00
alter pluggable database all close
2022-07-13T11:05:56.208116+00:00
ORCLPDB1(3):JIT: pid 26438 requesting stop
ORCLPDB1(3):Buffer Cache flush deferred for PDB 3
Pluggable database ORCLPDB1 closed
Completed: alter pluggable database all close
PDB$SEED(2):JIT: pid 26438 requesting stop
PDB$SEED(2):Buffer Cache flush deferred for PDB 2
License high water mark = 18
Dispatchers and shared servers shutdown

Data Pump shutdown on PDB: 1 in progress
ALTER DATABASE CLOSE NORMAL
Stopping Emon pool
Stopping background process AQPC
2022-07-13T11:05:57.997289+00:00
alter pluggable database all close
Completed: alter pluggable database all close
2022-07-13T11:05:58.999399+00:00

IM on ADG: Start of Empty Journal 

IM on ADG: End of Empty Journal 
Stopping Emon pool
stopping change tracking
2022-07-13T11:05:59.125624+00:00
Shutting down archive processes
2022-07-13T11:05:59.125760+00:00
TT00 (PID:2810): Gap Manager exiting
2022-07-13T11:06:00.126030+00:00
Archiving is disabled
2022-07-13T11:06:00.126439+00:00
Thread 1 closed at log sequence 9
Successful close of redo thread 1
2022-07-13T11:06:00.137324+00:00
Buffer Cache invalidation for all PDBs started
Buffer Cache invalidation for all PDBs complete
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
2022-07-13T11:06:01.453858+00:00
.... (PID:26438): Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
2022-07-13T11:06:02.454984+00:00
JIT: pid 26438 requesting stop
.... (PID:26438): Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
JIT: pid 26438 requesting stop
2022-07-13T11:06:02.466759+00:00
Stopping background process VKTM
2022-07-13T11:06:12.241842+00:00
Instance shutdown complete (OS id: 26438)


podman を用いた環境構築後に Oracle DB 環境を起動/停止した際のメモは後程整理します。