Exadata Exascale あらゆる規模のOracle Databaseワークロード（AIベクトル処理、分析、トランザクションなど）に卓越したパフォーマンスを提供するクラウド向けインテリジェント・データ・アーキテクチャであるExadata Exascaleの一般提供を発表しました。
Exadata Exascaleにより、あらゆる規模の組織はOracle Exadata独自の組み込みパフォーマンス、信頼性、可用性、セキュリティ機能を活用するためのコストを大幅に削減できます。
「Exadata Exascaleは、マルチテナントの超弾性クラウド向けに再設計されたExadataであり、すべてのOracle Databaseクラウド サービスの将来のアーキテクチャです」と、Exadata and Scale-Out Technologies担当 senior vice president,である Kothanda Umamageswaranは述べています。「インフラストラクチャ コストを最大95%削減することで、Exadata Exascaleにより、小規模なワークロードや中小企業がクラウド内のOracle Databases向けOracle Exadataの利点を活用できるようになります。」
技術アーキテクチャ: データベース ファイルのストレージは、Oracle Exadata Exascale Storage Vault にあります。Storage Vault は、高パフォーマンスでスケーラブルな Exadata スマート ストレージを提供します。ストレージは、必要に応じて 1 つのコマンドでオンラインで拡張でき、そのストレージはすぐに使用できるようになります。専用インフラストラクチャとは異なり、Exascale Infrastructure 上の Exadata Database Service (ExaDB-XS) では、 システムへのストレージ・サーバーの追加やストレージ割り当ての管理を行う必要がありません。
ストレージ プールは、複数のストレージ サーバー間でプール ディスクを集約し、ストレージ容量と I/O をシンプルかつ柔軟に割り当てる方法を実現します。Exascale は、新しい Exadata Database on Exascale Infrastructure Service (ExaDB-XS) のように、数千のストレージ・サーバーを組み込んで、真にクラウド規模のストレージ・リソースを作成できます。
ということで、ExaDB-XS を作成してみてみます。
■ 参考資料
Press Release
Documents
Blog
YouTube
■ Exascale Infrastructure 要件
次のドキュメントで開始するための基本的な概念を学習します。
■ Service Limit 確認
Exascale に必要な Service Limitを確認
■ Exascale Infrastructure 作成
● VM Cluster作成
1) OCIコンソール画面
[Oracle Database] > [Exadata Database Service on Exascale Infrastructure]をクリック
2) VM Clusters画面
VMクラスタを作成するリージョンおよびコンパートメントを選択し、[VM クラスタの作成]をクリック
3) VM Clusterの作成画面
次の項目を入力し、[VM Clusterの作成]をクリック
・ コンパートメント: VMクラスタ・リソースのコンパートメントを選択
・ 表示名 VMクラスタのユーザー・フレンドリな表示名を入力
・ クラスタ名 VMクラスタの名前を選択
・ 可用性ドメインの選択: 可用性ドメインを選択
・ VMクラスタの構成
- クラスタ内のVMの数: クラスタに対して構成するVMの数を2から10の間で設定
- VMごとに有効なECPU: VMクラスタに対して有効にするECPUコアの数を設定。最小は8,選択する値は4の倍数にする必要があります。
- オプション: 追加のECPUを予約
- VMごとに予約されているECPU(読取り専用): 追加の予約済ECPUを設定
- VM当たりの合計ECPU: VMごとに割り当てるECPUの合計数を設定。合計は8から200の間の数値にする必要があります。
- VM当たりのクラスタ全体で有効な合計ECPU: VMごとに割り当てるECPUの合計数を設定。合計は8から200の間の数値にする必要があります。
- VM当たりのメモリー(GB)(読取り専用): 各VMに割り当てられたメモリー量が表示されます。メモリーは、ECPU当たり2.75 GBに基づいて計算されます。「VMクラスタ全体の合計メモリー(GB)」フィールドが自動的に更新され、VMクラスタ全体で割り当てられた合計メモリー量が提供されます。
- VM当たりのVMファイル・システム・ストレージ容量(GB): VM当たりのストレージ容量(GB)を設定
・ Exascale Database Storage Vault
- Vault:ボールト名を入力
- データベースのストレージ容量(GB): 300から100,000までのデータベースの格納に使用できる使用可能なディスク・ストレージ容量。
- (オプション)スマート・フラッシュおよびメモリー・キャッシュの追加:スマート・フラッシュ・キャッシュの量を入力。ストレージ容量の割合に基づきます。
・ Grid Infrastructureの構成
- Grid Infrastructureバージョン: VMクラスタでのデプロイメントに使用可能なOracle Grid Infrastructureバージョンが表示されます。
- SSHキーの追加: DBシステムへのSSHアクセスに使用する各キー・ペアの公開キー部分を追加
・ ネットワーク設定の構成
- 仮想クラウド・ネットワーク: VMクラスタを作成するコンパートメントの仮想クラウド・ネットワーク(VCN)を選択
- クライアント・サブネット:コンパートメント内のクライアント・サブネットを選択
- バックアップ・サブネット:バックアップ・ネットワークに使用するサブネットを選択。通常は、バックアップ宛先との間のバックアップ情報の転送およびOracle Data Guardレプリケーションに使用されます。
- ノート:ネットワーク・セキュリティ・グループを使用してトラフィックを制御します。: オプションで、クライアント・ネットワークとバックアップ・ネットワークの両方に1つ以上のネットワーク・セキュリティ・グループ(NSG)を入力できます。
- ホスト名接頭辞: 選択したExadata DBシステムのホスト名を入力
- ホスト・ドメイン名(読取り専用): VMクラスタのホスト名を表示
- ホストおよびドメインURL (読取り専用): ホスト名とドメイン名を結合して、データベースの完全修飾ドメイン名(FQDN)を表示。最大長は63文字
・ ライセンス・タイプの選択:
- ライセンス込み: クラウド・サービスのコストにライセンスが含まれていることを意味します。
- Bring Your Own License (BYOL):ライセンス契約を契約されているOracle Databaseのお客様が、そのライセンスをOracle Cloud Infrastructureで使用することを意味します。
・ 診断収集: 診断収集および通知を有効にすると、ユーザーとOracle Cloud Operationsは、ゲストVMの問題を迅速かつ効率的に特定、調査、追跡および解決できます。
・ 拡張オプションの表示をクリックして、次の情報を入力します。
- タイム・ゾーン: 「管理」タブでは、DBシステムのデフォルトのタイム・ゾーンはUTCですが、別のタイム・ゾーンを設定
- SCANリスナー・ポート(TCP/IP): 1024から8999の範囲でSCANリスナー・ポート(TCP/IP)を割り当てます。デフォルトは1521
- タグ: フリーフォーム・タグまたは定義済タグを適用
4) プロビジョニング・ステータス画面
5) プロビジョニング中画面
6) プロビジョニング完了画面
・ログメッセージ画面
● Container Database作成
1) VMクラスタ詳細画面
Resourcesから[コンテナ・データベース]をクリックし、[コンテナ・データベースの作成]をクリック
2) コンテナ・データベースの作成画面
次の項目を入力し、[コンテナ・データベースの作成]をクリック
・ 基本情報
- データベース名:データベースの名前を入力
- 一意名(オプション):データベースの一意名を入力
- データベース・バージョン:使用可能なデータベース・バージョンを選択
- PDB名(オプション):最初に作成するPDBの名前を入力
・ データベース・ホームの指定
- データベース・ホーム・ソース: 「既存のデータベース・ホーム」または「新規データベース・ホームの作成」を使用する場合に選択
- データベース・ホームの表示名: デフォルトのデータベース・ホーム名を使用するか、データベース・ホーム名を入力
- データベース・イメージの変更(オプション): データベースに使用するOracle Databaseバージョンを設定。デフォルトでは、最新のOracle公開版データベース・ソフトウェア・イメージが選択されています。古いOracle公開イメージまたは事前に作成したカスタム・データベース・ソフトウェア・イメージを使用する場合に選択
・ 管理者資格証明を入力
- パスワード: 9文字から30文字とし、大文字、小文字、特殊文字および数字をそれぞれ2つ以上含める必要があります。特殊文字は、\、_、#または-である必要があります。
- パスワードの確認: 同じパスワードを入力
・ データベース・バックアップの構成
デフォルト設定を受け入れると、データベースはOracle Database Autonomous Recovery Serviceを使用してバックアップされます。
バックアップの保存先を変更してOCIオブジェクト・ストレージを使用するオプションがあります。
[自動バックアップの有効化]の選択を解除した場合、データベースはバックアップされません。自動バックアップは、コンテナ・データベースの作成後に有効にできます。
・ 拡張オプション
- Oracle SID接頭辞および文字セット(オプション): 「管理」タブで、「Oracle SID接頭辞」を追加し、「文字セット」および「各国語文字セット」を選択
- キー管理の構成: 「暗号化」タブには、データベース・キーを管理するためのオプションがあります。「Oracle管理キーの使用」を選択してウォレットを使用してデータベース・キーを管理するか、「顧客管理キーの使用」を選択してOCIボールトを使用してデータベース・キーを管理します。
- タグ: このリソースにフリーフォーム・タグまたは定義済タグを適用
3) コンテナ・データベース作成中
3) コンテナ・データベース作成完了
・ログ・メッセージ画面
・メトリック画面
● PDB画面
・コンテナ・データベース画面
Resourcesから[プラガブル・データベース]をクリック
・プラガブル・データベース画面
■ 接続確認
・ 仮想マシン Node1 へ ssh接続
[opc@vcn-exa-tokyo-inst01 ~]$ ssh -i .ssh/id_rsa2 opc@10.110.1.20
The authenticity of host '10.110.1.20 (10.110.1.20)' can't be established.
ECDSA key fingerprint is SHA256:CfxS+oocfSfOtkynv5exg/VtQRdGbBg1PT1l445Pzgo.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added '10.110.1.20' (ECDSA) to the
of known hosts.
Last login: Thu Jun 20 04:22:39 UTC 2024 from 10.10.0.2 on pts/0
Last login: Thu Jun 20 04:23:38 2024 from 10.10.0.2
[opc@exadb-xs1-55470 ~]$ id -a
uid=2000(opc) gid=2000(opc) groups=2000(opc)
■ Database 確認
1) oracleユーザーへログイン
[opc@exadb-xs1-55470 ~]$ sudo su - oracle
[oracle@exadb-xs1-55470 ~]$ id -a
uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(racoper),1004(asmdba)
2) DB接続用環境変数ファイル確認
DB名.env ファイルが oracleユーザーHOMEディレクトリにあることを確認
[oracle@exadb-xs1-55470 ~]$ ls -la
total 24
drwx------ 3 oracle oinstall 128 Jun 20 04:27 .
drwxr-xr-x 13 root root 170 Jun 19 05:34 ..
-rw------- 1 oracle oinstall 37 Jun 20 04:27 .bash_history
-rw-r--r-- 1 oracle oinstall 18 Aug 2 2022 .bash_logout
-rw-r--r-- 1 oracle oinstall 141 May 17 13:29 .bash_profile
-rw-r--r-- 1 oracle oinstall 376 Aug 2 2022 .bashrc
-rw-r--r-- 1 oracle oinstall 172 Oct 23 2023 .kshrc
drwx------ 2 oracle oinstall 108 Jun 19 05:34 .ssh
-rwxrwx--- 1 oracle oinstall 656 Jun 19 12:18 CDB23ai.env
3) 環境変数ファイル確認
[oracle@exadb-xs1-55470 ~]$ cat CDB23ai.env
PATH=/u02/app/oracle/product/23.0.0.0/dbhome_1/bin:/u02/app/oracle/product/23.0.0.0/dbhome_1/OPatch:$PATH; export PATH
ORACLE_UNQNAME=Ashburn; export ORACLE_UNQNAME
ORACLE_SID=CDB23ai1; export ORACLE_SID
ORACLE_HOSTNAME=exadb-xs1-55470.clientsubnet.vcndbashburn.oraclevcn.com; export ORACLE_HOSTNAME
LD_LIBRARY_PATH=/u02/app/oracle/product/23.0.0.0/dbhome_1/lib; export LD_LIBRARY_PATH
ORACLE_BASE=/u02/app/oracle; export ORACLE_BASE
OH=/u02/app/oracle/product/23.0.0.0/dbhome_1; export OH
ORACLE_HOME=/u02/app/oracle/product/23.0.0.0/dbhome_1; export ORACLE_HOME
TNS_ADMIN=/u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai; export TNS_ADMIN
4) 環境変数読み込み
[oracle@exadb-xs1-55470 ~]$ source CDB23ai.env
[oracle@exadb-xs1-55470 ~]$ env | grep ORA
ORACLE_UNQNAME=Ashburn
ORACLE_SID=CDB23ai1
ORACLE_BASE=/u02/app/oracle
ORACLE_HOME=/u02/app/oracle/product/23.0.0.0/dbhome_1
ORACLE_HOSTNAME=exadb-xs1-55470.clientsubnet.vcndbashburn.oraclevcn.com
[oracle@exadb-xs1-55470 ~]$ env | sort
eval ${which_declare} ) | /usr/bin/which --tty-only --read-alias --read-functions --show-tilde --show-dot $@
BASH_FUNC_which%%=() { ( alias;
HISTCONTROL=ignoredups
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=exadb-xs1-55470
LD_LIBRARY_PATH=/u02/app/oracle/product/23.0.0.0/dbhome_1/lib
LESSOPEN=||/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=rs=0:di=38;5;33:ln=38;5;51:mh=00:pi=40;38;5;11:so=38;5;13:do=38;5;5:bd=48;5;232;38;5;11:cd=48;5;232;38;5;3:or=48;5;232;38;5;9:mi=01;05;37;41:su=48;5;196;38;5;15:sg=48;5;11;38;5;16:ca=48;5;196;38;5;226:tw=48;5;10;38;5;16:ow=48;5;10;38;5;21:st=48;5;21;38;5;15:ex=38;5;40:*.tar=38;5;9:*.tgz=38;5;9:*.arc=38;5;9:*.arj=38;5;9:*.taz=38;5;9:*.lha=38;5;9:*.lz4=38;5;9:*.lzh=38;5;9:*.lzma=38;5;9:*.tlz=38;5;9:*.txz=38;5;9:*.tzo=38;5;9:*.t7z=38;5;9:*.zip=38;5;9:*.z=38;5;9:*.dz=38;5;9:*.gz=38;5;9:*.lrz=38;5;9:*.lz=38;5;9:*.lzo=38;5;9:*.xz=38;5;9:*.zst=38;5;9:*.tzst=38;5;9:*.bz2=38;5;9:*.bz=38;5;9:*.tbz=38;5;9:*.tbz2=38;5;9:*.tz=38;5;9:*.deb=38;5;9:*.rpm=38;5;9:*.jar=38;5;9:*.war=38;5;9:*.ear=38;5;9:*.sar=38;5;9:*.rar=38;5;9:*.alz=38;5;9:*.ace=38;5;9:*.zoo=38;5;9:*.cpio=38;5;9:*.7z=38;5;9:*.rz=38;5;9:*.cab=38;5;9:*.wim=38;5;9:*.swm=38;5;9:*.dwm=38;5;9:*.esd=38;5;9:*.jpg=38;5;13:*.jpeg=38;5;13:*.mjpg=38;5;13:*.mjpeg=38;5;13:*.gif=38;5;13:*.bmp=38;5;13:*.pbm=38;5;13:*.pgm=38;5;13:*.ppm=38;5;13:*.tga=38;5;13:*.xbm=38;5;13:*.xpm=38;5;13:*.tif=38;5;13:*.tiff=38;5;13:*.png=38;5;13:*.svg=38;5;13:*.svgz=38;5;13:*.mng=38;5;13:*.pcx=38;5;13:*.mov=38;5;13:*.mpg=38;5;13:*.mpeg=38;5;13:*.m2v=38;5;13:*.mkv=38;5;13:*.webm=38;5;13:*.ogm=38;5;13:*.mp4=38;5;13:*.m4v=38;5;13:*.mp4v=38;5;13:*.vob=38;5;13:*.qt=38;5;13:*.nuv=38;5;13:*.wmv=38;5;13:*.asf=38;5;13:*.rm=38;5;13:*.rmvb=38;5;13:*.flc=38;5;13:*.avi=38;5;13:*.fli=38;5;13:*.flv=38;5;13:*.gl=38;5;13:*.dl=38;5;13:*.xcf=38;5;13:*.xwd=38;5;13:*.yuv=38;5;13:*.cgm=38;5;13:*.emf=38;5;13:*.ogv=38;5;13:*.ogx=38;5;13:*.aac=38;5;45:*.au=38;5;45:*.flac=38;5;45:*.m4a=38;5;45:*.mid=38;5;45:*.midi=38;5;45:*.mka=38;5;45:*.mp3=38;5;45:*.mpc=38;5;45:*.ogg=38;5;45:*.ra=38;5;45:*.wav=38;5;45:*.oga=38;5;45:*.opus=38;5;45:*.spx=38;5;45:*.xspf=38;5;45:
MAIL=/var/spool/mail/oracle
OH=/u02/app/oracle/product/23.0.0.0/dbhome_1
ORACLE_BASE=/u02/app/oracle
ORACLE_HOME=/u02/app/oracle/product/23.0.0.0/dbhome_1
ORACLE_HOSTNAME=exadb-xs1-55470.clientsubnet.vcndbashburn.oraclevcn.com
ORACLE_SID=CDB23ai1
ORACLE_UNQNAME=Ashburn
PATH=/u02/app/oracle/product/23.0.0.0/dbhome_1/bin:/u02/app/oracle/product/23.0.0.0/dbhome_1/OPatch:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
PWD=/home/oracle
PYTHONPATH=:/opt/oracle.cellos/lib/python
SHELL=/bin/bash
SHLVL=1
S_COLORS=auto
TERM=xterm-256color
TNS_ADMIN=/u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai
USER=oracle
_=/usr/bin/env
which_declare=declare -f
}
5) sqlcl接続
[oracle@exadb-xs1-55470 ~]$ sql / as sysdba
SQLcl: Release 24.1 Production on Thu Jun 20 04:32:14 2024
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
SQL>
● CDB Database 確認
・ v$version 確認
SQL> select * from v$version;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
_______________________________________________________________________ ____________________________________________________________________________________________ _______________________________________________________________________ _________
Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production
Version 23.4.0.24.05 Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production 0
・ gv$instance確認
SQL> select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION,STATUS, THREAD#,INSTANCE_ROLE,DATABASE_TYPE from gv$instance order by 1;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STATUS THREAD# INSTANCE_ROLE DATABASE_TYPE
__________________ ________________ __________________ _____________ _________ __________ ___________________ ________________
1 CDB23ai1 exadb-xs1-55470 23.0.0.0.0 OPEN 1 PRIMARY_INSTANCE RAC
2 CDB23ai2 exadb-xs2-55471 23.0.0.0.0 OPEN 2 PRIMARY_INSTANCE RAC
・ gv$database確認
SQL> select DBID, CDB, NAME, DB_UNIQUE_NAME, INST_ID, LOG_MODE,FLASHBACK_ON, PROTECTION_MODE from gv$database;
DBID CDB NAME DB_UNIQUE_NAME INST_ID LOG_MODE FLASHBACK_ON PROTECTION_MODE
_____________ ______ __________ _________________ __________ _____________ _______________ ______________________
2166367504 YES CDB23AI Ashburn 2 ARCHIVELOG YES MAXIMUM PERFORMANCE
2166367504 YES CDB23AI Ashburn 1 ARCHIVELOG YES MAXIMUM PERFORMANCE
・ CHARACTERSET確認
SQL> SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
PARAMETER VALUE
_________________________ ____________
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8
・ PFIlE(初期化パラメータ)確認
SQL> create pfile='/tmp/init.ora' from spfile;
Pfile='/tmp/init.ora' FROM created.
SQL> host cat /tmp/init.ora
CDB23ai1.__data_transfer_cache_size=0
CDB23ai2.__data_transfer_cache_size=0
CDB23ai1.__datamemory_area_size=0
CDB23ai2.__datamemory_area_size=0
CDB23ai1.__db_cache_size=1845493760
CDB23ai2.__db_cache_size=1912602624
CDB23ai1.__inmemory_ext_roarea=0
CDB23ai2.__inmemory_ext_roarea=0
CDB23ai1.__inmemory_ext_rwarea=0
CDB23ai2.__inmemory_ext_rwarea=0
CDB23ai1.__java_pool_size=0
CDB23ai2.__java_pool_size=0
CDB23ai1.__large_pool_size=16777216
CDB23ai2.__large_pool_size=16777216
CDB23ai1.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment
CDB23ai2.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment
CDB23ai1.__pga_aggregate_target=2634022912
CDB23ai2.__pga_aggregate_target=2634022912
CDB23ai1.__sga_target=3992977408
CDB23ai2.__sga_target=3992977408
CDB23ai1.__shared_io_pool_size=134217728
CDB23ai2.__shared_io_pool_size=83886080
CDB23ai1.__shared_pool_size=1694498816
CDB23ai2.__shared_pool_size=1677721600
CDB23ai1.__streams_pool_size=0
CDB23ai2.__streams_pool_size=0
CDB23ai1.__unified_pga_pool_size=0
CDB23ai2.__unified_pga_pool_size=0
*._assm_segment_repair_bg=FALSE
*._instance_recovery_bloom_filter_size=1048576
CDB23ai1._instance_recovery_bloom_filter_size=1048576
CDB23ai2._instance_recovery_bloom_filter_size=1048576
*._parallel_adaptive_max_users=2
*.cluster_database=true
*.compatible='23.0.0'
*.control_files='@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/CONTROLFILE/Current.OMF.22E8DCE9'
*.control_management_pack_access='DIAGNOSTIC+TUNING'
*.db_block_checking='OFF'
*.db_block_checksum='TYPICAL'
*.db_block_size=8192
*.db_create_file_dest='@eDcvMrFC(DATA_HC_HIGHREDUNDANCY)'
*.db_create_online_log_dest_1='@eDcvMrFC(DATA_HC_HIGHREDUNDANCY)'
*.db_domain='clientsubnet.vcndbashburn.oraclevcn.com'
*.db_files=1024
*.db_flashback_retention_target=1440
*.db_lost_write_protect='typical'
*.db_name='CDB23ai'
*.db_recovery_file_dest='@eDcvMrFC(RECO_HC_HIGHREDUNDANCY)'
*.db_recovery_file_dest_size=737280m
*.db_unique_name='Ashburn'
*.diagnostic_dest='/u02/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CDB23aiXDB)'
*.distributed_lock_timeout=360
*.enable_ddl_logging=TRUE
*.enable_pluggable_database=true
*.fast_start_mttr_target=300
*.filesystemio_options='setall'
*.global_names=TRUE
*.inmemory_force='cellmemory_level'
family:dw_helper.instance_mode='read-only'
CDB23ai2.instance_number=2
CDB23ai1.instance_number=1
*.local_
ener='-oraagent-dummy-'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) MAX_FAILURE=1 REOPEN=5 DB_UNIQUE_NAME=Ashburn ALTERNATE=LOG_ARCHIVE_DEST_10'
*.log_archive_dest_10='LOCATION=@eDcvMrFC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=Ashburn ALTERNATE=LOG_ARCHIVE_DEST_1'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_10='ALTERNATE'
*.log_archive_dest_state_2='ALTERNATE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=268435456
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=1000
*.os_authent_prefix=''
*.parallel_execution_message_size=16384
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=2500m
*.processes=2048
*.recyclebin='on'
*.remote_
ener='exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com:1521'
*.remote_login_passwordfile='exclusive'
*.sec_protocol_error_further_action='(DROP,3)'
*.sga_target=3800m
*.sql92_security=TRUE
*.tde_configuration='keystore_configuration=FILE'
CDB23ai2.thread=2
CDB23ai1.thread=1
CDB23ai1.undo_tablespace='UNDOTBS1'
CDB23ai2.undo_tablespace='UNDOTBS2'
*.use_large_pages='ONLY'
*.wallet_root='/var/opt/oracle/dbaas_acfs/CDB23ai/wallet_root'
・ Data Files確認
表領域追加、ファイルサイズ変更など必要に応じて実施
SQL> SELECT
a.TABLESPACE_NAME
,a.BYTES/1024/1024 as "Size(MB)"
,a.FILE_NAME
,a.autoextensible as "Auto_Extent"
,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
,b.BLOCK_SIZE
,b.BIGFILE
FROM DBA_DATA_FILES a
, DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT
x.TABLESPACE_NAME
,x.BYTES/1024/1024 as "Size(MB)"
,x.FILE_NAME
,x.autoextensible as "Auto_Extent"
,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
,y.BLOCK_SIZE
,y.BIGFILE
FROM dba_temp_files x
, DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME
ORDER By TABLESPACE_NAME
;
TABLESPACE_NAME Size(MB) FILE_NAME Auto_Extent Auto_Extent_Size(MB) MAX_SIZE(MB) BLOCK_SIZE BIGFILE
__________________ ___________ ____________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
SYSAUX 2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/DATAFILE/SYSAUX.OMF.0B216FE0 YES 4096 33,554,432 8192 YES
SYSTEM 2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/DATAFILE/SYSTEM.OMF.166CD2D0 YES 4096 33,554,432 8192 YES
TEMP 17408 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/TEMPFILE/TEMP.OMF.19FF4F4B YES 16384 524,288 8192 YES
UNDOTBS1 2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/DATAFILE/UNDOTBS1.OMF.2EB9F6B0 YES 4096 524,288 8192 YES
UNDOTBS2 2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/DATAFILE/UNDOTBS2.OMF.077C0420 YES 4096 524,288 8192 YES
USERS 1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/DATAFILE/USERS.OMF.77A85354 YES 500 33,554,432 8192 YES
6 rows selected.
・ Redo Log確認
REDO Member/Group、サイズ変更など必要に応じて実施
SQL> SELECT
b.THREAD#
,b.MEMBERS
,a.GROUP#
,b.SEQUENCE#
,a.MEMBER
,b.bytes/1024/1024 as "Bytes(MB)"
,a.TYPE
,b.STATUS
,b.ARCHIVED
FROM
v$logfile a
,v$log b
WHERE
a.GROUP#=b.GROUP#
ORDER BY GROUP#;
THREAD# MEMBERS GROUP# SEQUENCE# MEMBER Bytes(MB) TYPE STATUS ARCHIVED
__________ __________ _________ ____________ ____________________________________________________________________________________________ ____________ _________ ___________ ___________
1 1 1 1 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_1.OMF.3503ACBF 4000 ONLINE INACTIVE YES
1 1 2 2 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_2.OMF.0752AEBA 4000 ONLINE INACTIVE YES
1 1 3 3 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_3.OMF.35BD5AF4 4000 ONLINE CURRENT NO
1 1 4 0 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_4.OMF.4E8C525D 4000 ONLINE UNUSED YES
2 1 5 1 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_5.OMF.58136441 4000 ONLINE INACTIVE YES
2 1 6 2 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_6.OMF.32D4EC63 4000 ONLINE INACTIVE YES
2 1 7 3 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_7.OMF.57E67361 4000 ONLINE INACTIVE YES
2 1 8 4 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/ONLINELOG/group_8.OMF.2A9287DC 4000 ONLINE CURRENT NO
8 rows selected.
・ ブロック・チェンジ・トラッキング確認
SQL> SELECT filename,status,bytes FROM v$block_change_tracking;
FILENAME STATUS BYTES
___________ ___________ ________
DISABLED
● PDB確認
・ PDB確認
SQL> show pdbs
CON_ID CON_NAME OPENMODE RESTRICTED
_________ ___________ _____________ _____________
2 PDB$SEED READ ONLY NO
3 PDB23AI READ WRITE NO
・ PDB接続
SQL> alter session set container=pdb23ai;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB23AI
・ 表領域確認
表領域追加、ファイルサイズ変更など必要に応じて実施
SQL> SELECT
a.TABLESPACE_NAME
,a.BYTES/1024/1024 as "Size(MB)"
,a.FILE_NAME
,a.autoextensible as "Auto_Extent"
,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
,b.BLOCK_SIZE
,b.BIGFILE
FROM DBA_DATA_FILES a
, DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT
x.TABLESPACE_NAME
,x.BYTES/1024/1024 as "Size(MB)"
,x.FILE_NAME
,x.autoextensible as "Auto_Extent"
,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
,y.BLOCK_SIZE
,y.BIGFILE
FROM dba_temp_files x
, DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME
ORDER By TABLESPACE_NAME
TABLESPACE_NAME Size(MB) FILE_NAME Auto_Extent Auto_Extent_Size(MB) MAX_SIZE(MB) BLOCK_SIZE BIGFILE
__________________ ___________ _____________________________________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
SYSAUX 600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/DATAFILE/SYSAUX.OMF.654CD5A5 YES 4096 33,554,432 8192 YES
SYSTEM 600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/DATAFILE/SYSTEM.OMF.25BB9995 YES 4096 33,554,432 8192 YES
TEMP 1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/TEMPFILE/TEMP.OMF.35D373A6 NO 0 0 8192 YES
UNDOTBS1 600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/DATAFILE/UNDOTBS1.OMF.4E32DDFF YES 4096 524,288 8192 YES
UNDO_4 95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/DATAFILE/UNDO_4.OMF.64E55E40 YES 4096 524,288 8192 YES
USERS 1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/1B3E0FACD39A087BE06314016E0AC272/DATAFILE/USERS.OMF.371FE95D YES 16384 33,554,432 8192 YES
6 rows selected.
● ORACLE*NET確認
・ TNS_ADMIN
[oracle@exadb-xs1-55470 ~]$ ls -la $ORACLE_HOME/network/admin
total 28
drwxr-xr-x 4 oracle oinstall 4096 Jun 19 12:14 .
drwxr-xr-x 10 oracle oinstall 4096 Apr 24 19:21 ..
drwxr-x--- 2 oracle oinstall 4096 Jun 19 12:14 CDB23ai
drwxr-xr-x 2 oracle oinstall 4096 Apr 24 19:21 samples
-rw-r--r-- 1 oracle oinstall 1866 May 19 2021 shrept.lst
lrwxrwxrwx 1 oracle oinstall 74 Jun 19 12:14 sqlnet.ora -> /u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai/sqlnet.ora
lrwxrwxrwx 1 oracle oinstall 76 Jun 19 12:14 tnsnames.ora -> /u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai/tnsnames.ora
・ sqlnet.ora
[oracle@exadb-xs1-55470 ~]$ cat $ORACLE_HOME/network/admin/sqlnet.ora
HTTPS_SSL_VERSION=1.2
SQLNET.CRYPTO_CHECKSUM_CLIENT=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256,SHA384,SHA512)
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_SERVER=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.EXPIRE_TIME=10
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.WALLET_OVERRIDE=FALSE
SSL_CIPHER_SUITES=(SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,SSL_ECDHE_RSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_RSA_WITH_AES_256_GCM_SHA384)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION=1.2
WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/grid/tcps_wallets)))
ENCRYPTION_WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/CDB23ai/wallet_root/tde)))
・ tnsnames.ora
[oracle@exadb-xs1-55470 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai/tnsnames.ora
# Generated by Oracle configuration tools.
ASHBURN=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL= TCP)
(HOST= exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com)
(PORT= 1521))
(CONNECT_DATA=
(SERVER= DEDICATED)
(SERVICE_NAME= Ashburn.clientsubnet.vcndbashburn.oraclevcn.com)))
CDB23AI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=Ashburn.clientsubnet.vcndbashburn.oraclevcn.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
PDB23AI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PDB23AI.clientsubnet.vcndbashburn.oraclevcn.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
CDB23AI_PDB23AI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=CDB23ai_PDB23AI.paas.oracle.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
・ opatch確認
[oracle@exadb-xs1-55470 ~]$ opatch lspatches
36656328;MERGE REQUEST ON TOP OF 23.0.0.0.0 FOR BUGS 36410732 36553613
OPatch succeeded.
■ Grid Infrastructure 確認
・ grid ユーザー・ログイン
[oracle@exadb-xs1-55470 ~]$ exit
logout
[opc@exadb-xs1-55470 ~]$ sudo su - grid
[grid@exadb-xs1-55470 ~]$ id -a
uid=1000(grid) gid=1001(oinstall) groups=1001(oinstall),1004(asmdba),1005(asmoper),1006(asmadmin)
・クラスタ・リソース状態確認
[grid@exadb-xs1-55470 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.
ENER.lsnr
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
ora.acfsrm
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
ora.ccmb
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
ora.chad
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
ora.edcvmrfc.vexdb78.acfs
ONLINE ONLINE exadb-xs1-55470 mounted on /var/opt/
oracle/dbaas_acfs,ST
ABLE
ONLINE ONLINE exadb-xs2-55471 mounted on /var/opt/
oracle/dbaas_acfs,ST
ABLE
ora.net1.network
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
ora.ons
ONLINE ONLINE exadb-xs1-55470 STABLE
ONLINE ONLINE exadb-xs2-55471 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.
ENER_SCAN1.lsnr
1 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.
ENER_SCAN2.lsnr
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.
ENER_SCAN3.lsnr
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.ashburn.cdb23ai_pdb23ai.paas.oracle.com.svc
1 ONLINE ONLINE exadb-xs1-55470 STABLE
2 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.ashburn.db
1 ONLINE ONLINE exadb-xs1-55470 Open,HOME=/u02/app/o
racle/product/23.0.0
.0/dbhome_1,STABLE
2 ONLINE ONLINE exadb-xs2-55471 Open,HOME=/u02/app/o
racle/product/23.0.0
.0/dbhome_1,STABLE
ora.ashburn.pdb23ai.pdb
1 ONLINE ONLINE exadb-xs1-55470 READ WRITE,STABLE
2 ONLINE ONLINE exadb-xs2-55471 READ WRITE,STABLE
ora.cdp1.cdp
1 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.cdp2.cdp
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.cdp3.cdp
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.cvu
1 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.exadb-xs1-55470.vip
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.exadb-xs2-55471.vip
1 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.scan1.vip
1 ONLINE ONLINE exadb-xs2-55471 STABLE
ora.scan2.vip
1 ONLINE ONLINE exadb-xs1-55470 STABLE
ora.scan3.vip
1 ONLINE ONLINE exadb-xs1-55470 STABLE
--------------------------------------------------------------------------------
・ クラスタ・リソース属性確認
[grid@exadb-xs1-55470 ~]$ crsctl stat resource -p
・・・
NAME=ora.ashburn.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:racoper:r-x,user:grid:r-x
ACTIONS=relocate_client,group:"dba",group:"racoper",user:"grid",user:"oracle" status_target,group:"dba",group:"racoper",user:"grid",user:"oracle"
JavaServices,group:"dba",group:"racoper",user:"grid",user:"oracle" isPUJSDone,group:"dba",group:"racoper",user:"grid",user:"oracle" unmonitor,user:"grid" serviceDrain,group:"dba",group:"racoper",user:"grid",user:"oracle" monitor,user:"grid" startoption,group:"dba",group:"racoper",user:"grid",user:"oracle"
DBInst,group:"dba",group:"racoper",user:"grid",user:"oracle"
ACTION_SCRIPT=
ACTION_START_OPTION=
ACTION_TIMEOUT=600
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_RESTART=default
AUTO_START=restore
BATCH_ENABLED=0
CARDINALITY=2
CHECK_INTERVAL=900
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
CLUSTER_DATABASE=true
CSS_CRITICAL=no
DATABASE_TYPE=RAC
DB_UNIQUE_NAME=Ashburn
DEFAULT_NETNUM=
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Database resource
DISABLED_REASON=
DRAIN_ID=
DRAIN_TIMEOUT=
DUAL_INST_STATE=
ENABLED=1
ENABLE_PDB=yes
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u02/app/oracle/product/23.0.0.0/dbhome_1/rdbms/audit
GEN_RESTART=
GEN_RESTART@SERVERNAME(exadb-xs1-55470)=StartCompleted
GEN_RESTART@SERVERNAME(exadb-xs2-55471)=StartCompleted
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(exadb-xs1-55470)=CDB23ai1
GEN_USR_ORA_INST_NAME@SERVERNAME(exadb-xs2-55471)=CDB23ai2
HOSTING_MEMBERS=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=0
INTERMEDIATE_TIMEOUT=0
JAVA_SERVICES=
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u02/app/oracle/product/23.0.0.0/dbhome_1
ORACLE_HOME_OLD=
PATCH_IN_PROGRESS=false
PLACEMENT=restricted
PWFILE=@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/PASSWORD/pwdASHBURN.491F5578
RANK=0
REGISTER_ENTRYPOINT_REQUIRED=one
REGISTER_TIMEOUT=60
RELOCATE_ACTION=0
RELOCATE_BY_DEPENDENCY=0
RELOCATE_KIND=offline
RESOURCE_GROUP=
RESTART_ATTEMPTS=2
RESTART_DELAY=0
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.Ashburn
SERVER_POOLS_PQ=
SERVER_POOLS_RF=
SERVICE_NAMES=
SPFILE=@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/PARAMETERFILE/spfile.OMF.34697CF5
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.edcvmrfc.vexdb78.acfs) weak(concurrent:type:ora.
ener.type,global:type:ora.scan_
ener.type,uniform:ora.ons,global:ora.gns) pullup(ora.edcvmrfc.vexdb78.acfs)
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="isEDV">False</Cond><Cond name="ASMClientMode">False</Cond><Cond name="ASMmode">legacy</Cond><Arg name="dg" type="Res
"></Arg><Arg name="acfs_or_nfs" type="Res
">ora.edcvmrfc.vexdb78.acfs</Arg><Cond name="OHResExist">False</Cond><Cond name="DATABASE_TYPE">RAC</Cond><Cond name="MANAGEMENT_POLICY">AUTOMATIC</Cond><Arg name="acfs_and_nfs" type="Res
">ora.edcvmrfc.vexdb78.acfs,</Arg></xml>
START_DEPENDENCIES_TEMPLATE=
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.edcvmrfc.vexdb78.acfs)
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">False</Cond><Cond name="DGExist">False</Cond><Arg name="acfs_same_as_oh" type="Res"></Arg><Arg name="acfs" type="Res
">ora.edcvmrfc.vexdb78.acfs</Arg><Cond name="OHResExist">False</Cond><Cond name="isEDV">False</Cond></xml>
STOP_DEPENDENCIES_TEMPLATE=
STOP_TIMEOUT=600
TARGET_DEFAULT=default
TARGET_NAME=
TARGET_TYPE=
TYPE_VERSION=3.3
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_QOS_DATA=no
USE_STICKINESS=0
USR_ORA_DB_NAME=CDB23ai
USR_ORA_DOMAIN=clientsubnet.vcndbashburn.oraclevcn.com
USR_ORA_ENV=TNS_ADMIN=/u02/app/oracle/product/23.0.0.0/dbhome_1/network/admin/CDB23ai
USR_ORA_FLAGS=
USR_ORA_INST_NAME=
USR_ORA_INST_NAME@SERVERNAME(exadb-xs1-55470)=CDB23ai1
USR_ORA_INST_NAME@SERVERNAME(exadb-xs2-55471)=CDB23ai2
USR_ORA_INST_NAME_OLD=
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
NAME=ora.ashburn.pdb23ai.pdb
TYPE=ora.pdb.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:racoper:r-x,user:grid:r-x
ACTIONS=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_RESTART=default
AUTO_START=never
BATCH_ENABLED=0
CARDINALITY=%CRS_SERVER_POOL_SIZE%
CHECK_INTERVAL=0
CHECK_TIMEOUT=0
CLEAN_TIMEOUT=60
CSS_CRITICAL=no
DELETE_TIMEOUT=60
DESCRIPTION=CRS resource type definition for Oracle Pluggable Database
DISABLED_REASON=
DRAIN_ID=
DRAIN_TIMEOUT=
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_USR_ORA_OPEN_MODE=
HOSTING_MEMBERS=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=MANUAL
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PDB_NAME=PDB23AI
PLACEMENT=restricted
RANK=0
REGISTER_ENTRYPOINT_REQUIRED=one
REGISTER_TIMEOUT=60
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=online
RESOURCE_GROUP=
RESTART_ATTEMPTS=0
RESTART_DELAY=0
ROLE=
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.Ashburn
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.ashburn.db) pullup(ora.ashburn.db)
START_DEPENDENCIES_RTE_INTERNAL=
START_DEPENDENCIES_TEMPLATE=
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.ashburn.db)
STOP_DEPENDENCIES_RTE_INTERNAL=
STOP_DEPENDENCIES_TEMPLATE=
STOP_TIMEOUT=600
TARGET_DEFAULT=offline
TYPE_VERSION=1.1
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_CARDINALITY=false
USE_STICKINESS=0
USR_ORA_ENV=
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
・・・
● ORACLE*NET確認
・ TNS_ADMIN
[grid@exadb-xs1-55470 ~]$ ls -l $ORACLE_HOME/network/admin/
total 24
-rw-r----- 1 grid oinstall 1372 Jun 19 11:11 listener.ora
-rw-r----- 1 grid oinstall 1050 Jun 19 11:09 listener.ora.bak.exadb-xs1-55470.grid
-rw-r----- 1 grid oinstall 882 Jun 19 10:59 listener24061910AM5909.bak
drwxr-xr-x 2 grid oinstall 64 Apr 24 19:32 samples
-rw-r--r-- 1 grid oinstall 1866 May 19 2021 shrept.lst
-rw-r----- 1 grid oinstall 980 Jun 19 11:09 sqlnet.ora
-rw-r----- 1 grid oinstall 216 Jun 19 11:09 sqlnet.ora_2024-06-19_11-09-31-AM
・ sqlnet.ora 確認
[grid@exadb-xs1-55470 admin]$ cat $ORACLE_HOME/network/admin/sqlnet.ora
# sqlnet.ora.exadb-xs1-55470 Network Configuration File: /u01/app/23.0.0.0/gridhome_1/network/admin/sqlnet.ora.exadb-xs1-55470
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA256,SHA384,SHA512,SHA1)
SQLNET.ENCRYPTION_SERVER=REQUESTED
SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
SQLNET.CRYPTO_CHECKSUM_CLIENT=ACCEPTED
HTTPS_SSL_VERSION=1.2
SSL_VERSION=1.2
SSL_CIPHER_SUITES=(SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,SSL_ECDHE_RSA_WITH_AES_128_GCM_SHA256,SSL_ECDHE_RSA_WITH_AES_256_GCM_SHA384)
WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/grid/tcps_wallets)))
SQLNET.WALLET_OVERRIDE=FALSE
SSL_CLIENT_AUTHENTICATION=FALSE
・ listener.ora 確認
[grid@exadb-xs1-55470 ~]$ cat $ORACLE_HOME/network/admin/listener.ora
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN2=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
SSL_VERSION=1.2
WALLET_LOCATION=(SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /var/opt/oracle/dbaas_acfs/grid/tcps_wallets)))
SSL_CLIENT_AUTHENTICATION = FALSE
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN3=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
・ listnerctl stat
[grid@exadb-xs1-55470 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 20-JUN-2024 05:01:11
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production
Start Date 19-JUN-2024 11:11:25
Uptime 0 days 17 hr. 49 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/23.0.0.0/gridhome_1/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/exadb-xs1-55470/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=10.110.1.193)(PORT=2484)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.110.1.20)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.110.1.193)(PORT=1521)))
Services Summary...
Service "1b3e0facd39a087be06314016e0ac272.clientsubnet.vcndbashburn.oraclevcn.com" has 1 instance(s).
Instance "CDB23ai1", status READY, has 1 handler(s) for this service...
Service "Ashburn.clientsubnet.vcndbashburn.oraclevcn.com" has 1 instance(s).
Instance "CDB23ai1", status READY, has 1 handler(s) for this service...
Service "CDB23aiXDB.clientsubnet.vcndbashburn.oraclevcn.com" has 1 instance(s).
Instance "CDB23ai1", status READY, has 1 handler(s) for this service...
Service "CDB23ai_PDB23AI.paas.oracle.com" has 1 instance(s).
Instance "CDB23ai1", status READY, has 1 handler(s) for this service...
Service "pdb23ai.clientsubnet.vcndbashburn.oraclevcn.com" has 1 instance(s).
Instance "CDB23ai1", status READY, has 1 handler(s) for this service...
The command completed successfully
・ サービス名確認
[grid@exadb-xs1-55470 ~]$ srvctl status service -d cdb23ai_ashburn
Service cdb23ai_pdb23ai.paas.oracle.com is running on instances CDB23ai1,CDB23ai2
・ Cluster名確認
[grid@exadb-xs1-55470 ~]$ olsnodes -c
Cluster
・ RAC Node確認
[grid@exadb-xs1-55470 ~]$ olsnodes -n -s
exadb-xs1-55470 1 Active
exadb-xs2-55471 2 Active
・ Interconnect確認
local Nodeのみ表示できるので次のように各 Nodeで確認
Node1
[grid@exadb-xs1-55470 ~]$ olsnodes -l -p
exadb-xs1-55470 100.107.1.48,100.107.1.49
Node2
[grid@exadb-xs2-55471 ~]$ olsnodes -l -p
exadb-xs2-55471 100.107.1.50,100.107.1.51
・ OCR情報確認
[grid@exadb-xs1-55470 ~]$ cat /etc/oracle/ocr.loc
ocrconfig_loc=@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/data.ocr
local_only=FALSE
・ Voting情報確認
[grid@exadb-xs1-55470 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE b12c2d2ea8394faebf9047a9480562c6 (@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/vfile1) []
Located 1 voting disk(s).
・ SCAN確認
[grid@exadb-xs1-55470 ~]$ srvctl config scan
SCAN name: exadb-xs-scan-55486.clientsubnet.vcndbashburn.oraclevcn.com, Network: 1
Subnet IPv4: 10.110.1.0/255.255.255.0/bondeth0, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.110.1.149
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.110.1.87
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 10.110.1.180
SCAN VIP is enabled.
・ SCAN Listener確認
[grid@exadb-xs1-55470 ~]$ srvctl config scan_listener
SCAN Listeners for network 1:
Registration invited nodes:
Registration invited subnets:
Endpoints: TCP:1521/TCPS:2484
SCAN Listener LISTENER_SCAN1 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN2 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN3 exists
SCAN Listener is enabled.
■ VM クラスタ確認
・ CPU確認
[grid@exadb-xs1-55470 ~]$ lscpu | grep Intel
Vendor ID: GenuineIntel
Model name: Intel(R) Xeon(R) Platinum 8270CL CPU @ 2.70GHz
・ ifconfig
[opc@exadb-xs1-55470 ~]$ ifconfig -a
bondeth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.110.1.20 netmask 255.255.255.0 broadcast 10.110.1.255
ether 02:00:17:09:8e:2e txqueuelen 1000 (Ethernet)
RX packets 875037 bytes 130183326 (124.1 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 917963 bytes 18377042023 (17.1 GiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
bondeth0:1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.110.1.193 netmask 255.255.255.0 broadcast 10.110.1.255
ether 02:00:17:09:8e:2e txqueuelen 1000 (Ethernet)
bondeth0:2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.110.1.180 netmask 255.255.255.0 broadcast 10.110.1.255
ether 02:00:17:09:8e:2e txqueuelen 1000 (Ethernet)
bondeth1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 10.110.2.221 netmask 255.255.255.0 broadcast 10.110.2.255
ether 02:00:17:09:b1:84 txqueuelen 1000 (Ethernet)
RX packets 21840 bytes 5179011 (4.9 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 15149 bytes 196586378 (187.4 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
clre0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 2300
inet 100.107.1.48 netmask 255.255.0.0 broadcast 100.107.255.255
ether 52:54:00:54:e5:89 txqueuelen 1000 (Ethernet)
RX packets 147895 bytes 76474475 (72.9 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 151677 bytes 96032991 (91.5 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
clre1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 2300
inet 100.107.1.49 netmask 255.255.0.0 broadcast 100.107.255.255
ether 52:54:00:03:70:d7 txqueuelen 1000 (Ethernet)
RX packets 124185 bytes 74828416 (71.3 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 126139 bytes 93224920 (88.9 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 169.254.200.2 netmask 255.255.255.252 broadcast 169.254.200.3
ether 52:54:00:7a:69:26 txqueuelen 1000 (Ethernet)
RX packets 2601 bytes 584973 (571.2 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2789 bytes 461384 (450.5 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
loop txqueuelen 1000 (Local Loopback)
RX packets 1197765 bytes 184161598 (175.6 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1197765 bytes 184161598 (175.6 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
stre0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 2300
inet 100.105.64.48 netmask 255.255.0.0 broadcast 100.105.255.255
ether 52:54:00:88:d5:03 txqueuelen 1000 (Ethernet)
RX packets 7444778 bytes 458613862 (437.3 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 68313 bytes 14150697 (13.4 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
stre1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 2300
inet 100.105.64.49 netmask 255.255.0.0 broadcast 100.105.255.255
ether 52:54:00:86:5d:6a txqueuelen 1000 (Ethernet)
RX packets 7417639 bytes 445660607 (425.0 MiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 38003 bytes 2825022 (2.6 MiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
・ /etc/hosts
[opc@exadb-xs1-55470 ~]$ cat /etc/hosts
#### BEGIN Generated by Exadata ####
127.0.0.1 localhost.localdomain localhost
::1 ip6-localhost.localdomain ip6-localhost
10.110.1.20 exadb-xs1-55470.clientsubnet.vcndbashburn.oraclevcn.com exadb-xs1-55470
10.110.2.221 exadb-xs1-bkp-55480.buckupsubnet.vcndbashburn.oraclevcn.com exadb-xs1-bkp-55480
169.254.200.2 iad309912exddu1101.localdomain iad309912exddu1101
#### END Generated by Exadata ####
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
169.254.200.1 nat-mvm1-hostname
・df
[root@exadb-xs1-55470 ~]# df -hT
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 38G 0 38G 0% /dev
tmpfs tmpfs 38G 5.0M 38G 1% /run
tmpfs tmpfs 38G 0 38G 0% /sys/fs/cgroup
/dev/mapper/VGExaDb-LVDbSys1 xfs 15G 6.4G 8.6G 43% /
/dev/mapper/VGExaDb-LVDbKdump xfs 20G 175M 20G 1% /crashfiles
/dev/mapper/VGExaDbDisk.u02_extra.img-LVDBDisk ext4 81G 8.1G 68G 11% /u02
/dev/sda1 xfs 412M 119M 294M 29% /boot
/dev/mapper/VGExaDb-LVDbVar1 xfs 5.0G 882M 4.1G 18% /var
/dev/mapper/VGExaDb-LVDbTmp xfs 10G 105M 9.9G 2% /tmp
/dev/mapper/VGExaDb-LVDbHome xfs 4.0G 77M 4.0G 2% /home
/dev/mapper/VGExaDbDisk.u01_Vm99097_1_7a1b-LVDBDisk xfs 80G 8.3G 72G 11% /u01
/dev/mapper/VGExaDb-LVDbVarLog xfs 18G 575M 18G 4% /var/log
/dev/mapper/VGExaDb-LVDbVarLogAudit xfs 3.0G 158M 2.8G 6% /var/log/audit
tmpfs tmpfs 76G 512M 75G 1% /dev/shm
oracle_clusterware tmpfs 128M 15M 114M 12% /u01/app/grid/crsdata/exadb-xs1-55470/shm
/dev/exc/vExdb78 acfs 200G 3.9G 197G 2% /var/opt/oracle/dbaas_acfs
tmpfs tmpfs 7.6G 0 7.6G 0% /run/user/1001
tmpfs tmpfs 7.6G 0 7.6G 0% /run/user/2000
・ lvs
[root@exadb-xs1-55470 ~]# lvs
LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert
LVDbHome VGExaDb -wi-ao---- 4.00g
LVDbKdump VGExaDb -wi-ao---- 20.00g
LVDbSwap1 VGExaDb -wi-ao---- 16.00g
LVDbSys1 VGExaDb -wi-ao---- 15.00g
LVDbSys2 VGExaDb -wi-a----- 15.00g
LVDbTmp VGExaDb -wi-ao---- 10.00g
LVDbVar1 VGExaDb -wi-ao---- 5.00g
LVDbVar2 VGExaDb -wi-a----- 5.00g
LVDbVarLog VGExaDb -wi-ao---- 18.00g
LVDbVarLogAudit VGExaDb -wi-ao---- 3.00g
LVDoNotRemoveOrUse VGExaDb -wi-a----- 2.00g
LVDBDisk VGExaDbDisk.u01_Vm99097_1_7a1b -wi-ao---- 80.00g
LVDBDisk VGExaDbDisk.u02_extra.img -wi-ao---- 82.00g
・ lsblk
[root@exadb-xs1-55470 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 114G 0 disk
├─sda1 8:1 0 512M 0 part /boot
├─sda2 8:2 0 256M 0 part
└─sda3 8:3 0 113.3G 0 part
├─VGExaDb-LVDbSys1 252:2 0 15G 0 lvm /
├─VGExaDb-LVDbVar1 252:3 0 5G 0 lvm /var
├─VGExaDb-LVDbVarLog 252:4 0 18G 0 lvm /var/log
├─VGExaDb-LVDbHome 252:5 0 4G 0 lvm /home
├─VGExaDb-LVDbSys2 252:6 0 15G 0 lvm
├─VGExaDb-LVDbSwap1 252:7 0 16G 0 lvm [SWAP]
├─VGExaDb-LVDbTmp 252:8 0 10G 0 lvm /tmp
├─VGExaDb-LVDbVar2 252:9 0 5G 0 lvm
├─VGExaDb-LVDbVarLogAudit 252:10 0 3G 0 lvm /var/log/audit
├─VGExaDb-LVDbKdump 252:11 0 20G 0 lvm /crashfiles
└─VGExaDb-LVDoNotRemoveOrUse 252:12 0 2G 0 lvm
sdb 8:16 0 84G 0 disk
└─sdb1 8:17 0 84G 0 part
└─VGExaDbDisk.u02_extra.img-LVDBDisk 252:1 0 82G 0 lvm /u02
sdc 8:32 0 82G 0 disk
└─sdc1 8:33 0 82G 0 part
└─VGExaDbDisk.u01_Vm99097_1_7a1b-LVDBDisk 252:0 0 80G 0 lvm /u01
exc-dev1 251:1 0 200G 0 disk /var/opt/oracle/dbaas_acfs
・ xsh 確認
1) Vault名確認
[root@exadb-xs1-55470 ~]# xsh ls
@eDcvMrFC
2) ファイル確認
[root@exadb-xs1-55470 ~]# xsh ls @eDcvMrFC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/ASHBURN/AUTOBACKUP/2024_06_19/s_1172060845.OMF.15AC1997
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/199B5196EE96B63BE063CA504664BC13/DATAFILE/SYSAUX.OMF.4C97521B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/199B5196EE96B63BE063CA504664BC13/DATAFILE/SYSTEM.OMF.579BC378
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/199B5196EE96B63BE063CA504664BC13/DATAFILE/UNDOTBS1.OMF.029BBFA7
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/199B5196EE96B63BE063CA504664BC13/DATAFILE/temp012024-06-20_05-26-53-761-AM.dbf
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSAUX.OMF.4EEBECB8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSAUX.OMF.615A3B80
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSTEM.OMF.161A3D33
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSTEM.OMF.1CA59B45
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDOTBS1.OMF.24F9A4A0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_4.OMF.328C79F8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/USERS.OMF.67813A53
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/TEMPFILE/TEMP.OMF.39A0866D
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1000.OMF.2550B0DA
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1001.OMF.6DBBD703
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1002.OMF.77E511E3
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1003.OMF.51AE27D0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1004.OMF.3670D9B9
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1005.OMF.51F16348
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1006.OMF.68DBE85D
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1007.OMF.14B318C4
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_1008.OMF.6F88053D
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_973.OMF.01F34068
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_974.OMF.2741A521
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_975.OMF.4EFA24EC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_976.OMF.2B961660
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_977.OMF.747F5806
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_978.OMF.21EC8CEA
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_979.OMF.237D4ABB
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_980.OMF.3A4848F0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_981.OMF.2F07F390
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_982.OMF.04E4A0D0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_983.OMF.63D087CC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_984.OMF.07D95FBA
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_985.OMF.1F7A4CBF
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_986.OMF.1542642E
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_987.OMF.2D61DBCC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_988.OMF.28F8E604
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_989.OMF.474AB9B4
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_990.OMF.173F2BAC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_991.OMF.02BF9ACD
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_992.OMF.4C6D4357
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_993.OMF.25FEB9B5
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_994.OMF.2AD384AC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_995.OMF.5368F601
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_996.OMF.348822C9
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_997.OMF.78143145
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_998.OMF.35C220AE
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_1_seq_999.OMF.7230F14E
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_945.OMF.50F2835A
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_946.OMF.6CF6741C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_947.OMF.70DF62A5
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_948.OMF.6A1D6107
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_949.OMF.19107F3C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_950.OMF.45C7198C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_951.OMF.6F58CD76
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_952.OMF.22F79A64
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_953.OMF.53C12814
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_954.OMF.6EEE40A8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_955.OMF.4A4E922E
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_956.OMF.18DC22D8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_957.OMF.5E651145
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_958.OMF.71D73DB3
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_959.OMF.0E1BF44E
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_960.OMF.0A942A9C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_961.OMF.40009ECA
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_962.OMF.54910183
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_963.OMF.5E908416
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_964.OMF.673E3A09
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_965.OMF.0A29F681
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_966.OMF.78F31EB7
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_967.OMF.3BA2141C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_968.OMF.1F99AFD1
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_969.OMF.1D0E39B9
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_970.OMF.2FFFEFE0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_971.OMF.57968382
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_972.OMF.1FBB1F37
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_973.OMF.4E5F9197
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_974.OMF.7F745E8B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_975.OMF.0EBB15B5
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_976.OMF.20970248
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_977.OMF.56B5E839
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_09/thread_2_seq_978.OMF.24D39872
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1009.OMF.5DE4644A
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1010.OMF.2A757A91
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1011.OMF.075CE094
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1012.OMF.5F476C2F
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1013.OMF.28575BE9
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1014.OMF.3B9A64A8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1015.OMF.6C0D6C2B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1016.OMF.51F5839A
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1017.OMF.3CF636DB
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1018.OMF.47023432
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1019.OMF.7314C74A
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1020.OMF.22AB7FA3
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1021.OMF.66314943
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1022.OMF.67EC0396
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_1_seq_1023.OMF.31A665CC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_979.OMF.753788B8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_980.OMF.194EA848
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_981.OMF.419C119D
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_982.OMF.4ECC3187
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_983.OMF.4D80DFB2
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_984.OMF.278B8FA5
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_985.OMF.7830A180
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_986.OMF.1A5AA566
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_987.OMF.3D1EDBC0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_988.OMF.7B9BA4E2
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_989.OMF.3927F2EB
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_990.OMF.258ADE48
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_991.OMF.4512FD64
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_992.OMF.0A70FE1E
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ARCHIVELOG/2024_07_10/thread_2_seq_993.OMF.01D5ADB0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/CHANGETRACKING/ctf.OMF.5A97EE16
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/CONTROLFILE/Current.OMF.1EEB09FC
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/CONTROLFILE/snapcf_CDB23ai.f
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSAUX.OMF.664A5E60
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSTEM.OMF.4037C9A4
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS1.OMF.0F3E2866
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS2.OMF.59C33A6B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/USERS.OMF.326FA4F8
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_1.OMF.55DD946C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_2.OMF.10E0C003
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_3.OMF.7FAB3D7C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_4.OMF.469A9E5B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_5.OMF.7F3FB267
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/FLASHBACK/log_6.OMF.0671FD13
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_1.OMF.0D7A9596
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_2.OMF.4989B1BB
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_3.OMF.353F433A
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_4.OMF.518E17CA
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_5.OMF.55ED58F7
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_6.OMF.112BC50C
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_7.OMF.0D0C6A2F
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_8.OMF.57A73396
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/PARAMETERFILE/spfile.OMF.79F2EC13
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/PASSWORD/pwdCDB23AI_ASHBURN.1067BBD0
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/TEMPFILE/TEMP.OMF.2F25E22B
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/backup00.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/backup01.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/backup02.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/data.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/day.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/day_.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/vfile1
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/week.ocr
@eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/week_.ocr
● ACFS OSファイルシステム確認
[grid@exadb-xs1-55470 ~]$ df -hT | grep acfs
/dev/exc/vExdb78 acfs 200G 3.9G 197G 2% /var/opt/oracle/dbaas_acfs
■ ExaWatcher
ExaWatcherは、主にオペレーティング・システムおよびネットワーク・インタフェースに焦点を当てて、非常に詳細なシステム統計を収集します。
ExaWatcherは各サーバーで個別に実行され、オペレーティング・システム・ツールおよびユーティリティ(iostat、vmstat、mpstat、topなど)を使用してサーバーおよびネットワーク関連のデータを収集します。また、cellsrvstatを使用してストレージ・サーバー統計を収集します。
この情報は非常に詳細で、ほとんどのオペレーティング・システム統計が5秒間隔で収集されます。分析のためにExaWatcherから統計を抽出するには、GetExaWatcherResults.shスクリプトを使用できます。
・ OS統計情報出力
ノードで以下のように日付_時間を範囲指定して取得します
[root@exadb-xs1-55470 ~]# cd /opt/oracle.ExaWatcher
[root@exadb-xs1-55470 oracle.ExaWatcher]# date
Thu Jul 11 12:45:47 UTC 2024
[root@exadb-xs1-55470 oracle.ExaWatcher]# ./GetExaWatcherResults.sh --from 07/10/2024_14:00:00 --to 07/10/2024_15:00:00
[2024-07-11 12:46:25 +0000][INFO ][exawchart_io.py][_print_summary_chart][516] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_iosummary.html
[2024-07-11 12:46:25 +0000][INFO ][exawchart_io.py][_print_detail_charts][776] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_iodetail.html
[2024-07-11 12:46:25 +0000][INFO ][exawchart_io.py][_print_cpu_chart][259] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_cpu.html
[2024-07-11 12:46:25 +0000][INFO ][exawchart.py][main][408] iostat elapsed(s): 0
[2024-07-11 12:46:25 +0000][INFO ][exawchart_mp.py][print_charts][340] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_mp.html
[2024-07-11 12:46:25 +0000][INFO ][exawchart.py][main][417] mpstat elapsed(s): 0
[2024-07-11 12:46:25 +0000][INFO ][exawchart_mem.py][_print_meminfo_charts][877] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_meminfo.html
[2024-07-11 12:46:25 +0000][INFO ][exawchart.py][main][426] meminfo elapsed(s): 0
[2024-07-11 12:46:26 +0000][INFO ][exawchart_roce.py][_print_rocestat_chart][964] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_roce.html
[2024-07-11 12:46:26 +0000][INFO ][exawchart.py][main][435] rocestat elapsed(s): 0
[2024-07-11 12:46:26 +0000][INFO ][exawchart.py][main][463] Not collecting alert history
[2024-07-11 12:46:26 +0000][INFO ][exawchart.py][_process_summary_pages][172] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470.html
[2024-07-11 12:46:26 +0000][INFO ][exawchart.py][main][511] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/exadb-xs1-55470_menu.html
[2024-07-11 12:46:26 +0000][INFO ][exawchart.py][main][522] Generated file: /opt/oracle.ExaWatcher/archive/ExtractedResults/ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s/Charts.ExaWatcher.exadb-xs1-55470/2024_07_10_14_00_00_01h00m00s_0/index.html
[INFO ] Result files which are modified after 2024-07-10 14:00:00 and before 2024-07-10 15:00:00 are extracted in a zipped package in /opt/oracle.ExaWatcher/archive/ExtractedResults.
[root@exadb-xs1-55470 oracle.ExaWatcher]# cd archive/ExtractedResults/
[root@exadb-xs1-55470 ExtractedResults]# ls -l
total 2152
-rw-r----- 1 root root 2200525 Jul 11 12:46 ExaWatcher_exadb-xs1-55470_2024-07-10_14_00_00_1h00m00s.tar.bz2
■ EXAchk
Oracle ORAchkおよびOracle EXAchkには、ソフトウェアおよびハードウェア・コンポーネントのOracleスタック用の軽量かつ非割込み型の状態チェック・フレームワークが用意されています。
・ ビジネスが影響を受ける前のリスク識別および事前対応型の通知を自動化します。
・ 重大かつ再発する問題に基づいて状態チェックを実行します。
・ 問題を確認するための、システム状態のリスクと脆弱性に関する概要レベルのレポートを提示します。
・ 特定の問題にドリルダウンして解決を理解できるようにします。
・ 一定間隔での定期的な状態チェックのスケジュールを可能にします。
・ デーモン・モードでの実行中に電子メール通知および差分レポートを送信します。
・ 結果をOracle Health Check Collections Managerおよび選択したその他のツールに統合します。
・ オラクルに何も送信する必要なく、環境内で実行されます。
・ Version確認
[root@exadb-xs1-55470 ~]# exachk -v
EXACHK VERSION: 24.4.2_20240520
・ exachk設定確認
設定されているすべてのオプションを取得
[root@exadb-xs1-55470 ~]# exachk -get all
------------------------------------------------------------
Scheduled runs:
------------------------------------------------------------
ID: exachk.autostart_client_exatier1
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -profile exatier1 -dball -showpass -tag autostart_client_exatier1 -readenvconfig
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
COLLECTION_RETENTION = 7
------------------------------------------------------------
------------------------------------------------------------
ID: exachk.autostart_client
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -tag autostart_client -readenvconfig
AUTORUN_SCHEDULE = 3 3 * * 0
COLLECTION_RETENTION = 14
------------------------------------------------------------
・ exachk実行
オンデマンドでコンプライアンス・チェックの実行を開始
zipファイルが作成されるので、Downloadしてレポートを確認できます
[root@exadb-xs1-55470 ~]# exachk
Searching for running databases . . . . .
. .
List of running databases registered in OCR
1. CDB23ai_Ashburn
2. None of above
Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1]. 1
. . . .
. . .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . .
. . . . . . . . . . . . . . . . . . . . .
Either Cluster Verification Utility pack (cvupack) does not exist at /opt/oracle.ahf/common/cvu or it is an old or invalid cvupack
Checking Cluster Verification Utility (CVU) version at CRS Home - /u01/app/23.0.0.0/gridhome_1
Starting to run exachk in background on exadb-xs2-55471 using socket
. . . .
. .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS on exadb-xs1-55470
. . . . . .
. . . . . . . . . . . . .
UPLOAD [if required] - /u02/oracle.ahf/data/exadb-xs1-55470/exachk/user_root/output/exachk_exadb-xs1-55470_CDB23ai_Ashburn_071024_070142.zip
■ VMノード追加
Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS) は 小規模から大規模までスケーラブルな性能かつ柔軟な価格で提供可能とした新たなデータベースサービスです。ニーズの増大に応じて既存のVMクラスタに対して簡単に VM (Vehicle Machine) を追加または削除することができます。
■ 参考
・ Press Release
- Oracle Announces Exadata Exascale, World’s Only Intelligent Data Architecture for the Cloud
・ Documents
- Exadata Database Service on Exascale Infrastructure
- Provision Oracle Exadata Database Service on Exascale Infrastructure
- Oracle Exadata Database Service on Exascale Infrastructure
- Exadata Database Service on Exascale Infrastructure
- Oracle ORAchkおよびOracle EXAchkの概要
・ Blog
- Introducing Oracle Exadata Database Service on Exascale Infrastructure
- Exadata Exascale - World's Only Intelligent Data Architecture for Cloud
- Global Industry Analyst Perspectives on Oracle Exadata Exascale
- Exadata の2023年の振り返り
・ YouTube
- Oracle Exadata Exascale: The World’s Only Intelligent Data Architecture for Cloud
- Exadata Database Service on Exascale Infrastructure Provisioning
・ x.com
- Oracle Exadata (@OracleExadata)