OS/Orange PI
Orange Pi 3B : ARM 프로세서를 지원하는 Oracle 데이터베이스용 컨테이너 이미지 빌드
파란크리스마스
2024. 3. 1. 22:05
728x90
출처
- GitHub - oraclesean/cloud-native-oracle: A repository of container image builds for Oracle databases, with support for Intel, Apple Silicon, and ARM processors.
- buildContainerImage.sh fails when called as documented in README.md · Issue #1944 · oracle/docker-images · GitHub
- [DB] oracle database 19c with docker (arm 기반 mac) 설치 및 실행 ::: Profile-exe.log
- Setup Oracle Database on Apple Silicon Chip (Docker) · GitHub
- How to run Oracle DB in Docker. A quick and easy local setup | by Sebastian Ohm | Medium
- Docker활용 Oracle 11g 설치하기 : David'sStudy
리눅스 버전 확인
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.44Oracle 데이터베이스용 컨테이너 이미지 빌드 스크립트 다운로드
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 templatesDatabase 파일(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 foundLINUX.ARM64_1919000_db_home.zip 파일을 다운받아서 database 디렉토리에 복사
orangepi@orangepi3b:~/cloud-native-oracle$ ls database/
LINUX.ARM64_1919000_db_home.zip patches README.mdARM 프로세서를 지원하는 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 ~/.profileCONTAINER_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}
doneorangepi@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 recoOracle 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-EEorangepi@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 296960KSQLPlus 접속
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$