[Oracle Cloud] Exadata Exascale がリリースされたので作成してみてみた

**[Exadata Exascale](https://www.oracle.com/news/announcement/oracle-announces-exadata-exascale-worlds-only-intelligent-data-architecture-for-the-cloud-2024-07-11/)** あらゆる規模のOracle Databaseワークロード（AIベクトル処理、分析、トランザクションなど）に卓越したパフォーマンスを提供するクラウド向けインテリジェント・データ・アーキテクチャであるExadata Exascaleの一般提供を発表しました。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/e0173aa2-8a9f-7180-7c13-23d4993474b1.png)
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の利点を活用できるようになります。」
<iframe width="560" height="315" src="https://www.youtube.com/embed/XtV4Dny7c7c?si=9KiPTnKYCAxdQuAw" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
Exascale Infrastructure 上の Exadata Database Service (ExaDB-XS) は、 Oracle Exadata の次世代アーキテクチャです。ストレージ効率を高め、データベースのプロビジョニングを簡素化し、Exadata スマート ソフトウェアの卓越したパフォーマンスと最新のクラウドのコストおよび弾力性のメリットを組み合わせます。

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/9d057e0a-6f53-8d9e-d8f2-a71c0d8b53b6.png)

[技術アーキテクチャ](https://blogs.oracle.com/exadata/post/exadata-exascale): データベース ファイルのストレージは、Oracle Exadata Exascale Storage Vault にあります。Storage Vault は、高パフォーマンスでスケーラブルな Exadata スマート ストレージを提供します。ストレージは、必要に応じて 1 つのコマンドでオンラインで拡張でき、そのストレージはすぐに使用できるようになります。専用インフラストラクチャとは異なり、Exascale Infrastructure 上の Exadata Database Service (ExaDB-XS) では、 システムへのストレージ・サーバーの追加やストレージ割り当ての管理を行う必要がありません。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c9b3d6f8-4a92-fe83-d5d0-142f4f7ce39b.png)
ストレージ プールは、複数のストレージ サーバー間でプール ディスクを集約し、ストレージ容量と I/O をシンプルかつ柔軟に割り当てる方法を実現します。Exascale は、新しい Exadata Database on Exascale Infrastructure Service (ExaDB-XS) のように、数千のストレージ・サーバーを組み込んで、真にクラウド規模のストレージ・リソースを作成できます。
ということで、ExaDB-XS を作成してみてみます。
# ■ 参考資料
　:white_check_mark: [Press Release](#-参考)
　:white_check_mark: [Documents](#-参考)
　:white_check_mark: [Blog](#-参考)
　:white_check_mark: [YouTube](#-参考)



# ■ Exascale Infrastructure 要件
次のドキュメントで開始するための基本的な概念を学習します。

https://docs.oracle.com/en-us/iaas/exadb-xs/doc/preparing-for-exadb-xs-deployment.html


# ■ Service Limit 確認
Exascale に必要な Service Limitを確認
![00_ServiceLimit01.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/be6927bf-dc6d-3a65-7b5b-5f58349bb9b0.jpeg)


# ■ Exascale Infrastructure 作成
## ● VM Cluster作成
**1) OCIコンソール画面**
[Oracle Database] > [Exadata Database Service on Exascale Infrastructure]をクリック
![01_ExaDB-XS作成01.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/79c200d2-3037-419e-91fc-96649f18ac33.png)


**2) VM Clusters画面**
VMクラスタを作成するリージョンおよびコンパートメントを選択し、[VM クラスタの作成]をクリック
![01_ExaDB-XS作成02.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c4ecb6ed-d0a3-7d37-498c-6f77bc0ba8eb.png)



**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
	- タグ: フリーフォーム・タグまたは定義済タグを適用
```
![01_ExaDB-XS作成03.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/53a2898f-96a4-dc49-382e-d182c721b730.png)
![01_ExaDB-XS作成04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/0697b59e-fd3a-2232-6473-d499248a2966.png)


**4) プロビジョニング・ステータス画面**
![01_ExaDB-XS作成05.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/5a6f7fe4-79e6-3d1f-ca79-cdf59ec5a70a.png)


**5) プロビジョニング中画面**
![01_ExaDB-XS作成06.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/41a4e3d1-1b64-f9d8-862c-5d008be8cae7.png)



**6) プロビジョニング完了画面**
![01_ExaDB-XS作成08.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/b1fd7aec-7f27-0083-c7a9-222d282bf555.png)

**・ログメッセージ画面**
![01_ExaDB-XS作成09.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/b796cd41-8773-214b-47cc-58a488037143.png)

## ● Container Database作成
**1) VMクラスタ詳細画面**
Resourcesから[コンテナ・データベース]をクリックし、[コンテナ・データベースの作成]をクリック
![03_ContainerDB作成01.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/af641394-44c5-39dd-84f7-c57170741d3f.png)

**2) コンテナ・データベースの作成画面**
次の項目を入力し、[コンテナ・データベースの作成]をクリック
```
・ 基本情報
	- データベース名:データベースの名前を入力
	- 一意名(オプション):データベースの一意名を入力
	- データベース・バージョン:使用可能なデータベース・バージョンを選択
	- PDB名(オプション):最初に作成するPDBの名前を入力

・ データベース・ホームの指定
	- データベース・ホーム・ソース: 「既存のデータベース・ホーム」または「新規データベース・ホームの作成」を使用する場合に選択
	- データベース・ホームの表示名: デフォルトのデータベース・ホーム名を使用するか、データベース・ホーム名を入力
	- データベース・イメージの変更(オプション): データベースに使用するOracle Databaseバージョンを設定。デフォルトでは、最新のOracle公開版データベース・ソフトウェア・イメージが選択されています。古いOracle公開イメージまたは事前に作成したカスタム・データベース・ソフトウェア・イメージを使用する場合に選択

・ 管理者資格証明を入力
	- パスワード: 9文字から30文字とし、大文字、小文字、特殊文字および数字をそれぞれ2つ以上含める必要があります。特殊文字は、\、_、#または-である必要があります。
	- パスワードの確認: 同じパスワードを入力

・ データベース・バックアップの構成
	デフォルト設定を受け入れると、データベースはOracle Database Autonomous Recovery Serviceを使用してバックアップされます。
	バックアップの保存先を変更してOCIオブジェクト・ストレージを使用するオプションがあります。
	[自動バックアップの有効化]の選択を解除した場合、データベースはバックアップされません。自動バックアップは、コンテナ・データベースの作成後に有効にできます。

・ 拡張オプション
	- Oracle SID接頭辞および文字セット(オプション): 「管理」タブで、「Oracle SID接頭辞」を追加し、「文字セット」および「各国語文字セット」を選択
	- キー管理の構成: 「暗号化」タブには、データベース・キーを管理するためのオプションがあります。「Oracle管理キーの使用」を選択してウォレットを使用してデータベース・キーを管理するか、「顧客管理キーの使用」を選択してOCIボールトを使用してデータベース・キーを管理します。
	- タグ: このリソースにフリーフォーム・タグまたは定義済タグを適用
```
![03_ContainerDB作成04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/ac1d5325-e7e4-cf63-e023-2394523b72fa.png)

**3) コンテナ・データベース作成中**
![03_ContainerDB作成05.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/14532c5c-54e5-c2ac-ceb3-2ca22224b9ff.png)


**3) コンテナ・データベース作成完了**
![03_ContainerDB作成07.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/93a85586-229e-73e1-f101-8fbe08b4b897.png)
**・ログ・メッセージ画面**
![03_ContainerDB作成08.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c7937730-1c56-805c-1d90-d19071a251ec.png)
**・メトリック画面**
![03_ContainerDB作成09.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/97e322fa-ae88-b3d4-16af-1321b14bd930.png)


## ● PDB画面
**・コンテナ・データベース画面**
Resourcesから[プラガブル・データベース]をクリック
![03_ContainerDB作成10.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/80760392-0975-1c98-b8df-9c64e951d87f.png)

**・プラガブル・データベース画面**
![03_ContainerDB作成11.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/4ebbf4c2-d846-dc48-2b23-b57e38cee52e.png)







# ■ 接続確認
**・ 仮想マシン 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クラスタ・スケーリング
Exascaleインフラストラクチャ上のOracle Exadata Database ServiceでVMクラスタで使用可能なECPU、メモリーまたはストレージを増減します

## ● ECPUスケーリング
VMごとに有効なECPUをスケーリングできます。メモリーは合計ECPU数でスケーリングされることに注意してください。 
今回 OCI CLI で ECPU スケーリングしてみてみます。
・参考: [OCI CLI Command Refaerence: exadb-vm-cluster](https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.51.8/oci_cli_docs/cmdref/db/exadb-vm-cluster.html)

```:構文
oci db exadb-vm-cluster update --enabled-e-cpu-count <有効なECPU数> --total-e-cpu-count <予約済みECPU含めた合計ECPU数> --exadb-vm-cluster-id <CM Cluster OCID>
```

```:引数
・enabled-e-cpu-count: VMクラスタ全体の有効な合計ECPU。最小は1VMあたり 8 ECPUです。選択する値は4の倍数にする必要があります。
・total-e-cpu-count: 予約済みECPU含めたVMクラスタ全体の合計ECPU数
```

:::note info
有効なECPUは、ゼロにスケーリングして、一時的にVMを停止し、使用量請求を停止できます。
合計ECPUの請求は続行されます。 
:::

OCI CLI は次を参考にインストールしときます。

https://qiita.com/shirok/items/e63be9a22158fef10ba9

**1) 現在のECPU数確認**
**・ CLIコマンド確認**
```
shirok@MacBook ~ % oci db exadb-vm-cluster get --exadb-vm-cluster-id ocid1.exadbvmcluster.oc1.iad.lowuetv902fviso8ielq --profile ASHBURN --query  'data.{"1.Name":"display-name","2.shape":"shape","3.enabled-e-cpu-count":"enabled-e-cpu-count","4.total-e-cpu-count":"total-e-cpu-count"}'

{
  "1.Name": "ExaDB-XS",
  "2.shape": "EXADBXS",
  "3.enabled-e-cpu-count": 16,
  "4.total-e-cpu-count": 16
}
```
**・ コンソール確認**
[VMリソースのスケーリング]をクリックして、'VMクラスタ全体の有効な合計ECPU' と 'VMクラスタ全体の合計ECPU' を確認できます。
![01_初期有効なECPU16個02-2.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/e5f507c3-d190-4d78-b224-46da45b85609.jpeg)


**2) ECPUスケール**
次の値へ変更してみてみます。
```:変更値
・VMクラスタ全体の有効な合計ECPU: 16
・VMクラスタ全体の合計ECPU; 24
・予約済ECPU:8 = total-e-cpu-count - enabled-e-cpu-countで計算できます
```
**・ CLIコマンド実行**
```
shirok@MacBook ~ % oci db exadb-vm-cluster update --enabled-e-cpu-count 16 --total-e-cpu-count 24 --exadb-vm-cluster-id ocid1.exadbvmcluster.oc1.iad.lowuetv902fviso8ielq --profile ASHBURN
```

**・ ECPU変更中〜**
![02_ECPU16-32へスケール01.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a1e016d1-6e54-45bf-82fb-351b697d799c.jpeg)


**3) ECPU数変更確認**
**・ CLIコマンド確認**
```
shirok@MacBook ~ % oci db exadb-vm-cluster get --exadb-vm-cluster-id ocid1.exadbvmcluster.oc1.iad.lowuetv902fviso8ielq --profile ASHBURN --query  'data.{"1.Name":"display-name","2.shape":"shape","3.enabled-e-cpu-count":"enabled-e-cpu-count","4.total-e-cpu-count":"total-e-cpu-count"}'

{
  "1.Name": "ExaDB-XS",
  "2.shape": "EXADBXS",
  "3.enabled-e-cpu-count": 16,
  "4.total-e-cpu-count": 24
}
```
**・ コンソール確認**
[VMリソースのスケーリング]をクリックして、'VMクラスタ全体の有効な合計ECPU' と 'VMクラスタ全体の合計ECPU' を確認できます。
![03_ECPU16-32へスケール完了02-2.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/2d05fb7a-fda5-47b0-98bd-e4569278d165.jpeg)



# ■ VMノード追加
Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS) は 小規模から大規模までスケーラブルな性能かつ柔軟な価格で提供可能とした新たなデータベースサービスです。ニーズの増大に応じて既存のVMクラスタに対して簡単に VM (Vehicle Machine) を追加または削除することができます。

https://qiita.com/shirok/items/c64c969c8cea3b3eaac4


# ■ データベースパスワードの変更
SYS,SYSTEM パスワードを変更もしくは、TDE ウォレット パスワードを変更します。
Exascale Infrastructure インスタンスまたはデータベースで新しいOracle Exadata Database Serviceを作成するときに「データベース管理者パスワード」フィールドに指定するパスワードは、SYS、SYSTEM、TDE ウォレット、および PDB 管理者資格証明のパスワードとして設定されます。
:::note info
注記：データベースに対して Data Guard を有効にする場合、プライマリ データベースとスタンバイ データベースの SYS パスワードと TDE ウォレット パスワードはすべて同じである必要があります。
:::
**1) Database 詳細画面**
Database 詳細画面にある [その他アクション] > [パスワードの管理]をクリック
![パスワード変更01.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/597f0d0a-a8ea-4abb-b61e-1bcd90648e85.jpeg)

**2) パスワードの管理画面**
**・ 管理パスワードの更新**
![パスワード変更02.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a9c90e54-47b6-4266-b9af-faa80be88ae6.jpeg)

**・TDEウォレットのパスワードの更新**
![パスワード変更03.jpg](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/d851c0bb-cd28-495a-8752-cc21c00a853d.jpeg)



# ■ 参考
**・ Press Release**
　- [Oracle Announces Exadata Exascale, World’s Only Intelligent Data Architecture for the Cloud](https://www.oracle.com/news/announcement/oracle-announces-exadata-exascale-worlds-only-intelligent-data-architecture-for-the-cloud-2024-07-11/)
**・ Documents**
　- [Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/engineered-systems/exadata-database-exascale/exdxs/)
　- [Provision Oracle Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/learn/exadb-xs-db/#introduction)
　- [Oracle Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en-us/iaas/exadb-xs/index.html)
　- [Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/engineered-systems/exadata-database-exascale/exdxs/overview-exadb-xs-service.html)
　- [Oracle ORAchkおよびOracle EXAchkの概要](https://docs.oracle.com/cd/F19136_01/atnms/introduction-orachk-and-exachk.html)
　- [Oracle Exadata Database Service on Exascale Infrastructureの概要 ](https://docs.oracle.com/ja-jp/iaas/exadb-xs/doc/overview-exadb-xs-service.html)
　- [OCI CLI Command Refaerence: exadb-vm-cluster](https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.51.8/oci_cli_docs/cmdref/db/exadb-vm-cluster.html)
**・ Blog**
　- [Introducing Oracle Exadata Database Service on Exascale Infrastructure](https://blogs.oracle.com/database/post/introducing-oracle-exadata-database-service-on-exascale-infrastructure)
　- [Exadata Exascale - World's Only Intelligent Data Architecture for Cloud](https://blogs.oracle.com/exadata/post/exadata-exascale)
　- [Global Industry Analyst Perspectives on Oracle Exadata Exascale ](https://blogs.oracle.com/infrastructure/post/global-industry-analyst-perspectives-on-oracle-exadata-exascale)
　- [Exadata の2023年の振り返り](https://blogs.oracle.com/oracle4engineer/post/exadata-2023-recap-jp)
**・ YouTube**
　- [Oracle Exadata Exascale: The World’s Only Intelligent Data Architecture for Cloud ](https://www.youtube.com/watch?v=XtV4Dny7c7c)
　- [Exadata Database Service on Exascale Infrastructure Provisioning](https://www.youtube.com/watch?v=ggh0pIuPj2g)
**・ x.com**
　- [Oracle Exadata (@OracleExadata)](https://x.com/oracleexadata)