OS/Orange PI

Orange Pi 3B : ARM 프로세서를 지원하는 Oracle 데이터베이스용 컨테이너 이미지 빌드

파란크리스마스 2024. 3. 1. 22:05
728x90

출처

리눅스 버전 확인

orangepi@orangepi3b:~$ uname -a
Linux orangepi3b 5.10.160-rockchip-rk356x #1.0.4 SMP Tue Dec 26 10:41:53 CST 2023 aarch64 aarch64 aarch64 GNU/Linux

도커 설치

orangepi@orangepi3b:~$ curl -sSL https://get.docker.com | sh
## Executing docker install script, commit: e5543d473431b782227f8908005543bb4389b8de
+ sudo -E sh -c apt-get update -qq >/dev/null
+ sudo -E sh -c DEBIAN_FRONTEND=noninteractive apt-get install -y -qq apt-transport-https ca-certificates curl >/dev/null
+ sudo -E sh -c install -m 0755 -d /etc/apt/keyrings
+ sudo -E sh -c curl -fsSL "https://download.docker.com/linux/ubuntu/gpg" | gpg --dearmor --yes -o /etc/apt/keyrings/docker.gpg
gpg: WARNING: unsafe ownership on homedir '/home/orangepi/.gnupg'
+ sudo -E sh -c chmod a+r /etc/apt/keyrings/docker.gpg
+ sudo -E sh -c echo "deb [arch=arm64 signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu focal stable" > /etc/apt/sources.list.d/docker.list
+ sudo -E sh -c apt-get update -qq >/dev/null
+ sudo -E sh -c DEBIAN_FRONTEND=noninteractive apt-get install -y -qq docker-ce docker-ce-cli containerd.io docker-compose-plugin docker-ce-rootless-extras docker-buildx-plugin >/dev/null
+ sudo -E sh -c docker version
Client: Docker Engine - Community
 Version:           25.0.3
 API version:       1.44
 Go version:        go1.21.6
 Git commit:        4debf41
 Built:             Tue Feb  6 21:13:09 2024
 OS/Arch:           linux/arm64
 Context:           default
 
Server: Docker Engine - Community
 Engine:
  Version:          25.0.3
  API version:      1.44 (minimum version 1.24)
  Go version:       go1.21.6
  Git commit:       f417435
  Built:            Tue Feb  6 21:13:09 2024
  OS/Arch:          linux/arm64
  Experimental:     false
 containerd:
  Version:          1.6.28
  GitCommit:        ae07eda36dd25f8a1b98dfbf587313b99c0190bb
 runc:
  Version:          1.1.12
  GitCommit:        v1.1.12-0-g51d5e94
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
 
================================================================================
 
To run Docker as a non-privileged user, consider setting up the
Docker daemon in rootless mode for your user:
 
    dockerd-rootless-setuptool.sh install
 
Visit https://docs.docker.com/go/rootless/ to learn about rootless mode.
 
 
To run the Docker daemon as a fully privileged service, but granting non-root
users access, refer to https://docs.docker.com/go/daemon-access/
 
WARNING: Access to the remote API on a privileged Docker daemon is equivalent
         to root access on the host. Refer to the 'Docker daemon attack surface'
         documentation for details: https://docs.docker.com/go/attack-surface/
 
================================================================================

도커 버전 확인

orangepi@orangepi3b:~$ sudo docker version
Client: Docker Engine - Community
 Version:           25.0.3
 API version:       1.44

Oracle 데이터베이스용 컨테이너 이미지 빌드 스크립트 다운로드

orangepi@orangepi3b:~$ git clone https://github.com/oraclesean/cloud-native-oracle.git
orangepi@orangepi3b:~$ cd cloud-native-oracle/
orangepi@orangepi3b:~/cloud-native-oracle$ ls
bashrc19  bashrc21  buildDBImage.sh  config  database  functions.sh  manageOracle.sh  README.md  templates

Database 파일(LINUX.ARM64_1919000_db_home.zip) database 디렉토리에 복사

설치 오류 확인

  58 |     # Install DB software binaries
--------------------
ERROR: failed to solve: failed to compute cache key: failed to calculate checksum of ref 050c0aad-4de3-4c6a-b3ea-13b26006aa1c::t73wcuyjin3wcc0vlsq4rux5h: "/database": not found

LINUX.ARM64_1919000_db_home.zip 파일을 다운받아서 database 디렉토리에 복사

orangepi@orangepi3b:~/cloud-native-oracle$ ls database/
LINUX.ARM64_1919000_db_home.zip  patches  README.md

ARM 프로세서를 지원하는 Oracle 데이터베이스용 컨테이너 이미지 빌드

orangepi@orangepi3b:~/cloud-native-oracle$ sudo ./buildDBImage.sh
[sudo] password for orangepi: 
[+] Building 455.7s (7/7) FINISHED                                                             docker:default
 => [internal] load build definition from Dockerfile.oraclelinux.202403020836.fy3l                       0.1s
 => => transferring dockerfile: 1.53kB                                                                   0.0s
 => [internal] load metadata for docker.io/library/oraclelinux:8-slim                                    7.5s
 => [internal] load build context                                                                        0.2s
 => => transferring context: 38B                                                                         0.0s
 => [1/3] FROM docker.io/library/oraclelinux:8-slim@sha256:97ac18066921f7939120c4c2453ec26c40fcf2d6dc8b  0.0s
 => CACHED [2/3] COPY manageOracle.sh /opt/scripts/                                                      0.0s
 => [3/3] RUN chmod ug+x /opt/scripts/manageOracle.sh &&      /opt/scripts/manageOracle.sh -e &&       436.4s
 => exporting to image                                                                                  11.1s 
 => => exporting layers                                                                                 11.1s 
 => => writing image sha256:e91736be6ce42035dd6d657b6096488b73ea91d9ee90b789c493c09052892a42             0.0s 
 => => naming to docker.io/library/oraclelinux:8-slim-19c                                                0.0s 
[+] Building 1977.7s (20/20) FINISHED                                                          docker:default 
 => [internal] load build definition from Dockerfile.db.202403020844.ie8y                                0.0s 
 => => transferring dockerfile: 5.33kB                                                                   0.0s
 => resolve image config for docker.io/docker/dockerfile:1.4                                             3.0s
 => CACHED docker-image://docker.io/docker/dockerfile:1.4@sha256:9ba7531bd80fb0a858632727cf7a112fbfd19b  0.0s
 => [internal] load .dockerignore                                                                        0.1s
 => => transferring context: 2B                                                                          0.0s
 => [internal] load metadata for docker.io/library/oraclelinux:8-slim-19c                                0.0s
 => [internal] load build context                                                                       78.5s
 => => transferring context: 2.42GB                                                                     74.0s
 => [db 1/6] FROM docker.io/library/oraclelinux:8-slim-19c                                               0.1s
 => [db 2/6] COPY --chown=oracle:oinstall manageOracle.sh      /opt/scripts/                            34.8s
 => [stage-1 2/8] COPY --chown=oracle:oinstall ./config/dbca.*        /opt/install/                     34.7s
 => [stage-1 3/8] COPY --chown=oracle:oinstall ./config/*.tmpl        /opt/install/                      0.7s
 => [db 3/6] COPY --chown=oracle:oinstall ./config/inst.*     /opt/install/                              0.4s
 => [db 4/6] COPY --chown=oracle:oinstall ./config/manifest   /opt/install/                              0.5s
 => [stage-1 4/8] COPY --chown=oracle:oinstall manageOracle.sh         /opt/scripts/                     0.6s
 => [db 5/6] COPY --chown=oracle:oinstall ./database/         /opt/install/                            161.9s
 => [db 6/6] RUN  chmod ug+x /opt/scripts/manageOracle.sh &&      /opt/scripts/manageOracle.sh -O      845.7s
 => [stage-1 5/8] COPY --chown=oracle:oinstall --from=db /u01/app/oraInventory  /u01/app/oraInventory    0.8s 
 => [stage-1 6/8] COPY --chown=oracle:oinstall --from=db /u01/app/oracle /u01/app/oracle               435.6s 
 => [stage-1 7/8] RUN  /opt/scripts/manageOracle.sh -R                                                   4.1s 
 => [stage-1 8/8] WORKDIR /home/oracle                                                                   0.4s 
 => exporting to image                                                                                 238.3s 
 => => exporting layers                                                                                238.2s 
 => => writing image sha256:3deb038e98a0f2c5174d6b9cddc155eaeb541b6c5fe4d211cfb962031f74c675             0.0s 
 => => naming to docker.io/oracle/db:19.19-EE                                                            0.0s 
REPOSITORY    TAG          IMAGE ID       CREATED          SIZE                                               
oracle/db     19.19-EE     3deb038e98a0   3 minutes ago    5.86GB
oraclelinux   8-slim-19c   e91736be6ce4   33 minutes ago   676MB

환경변수 추가

orangepi@orangepi3b:~$ vi ~/.profile
CONTAINER_NAME=ORCL
ORADATA=~/oracle-docker/oradata

데이터 디렉터리 및 Docker 볼륨 만들기

mkdir -p $ORADATA/scripts
for dir in audit data diag reco
do mkdir -p $ORADATA/${CONTAINER_NAME}/${dir}
    rm -fr $ORADATA/${CONTAINER_NAME}/${dir}/*
    docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null
    docker volume create --opt type=none --opt o=bind \
        --opt device=$ORADATA/${CONTAINER_NAME}/${dir} \
        ${CONTAINER_NAME}_${dir}
done
orangepi@orangepi3b:~$ mkdir -p $ORADATA/scripts
orangepi@orangepi3b:~$ for dir in audit data diag reco
> do mkdir -p $ORADATA/${CONTAINER_NAME}/${dir}
>     rm -fr $ORADATA/${CONTAINER_NAME}/${dir}/*
>     docker volume rm ${CONTAINER_NAME}_${dir} 2>/dev/null
>     docker volume create --opt type=none --opt o=bind \
>         --opt device=$ORADATA/${CONTAINER_NAME}/${dir} \
>         ${CONTAINER_NAME}_${dir}
> done
ORADB_audit
ORADB_data
ORADB_diag
ORADB_reco
orangepi@orangepi3b:~$ 

도커 이미지에서 디렉토리 권한이 없으므로 디렉토리 권한 해제

orangepi@orangepi3b:~$ cd oracle-docker/oradata/
orangepi@orangepi3b:~/oracle-docker/oradata$ sudo chmod 777 -Rf ORCL
orangepi@orangepi3b:~/oracle-docker/oradata$ cd ORCL
orangepi@orangepi3b:~/oracle-docker/oradata/ORCL$ ls -al
total 24
drwxrwxrwx  6 orangepi orangepi 4096 Mar  2 13:24 .
drwxrwxr-x  4 orangepi orangepi 4096 Mar  2 13:24 ..
drwxrwxrwx  3    54321    54321 4096 Mar  2 13:26 audit
drwxrwxrwx  4 orangepi orangepi 4096 Mar  2 13:53 data
drwxrwxrwx 23    54321    54321 4096 Mar  2 13:26 diag
drwxrwxrwx  4 orangepi orangepi 4096 Mar  2 13:37 reco

Oracle Docker 이미지 실행

docker run -d \
    --name ${CONTAINER_NAME} \
    --volume ${CONTAINER_NAME}_data:/u02/app/oracle/oradata \
    --volume ${CONTAINER_NAME}_diag:/u01/app/oracle/diag \
    --volume ${CONTAINER_NAME}_audit:/u01/app/oracle/admin \
    --volume ${CONTAINER_NAME}_reco:/u03/app/oracle \
    --volume $ORADATA/scripts:/scripts \
    -e ORACLE_SID=${CONTAINER_NAME} \
    -e ORACLE_PDB=${CONTAINER_NAME}PDB1 \
    -p 8080:8080 \
    -p 1521:1521 \
    oracle/db:19.19-EE
orangepi@orangepi3b:~$ sudo docker run -d \
>     --name ${CONTAINER_NAME} \
>     --volume ${CONTAINER_NAME}_data:/u02/app/oracle/oradata \
>     --volume ${CONTAINER_NAME}_diag:/u01/app/oracle/diag \
>     --volume ${CONTAINER_NAME}_audit:/u01/app/oracle/admin \
>     --volume ${CONTAINER_NAME}_reco:/u03/app/oracle \
>     --volume $ORADATA/scripts:/scripts \
>     -e ORACLE_SID=${CONTAINER_NAME} \
>     -e ORACLE_PDB=${CONTAINER_NAME}PDB1 \
>     -p 8080:8080 \
>     -p 1521:1521 \
>     oracle/db:19.19-EE
6357be4fc74139beac920cc5d3577827a1ee96a8a8f607e5a55cb0dafc1235f6

도커 실행 로그 확인

orangepi@orangepi3b:~/oracle-docker/oradata/ORCL$ docker logs -f $CONTAINER_NAME
 
## ----------------------------------------------------------------------------------------------- #
  Oracle password for SYS, SYSTEM and PDBADMIN: LGYm6_M#5oQC_4
## ----------------------------------------------------------------------------------------------- #
 
## ----------------------------------------------------------------------------------------------- #
  runDBCA: Running DBCA for database ORCL at 2024-03-02 13:32:19
## ----------------------------------------------------------------------------------------------- #
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-MAR-2024 13:32:19
 
Copyright (c) 1991, 2023, Oracle.  All rights reserved.
 
Starting /u01/app/oracle/product/19.19/dbhome_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.19/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/6357be4fc741/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                02-MAR-2024 13:32:19
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.19/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/6357be4fc741/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
 
## ----------------------------------------------------------------------------------------------- #
  runDBCA: Creating container database ORCL and 1 pluggable database(s) with name ORCLPDB1 at 2024-03-02 13:32:20
## ----------------------------------------------------------------------------------------------- #
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:
 /u01/app/oracle/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID):ORCL
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL.log" for further details.
 
Pluggable database altered.
 
 
Pluggable database altered.
 
 
## ----------------------------------------------------------------------------------------------- #
  runDBCA: DBCA complete at 2024-03-02 13:53:34
## ----------------------------------------------------------------------------------------------- #
 
## ----------------------------------------------------------------------------------------------- #
  Database ORCL with unique name ORCL is open and available. 
## ----------------------------------------------------------------------------------------------- #
 
## ----------------------------------------------------------------------------------------------- #
  Tailing alert_ORCL.log: 
2024-03-02T13:53:31.597088+00:00
ORCLPDB1(3):CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
ORCLPDB1(3):Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
ORCLPDB1(3):ALTER DATABASE DEFAULT TABLESPACE "USERS"
ORCLPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2024-03-02T13:53:34.793602+00:00
alter pluggable database all open
Completed: alter pluggable database all open
alter pluggable database all save state
Completed: alter pluggable database all save state
2024-03-02T13:54:16.789709+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_3124.trc  (incident=10321) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [ksm_mga_pseg_cbk_attach:map_null], [], [], [], [], [], [], [], [], [], [], []
ORA-27300: OS system dependent operation:mmap failed with status: 12
ORA-27301: OS failure message: Cannot allocate memory
ORA-27302: failure occurred at: sskgm_mga_at
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_10321/ORCL_m000_3124_i10321.trc
2024-03-02T13:54:34.950603+00:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_3124.trc  (incident=10322) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [ksm_mga_pseg_cbk_attach:map_null], [], [], [], [], [], [], [], [], [], [], []
ORA-27300: OS system dependent operation:mmap failed with status: 12
ORA-27301: OS failure message: Cannot allocate memory
ORA-27302: failure occurred at: sskgm_mga_at
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_10322/ORCL_m000_3124_i10322.trc
2024-03-02T13:54:35.141427+00:00
Dumping diagnostic data in directory=[cdmp_20240302135435], requested by (instance=1, osid=3124 (M000)), summary=[incident=10321].
2024-03-02T13:54:42.606206+00:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-03-02T13:54:42.607531+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_3124.trc:
ORA-00600: internal error code, arguments: [ksm_mga_pseg_cbk_attach:map_null], [], [], [], [], [], [], [], [], [], [], []
ORA-27300: OS system dependent operation:mmap failed with status: 12
ORA-27301: OS failure message: Cannot allocate memory
ORA-27302: failure occurred at: sskgm_mga_at
2024-03-02T13:54:43.057745+00:00
Dumping diagnostic data in directory=[cdmp_20240302135443], requested by (instance=1, osid=3124 (M000)), summary=[incident=10322].
2024-03-02T14:02:13.059101+00:00
ORCLPDB1(3):Resize operation completed for file# 10, fname /u02/app/oracle/oradata/ORCL/12AECDF328D30D6DE063020011ACF430/datafile/o1_mf_sysaux_ly6cs3ot_.dbf, old size 286720K, new size 296960K

SQLPlus 접속

orangepi@orangepi3b:~$ docker exec -it 6357be4fc741 sqlplus
 
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 2 13:58:42 2024
Version 19.19.0.0.0
 
Copyright (c) 1982, 2023, Oracle.  All rights reserved.
 
Enter user-name: SYSTEM
Enter password: 
Last Successful login time: Sat Mar 02 2024 13:56:21 +00:00
 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
 
SQL> select table_name from tabs;
 
TABLE_NAME
--------------------------------------------------------------------------------------------------------------------------------
LOGMNR_SESSION_EVOLVE$
LOGMNR_GLOBAL$
LOGMNR_PDB_INFO$
LOGMNR_DID$
LOGMNR_UID$
LOGMNRGGC_GTLO
LOGMNRGGC_GTCS
LOGMNRC_DBNAME_UID_MAP
LOGMNR_LOG$
LOGMNR_PROCESSED_LOG$
LOGMNR_SPILL$
LOGMNR_AGE_SPILL$
LOGMNR_RESTART_CKPT_TXINFO$
LOGMNR_ERROR$
LOGMNR_RESTART_CKPT$
LOGMNR_FILTER$
LOGMNR_SESSION_ACTIONS$
LOGMNR_PARAMETER$
LOGMNR_SESSION$
LOGMNR_PROFILE_TABLE_STATS$
LOGMNR_PROFILE_PLSQL_STATS$
REDO_DB
REDO_LOG
ROLLING$CONNECTIONS
ROLLING$DATABASES
ROLLING$DIRECTIVES
ROLLING$EVENTS
ROLLING$PARAMETERS
ROLLING$PLAN
ROLLING$STATISTICS
ROLLING$STATUS
MVIEW$_ADV_WORKLOAD
MVIEW$_ADV_BASETABLE
MVIEW$_ADV_SQLDEPEND
MVIEW$_ADV_PRETTY
MVIEW$_ADV_TEMP
MVIEW$_ADV_FILTER
MVIEW$_ADV_LOG
MVIEW$_ADV_FILTERINSTANCE
MVIEW$_ADV_LEVEL
MVIEW$_ADV_ROLLUP
MVIEW$_ADV_AJG
MVIEW$_ADV_FJG
MVIEW$_ADV_GC
MVIEW$_ADV_CLIQUE
MVIEW$_ADV_ELIGIBLE
MVIEW$_ADV_OUTPUT
MVIEW$_ADV_EXCEPTIONS
MVIEW$_ADV_PARAMETERS
MVIEW$_ADV_INFO
MVIEW$_ADV_JOURNAL
MVIEW$_ADV_PLAN
AQ$_QUEUE_TABLES
AQ$_KEY_SHARD_MAP
AQ$_QUEUES
AQ$_SCHEDULES
AQ$_INTERNET_AGENTS
AQ$_INTERNET_AGENT_PRIVS
SCHEDULER_PROGRAM_ARGS_TBL
SCHEDULER_JOB_ARGS_TBL
LOGSTDBY$PARAMETERS
LOGSTDBY$EVENTS
LOGSTDBY$APPLY_MILESTONE
LOGSTDBY$SCN
LOGSTDBY$FLASHBACK_SCN
LOGSTDBY$PLSQL
LOGSTDBY$SKIP_TRANSACTION
LOGSTDBY$SKIP
LOGSTDBY$SKIP_SUPPORT
LOGSTDBY$HISTORY
LOGSTDBY$EDS_TABLES
SQLPLUS_PRODUCT_PROFILE
HELP
LOGMNR_GT_TAB_INCLUDE$
LOGMNR_GT_USER_INCLUDE$
LOGMNR_GT_XID_INCLUDE$
LOGMNRT_MDDL$
OL$
OL$HINTS
OL$NODES
LOGMNR_DICTSTATE$
LOGMNRC_GTLO
LOGMNRC_GTCS
LOGMNRC_SEQ_GG
LOGMNRC_CON_GG
LOGMNRC_CONCOL_GG
LOGMNRC_IND_GG
LOGMNRC_INDCOL_GG
LOGMNRC_SHARD_TS
LOGMNRC_TSPART
LOGMNRC_TS
LOGMNRC_GSII
LOGMNRC_GSBA
LOGMNRC_USER
LOGMNR_SEED$
LOGMNR_DICTIONARY$
LOGMNR_OBJ$
LOGMNR_TAB$
LOGMNR_COL$
LOGMNR_ATTRCOL$
LOGMNR_TS$
LOGMNR_IND$
LOGMNR_USER$
LOGMNR_TABPART$
LOGMNR_TABSUBPART$
LOGMNR_TABCOMPART$
LOGMNR_TYPE$
LOGMNR_COLTYPE$
LOGMNR_ATTRIBUTE$
LOGMNR_LOB$
LOGMNR_CON$
LOGMNR_CONTAINER$
LOGMNR_CDEF$
LOGMNR_CCOL$
LOGMNR_ICOL$
LOGMNR_LOBFRAG$
LOGMNR_INDPART$
LOGMNR_INDSUBPART$
LOGMNR_INDCOMPART$
LOGMNR_LOGMNR_BUILDLOG
LOGMNR_NTAB$
LOGMNR_OPQTYPE$
LOGMNR_SUBCOLTYPE$
LOGMNR_KOPM$
LOGMNR_PROPS$
LOGMNR_ENC$
LOGMNR_REFCON$
LOGMNR_IDNSEQ$
LOGMNR_PARTOBJ$
LOGMNRP_CTAS_PART_MAP
LOGMNR_SHARD_TS
LOGSTDBY$APPLY_PROGRESS
 
132 rows selected.
 
SQL> 

 

 

 

도커 : 이미지 목록 조회, 삭제

orangepi@orangepi3b:~/cloud-native-oracle$ docker images
REPOSITORY    TAG          IMAGE ID       CREATED         SIZE
oraclelinux   8-slim-19c   c0e3a8e31386   8 minutes ago   676MB
orangepi@orangepi3b:~/cloud-native-oracle$ docker rmi c0e3a8e31386
Untagged: oraclelinux:8-slim-19c
Deleted: sha256:c0e3a8e3138639bda7c2fa55e1d5ebff39ff1706665f8b4e9da0bb966882344b
orangepi@orangepi3b:~/cloud-native-oracle$ docker images
REPOSITORY   TAG       IMAGE ID   CREATED   SIZE
orangepi@orangepi3b:~/cloud-native-oracle$