Oracle Database 19cでOracle Blockchain Tableを利用するまでの準備

Blockchain Table
2021.04.18

*2021/4/29追記*　
2021年4月のRU19.11がリリースされ個別パッチを当てなくとも「RU19.11」の適用でOracle Blockchain Tableが利用できるようになりました。

久しぶりのブログ記事になります。今回はOracle Database 19cでOracle Databaseの新機能であるOracle Blockchain Tableを利用する準備をしていきたいと思います。

「Oracle Blockchain Tableとは」、「Oracle Blockchain Tableの使い方」については過去の記事をご覧ください。

本記事での前提について

Oracle Blockchain Tableを利用するにはOracle Database 19cにパッチを当てる必要があります。以下に今回の環境を書いておきます。

  • OS Oracle Linux 7.9
  • Oracle Database 19c EE (バージョン 19.3)
  • オンプレミス想定（非クラウドサービス）
  • マルチテナント PDB構成

RUパッチ「RU19.10」の適用

現在のバージョンが19.3なのでまずは19.10のRUを適用する必要があります。

Oracle Cloud InfrastructureのPaaSサービスであるDatabase Cloud Service (DBCS)ではUI上のボタンポチポチで完了しますが、今回はオンプレミス環境想定なのでOPatchを使用してパッチの適用を行います。

まずは19.10をダウンロードしてきます。パッチはMy Oracle Support (MOS)からダウンロードできます。

こちらに19cのRU パッチが記載されています。MOSによると「Patch 32218454」が19.10RUに該当するようです。

Database Release Update 19.10.0<Patch 32218454>

Patch 32218454 Linux x86-64 (American English)をダウンロードしてきます (ご利用の環境にあったパッチをダウンロードしてください)。

ダウンロードしたzipファイル「p32218454_190000_Linux-x86-64.zip」をunzipし、解凍してできたディレクトリに移動します。

[oracle@db19c-146641 32218454]$

次にパッチの競合チェック、パッチの適用を行います。*パッチ操作を行う前にDatabaseをシャットダウンしてください。

パッチ競合チェック、適用には$ORACLE_HOMEの下のOPatchを利用します。

まずは競合チェック（opatch prereq CheckConflictAgainstOHWithDetail）を実行します。

[oracle@db19c-146641 32218454]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-02-02PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

競合チェックが完了しました。「passed」と表示されたので問題ないようです。

次にパッチの適用（opatch apply）を実行します。

[oracle@db19c-146641 32218454]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-02-19PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following active executables are not used by opatch process :
/u01/app/oracle/product/19.3/dbhome_1/lib/libclntsh.so.19.1
/u01/app/oracle/product/19.3/dbhome_1/lib/libsqlplus.so

Following active executables are used by opatch process :


UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-02-19PM_1.log

OPatch failed with error code 73

エラーとなり、失敗しました。

何かアクティブなライブラリが問題なようです。プロセスを確認すると、

[oracle@db19c-146641 32218454]$ /sbin/fuser /u01/app/oracle/product/19.3/dbhome_1/lib/libclntsh.so.19.1
/u01/app/oracle/product/19.3/dbhome_1/lib/libclntsh.so.19.1: 14520m 14538m
[oracle@db19c-146641 32218454]$ ps -ef | grep 14538
oracle    2759 24349  0 15:08 pts/3    00:00:00 grep --color=auto 14538
oracle   14538  5345  0 14:07 pts/1    00:00:00 sqlplus   as sysdba

データベースは終了しましたが、別のターミナルでsqlplusにつないだままでした。

動いているプロセスを終了し再度実行。

[oracle@db19c-146641 32218454]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-08-39PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-08-53PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32218454

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32218454' to OH '/u01/app/oracle/product/19.3/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

～中略～

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 32218454 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [32218454].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3/dbhome_1/cfgtoollogs/opatch/opatch2021-04-14_15-08-53PM_1.log

OPatch succeeded.

OPatchが成功しました！

次にパッチ適用後の SQL の実行を自動化をするデータパッチを実行します。その前にデータベースを起動しておきます。

//データベースを起動
[oracle@db19c-146641 32218454]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 14 15:12:34 2021
Version 21.1.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> startup
~省略~

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

//データパッチ実行
[oracle@db19c-146641 32218454]$ $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.10.0.0.0 Production on Wed Apr 14 15:12:57 2021
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_7722_2021_04_14_15_12_57/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Warning: PDB MIYAPDB1 is in mode MOUNTED and will be skipped.
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.10.0.0.0 Release_Update 210108185017: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-APR-21 01.44.18.237584 PM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-APR-21 01.51.15.438454 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT
    No interim patches need to be rolled back
    Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017
    No interim patches need to be applied
  For the following PDBs: PDB$SEED
    No interim patches need to be rolled back
    Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017
    No interim patches need to be applied

Installing patches...

Patch installation complete.  Total patches installed: 2

Validating logfiles...done
Patch 32218454 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_MIYADB_CDBROOT_2021Apr14_15_13_17.log (no errors)
Patch 32218454 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_MIYADB_PDBSEED_2021Apr14_15_17_12.log (no errors)
SQL Patching tool complete on Wed Apr 14 15:19:36 2021
[oracle@db19c-146641 32218454]$

データパッチの適用を実行しましたが、以下のWarningがでて肝心のPDBに適用されませんでした。

PDBを起動させていませんでした、うっかりしていました。

Warning: PDB MIYAPDB1 is in mode MOUNTED and will be skipped.
Bootstrapping registry and package to current versions...done
Determining current state...done

PDBを起動してから再度実行します。

//PDBを起動
[oracle@db19c-146641 32218454]$ sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 14 15:19:40 2021
Version 21.1.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 MIYAPDB1                       MOUNTED

SQL> alter session set container = miyapdb1;

Session altered.

SQL> startup

Pluggable Database opened.

//再度datapatch実行
[oracle@db19c-146641 32218454]$ $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.10.0.0.0 Production on Wed Apr 14 15:20:30 2021
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_11101_2021_04_14_15_20_30/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.10.0.0.0 Release_Update 210108185017: Installed
  PDB CDB$ROOT:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 14-APR-21 03.19.23.924487 PM
  PDB MIYAPDB1:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 14-APR-21 01.51.15.438454 PM
  PDB PDB$SEED:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 14-APR-21 03.19.25.157843 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED
    No interim patches need to be rolled back
    No release update patches need to be installed
    No interim patches need to be applied
  For the following PDBs: MIYAPDB1
    No interim patches need to be rolled back
    Patch 32218454 (Database Release Update : 19.10.0.0.210119 (32218454)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.10.0.0.0 Release_Update 210108185017
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 32218454 apply (pdb MIYAPDB1): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_MIYADB_MIYAPDB1_2021Apr14_15_20_43.log (no errors)
SQL Patching tool complete on Wed Apr 14 15:24:07 2021

完了しました！

改めてsqlplusに入ってみると19.10になっていることが確認できました。

[oracle@db19c-146641 32218454]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 14 15:24:40 2021
Version 21.1.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SQL>

*OPatchのバージョンが低いと「このパッチにはOPatchバージョン〇〇以上が必要です」とエラーが出ることがあります。その場合は表示されるバージョン以上のOPatchをMOSからダウンロードし、$ORACLE_HOME下のOPatchと入れ替えてください（入れ替える際は元のOPatchのバックアップを取ることをお勧めします）。

個別パッチ「32431413」の適用

次に個別パッチ「32431413」を適用します。19.10RUと同様にMOSからダウンロードしてきます。

手順はRUと同じです。64bit Linux用のパッチ「p32431413_1910000DBRU_Linux-x86-64.zip」をダウンロードします。

ダウンロードしたファイルをunzipします。unzipしてできたファイル「32431413」に移動します。*パッチ操作を行う前にDatabaseをシャットダウンしてください。

*以下のログは先ほどと別のDatabaseに対してのパッチ適用になりますが、操作は変わりません

//競合チェック実行
[oracle@miya19 32431413]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-07_09-10-26AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

//パッチ適用実行
[oracle@miya19 32431413]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.24
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.24
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-07_09-12-51AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32431413

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.0.0.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32431413' to OH '/u01/app/oracle/product/19.0.0.0/dbhome_1'

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patch 32431413 successfully applied.
Log file location: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-04-07_09-12-51AM_1.log

OPatch succeeded.

//sqlplusにログイン後データベース起動（PDBは同時に起動される設定になっています）
SQL> startup
ORACLE instance started.

Total System Global Area 6442449464 bytes
Fixed Size                  9148984 bytes
Variable Size            1140850688 bytes
Database Buffers         5268045824 bytes
Redo Buffers               24403968 bytes
Database mounted.
Database opened.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

//データパッチ適用の実行
[oracle@miya19 32431413]$ $ORACLE_HOME/OPatch/datapatch -verbose
SQL Patching tool version 19.10.0.0.0 Production on Wed Apr  7 09:16:47 2021
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_81894_2021_04_07_09_16_47/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
Interim patch 31465389 (RMAN RECOVER FAILS FOR PDB$SEED DATAFILES RMAN-06163 RMAN-06166):
  Binary registry: Installed
  PDB CDB$ROOT: Applied successfully on 19-FEB-21 10.18.48.497884 AM
  PDB MIYA19_PDB1: Applied successfully on 19-FEB-21 10.18.57.969011 AM
  PDB PDB$SEED: Applied successfully on 19-FEB-21 10.18.57.969011 AM
Interim patch 32067171 (OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)):
  Binary registry: Installed
  PDB CDB$ROOT: Applied successfully on 19-FEB-21 10.18.48.350455 AM
  PDB MIYA19_PDB1: Applied successfully on 19-FEB-21 10.18.57.895123 AM
  PDB PDB$SEED: Applied successfully on 19-FEB-21 10.18.57.895123 AM

Current state of release update SQL patches:
  Binary registry:
    19.10.0.0.0 Release_Update 210108185017: Installed
  PDB CDB$ROOT:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 19-FEB-21 10.18.48.271880 AM
  PDB MIYA19_PDB1:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 19-FEB-21 10.18.57.891460 AM
  PDB PDB$SEED:
    Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 19-FEB-21 10.18.57.891460 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED MIYA19_PDB1
    No interim patches need to be rolled back
    No release update patches need to be installed
    No interim patches need to be applied

SQL Patching tool complete on Wed Apr  7 09:17:49 2021
[oracle@miya19 32431413]$

以上でパッチ適用が完了しました！

COMPATIBLEパラメータの変更

パッチの適用が完了しました、早速Blockchain Tableを作成してみましょう！

CREATE BLOCKCHAIN TABLE bc_table (insert_date DATE DEFAULT SYSDATE, col2 VARCHAR2(20), col3 NUMBER(20))
                     NO DROP UNTIL 5 DAYS IDLE
                     NO DELETE UNTIL 16 DAYS AFTER INSERT
                     HASHING USING "SHA2_512" VERSION "v1";

次のコマンドの開始中にエラーが発生しました : 行 1 -
CREATE BLOCKCHAIN TABLE bc_table (insert_date DATE DEFAULT SYSDATE, col2 VARCHAR2(20), col3 NUMBER(20))
                     NO DROP UNTIL 5 DAYS IDLE
                     NO DELETE UNTIL 16 DAYS AFTER INSERT
                     HASHING USING "SHA2_512" VERSION "v1"
エラー・レポート -
ORA-05728: COMPATIBLE needs to be 19.10.0.0.0 or higher to use blockchain table
ORA-00722: 機能"Blockchain table"

show parameter compatible;
NAME              TYPE    VALUE    
----------------- ------- -------- 
compatible        string  19.0.0.0 
noncdb_compatible boolean FALSE

ORA-05728エラーが発生しました。Blockchain Tableを利用するにはCompatibleパラメーターを19.10に変更する必要があります。compatibleの変更はスコープがSPFILEなのでデータベースの再起動後に適用されます。

*通常はCOMPATIBLEパラメータにRUのバージョンを格納しません。変更時は注意してください。

ALTER SYSTEM SET COMPATIBLE = '19.10.0.0.0' scope=spfile;

//データベース再起動

CREATE BLOCKCHAIN TABLE bc_table (insert_date DATE DEFAULT SYSDATE, col2 VARCHAR2(20), col3 NUMBER(20))
                     NO DROP UNTIL 5 DAYS IDLE
                     NO DELETE UNTIL 16 DAYS AFTER INSERT
                     HASHING USING "SHA2_512" VERSION "v1";
					 
Blockchain TABLEは作成されました。

無事Blockchain Tableが作成されました！

おわりに

今回はOracle Blockchain TableをOracle Database 19cで利用する準備をしました。主にパッチ適用の作業となりましたが思ったより簡単にできました。

Compatibleの変更では「ORA-05728: COMPATIBLE needs to be 19.10.0.0.0 or higher to use blockchain table」というエラーが出てくる親切設計になっています。

これで19cでもBlockchain Tableを利用できるようになりました、またいろいろと試していきたいと思います。

最後までご覧いただきありがとうございました。

コメント

タイトルとURLをコピーしました