はじめに
2023年4月に Oracle Database 23c Free-Developer Release が発表されました。その後、2023年9月にBase-DBで23cがGAされたことにともない、Oracle Database 23c Freeが新たにリリースされていました。
という事で、現在お試し環境として利用している 23c Free-Developer Releaseの環境を、最新の 23c Freeの環境にアップグレードしてみました。
なお、23c Free-Developer Releaseは既に提供は終了されているようです。
Oracle Database 23c Freeへアップグレードしてみた
アップグレード対象の環境は、現在お試し環境として利用している以下の環境です。
- OS: RHEL8.4
- DB: Oracle Database 23c Free-Developer Release(23.2.0.0.0)
- OBJECT: TESTTBLオブジェクトをTESTUSRスキーマに作成
TESTTBLオブジェクト
$ sqlplus TESTUSR/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/FREEPDB1
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Oct 2 05:01:17 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Mon Oct 02 2023 04:28:11 +00:00
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> select object_name from user_objects;
OBJECT_NAME
--------------------------------------------------------------------------------
TESTTBL
SQL> select * from testtbl;
ID TESTCOL
---------- --------------------
1 hogehoge
2 hogehogehoge
SQL>
アップグレードの方法は 23c Free の Installation Guideにある 通り、以下のような流れになります。インプレースアップグレードのようなことはできないようです。
- 23c Free-Developer Releaseのデータをエクスポート
- 23c Free-Developer Releaseをアンインストール（+ PreInstallation RPMsもアンインストール）
- 23c Freeをインストール（+ PreInstallation RPMsもインストール）
- エクスポートデータをインポート
では、実施していきます。
1. 23c Free-Developer Releaseのデータをエクスポート
SYSTEMユーザでFULL=Yでexpdpするだけですが、一応手順はDirectoryを作って権限をつけるところも実施されているので、そちらをなぞります。
エクスポート用のディレクトリ作成等、エクスポート準備を行います。
エクスポート準備
$ sqlplus '/as sysdba'
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Oct 2 04:34:23 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> ALTER SESSION SET CONTAINER=freepdb1;
Session altered.
SQL> CREATE DIRECTORY DUMP_DIR AS '/opt/dump';
Directory created.
SQL> GRANT READ, WRITE ON DIRECTORY DUMP_DIR TO SYSTEM;
Grant succeeded.
SQL> exit
SYSTEMユーザでFULL Exportを行います。
エクスポート実行
$ /opt/oracle/product/23c/dbhomeFree/bin/expdp system/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/freepdb1 full=Y directory=DUMP_DIR dumpfile=expdb23c_freepdb1.dmp logfile=expdb23c_freepdb1.log
Export: Release 23.0.0.0.0 - Developer-Release on Mon Oct 2 04:38:29 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/freepdb1 full=Y directory=DUMP_DIR dumpfile=expdb23c_freepdb1.dmp logfile=expdb23c_freepdb1.log
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/RULE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/AQ
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/SQL
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/JVM
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM/LOGREP
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ/SCHEDULER
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM/SEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA/LOGREP
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
. . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.070 KB 34 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P265" 22.86 MB 14062 rows
. . exported "SYSTEM"."REDO_DB" 27.18 KB 1 rows
. . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.50 KB 1 rows
. . exported "WMSYS"."WM$HINT_TABLE$" 10.10 KB 97 rows
. . exported "LBACSYS"."OLS$INSTALLATIONS" 7.078 KB 2 rows
. . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.195 KB 11 rows
. . exported "SYS"."DAM_CONFIG_PARAM$" 6.625 KB 14 rows
. . exported "SYS"."TSDP_SUBPOL$" 6.421 KB 1 rows
. . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.468 KB 1 rows
. . exported "LBACSYS"."OLS$PROPS" 6.171 KB 3 rows
. . exported "WMSYS"."WM$ENV_VARS$" 6.085 KB 3 rows
. . exported "SYS"."TSDP_PARAMETER$" 6.023 KB 1 rows
. . exported "SYS"."TSDP_POLICY$" 5.992 KB 1 rows
. . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 6.054 KB 1 rows
. . exported "WMSYS"."WM$EVENTS_INFO$" 5.859 KB 12 rows
. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.804 KB 8 rows
. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.585 KB 2 rows
. . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P281" 59.59 KB 3 rows
. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P391" 59.44 KB 6 rows
. . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows
. . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POL" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows
. . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows
. . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows
. . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows
. . exported "SYS"."AUD$" 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows
. . exported "SYS"."FW_ALLOW_LIST$" 0 KB 0 rows
. . exported "SYS"."FW_ALLOW_LIST_CONTEXT$" 0 KB 0 rows
. . exported "SYS"."FW_ALLOW_LIST_SQL$" 0 KB 0 rows
. . exported "SYS"."FW_CAPTURE$" 0 KB 0 rows
. . exported "SYS"."SQL_LOG$" 0 KB 0 rows
. . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows
. . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows
. . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows
. . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows
. . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows
. . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows
. . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows
. . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows
. . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows
. . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows
. . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows
. . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows
. . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows
. . exported "MDSYS"."RDF_PARAM$" 6.609 KB 3 rows
. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 6.023 KB 2 rows
. . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows
. . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . exported "SYS"."GV_$UNIFIED_AUDIT_TRAIL" 0 KB 0 rows
. . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows
. . exported "SYS"."NACL$_HOST_EXP" 7.476 KB 1 rows
. . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows
. . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows
. . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows
. . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows
. . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows
. . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows
. . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows
. . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows
. . exported "WMSYS"."WM$EXP_MAP" 7.882 KB 3 rows
. . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows
. . exported "TESTUSR"."TESTTBL" 5.554 KB 2 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
/opt/dump/expdb23c_freepdb1.dmp
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Mon Oct 2 04:44:10 2023 elapsed 0 00:05:36
2. 23c Free-Developer Releaseをアンインストール（+ PreInstallation RPMsもアンインストール）
23c Free-Developer ReleaseのDB (SID=FREE) を削除します。
FREE DB削除
# /etc/init.d/oracle-free-23c delete
Deleting Oracle Listener.
Deleting Oracle Database FREE.
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
39% complete
42% complete
45% complete
48% complete
52% complete
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE0.log" for further details.
23c Free-Developer Releaseをアンインストールします。
23c Free-Developer Releaseアンインストール
# yum remove oracle-database-free-23c
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use subscription-manager to register.
Dependencies resolved.
==================================================================================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================================================================================
Removing:
oracle-database-free-23c x86_64 1.0-1 @@commandline 5.2 G
Transaction Summary
==================================================================================================================================================================================================================
Remove 1 Package
Freed space: 5.2 G
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
Erasing : oracle-database-free-23c-1.0-1.x86_64 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
Verifying : oracle-database-free-23c-1.0-1.x86_64 1/1
Installed products updated.
Removed:
oracle-database-free-23c-1.0-1.x86_64
Complete!
23c Free-Developer Release用のRPM（oracle-database-preinstall-23c）を削除します。
Preinstallation RPMsの削除
# yum remove oracle-database-preinstall-23c
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use subscription-manager to register.
Dependencies resolved.
==================================================================================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================================================================================
Removing:
oracle-database-preinstall-23c x86_64 1.0-0.5.el8 @@commandline 77 k
Removing unused dependencies:
bc x86_64 1.07.1-5.el8 @rhel-8-baseos-rhui-rpms 234 k
bind-libs x86_64 32:9.11.36-8.el8 @rhel-8-appstream-rhui-rpms 198 k
bind-libs-lite x86_64 32:9.11.36-8.el8 @rhel-8-appstream-rhui-rpms 3.1 M
bind-license noarch 32:9.11.36-8.el8 @rhel-8-appstream-rhui-rpms 29 k
bind-utils x86_64 32:9.11.36-8.el8 @rhel-8-appstream-rhui-rpms 1.3 M
binutils x86_64 2.30-119.el8 @rhel-8-baseos-rhui-rpms 24 M
compat-openssl10 x86_64 1:1.0.2o-4.el8_6 @rhel-8-appstream-rhui-rpms 2.9 M
fstrm x86_64 0.6.1-3.el8 @rhel-8-appstream-rhui-rpms 47 k
glibc-devel x86_64 2.28-189.1.el8 @rhel-8-baseos-rhui-rpms 234 k
glibc-headers x86_64 2.28-189.1.el8 @rhel-8-baseos-rhui-rpms 1.9 M
gssproxy x86_64 0.8.0-21.el8 @rhel-8-baseos-rhui-rpms 263 k
kernel-headers x86_64 4.18.0-477.13.1.el8_8 @rhel-8-baseos-rhui-rpms 5.3 M
keyutils x86_64 1.5.10-9.el8 @rhel-8-baseos-rhui-rpms 118 k
ksh x86_64 20120801-257.el8 @rhel-8-appstream-rhui-rpms 3.2 M
libICE x86_64 1.0.9-15.el8 @rhel-8-appstream-rhui-rpms 191 k
libSM x86_64 1.2.3-1.el8 @rhel-8-appstream-rhui-rpms 91 k
libX11 x86_64 1.6.8-5.el8 @rhel-8-appstream-rhui-rpms 1.3 M
libX11-common noarch 1.6.8-5.el8 @rhel-8-appstream-rhui-rpms 1.3 M
libX11-xcb x86_64 1.6.8-5.el8 @rhel-8-appstream-rhui-rpms 7.4 k
libXau x86_64 1.0.9-3.el8 @rhel-8-appstream-rhui-rpms 60 k
libXcomposite x86_64 0.4.4-14.el8 @rhel-8-appstream-rhui-rpms 35 k
libXext x86_64 1.3.4-1.el8 @rhel-8-appstream-rhui-rpms 90 k
libXi x86_64 1.7.10-1.el8 @rhel-8-appstream-rhui-rpms 73 k
libXinerama x86_64 1.1.4-1.el8 @rhel-8-appstream-rhui-rpms 15 k
libXmu x86_64 1.1.3-1.el8 @rhel-8-appstream-rhui-rpms 177 k
libXrandr x86_64 1.5.2-1.el8 @rhel-8-appstream-rhui-rpms 48 k
libXrender x86_64 0.9.10-7.el8 @rhel-8-appstream-rhui-rpms 50 k
libXt x86_64 1.1.5-12.el8 @rhel-8-appstream-rhui-rpms 538 k
libXtst x86_64 1.2.3-7.el8 @rhel-8-appstream-rhui-rpms 34 k
libXv x86_64 1.0.11-7.el8 @rhel-8-appstream-rhui-rpms 26 k
libXxf86dga x86_64 1.1.5-1.el8 @rhel-8-appstream-rhui-rpms 30 k
libXxf86misc x86_64 1.0.4-1.el8 @rhel-8-appstream-rhui-rpms 31 k
libXxf86vm x86_64 1.1.4-9.el8 @rhel-8-appstream-rhui-rpms 26 k
libaio x86_64 0.3.112-1.el8 @rhel-8-baseos-rhui-rpms 93 k
libdmx x86_64 1.1.4-3.el8 @rhel-8-appstream-rhui-rpms 21 k
libnsl x86_64 2.28-189.1.el8 @rhel-8-baseos-rhui-rpms 97 k
libverto-libevent x86_64 0.3.0-5.el8 @rhel-8-baseos-rhui-rpms 12 k
libxcb x86_64 1.13.1-1.el8 @rhel-8-appstream-rhui-rpms 1.0 M
libxcrypt-devel x86_64 4.1.1-6.el8 @rhel-8-baseos-rhui-rpms 24 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 @rhel-8-baseos-rhui-rpms 87 k
make x86_64 1:4.2.1-11.el8 @rhel-8-baseos-rhui-rpms 1.4 M
net-tools x86_64 2.0-0.52.20160912git.el8 @rhel-8-baseos-rhui-rpms 942 k
nfs-utils x86_64 1:2.3.3-59.el8 @rhel-8-baseos-rhui-rpms 1.6 M
policycoreutils-python-utils noarch 2.9-19.el8 @rhel-8-baseos-rhui-rpms 138 k
protobuf-c x86_64 1.3.0-6.el8 @rhel-8-appstream-rhui-rpms 56 k
python3-bind noarch 32:9.11.36-8.el8 @rhel-8-appstream-rhui-rpms 178 k
quota x86_64 1:4.04-14.el8 @rhel-8-baseos-rhui-rpms 887 k
quota-nls noarch 1:4.04-14.el8 @rhel-8-baseos-rhui-rpms 277 k
rpcbind x86_64 1.2.5-10.el8 @rhel-8-baseos-rhui-rpms 108 k
smartmontools x86_64 1:7.1-1.el8 @rhel-8-baseos-rhui-rpms 1.9 M
sysstat x86_64 11.7.3-9.el8 @rhel-8-appstream-rhui-rpms 1.4 M
unzip x86_64 6.0-46.el8 @rhel-8-baseos-rhui-rpms 414 k
xorg-x11-utils x86_64 7.5-28.el8 @rhel-8-appstream-rhui-rpms 332 k
xorg-x11-xauth x86_64 1:1.0.9-12.el8 @rhel-8-appstream-rhui-rpms 63 k
Transaction Summary
==================================================================================================================================================================================================================
Remove 55 Packages
Freed space: 58 M
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 1/1
Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 1/55
Erasing : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 1/55
Running scriptlet: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 1/55
Erasing : xorg-x11-utils-7.5-28.el8.x86_64 2/55
Erasing : bind-utils-32:9.11.36-8.el8.x86_64 3/55
Erasing : bind-libs-32:9.11.36-8.el8.x86_64 4/55
Erasing : bind-libs-lite-32:9.11.36-8.el8.x86_64 5/55
Erasing : libXrandr-1.5.2-1.el8.x86_64 6/55
Erasing : libXtst-1.2.3-7.el8.x86_64 7/55
Running scriptlet: nfs-utils-1:2.3.3-59.el8.x86_64 8/55
Erasing : nfs-utils-1:2.3.3-59.el8.x86_64 8/55
warning: directory /var/lib/nfs/rpc_pipefs: remove failed: Device or resource busy
Running scriptlet: nfs-utils-1:2.3.3-59.el8.x86_64 8/55
Erasing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 9/55
Running scriptlet: glibc-devel-2.28-189.1.el8.x86_64 10/55
Erasing : glibc-devel-2.28-189.1.el8.x86_64 10/55
Erasing : libXmu-1.1.3-1.el8.x86_64 11/55
Erasing : libXt-1.1.5-12.el8.x86_64 12/55
Erasing : libXi-1.7.10-1.el8.x86_64 13/55
Erasing : libXinerama-1.1.4-1.el8.x86_64 14/55
Erasing : libXv-1.0.11-7.el8.x86_64 15/55
Erasing : libXxf86dga-1.1.5-1.el8.x86_64 16/55
Erasing : libXxf86vm-1.1.4-9.el8.x86_64 17/55
Erasing : libdmx-1.1.4-3.el8.x86_64 18/55
Erasing : libXrender-0.9.10-7.el8.x86_64 19/55
Erasing : libXxf86misc-1.0.4-1.el8.x86_64 20/55
Erasing : libxcrypt-devel-4.1.1-6.el8.x86_64 21/55
Erasing : glibc-headers-2.28-189.1.el8.x86_64 22/55
Erasing : python3-bind-32:9.11.36-8.el8.noarch 23/55
Erasing : libXext-1.3.4-1.el8.x86_64 24/55
Erasing : libSM-1.2.3-1.el8.x86_64 25/55
Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 26/55
Erasing : gssproxy-0.8.0-21.el8.x86_64 26/55
Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 26/55
Erasing : quota-1:4.04-14.el8.x86_64 27/55
Erasing : libXcomposite-0.4.4-14.el8.x86_64 28/55
Erasing : libX11-1.6.8-5.el8.x86_64 29/55
Erasing : libxcb-1.13.1-1.el8.x86_64 30/55
Erasing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 31/55
Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 31/55
Running scriptlet: sysstat-11.7.3-9.el8.x86_64 32/55
Erasing : sysstat-11.7.3-9.el8.x86_64 32/55
Running scriptlet: sysstat-11.7.3-9.el8.x86_64 32/55
Erasing : libX11-common-1.6.8-5.el8.noarch 33/55
Erasing : quota-nls-1:4.04-14.el8.noarch 34/55
Erasing : bind-license-32:9.11.36-8.el8.noarch 35/55
Erasing : kernel-headers-4.18.0-477.13.1.el8_8.x86_64 36/55
Erasing : policycoreutils-python-utils-2.9-19.el8.noarch 37/55
Erasing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 38/55
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 38/55
Running scriptlet: make-1:4.2.1-11.el8.x86_64 39/55
Erasing : make-1:4.2.1-11.el8.x86_64 39/55
Erasing : libXau-1.0.9-3.el8.x86_64 40/55
Erasing : libverto-libevent-0.3.0-5.el8.x86_64 41/55
Erasing : libICE-1.0.9-15.el8.x86_64 42/55
Erasing : keyutils-1.5.10-9.el8.x86_64 43/55
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 44/55
Erasing : rpcbind-1.2.5-10.el8.x86_64 44/55
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 44/55
Erasing : fstrm-0.6.1-3.el8.x86_64 45/55
Erasing : protobuf-c-1.3.0-6.el8.x86_64 46/55
Erasing : libX11-xcb-1.6.8-5.el8.x86_64 47/55
Running scriptlet: bc-1.07.1-5.el8.x86_64 48/55
Erasing : bc-1.07.1-5.el8.x86_64 48/55
Running scriptlet: binutils-2.30-119.el8.x86_64 49/55
Erasing : binutils-2.30-119.el8.x86_64 49/55
Running scriptlet: binutils-2.30-119.el8.x86_64 49/55
Running scriptlet: ksh-20120801-257.el8.x86_64 50/55
Erasing : ksh-20120801-257.el8.x86_64 50/55
Running scriptlet: ksh-20120801-257.el8.x86_64 50/55
Erasing : libaio-0.3.112-1.el8.x86_64 51/55
Erasing : libnsl-2.28-189.1.el8.x86_64 52/55
Erasing : net-tools-2.0-0.52.20160912git.el8.x86_64 53/55
Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 53/55
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 54/55
Erasing : smartmontools-1:7.1-1.el8.x86_64 54/55
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 54/55
Erasing : unzip-6.0-46.el8.x86_64 55/55
Running scriptlet: unzip-6.0-46.el8.x86_64 55/55
Verifying : bc-1.07.1-5.el8.x86_64 1/55
Verifying : bind-libs-32:9.11.36-8.el8.x86_64 2/55
Verifying : bind-libs-lite-32:9.11.36-8.el8.x86_64 3/55
Verifying : bind-license-32:9.11.36-8.el8.noarch 4/55
Verifying : bind-utils-32:9.11.36-8.el8.x86_64 5/55
Verifying : binutils-2.30-119.el8.x86_64 6/55
Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 7/55
Verifying : fstrm-0.6.1-3.el8.x86_64 8/55
Verifying : glibc-devel-2.28-189.1.el8.x86_64 9/55
Verifying : glibc-headers-2.28-189.1.el8.x86_64 10/55
Verifying : gssproxy-0.8.0-21.el8.x86_64 11/55
Verifying : kernel-headers-4.18.0-477.13.1.el8_8.x86_64 12/55
Verifying : keyutils-1.5.10-9.el8.x86_64 13/55
Verifying : ksh-20120801-257.el8.x86_64 14/55
Verifying : libICE-1.0.9-15.el8.x86_64 15/55
Verifying : libSM-1.2.3-1.el8.x86_64 16/55
Verifying : libX11-1.6.8-5.el8.x86_64 17/55
Verifying : libX11-common-1.6.8-5.el8.noarch 18/55
Verifying : libX11-xcb-1.6.8-5.el8.x86_64 19/55
Verifying : libXau-1.0.9-3.el8.x86_64 20/55
Verifying : libXcomposite-0.4.4-14.el8.x86_64 21/55
Verifying : libXext-1.3.4-1.el8.x86_64 22/55
Verifying : libXi-1.7.10-1.el8.x86_64 23/55
Verifying : libXinerama-1.1.4-1.el8.x86_64 24/55
Verifying : libXmu-1.1.3-1.el8.x86_64 25/55
Verifying : libXrandr-1.5.2-1.el8.x86_64 26/55
Verifying : libXrender-0.9.10-7.el8.x86_64 27/55
Verifying : libXt-1.1.5-12.el8.x86_64 28/55
Verifying : libXtst-1.2.3-7.el8.x86_64 29/55
Verifying : libXv-1.0.11-7.el8.x86_64 30/55
Verifying : libXxf86dga-1.1.5-1.el8.x86_64 31/55
Verifying : libXxf86misc-1.0.4-1.el8.x86_64 32/55
Verifying : libXxf86vm-1.1.4-9.el8.x86_64 33/55
Verifying : libaio-0.3.112-1.el8.x86_64 34/55
Verifying : libdmx-1.1.4-3.el8.x86_64 35/55
Verifying : libnsl-2.28-189.1.el8.x86_64 36/55
Verifying : libverto-libevent-0.3.0-5.el8.x86_64 37/55
Verifying : libxcb-1.13.1-1.el8.x86_64 38/55
Verifying : libxcrypt-devel-4.1.1-6.el8.x86_64 39/55
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 40/55
Verifying : make-1:4.2.1-11.el8.x86_64 41/55
Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 42/55
Verifying : nfs-utils-1:2.3.3-59.el8.x86_64 43/55
Verifying : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 44/55
Verifying : policycoreutils-python-utils-2.9-19.el8.noarch 45/55
Verifying : protobuf-c-1.3.0-6.el8.x86_64 46/55
Verifying : python3-bind-32:9.11.36-8.el8.noarch 47/55
Verifying : quota-1:4.04-14.el8.x86_64 48/55
Verifying : quota-nls-1:4.04-14.el8.noarch 49/55
Verifying : rpcbind-1.2.5-10.el8.x86_64 50/55
Verifying : smartmontools-1:7.1-1.el8.x86_64 51/55
Verifying : sysstat-11.7.3-9.el8.x86_64 52/55
Verifying : unzip-6.0-46.el8.x86_64 53/55
Verifying : xorg-x11-utils-7.5-28.el8.x86_64 54/55
Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 55/55
Installed products updated.
Removed:
bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.36-8.el8.x86_64 bind-libs-lite-32:9.11.36-8.el8.x86_64 bind-license-32:9.11.36-8.el8.noarch
bind-utils-32:9.11.36-8.el8.x86_64 binutils-2.30-119.el8.x86_64 compat-openssl10-1:1.0.2o-4.el8_6.x86_64 fstrm-0.6.1-3.el8.x86_64
glibc-devel-2.28-189.1.el8.x86_64 glibc-headers-2.28-189.1.el8.x86_64 gssproxy-0.8.0-21.el8.x86_64 kernel-headers-4.18.0-477.13.1.el8_8.x86_64
keyutils-1.5.10-9.el8.x86_64 ksh-20120801-257.el8.x86_64 libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64
libX11-1.6.8-5.el8.x86_64 libX11-common-1.6.8-5.el8.noarch libX11-xcb-1.6.8-5.el8.x86_64 libXau-1.0.9-3.el8.x86_64
libXcomposite-0.4.4-14.el8.x86_64 libXext-1.3.4-1.el8.x86_64 libXi-1.7.10-1.el8.x86_64 libXinerama-1.1.4-1.el8.x86_64
libXmu-1.1.3-1.el8.x86_64 libXrandr-1.5.2-1.el8.x86_64 libXrender-0.9.10-7.el8.x86_64 libXt-1.1.5-12.el8.x86_64
libXtst-1.2.3-7.el8.x86_64 libXv-1.0.11-7.el8.x86_64 libXxf86dga-1.1.5-1.el8.x86_64 libXxf86misc-1.0.4-1.el8.x86_64
libXxf86vm-1.1.4-9.el8.x86_64 libaio-0.3.112-1.el8.x86_64 libdmx-1.1.4-3.el8.x86_64 libnsl-2.28-189.1.el8.x86_64
libverto-libevent-0.3.0-5.el8.x86_64 libxcb-1.13.1-1.el8.x86_64 libxcrypt-devel-4.1.1-6.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64
make-1:4.2.1-11.el8.x86_64 net-tools-2.0-0.52.20160912git.el8.x86_64 nfs-utils-1:2.3.3-59.el8.x86_64 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
policycoreutils-python-utils-2.9-19.el8.noarch protobuf-c-1.3.0-6.el8.x86_64 python3-bind-32:9.11.36-8.el8.noarch quota-1:4.04-14.el8.x86_64
quota-nls-1:4.04-14.el8.noarch rpcbind-1.2.5-10.el8.x86_64 smartmontools-1:7.1-1.el8.x86_64 sysstat-11.7.3-9.el8.x86_64
unzip-6.0-46.el8.x86_64 xorg-x11-utils-7.5-28.el8.x86_64 xorg-x11-xauth-1:1.0.9-12.el8.x86_64
Complete!
3. 23c Freeをインストール（+ PreInstallation RPMsもインストール）
23c Freeのインストールを実施します。
RHEL向けのバイナリは こちらのRedHat compatible Linux distribution から入手できます。
まず、23c Free 用のRPM（oracle-database-preinstall-23c-1.0-1.el8.x86_64.rpm）をインストールします。
oracle-database-preinstall-23c-1.0-1.el8.x86_64.rpm のインストール
$ sudo dnf -y localinstall oracle-database-preinstall-23c-1.0-1.el8.x86_64.rpm
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use subscription-manager to register.
Last metadata expiration check: 0:41:01 ago on Mon 02 Oct 2023 04:32:40 AM UTC.
Dependencies resolved.
==================================================================================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================================================================================
Installing:
oracle-database-preinstall-23c x86_64 1.0-1.el8 @commandline 30 k
Installing dependencies:
bc x86_64 1.07.1-5.el8 rhel-8-baseos-rhui-rpms 129 k
bind-libs x86_64 32:9.11.36-8.el8_8.1 rhel-8-appstream-rhui-rpms 176 k
bind-libs-lite x86_64 32:9.11.36-8.el8_8.1 rhel-8-appstream-rhui-rpms 1.2 M
bind-license noarch 32:9.11.36-8.el8_8.1 rhel-8-appstream-rhui-rpms 104 k
bind-utils x86_64 32:9.11.36-8.el8_8.1 rhel-8-appstream-rhui-rpms 453 k
binutils x86_64 2.30-119.el8 rhel-8-baseos-rhui-rpms 5.8 M
compat-openssl10 x86_64 1:1.0.2o-4.el8_6 rhel-8-appstream-rhui-rpms 1.1 M
dejavu-fonts-common noarch 2.35-7.el8 rhel-8-baseos-rhui-rpms 74 k
dejavu-sans-fonts noarch 2.35-7.el8 rhel-8-baseos-rhui-rpms 1.5 M
fontconfig x86_64 2.13.1-4.el8 rhel-8-baseos-rhui-rpms 274 k
fontpackages-filesystem noarch 1.44-22.el8 rhel-8-baseos-rhui-rpms 16 k
fstrm x86_64 0.6.1-3.el8 rhel-8-appstream-rhui-rpms 29 k
glibc-devel x86_64 2.28-189.1.el8 rhel-8-baseos-rhui-rpms 79 k
glibc-headers x86_64 2.28-189.1.el8 rhel-8-baseos-rhui-rpms 483 k
gssproxy x86_64 0.8.0-21.el8 rhel-8-baseos-rhui-rpms 119 k
kernel-headers x86_64 4.18.0-477.27.1.el8_8 rhel-8-baseos-rhui-rpms 11 M
keyutils x86_64 1.5.10-9.el8 rhel-8-baseos-rhui-rpms 66 k
ksh x86_64 20120801-257.el8 rhel-8-appstream-rhui-rpms 929 k
libICE x86_64 1.0.9-15.el8 rhel-8-appstream-rhui-rpms 74 k
libSM x86_64 1.2.3-1.el8 rhel-8-appstream-rhui-rpms 48 k
libX11 x86_64 1.6.8-5.el8 rhel-8-appstream-rhui-rpms 611 k
libX11-common noarch 1.6.8-5.el8 rhel-8-appstream-rhui-rpms 158 k
libX11-xcb x86_64 1.6.8-5.el8 rhel-8-appstream-rhui-rpms 14 k
libXau x86_64 1.0.9-3.el8 rhel-8-appstream-rhui-rpms 37 k
libXcomposite x86_64 0.4.4-14.el8 rhel-8-appstream-rhui-rpms 29 k
libXext x86_64 1.3.4-1.el8 rhel-8-appstream-rhui-rpms 45 k
libXi x86_64 1.7.10-1.el8 rhel-8-appstream-rhui-rpms 49 k
libXinerama x86_64 1.1.4-1.el8 rhel-8-appstream-rhui-rpms 16 k
libXmu x86_64 1.1.3-1.el8 rhel-8-appstream-rhui-rpms 75 k
libXrandr x86_64 1.5.2-1.el8 rhel-8-appstream-rhui-rpms 34 k
libXrender x86_64 0.9.10-7.el8 rhel-8-appstream-rhui-rpms 33 k
libXt x86_64 1.1.5-12.el8 rhel-8-appstream-rhui-rpms 185 k
libXtst x86_64 1.2.3-7.el8 rhel-8-appstream-rhui-rpms 22 k
libXv x86_64 1.0.11-7.el8 rhel-8-appstream-rhui-rpms 20 k
libXxf86dga x86_64 1.1.5-1.el8 rhel-8-appstream-rhui-rpms 26 k
libXxf86misc x86_64 1.0.4-1.el8 rhel-8-appstream-rhui-rpms 23 k
libXxf86vm x86_64 1.1.4-9.el8 rhel-8-appstream-rhui-rpms 19 k
libaio x86_64 0.3.112-1.el8 rhel-8-baseos-rhui-rpms 33 k
libdmx x86_64 1.1.4-3.el8 rhel-8-appstream-rhui-rpms 22 k
libverto-libevent x86_64 0.3.0-5.el8 rhel-8-baseos-rhui-rpms 16 k
libxcb x86_64 1.13.1-1.el8 rhel-8-appstream-rhui-rpms 229 k
libxcrypt-devel x86_64 4.1.1-6.el8 rhel-8-baseos-rhui-rpms 25 k
lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 rhel-8-baseos-rhui-rpms 59 k
make x86_64 1:4.2.1-11.el8 rhel-8-baseos-rhui-rpms 498 k
net-tools x86_64 2.0-0.52.20160912git.el8 rhel-8-baseos-rhui-rpms 322 k
nfs-utils x86_64 1:2.3.3-59.el8 rhel-8-baseos-rhui-rpms 515 k
policycoreutils-python-utils noarch 2.9-19.el8 rhel-8-baseos-rhui-rpms 253 k
protobuf-c x86_64 1.3.0-6.el8 rhel-8-appstream-rhui-rpms 37 k
python3-bind noarch 32:9.11.36-8.el8_8.1 rhel-8-appstream-rhui-rpms 151 k
quota x86_64 1:4.04-14.el8 rhel-8-baseos-rhui-rpms 214 k
quota-nls noarch 1:4.04-14.el8 rhel-8-baseos-rhui-rpms 95 k
rpcbind x86_64 1.2.5-10.el8 rhel-8-baseos-rhui-rpms 70 k
smartmontools x86_64 1:7.1-1.el8 rhel-8-baseos-rhui-rpms 544 k
sysstat x86_64 11.7.3-9.el8 rhel-8-appstream-rhui-rpms 426 k
xorg-x11-utils x86_64 7.5-28.el8 rhel-8-appstream-rhui-rpms 135 k
xorg-x11-xauth x86_64 1:1.0.9-12.el8 rhel-8-appstream-rhui-rpms 39 k
Transaction Summary
==================================================================================================================================================================================================================
Install 57 Packages
Total size: 28 M
Total download size: 28 M
Installed size: 63 M
Downloading Packages:
(1/56): libXtst-1.2.3-7.el8.x86_64.rpm 386 kB/s | 22 kB 00:00
(2/56): libXinerama-1.1.4-1.el8.x86_64.rpm 264 kB/s | 16 kB 00:00
(3/56): libXxf86misc-1.0.4-1.el8.x86_64.rpm 368 kB/s | 23 kB 00:00
(4/56): libSM-1.2.3-1.el8.x86_64.rpm 2.8 MB/s | 48 kB 00:00
(5/56): xorg-x11-utils-7.5-28.el8.x86_64.rpm 5.5 MB/s | 135 kB 00:00
(6/56): libXxf86vm-1.1.4-9.el8.x86_64.rpm 775 kB/s | 19 kB 00:00
(7/56): libdmx-1.1.4-3.el8.x86_64.rpm 1.3 MB/s | 22 kB 00:00
(8/56): libXcomposite-0.4.4-14.el8.x86_64.rpm 1.7 MB/s | 29 kB 00:00
(9/56): libXrender-0.9.10-7.el8.x86_64.rpm 2.0 MB/s | 33 kB 00:00
(10/56): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 2.7 MB/s | 39 kB 00:00
(11/56): libXv-1.0.11-7.el8.x86_64.rpm 869 kB/s | 20 kB 00:00
(12/56): libICE-1.0.9-15.el8.x86_64.rpm 4.1 MB/s | 74 kB 00:00
(13/56): libXt-1.1.5-12.el8.x86_64.rpm 5.8 MB/s | 185 kB 00:00
(14/56): libXext-1.3.4-1.el8.x86_64.rpm 3.6 MB/s | 45 kB 00:00
(15/56): libxcb-1.13.1-1.el8.x86_64.rpm 7.9 MB/s | 229 kB 00:00
(16/56): libXi-1.7.10-1.el8.x86_64.rpm 2.3 MB/s | 49 kB 00:00
(17/56): libXrandr-1.5.2-1.el8.x86_64.rpm 1.7 MB/s | 34 kB 00:00
(18/56): libXxf86dga-1.1.5-1.el8.x86_64.rpm 2.0 MB/s | 26 kB 00:00
(19/56): libXau-1.0.9-3.el8.x86_64.rpm 2.8 MB/s | 37 kB 00:00
(20/56): libXmu-1.1.3-1.el8.x86_64.rpm 4.1 MB/s | 75 kB 00:00
(21/56): libX11-xcb-1.6.8-5.el8.x86_64.rpm 894 kB/s | 14 kB 00:00
(22/56): protobuf-c-1.3.0-6.el8.x86_64.rpm 1.4 MB/s | 37 kB 00:00
(23/56): libX11-common-1.6.8-5.el8.noarch.rpm 7.4 MB/s | 158 kB 00:00
(24/56): libX11-1.6.8-5.el8.x86_64.rpm 14 MB/s | 611 kB 00:00
(25/56): fstrm-0.6.1-3.el8.x86_64.rpm 2.2 MB/s | 29 kB 00:00
(26/56): ksh-20120801-257.el8.x86_64.rpm 23 MB/s | 929 kB 00:00
(27/56): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm 16 MB/s | 1.1 MB 00:00
(28/56): sysstat-11.7.3-9.el8.x86_64.rpm 12 MB/s | 426 kB 00:00
(29/56): bind-libs-9.11.36-8.el8_8.1.x86_64.rpm 5.9 MB/s | 176 kB 00:00
(30/56): python3-bind-9.11.36-8.el8_8.1.noarch.rpm 8.9 MB/s | 151 kB 00:00
(31/56): bind-license-9.11.36-8.el8_8.1.noarch.rpm 6.9 MB/s | 104 kB 00:00
(32/56): libverto-libevent-0.3.0-5.el8.x86_64.rpm 1.1 MB/s | 16 kB 00:00
(33/56): bind-utils-9.11.36-8.el8_8.1.x86_64.rpm 12 MB/s | 453 kB 00:00
(34/56): bind-libs-lite-9.11.36-8.el8_8.1.x86_64.rpm 14 MB/s | 1.2 MB 00:00
(35/56): fontpackages-filesystem-1.44-22.el8.noarch.rpm 661 kB/s | 16 kB 00:00
(36/56): bc-1.07.1-5.el8.x86_64.rpm 2.8 MB/s | 129 kB 00:00
(37/56): libaio-0.3.112-1.el8.x86_64.rpm 2.6 MB/s | 33 kB 00:00
(38/56): net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 15 MB/s | 322 kB 00:00
(39/56): dejavu-fonts-common-2.35-7.el8.noarch.rpm 4.0 MB/s | 74 kB 00:00
(40/56): smartmontools-7.1-1.el8.x86_64.rpm 13 MB/s | 544 kB 00:00
(41/56): libxcrypt-devel-4.1.1-6.el8.x86_64.rpm 1.2 MB/s | 25 kB 00:00
(42/56): keyutils-1.5.10-9.el8.x86_64.rpm 4.3 MB/s | 66 kB 00:00
(43/56): dejavu-sans-fonts-2.35-7.el8.noarch.rpm 26 MB/s | 1.5 MB 00:00
(44/56): quota-nls-4.04-14.el8.noarch.rpm 2.7 MB/s | 95 kB 00:00
(45/56): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm 2.3 MB/s | 59 kB 00:00
(46/56): quota-4.04-14.el8.x86_64.rpm 13 MB/s | 214 kB 00:00
(47/56): fontconfig-2.13.1-4.el8.x86_64.rpm 9.9 MB/s | 274 kB 00:00
(48/56): glibc-headers-2.28-189.1.el8.x86_64.rpm 14 MB/s | 483 kB 00:00
(49/56): make-4.2.1-11.el8.x86_64.rpm 14 MB/s | 498 kB 00:00
(50/56): policycoreutils-python-utils-2.9-19.el8.noarch.rpm 8.0 MB/s | 253 kB 00:00
(51/56): glibc-devel-2.28-189.1.el8.x86_64.rpm 3.0 MB/s | 79 kB 00:00
(52/56): gssproxy-0.8.0-21.el8.x86_64.rpm 6.8 MB/s | 119 kB 00:00
(53/56): rpcbind-1.2.5-10.el8.x86_64.rpm 4.9 MB/s | 70 kB 00:00
(54/56): nfs-utils-2.3.3-59.el8.x86_64.rpm 24 MB/s | 515 kB 00:00
(55/56): binutils-2.30-119.el8.x86_64.rpm 41 MB/s | 5.8 MB 00:00
(56/56): kernel-headers-4.18.0-477.27.1.el8_8.x86_64.rpm 45 MB/s | 11 MB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 34 MB/s | 28 MB 00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : bind-license-32:9.11.36-8.el8_8.1.noarch 1/57
Installing : fstrm-0.6.1-3.el8.x86_64 2/57
Installing : protobuf-c-1.3.0-6.el8.x86_64 3/57
Installing : bind-libs-lite-32:9.11.36-8.el8_8.1.x86_64 4/57
Installing : make-1:4.2.1-11.el8.x86_64 5/57
Running scriptlet: make-1:4.2.1-11.el8.x86_64 5/57
Installing : fontpackages-filesystem-1.44-22.el8.noarch 6/57
Installing : libXau-1.0.9-3.el8.x86_64 7/57
Installing : libxcb-1.13.1-1.el8.x86_64 8/57
Installing : libICE-1.0.9-15.el8.x86_64 9/57
Installing : libSM-1.2.3-1.el8.x86_64 10/57
Installing : dejavu-fonts-common-2.35-7.el8.noarch 11/57
Installing : dejavu-sans-fonts-2.35-7.el8.noarch 12/57
Installing : fontconfig-2.13.1-4.el8.x86_64 13/57
Running scriptlet: fontconfig-2.13.1-4.el8.x86_64 13/57
Installing : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 14/57
Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64 14/57
Installing : bind-libs-32:9.11.36-8.el8_8.1.x86_64 15/57
Installing : python3-bind-32:9.11.36-8.el8_8.1.noarch 16/57
Installing : bind-utils-32:9.11.36-8.el8_8.1.x86_64 17/57
Installing : kernel-headers-4.18.0-477.27.1.el8_8.x86_64 18/57
Running scriptlet: glibc-headers-2.28-189.1.el8.x86_64 19/57
Installing : glibc-headers-2.28-189.1.el8.x86_64 19/57
Installing : glibc-devel-2.28-189.1.el8.x86_64 20/57
Running scriptlet: glibc-devel-2.28-189.1.el8.x86_64 20/57
Installing : libxcrypt-devel-4.1.1-6.el8.x86_64 21/57
Installing : binutils-2.30-119.el8.x86_64 22/57
Running scriptlet: binutils-2.30-119.el8.x86_64 22/57
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 23/57
Installing : rpcbind-1.2.5-10.el8.x86_64 23/57
Running scriptlet: rpcbind-1.2.5-10.el8.x86_64 23/57
Installing : policycoreutils-python-utils-2.9-19.el8.noarch 24/57
Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 25/57
Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 25/57
Installing : sysstat-11.7.3-9.el8.x86_64 26/57
Running scriptlet: sysstat-11.7.3-9.el8.x86_64 26/57
Installing : quota-nls-1:4.04-14.el8.noarch 27/57
Installing : quota-1:4.04-14.el8.x86_64 28/57
Installing : keyutils-1.5.10-9.el8.x86_64 29/57
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 30/57
Installing : smartmontools-1:7.1-1.el8.x86_64 30/57
Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 30/57
Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 31/57
Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 31/57
Installing : libaio-0.3.112-1.el8.x86_64 32/57
Installing : bc-1.07.1-5.el8.x86_64 33/57
Running scriptlet: bc-1.07.1-5.el8.x86_64 33/57
Installing : libverto-libevent-0.3.0-5.el8.x86_64 34/57
Installing : gssproxy-0.8.0-21.el8.x86_64 35/57
Running scriptlet: gssproxy-0.8.0-21.el8.x86_64 35/57
Running scriptlet: nfs-utils-1:2.3.3-59.el8.x86_64 36/57
Installing : nfs-utils-1:2.3.3-59.el8.x86_64 36/57
Running scriptlet: nfs-utils-1:2.3.3-59.el8.x86_64 36/57
Installing : ksh-20120801-257.el8.x86_64 37/57
Running scriptlet: ksh-20120801-257.el8.x86_64 37/57
Installing : libX11-common-1.6.8-5.el8.noarch 38/57
Installing : libX11-1.6.8-5.el8.x86_64 39/57
Installing : libXext-1.3.4-1.el8.x86_64 40/57
Installing : libXi-1.7.10-1.el8.x86_64 41/57
Installing : libXrender-0.9.10-7.el8.x86_64 42/57
Installing : libXrandr-1.5.2-1.el8.x86_64 43/57
Installing : libXtst-1.2.3-7.el8.x86_64 44/57
Installing : libXxf86misc-1.0.4-1.el8.x86_64 45/57
Installing : libXinerama-1.1.4-1.el8.x86_64 46/57
Installing : libXxf86vm-1.1.4-9.el8.x86_64 47/57
Installing : libdmx-1.1.4-3.el8.x86_64 48/57
Installing : libXv-1.0.11-7.el8.x86_64 49/57
Installing : libXxf86dga-1.1.5-1.el8.x86_64 50/57
Installing : libXcomposite-0.4.4-14.el8.x86_64 51/57
Installing : libXt-1.1.5-12.el8.x86_64 52/57
Installing : libXmu-1.1.3-1.el8.x86_64 53/57
Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 54/57
Installing : libX11-xcb-1.6.8-5.el8.x86_64 55/57
Installing : xorg-x11-utils-7.5-28.el8.x86_64 56/57
Installing : oracle-database-preinstall-23c-1.0-1.el8.x86_64 57/57
Running scriptlet: oracle-database-preinstall-23c-1.0-1.el8.x86_64 57/57
Running scriptlet: fontconfig-2.13.1-4.el8.x86_64 57/57
Verifying : libXxf86misc-1.0.4-1.el8.x86_64 1/57
Verifying : libXtst-1.2.3-7.el8.x86_64 2/57
Verifying : libXinerama-1.1.4-1.el8.x86_64 3/57
Verifying : xorg-x11-utils-7.5-28.el8.x86_64 4/57
Verifying : libSM-1.2.3-1.el8.x86_64 5/57
Verifying : libXxf86vm-1.1.4-9.el8.x86_64 6/57
Verifying : libdmx-1.1.4-3.el8.x86_64 7/57
Verifying : libXcomposite-0.4.4-14.el8.x86_64 8/57
Verifying : libXrender-0.9.10-7.el8.x86_64 9/57
Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 10/57
Verifying : libXv-1.0.11-7.el8.x86_64 11/57
Verifying : libXt-1.1.5-12.el8.x86_64 12/57
Verifying : libICE-1.0.9-15.el8.x86_64 13/57
Verifying : libxcb-1.13.1-1.el8.x86_64 14/57
Verifying : libXext-1.3.4-1.el8.x86_64 15/57
Verifying : libXi-1.7.10-1.el8.x86_64 16/57
Verifying : libXrandr-1.5.2-1.el8.x86_64 17/57
Verifying : libXxf86dga-1.1.5-1.el8.x86_64 18/57
Verifying : libXau-1.0.9-3.el8.x86_64 19/57
Verifying : libXmu-1.1.3-1.el8.x86_64 20/57
Verifying : protobuf-c-1.3.0-6.el8.x86_64 21/57
Verifying : libX11-xcb-1.6.8-5.el8.x86_64 22/57
Verifying : libX11-1.6.8-5.el8.x86_64 23/57
Verifying : libX11-common-1.6.8-5.el8.noarch 24/57
Verifying : compat-openssl10-1:1.0.2o-4.el8_6.x86_64 25/57
Verifying : ksh-20120801-257.el8.x86_64 26/57
Verifying : fstrm-0.6.1-3.el8.x86_64 27/57
Verifying : sysstat-11.7.3-9.el8.x86_64 28/57
Verifying : bind-libs-32:9.11.36-8.el8_8.1.x86_64 29/57
Verifying : bind-libs-lite-32:9.11.36-8.el8_8.1.x86_64 30/57
Verifying : python3-bind-32:9.11.36-8.el8_8.1.noarch 31/57
Verifying : bind-license-32:9.11.36-8.el8_8.1.noarch 32/57
Verifying : bind-utils-32:9.11.36-8.el8_8.1.x86_64 33/57
Verifying : libverto-libevent-0.3.0-5.el8.x86_64 34/57
Verifying : bc-1.07.1-5.el8.x86_64 35/57
Verifying : fontpackages-filesystem-1.44-22.el8.noarch 36/57
Verifying : libaio-0.3.112-1.el8.x86_64 37/57
Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 38/57
Verifying : smartmontools-1:7.1-1.el8.x86_64 39/57
Verifying : dejavu-fonts-common-2.35-7.el8.noarch 40/57
Verifying : dejavu-sans-fonts-2.35-7.el8.noarch 41/57
Verifying : libxcrypt-devel-4.1.1-6.el8.x86_64 42/57
Verifying : keyutils-1.5.10-9.el8.x86_64 43/57
Verifying : quota-nls-1:4.04-14.el8.noarch 44/57
Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 45/57
Verifying : quota-1:4.04-14.el8.x86_64 46/57
Verifying : fontconfig-2.13.1-4.el8.x86_64 47/57
Verifying : glibc-headers-2.28-189.1.el8.x86_64 48/57
Verifying : make-1:4.2.1-11.el8.x86_64 49/57
Verifying : policycoreutils-python-utils-2.9-19.el8.noarch 50/57
Verifying : glibc-devel-2.28-189.1.el8.x86_64 51/57
Verifying : gssproxy-0.8.0-21.el8.x86_64 52/57
Verifying : rpcbind-1.2.5-10.el8.x86_64 53/57
Verifying : binutils-2.30-119.el8.x86_64 54/57
Verifying : nfs-utils-1:2.3.3-59.el8.x86_64 55/57
Verifying : kernel-headers-4.18.0-477.27.1.el8_8.x86_64 56/57
Verifying : oracle-database-preinstall-23c-1.0-1.el8.x86_64 57/57
Installed products updated.
Installed:
bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.36-8.el8_8.1.x86_64 bind-libs-lite-32:9.11.36-8.el8_8.1.x86_64 bind-license-32:9.11.36-8.el8_8.1.noarch
bind-utils-32:9.11.36-8.el8_8.1.x86_64 binutils-2.30-119.el8.x86_64 compat-openssl10-1:1.0.2o-4.el8_6.x86_64 dejavu-fonts-common-2.35-7.el8.noarch
dejavu-sans-fonts-2.35-7.el8.noarch fontconfig-2.13.1-4.el8.x86_64 fontpackages-filesystem-1.44-22.el8.noarch fstrm-0.6.1-3.el8.x86_64
glibc-devel-2.28-189.1.el8.x86_64 glibc-headers-2.28-189.1.el8.x86_64 gssproxy-0.8.0-21.el8.x86_64 kernel-headers-4.18.0-477.27.1.el8_8.x86_64
keyutils-1.5.10-9.el8.x86_64 ksh-20120801-257.el8.x86_64 libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64
libX11-1.6.8-5.el8.x86_64 libX11-common-1.6.8-5.el8.noarch libX11-xcb-1.6.8-5.el8.x86_64 libXau-1.0.9-3.el8.x86_64
libXcomposite-0.4.4-14.el8.x86_64 libXext-1.3.4-1.el8.x86_64 libXi-1.7.10-1.el8.x86_64 libXinerama-1.1.4-1.el8.x86_64
libXmu-1.1.3-1.el8.x86_64 libXrandr-1.5.2-1.el8.x86_64 libXrender-0.9.10-7.el8.x86_64 libXt-1.1.5-12.el8.x86_64
libXtst-1.2.3-7.el8.x86_64 libXv-1.0.11-7.el8.x86_64 libXxf86dga-1.1.5-1.el8.x86_64 libXxf86misc-1.0.4-1.el8.x86_64
libXxf86vm-1.1.4-9.el8.x86_64 libaio-0.3.112-1.el8.x86_64 libdmx-1.1.4-3.el8.x86_64 libverto-libevent-0.3.0-5.el8.x86_64
libxcb-1.13.1-1.el8.x86_64 libxcrypt-devel-4.1.1-6.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 make-1:4.2.1-11.el8.x86_64
net-tools-2.0-0.52.20160912git.el8.x86_64 nfs-utils-1:2.3.3-59.el8.x86_64 oracle-database-preinstall-23c-1.0-1.el8.x86_64 policycoreutils-python-utils-2.9-19.el8.noarch
protobuf-c-1.3.0-6.el8.x86_64 python3-bind-32:9.11.36-8.el8_8.1.noarch quota-1:4.04-14.el8.x86_64 quota-nls-1:4.04-14.el8.noarch
rpcbind-1.2.5-10.el8.x86_64 smartmontools-1:7.1-1.el8.x86_64 sysstat-11.7.3-9.el8.x86_64 xorg-x11-utils-7.5-28.el8.x86_64
xorg-x11-xauth-1:1.0.9-12.el8.x86_64
Complete!
引き続き、Oracle Database 23c Free (oracle-database-free-23c-1.0-1.el8.x86_64.rpm)をインストールします。
oracle-database-free-23c-1.0-1.el8.x86_64.rpm のインストール
$ sudo dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered with an entitlement server. You can use subscription-manager to register.
Last metadata expiration check: 0:41:54 ago on Mon 02 Oct 2023 04:32:40 AM UTC.
Dependencies resolved.
==================================================================================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================================================================================
Installing:
oracle-database-free-23c x86_64 1.0-1 @commandline 1.6 G
Transaction Summary
==================================================================================================================================================================================================================
Install 1 Package
Total size: 1.6 G
Installed size: 4.0 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
Installing : oracle-database-free-23c-1.0-1.x86_64 1/1
Running scriptlet: oracle-database-free-23c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.
Verifying : oracle-database-free-23c-1.0-1.x86_64 1/1
Installed products updated.
Installed:
oracle-database-free-23c-1.0-1.x86_64
Complete!
DBCAでデフォルトデータベース(FREE)を作成します。
デフォルトデータベースの作成
(上に空行が必要)
# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. 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]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
*********
Enter SYSTEM user password:
***********
Enter PDBADMIN User Password:
***********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE1.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: ip-xx-xx-xx-xx.ap-northeast-1.compute.internal/FREEPDB1
Multitenant container database: ip-xx-xx-xx-xx.ap-northeast-1.compute.internal
4. エクスポートデータをインポート
アップグレード前にエクスポートしていたデータのインポートを行います。
まず、データインポートの準備としてエクスポート前に実施していたのと同じディレクトリ作成等を行います。
データのインポート準備
$ /opt/oracle/product/23c/dbhomeFree/bin/sqlplus / AS SYSDBA
SQL*Plus: Release 23.0.0.0.0 - Production on Mon Oct 2 05:35:08 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> ALTER SESSION SET CONTAINER=freepdb1;
Session altered.
SQL> CREATE DIRECTORY DUMP_DIR AS '/opt/dump';
Directory created.
SQL> GRANT READ, WRITE ON DIRECTORY DUMP_DIR TO SYSTEM;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SYSTEMユーザでデータのインポートを行います。
データのインポート
$ /opt/oracle/product/23c/dbhomeFree/bin/impdp system/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/freepdb1 full=Y directory=DUMP_DIR dumpfile=expdb23c_freepdb1.dmp logfile=impdb23c_freepdb1.log
Import: Release 23.0.0.0.0 - Production on Mon Oct 2 05:37:06 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/freepdb1 full=Y directory=DUMP_DIR dumpfile=expdb23c_freepdb1.dmp logfile=impdb23c_freepdb1.log
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER/LABEL_SECURITY
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER/SEMANTIC
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER/SCHEDULER
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER/WMSYS
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER/DATAPUMP
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/AUDIT_TRAILS
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/DATAPUMP
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/LABEL_SECURITY
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/NETWORK_ACL
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/PSTDY
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/SCHEDULER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/SEMANTIC
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/SMB
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/SQL_FIREWALL
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/TSDP
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER/WMSYS
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"PDBADMIN" already exists
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/RULE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/AQ
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/SQL
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT/JVM
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
ORA-31684: Object type DIRECTORY:"DUMP_DIR" already exists
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM/LOGREP
>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1.
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ/SCHEDULER
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM/RMGR
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM/SEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA/LOGREP
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "SYS"."KU$_EXPORT_USER_MAP" 6.070 KB 34 rows
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER/DATAPUMP
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P265" 22.86 MB 14062 rows
. . imported "SYSTEM"."REDO_DB_TMP" 27.18 KB 1 rows
. . imported "WMSYS"."E$WORKSPACES_TABLE$" 12.50 KB 1 rows
. . imported "WMSYS"."E$HINT_TABLE$" 10.10 KB 97 rows
. . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE$" 7.195 KB 11 rows
. . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 6.625 KB 14 rows
. . imported "SYS"."DP$TSDP_SUBPOL$" 6.421 KB 1 rows
. . imported "WMSYS"."E$NEXTVER_TABLE$" 6.468 KB 1 rows
. . imported "WMSYS"."E$ENV_VARS$" 6.085 KB 3 rows
. . imported "SYS"."DP$TSDP_PARAMETER$" 6.023 KB 1 rows
. . imported "SYS"."DP$TSDP_POLICY$" 5.992 KB 1 rows
. . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE$" 6.054 KB 1 rows
. . imported "WMSYS"."E$EVENTS_INFO$" 5.859 KB 12 rows
. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows
. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P281" 59.59 KB 3 rows
. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P391" 59.44 KB 6 rows
. . imported "LBACSYS"."OLS_DP$OLS$AUDIT" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$GROUPS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$LAB" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$LEVELS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POL" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POLS" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$POLT" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$PROFILE" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$PROG" 0 KB 0 rows
. . imported "LBACSYS"."OLS_DP$OLS$USER" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$AUD$" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows
. . imported "SYS"."SQLFW$DP$FW_ALLOW_LIST$" 0 KB 0 rows
. . imported "SYS"."SQLFW$DP$FW_ALLOW_LIST_CONTEXT$" 0 KB 0 rows
. . imported "SYS"."SQLFW$DP$FW_ALLOW_LIST_SQL$" 0 KB 0 rows
. . imported "SYS"."SQLFW$DP$FW_CAPTURE$" 0 KB 0 rows
. . imported "SYS"."SQLFW$DP$SQL_LOG$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_ASSOCIATION$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_CONDITION$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_FEATURE_POLICY$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_PROTECTION$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SENSITIVE_DATA$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SENSITIVE_TYPE$" 0 KB 0 rows
. . imported "SYS"."DP$TSDP_SOURCE$" 0 KB 0 rows
. . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows
. . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows
. . imported "WMSYS"."E$CONSTRAINTS_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$CONS_COLUMNS$" 0 KB 0 rows
. . imported "WMSYS"."E$LOCKROWS_INFO$" 0 KB 0 rows
. . imported "WMSYS"."E$MODIFIED_TABLES$" 0 KB 0 rows
. . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$NESTED_COLUMNS_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$RIC_LOCKING_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$RIC_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$RIC_TRIGGERS_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows
. . imported "WMSYS"."E$UDTRIG_INFO$" 0 KB 0 rows
. . imported "WMSYS"."E$VERSION_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$VT_ERRORS_TABLE$" 0 KB 0 rows
. . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
. . imported "MDSYS"."RDF_PARAM$TBL" 6.609 KB 3 rows
. . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 6.023 KB 2 rows
. . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows
. . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows
. . imported "SYS"."AMGT$DP$GV_$UNIFIED_AUDIT_TRAIL" 0 KB 0 rows
. . imported "SYS"."NACL$_ACE_IMP" 0 KB 0 rows
. . imported "SYS"."NACL$_HOST_IMP" 7.476 KB 1 rows
. . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQL$TEXT" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQL$" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQLOBJ$AUXDATA" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQLOBJ$DATA" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQLOBJ$PLAN" 0 KB 0 rows
. . imported "SYS"."DATAPUMP$SQLOBJ$" 0 KB 0 rows
. . imported "WMSYS"."E$EXP_MAP" 7.882 KB 3 rows
. . imported "WMSYS"."E$METADATA_MAP" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/AUDIT_TRAILS
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/LABEL_SECURITY
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/NETWORK_ACL
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/PSTDY
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/SCHEDULER
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/SEMANTIC
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/SMB
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/SQL_FIREWALL
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/TSDP
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER/WMSYS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "TESTUSR"."TESTTBL" 5.554 KB 2 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/AUDIT_TRAILS
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/DATAPUMP
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/LABEL_SECURITY
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/NETWORK_ACL
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/PSTDY
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/SCHEDULER
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/SEMANTIC
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/SMB
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/SQL_FIREWALL
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/TSDP
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER/WMSYS
Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER/LABEL_SECURITY
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER/SEMANTIC
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER/SCHEDULER
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER/WMSYS
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER/DATAPUMP
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 5 error(s) at Mon Oct 2 05:41:15 2023 elapsed 0 00:04:03
アップグレード前のTESTTBLにデータが格納されていることを確認します。
TESTTBL 確認
$ sqlplus TESTUSR/xxxxxxxx@ip-xx-xx-xx-xx.ap-northeast-1.compute.internal:1521/FREEPDB1
SQL*Plus: Release 23.0.0.0.0 - Production on Mon Oct 2 05:41:39 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> select object_name from user_objects;
OBJECT_NAME
--------------------------------------------------------------------------------
TESTTBL
SQL> select * from testtbl;
ID TESTCOL
---------- --------------------
1 hogehoge
2 hogehogehoge
SQL> exit
Disconnected from Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
まとめ
ガイドに沿ってですが、突貫で23c Free-Developer Release から 23c Freeへのアップグレードを行ってみました。今だけだと思いますが、インプレースでアップグレードを行えないのは不便ですね。。
実際に23.2のdatafileは23.3では読み込めないのか、とか、23c Freeの文字コード変更どうするんだっけ？とか、幾つか試してみたいことはあるので、余裕があれば試してみたいと思います。