podman を用いた環境構築後に Oracle DB 環境を起動／停止した際のメモ

Oracle DB podman

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


  • Oralce DB の起動
$ podman ps
CONTAINER ID  IMAGE       COMMAND     CREATED     STATUS      PORTS       NAMES
$ 
$ podman ps -a
CONTAINER ID  IMAGE                                                       COMMAND               CREATED      STATUS                    PORTS                                           NAMES
93b06e918504  container-registry.oracle.com/database/enterprise:19.3.0.0  /bin/sh -c exec $...  2 weeks ago  Exited (137) 2 weeks ago  0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp  test_oracle
$ 
$ podman start test_oracle
test_oracle


  • SQL*Plus からログイン可能なことを確認
$ podman exec -it test_oracle bash
bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 29 01:28:06 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> 
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

bash-4.2$ 
bash-4.2$ exit


  • Oralce DB の停止
$ podman exec -it test_oracle bash
bash-4.2$ 
bash-4.2$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-JUL-2022 01:28:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
bash-4.2$ 
bash-4.2$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-JUL-2022 01:28:31

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
bash-4.2$ 
bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 29 01:28:44 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> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
bash-4.2$ exit
$
$ podman ps
CONTAINER ID  IMAGE                                                       COMMAND               CREATED      STATUS                       PORTS                                           NAMES
93b06e918504  container-registry.oracle.com/database/enterprise:19.3.0.0  /bin/sh -c exec $...  2 weeks ago  Up 2 minutes ago (starting)  0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp  test_oracle
$
$ podman stop test_oracle
test_oracle
$
$ podman ps
CONTAINER ID  IMAGE       COMMAND     CREATED     STATUS      PORTS       NAMES


podman を用いた環境構築後に Oracle DB の動作確認を実施した際のメモは後程整理します。