'분류 전체보기' 카테고리의 글 목록 (6 Page)

분류 전체보기

OCI VM기반 ACFS Resize 및 생성 2022.10.11
OCI DBCS Oracle Database 19c SE2 Transparent Data Encryption(TDE) 2022.10.04
Oracle Linux 8에 xorg-x11-apps Package 설치 하기 2022.09.26

OCI VM기반 ACFS Resize 및 생성

2022. 10. 11. 09:00

기존 상태 확인

[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62         5.0G  319M  4.7G   7% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       one19c                   STABLE
ora.chad
               ONLINE  ONLINE       one19c                   STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       one19c                   mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       one19c                   STABLE
ora.ons
               ONLINE  ONLINE       one19c                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       one19c                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.cvu
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c.vip
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c_icn153.db
      1        ONLINE  ONLINE       one19c                   Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       one19c                   STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/opt/oracle/dcs/commonstore
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Mon Sep 26 09:59:48 2022
    mount time:      Tue Sep 27 08:48:23 2022
    mount sequence number: 0
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   5368709120  (   5.00 GB )
    total free:   5034442752  (   4.69 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/commonstore-62
        label:
        state:                 Available
        major, minor:          251, 31745
        logical sector size:   512
        size:                  5368709120  (   5.00 GB )
        free:                  5034442752  (   4.69 GB )
        metadata read I/O count:         2140
        metadata write I/O count:        10
        total metadata bytes read:       8765440  (   8.36 MB )
        total metadata bytes written:    40960  (  40.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED
[grid@one19c ~]$

기존 ACFS Resize

[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62         5.0G  319M  4.7G   7% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil size 10G /opt/oracle/dcs/commonstore
acfsutil size: new file system size: 10737418240 (10240MB)
[grid@one19c ~]$
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62          10G  329M  9.7G   4% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/opt/oracle/dcs/commonstore
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Mon Sep 26 09:59:48 2022
    mount time:      Tue Sep 27 08:48:23 2022
    mount sequence number: 0
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   10737418240  (  10.00 GB )
    total free:   10392502272  (   9.68 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/commonstore-62
        label:
        state:                 Available
        major, minor:          251, 31745
        logical sector size:   512
        size:                  10737418240  (  10.00 GB )
        free:                  10392502272  (   9.68 GB )
        metadata read I/O count:         4278
        metadata write I/O count:        45
        total metadata bytes read:       17575936  (  16.76 MB )
        total metadata bytes written:    393216  ( 384.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED
[grid@one19c ~]$

신규 ACFS 생성

[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd -p
ASMCMD [+] > volcreate -G DATA -s 10G VOLUME1
ASMCMD [+] >
ASMCMD [+] > volinfo -G DATA VOLUME1
Diskgroup Name: DATA

         Volume Name: VOLUME1
         Volume Device: /dev/asm/volume1-62
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage:
         Mountpath:

ASMCMD [+] > exit
[grid@one19c ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 27 14:34:20 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> col volume_name for a20
SQL> col volume_device for a50
SQL> set linesize 150
SQL> SELECT volume_name, volume_device FROM V$ASM_VOLUME;
VOLUME_NAME          VOLUME_DEVICE
-------------------- --------------------------------------------------
COMMONSTORE          /dev/asm/commonstore-62
VOLUME1              /dev/asm/volume1-62
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[grid@one19c ~]$
[grid@one19c ~]$ which mkfs
/usr/sbin/mkfs
[grid@one19c ~]$ ls -al /usr/sbin/mkfs
-rwxr-xr-x 1 root root 11520 Dec 10  2021 /usr/sbin/mkfs
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ mkfs -t acfs /dev/asm/volume1-62
mkfs.acfs: version                   = 19.0.0.0.0
mkfs.acfs: on-disk version           = 46.0
mkfs.acfs: volume                    = /dev/asm/volume1-62
mkfs.acfs: volume size               = 10737418240  (  10.00 GB )
mkfs.acfs: Format complete.
[grid@one19c ~]$ exit
[root@one19c /]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]#
[root@one19c /]# mkdir /u02
[root@one19c /]# chown oracle:oinstall /u02
[root@one19c /]# cd /u01/app/19.0.0.0/grid/bin
[root@one19c bin]# pwd
/u01/app/19.0.0.0/grid/bin
[root@one19c bin]#
[root@one19c bin]# ./srvctl add filesystem -device /dev/asm/volume1-62 -path /u02
[root@one19c bin]# ./crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
               OFFLINE OFFLINE      one19c                   STABLE
--------------------------------------------------------------------------------
[root@one19c bin]# su - grid
[grid@one19c ~]$ srvctl start filesystem -d /dev/asm/volume1-62
[grid@one19c ~]$ crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
               ONLINE  ONLINE       one19c                   mounted on /u02,STAB
                                                             LE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   20M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  136M   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62          10G  329M  9.7G   4% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
/dev/asm/volume1-62              10G  329M  9.7G   4% /u02
[grid@one19c ~]$

OCI DBCS Oracle Database 19c SE2 Transparent Data Encryption(TDE)

2022. 10. 4. 09:00

일반적인 On-Premise환경에서 Oracle DB Standard Edition은 Transparent Data Encryption(TDE)를 지원 하지 않는다.
그러나 OCI DBCS환경에서는 Oracle DB Standard Edition에도 TDE를 지원 한다.

TDE 설정 확인

[oracle@one19c admin]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin
[oracle@one19c admin]$ ls
samples  shrept.lst  sqlnet.ora  tnsnames.ora
[oracle@one19c admin]$ more sqlnet.ora
# ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME)))
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde)))
SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)
SQLNET.ENCRYPTION_CLIENT=REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
SQLNET.EXPIRE_TIME=10
[oracle@one19c admin]$
[oracle@one19c ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 16:15:52 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
SQL> select PARAMETER, VALUE from v$option where parameter='Transparent Data Encryption';
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Transparent Data Encryption                                      FALSE
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ONE19C_PDB1                    READ WRITE NO
         4 SEPDB1                         READ WRITE NO
SQL>
SQL>
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> set linesize 200
SQL> col WRL_TYPE for a10
SQL> col WRL_PARAMETER for a60
SQL> select * from v$encryption_wallet;
WRL_TYPE   WRL_PARAMETER                                                STATUS                         WALLET_TYPE          WALLET_OR KEYSTORE FULLY_BAC     CON_ID
---------- ------------------------------------------------------------ ------------------------------ -------------------- --------- -------- --------- ----------
FILE       /opt/oracle/dcs/commonstore/wallets/one19c_icn1s3/tde/       OPEN                           AUTOLOGIN            SINGLE    NONE     NO                 1
FILE                                                                    OPEN                           AUTOLOGIN            SINGLE    UNITED   NO                 2
FILE                                                                    OPEN                           AUTOLOGIN            SINGLE    UNITED   NO                 3
FILE                                                                    OPEN                           AUTOLOGIN            SINGLE    UNITED   NO                 4
SQL>
SQL> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces;

TABLESPACE_NAME                ENC
------------------------------ ---
SYSTEM                         NO
SYSAUX                         NO
UNDOTBS1                       NO
TEMP                           NO
USERS                          YES
SQL>

암호화 Tablespace 생성

[oracle@one19c ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 16:15:52 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> alter session set container=SEPDB1;
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 SEPDB1                         READ WRITE NO
SQL>
SQL> show con_name
CON_NAME
------------------------------
SEPDB1
SQL>
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

SQL> select PARAMETER, VALUE from v$option where parameter='Transparent Data Encryption';
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Transparent Data Encryption                                      FALSE
SQL>
SQL> set linesize 200
SQL> col WRL_TYPE for a10
SQL> col WRL_PARAMETER for a60
SQL> SELECT * FROM V$ENCRYPTION_WALLET;
WRL_TYPE   WRL_PARAMETER                                                STATUS                         WALLET_TYPE          WALLET_OR KEYSTORE FULLY_BAC     CON_ID
---------- ------------------------------------------------------------ ------------------------------ -------------------- --------- -------- --------- ----------
FILE                                                                    OPEN                           AUTOLOGIN            SINGLE    UNITED   NO                 4
SQL>
SQL> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces;
TABLESPACE_NAME                ENC
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
SQL>
SQL> SELECT VT.NAME, VET.ENCRYPTIONALG FROM V$TABLESPACE VT, V$ENCRYPTED_TABLESPACES VET WHERE VT.TS#=VET.TS#;
NAME                           ENCRYPT
------------------------------ -------
SYSTEM                         AES128
SYSAUX                         AES128
UNDOTBS1                       AES128
TEMP                           AES128
USERS                          AES128
SQL>
SQL> CREATE TABLESPACE ENC_TS_AES256 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_DEFAULT DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_3DES168 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING '3DES168' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_AES192 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES192' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_ARIA192 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'ARIA128' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_ARIA256 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'ARIA192' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_SEED128 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'SEED128' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL> CREATE TABLESPACE ENC_TS_GOST256 DATAFILE SIZE 1G AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'GOST256' DEFAULT STORAGE(ENCRYPT);
Tablespace created.
SQL>
SQL> select TABLESPACE_NAME, ENCRYPTED from dba_tablespaces;
TABLESPACE_NAME                ENC
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
ENC_TS_AES256                  YES
ENC_TS_DEFAULT                 YES
ENC_TS_3DES168                 YES
ENC_TS_AES192                  YES
ENC_TS_ARIA192                 YES
ENC_TS_ARIA256                 YES
ENC_TS_SEED128                 YES
ENC_TS_GOST256                 YES
13 rows selected.
SQL>
SQL> SELECT VT.NAME, VET.ENCRYPTIONALG FROM V$TABLESPACE VT, V$ENCRYPTED_TABLESPACES VET WHERE VT.TS#=VET.TS#;
NAME                           ENCRYPT
------------------------------ -------
SYSTEM                         AES128
SYSAUX                         AES128
UNDOTBS1                       AES128
TEMP                           AES128
USERS                          AES128
ENC_TS_AES256                  AES256
ENC_TS_DEFAULT                 AES128
ENC_TS_3DES168                 3DES168
ENC_TS_AES192                  AES192
ENC_TS_ARIA192                 ARIA128
ENC_TS_ARIA256                 ARIA192
ENC_TS_SEED128                 SEED128
ENC_TS_GOST256                 GOST256
SQL> exit
[oracle@one19c ~]$

Oracle Linux 8에 xorg-x11-apps Package 설치 하기

2022. 9. 26. 09:00

현 상태 확인

[root@ol8-19c-sinlge ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@ol8-19c-sinlge ~]# more /etc/oracle-release
Oracle Linux Server release 8.6
[root@ol8-19c-sinlge ~]#
[root@ol8-19c-sinlge ~]# uname -a
Linux ol8-19c-sinlge.localdomain 5.4.17-2136.309.5.el8uek.x86_64 #2 SMP Sat Jul 16 13:06:22 PDT 2022 x86_64 x86_64 x86_64 GNU/Linux
[root@ol8-19c-sinlge ~]#
[root@ol8-19c-sinlge ~]# dnf install xorg-x11-apps
Last metadata expiration check: 0:03:23 ago on Mon 29 Aug 2022 04:03:27 PM KST.
No match for argument: xorg-x11-apps
Error: Unable to find a match: xorg-x11-apps
[root@ol8-19c-sinlge ~]#

xorg-x11-apps Package 설치 하기

[root@ol8-19c-sinlge ~]# dnf config-manager --enable ol8_codeready_builder
[root@ol8-19c-sinlge ~]# dnf install xorg-x11-apps
Oracle Linux 8 BaseOS Latest (x86_64)                                                                                                                                         6.4 kB/s | 3.6 kB     00:00
Oracle Linux 8 Application Stream (x86_64)                                                                                                                                    7.0 kB/s | 3.9 kB     00:00
Oracle Linux 8 CodeReady Builder (x86_64) - Unsupported                                                                                                                       2.4 MB/s | 6.5 MB     00:02
Dependencies resolved.
==============================================================================================================================================================================================================
 Package                                               Architecture                             Version                                         Repository                                               Size
==============================================================================================================================================================================================================
Installing:
 xorg-x11-apps                                         x86_64                                   7.7-21.el8                                      ol8_codeready_builder                                   334 k
Installing dependencies:
 xorg-x11-fonts-misc                                   noarch                                   7.5-19.el8                                      ol8_appstream                                           5.8 M
 xorg-x11-xbitmaps                                     noarch                                   1.1.1-13.el8                                    ol8_appstream                                            42 k

Transaction Summary
==============================================================================================================================================================================================================
Install  3 Packages

Total download size: 6.1 M
Installed size: 8.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): xorg-x11-xbitmaps-1.1.1-13.el8.noarch.rpm                                                                                                                               53 kB/s |  42 kB     00:00
(2/3): xorg-x11-apps-7.7-21.el8.x86_64.rpm                                                                                                                                    235 kB/s | 334 kB     00:01
(3/3): xorg-x11-fonts-misc-7.5-19.el8.noarch.rpm                                                                                                                              2.3 MB/s | 5.8 MB     00:02
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                         2.5 MB/s | 6.1 MB     00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                                                      1/1
  Installing       : xorg-x11-xbitmaps-1.1.1-13.el8.noarch                                                                                                                                                1/3
  Installing       : xorg-x11-fonts-misc-7.5-19.el8.noarch                                                                                                                                                2/3
  Running scriptlet: xorg-x11-fonts-misc-7.5-19.el8.noarch                                                                                                                                                2/3
  Installing       : xorg-x11-apps-7.7-21.el8.x86_64                                                                                                                                                      3/3
  Running scriptlet: xorg-x11-apps-7.7-21.el8.x86_64                                                                                                                                                      3/3
/sbin/ldconfig: /etc/ld.so.conf.d/kernel-5.4.17-2102.201.3.el8uek.x86_64.conf:6: hwcap directive ignored

  Verifying        : xorg-x11-fonts-misc-7.5-19.el8.noarch                                                                                                                                                1/3
  Verifying        : xorg-x11-xbitmaps-1.1.1-13.el8.noarch                                                                                                                                                2/3
  Verifying        : xorg-x11-apps-7.7-21.el8.x86_64                                                                                                                                                      3/3

Installed:
  xorg-x11-apps-7.7-21.el8.x86_64                                 xorg-x11-fonts-misc-7.5-19.el8.noarch                                 xorg-x11-xbitmaps-1.1.1-13.el8.noarch

Complete!
[root@ol8-19c-sinlge ~]#
[root@ol8-19c-sinlge ~]# which xclock
/usr/bin/xclock
[root@ol8-19c-sinlge ~]#

How To Install "xorg-x11-apps" Package in Oracle Linux 8 (문서 ID 2849317.1)

PREV 1 ···3 4 5 6 7 8 9 ···15 NEXT

Database Sync