検証用RAC環境（2node）

Oracle Database 19c
2node Rac
FlexASM
Single Tenant
#### crsctl stat res -t
```
[root@rac19c-node1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
ora.chad
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
ora.net1.network
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
ora.ons
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac19c-node2             STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             Started,STABLE
      2        ONLINE  ONLINE       rac19c-node2             Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.orcl.db
      1        ONLINE  ONLINE       rac19c-node1             Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /dbhome_1,STABLE
      2        ONLINE  ONLINE       rac19c-node2             Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.rac19c-node1.vip
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.rac19c-node2.vip
      1        ONLINE  ONLINE       rac19c-node2             STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac19c-node2             STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rac19c-node1             STABLE
--------------------------------------------------------------------------------
```
#### /etc/hosts (全ノード共通）
```
[root@rac19c-node1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

### Oracle Public IP
192.168.11.181 rac19c-node1.oracle.com rac19c-node1
192.168.11.182 rac19c-node2.oracle.com rac19c-node2
192.168.11.183 rac19c-node3.oracle.com rac19c-node3

### Oracle VIP
192.168.11.184 rac19c-node1-vip.oracle.com rac19c-node1-vip
192.168.11.185 rac19c-node2-vip.oracle.com rac19c-node2-vip
192.168.11.186 rac19c-node3-vip.oracle.com rac19c-node3-vip

### Oracle SCAN
192.168.11.187  rac19c-scan.oracle.com rac19c-scan
192.168.11.188  rac19c-scan.oracle.com rac19c-scan
192.168.11.189  rac19c-scan.oracle.com rac19c-scan

### Oracle Private IP(Interconnect)
192.168.0.11  rac19c-node1-priv1.oracle.com   rac19c-node1-priv1
192.168.0.12  rac19c-node2-priv1.oracle.com   rac19c-node2-priv1
192.168.0.13  rac19c-node3-priv1.oracle.com   rac19c-node3-priv1
```
#### srvctl config database -d 
```
[oracle@rac19c-node1 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.300.1070776865
Password file: +DATA/ORCL/PASSWORD/pwdorcl.284.1070770639
Domain: oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2
Configured nodes: rac19c-node1,rac19c-node2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
```
#### srvctl config service -d <DBNAME>
```
[root@rac19c-node1 ~]# srvctl config service -d orcl
サービス名: orcl_cdb
サーバー・プール:
カーディナリティ: 2
サービス・ロール: PRIMARY
管理ポリシー: AUTOMATIC
DTPトランザクション: false
AQのHA通知: false
グローバル: false
コミット結果: false
フェイルオーバー・タイプ:
フェイルオーバー・メソッド:
フェイルオーバー再試行:
フェイルオーバー遅延:
フェイルオーバー・リストア: NONE
接続ロード・バランシングの目標: LONG
ランタイム・ロード・バランシングの目標: NONE
TAFポリシー仕様: NONE
エディション:
プラガブル・データベース名:
ハブ・サービス:
最大タイム・ラグ: ANY
SQL翻訳プロファイル:
保存時間: 86400秒
リプレイ開始時間: 300秒
ドレイン・タイムアウト:
停止オプション:
セッション状態一貫性: DYNAMIC
GSMフラグ: 0
サービスは有効です
優先インスタンス: orcl1,orcl2
使用可能なインスタンス:
CSSクリティカル: no

サービス名: orcl_pdb
サーバー・プール:
カーディナリティ: 2
サービス・ロール: PRIMARY
管理ポリシー: MANUAL
DTPトランザクション: false
AQのHA通知: false
グローバル: false
コミット結果: false
フェイルオーバー・タイプ:
フェイルオーバー・メソッド:
フェイルオーバー再試行:
フェイルオーバー遅延:
フェイルオーバー・リストア: NONE
接続ロード・バランシングの目標: LONG
ランタイム・ロード・バランシングの目標: NONE
TAFポリシー仕様: NONE
エディション:
プラガブル・データベース名: pdb
ハブ・サービス:
最大タイム・ラグ: ANY
SQL翻訳プロファイル:
保存時間: 86400秒
リプレイ開始時間: 300秒
ドレイン・タイムアウト:
停止オプション:
セッション状態一貫性: DYNAMIC
GSMフラグ: 0
サービスは有効です
優先インスタンス: orcl1,orcl2
使用可能なインスタンス:
CSSクリティカル: no
```
#### srvctl config asm
```
oracle@rac19c-node1 ~]$ srvctl config asm
ASM home: <CRS home>
Password file: +CRS/orapwASM
Backup of Password file: +CRS/orapwASM_backup
ASM listener: LISTENER
ASM instance count: 3
Cluster ASM listener: ASMNET1LSNR_ASM
```
#### srvctl config scan
```
[root@rac19c-node1 ~]# srvctl config scan
SCAN name: rac19c-scan, Network: 1
Subnet IPv4: 192.168.11.0/255.255.255.0/ens192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.11.197
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.168.11.198
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.168.11.199
SCAN VIP is enabled.
```
#### srctl config vip -n 
```
[root@rac19c-node1 ~]# srvctl config vip -n rac19c-node1
VIP exists: network number 1, hosting node rac19c-node1
VIP Name: rac19c-node1-vip
VIP IPv4 Address: 192.168.11.195
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[root@rac19c-node1 ~]# srvctl config vip -n rac19c-node2
VIP exists: network number 1, hosting node rac19c-node2
VIP Name: rac19c-node2-vip
VIP IPv4 Address: 192.168.11.196
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
```
#### lsdg
```
ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304      2044     1680                0            1680              0             Y  CRS/
MOUNTED  EXTERN  N         512             512   4096  4194304     30716    19600                0           19600              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     20476    11092                0           11092              0             N  RECO/
```
#### show parameter（oracle）
```
SQL> show parameter

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
DBFIPS_140                           boolean                           FALSE
_ipddb_enable                        boolean                           TRUE
active_instance_count                integer
adg_account_info_tracking            string                            LOCAL
adg_redirect_dml                     boolean                           FALSE
allow_global_dblinks                 boolean                           FALSE
allow_group_access_to_sga            boolean                           FALSE
allow_rowid_column_type              boolean                           FALSE
approx_for_aggregation               boolean                           FALSE
approx_for_count_distinct            boolean                           FALSE
approx_for_percentile                string                            none
aq_tm_processes                      integer                           1
archive_lag_target                   integer                           0
asm_diskstring                       string
asm_preferred_read_failure_groups    string
audit_file_dest                      string                            /u01/app/oracle/admin/orcl/adu
                                                                       mp
audit_sys_operations                 boolean                           TRUE
audit_syslog_level                   string
audit_trail                          string                            DB
autotask_max_active_pdbs             integer                           2
awr_pdb_autoflush_enabled            boolean                           FALSE
awr_pdb_max_parallel_slaves          integer                           10
awr_snapshot_time_offset             integer                           0
background_core_dump                 string                            partial
background_dump_dest                 string                            /u01/app/oracle/product/19.0.0
                                                                       /dbhome_1/rdbms/log
backup_tape_io_slaves                boolean                           FALSE
bitmap_merge_area_size               integer                           1048576
blank_trimming                       boolean                           FALSE
buffer_pool_keep                     string
buffer_pool_recycle                  string
cdb_cluster                          boolean                           FALSE
cdb_cluster_name                     string
cell_offload_compaction              string                            ADAPTIVE
cell_offload_decryption              boolean                           TRUE
cell_offload_parameters              string
cell_offload_plan_display            string                            AUTO
cell_offload_processing              boolean                           TRUE
cell_offloadgroup_name               string
circuits                             integer
client_result_cache_lag              big integer                       3000
client_result_cache_size             big integer                       0
client_statistics_level              string                            TYPICAL
clonedb                              boolean                           FALSE
clonedb_dir                          string
cluster_database                     boolean                           TRUE
cluster_database_instances           integer                           2
cluster_interconnects                string
commit_logging                       string
commit_point_strength                integer                           1
commit_wait                          string
commit_write                         string
common_user_prefix                   string                            C##
compatible                           string                            19.0.0
connection_brokers                   string                            ((TYPE=DEDICATED)(BROKERS=1)),
                                                                        ((TYPE=EMON)(BROKERS=1))
containers_parallel_degree           integer                           65535
control_file_record_keep_time        integer                           7
control_files                        string                            +DATA/ORCL/CONTROLFILE/current
                                                                       .285.1070770659, +RECO/ORCL/CO
                                                                       NTROLFILE/current.262.10707706
                                                                       61
control_management_pack_access       string                            DIAGNOSTIC+TUNING
core_dump_dest                       string                            /u01/app/oracle/diag/rdbms/orc
                                                                       l/orcl1/cdump
cpu_count                            integer                           2
cpu_min_count                        string                            2
create_bitmap_area_size              integer                           8388608
create_stored_outlines               string
cursor_bind_capture_destination      string                            memory+disk
cursor_invalidation                  string                            IMMEDIATE
cursor_sharing                       string                            EXACT
cursor_space_for_time                boolean                           FALSE
data_guard_max_io_time               integer                           240
data_guard_max_longio_time           integer                           240
data_guard_sync_latency              integer                           0
data_transfer_cache_size             big integer                       0
db_16k_cache_size                    big integer                       0
db_2k_cache_size                     big integer                       0
db_32k_cache_size                    big integer                       0
db_4k_cache_size                     big integer                       0
db_8k_cache_size                     big integer                       0
db_big_table_cache_percent_target    string                            0
db_block_buffers                     integer                           0
db_block_checking                    string                            FALSE
db_block_checksum                    string                            TYPICAL
db_block_size                        integer                           8192
db_cache_advice                      string                            ON
db_cache_size                        big integer                       0
db_create_file_dest                  string                            +DATA
db_create_online_log_dest_1          string                            +DATA
db_create_online_log_dest_2          string                            +RECO
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
db_domain                            string                            oracle.com
db_file_multiblock_read_count        integer                           128
db_file_name_convert                 string
db_files                             integer                           200
db_flash_cache_file                  string
db_flash_cache_size                  big integer                       0
db_flashback_retention_target        integer                           1440
db_index_compression_inheritance     string                            NONE
db_keep_cache_size                   big integer                       0
db_lost_write_protect                string                            NONE
db_name                              string                            orcl
db_performance_profile               string
db_recovery_file_dest                string                            +RECO
db_recovery_file_dest_size           big integer                       20G
db_recycle_cache_size                big integer                       0
db_securefile                        string                            PREFERRED
db_ultra_safe                        string                            OFF
db_unique_name                       string                            orcl
db_unrecoverable_scn_tracking        boolean                           TRUE
db_writer_processes                  integer                           1
dbwr_io_slaves                       integer                           0
ddl_lock_timeout                     integer                           0
default_sharing                      string                            metadata
deferred_segment_creation            boolean                           TRUE
dg_broker_config_file1               string                            /u01/app/oracle/product/19.0.0
                                                                       /dbhome_1/dbs/dr1orcl.dat
dg_broker_config_file2               string                            /u01/app/oracle/product/19.0.0
                                                                       /dbhome_1/dbs/dr2orcl.dat
dg_broker_start                      boolean                           FALSE
diagnostic_dest                      string                            /u01/app/oracle
disable_pdb_feature                  big integer                       0
disk_asynch_io                       boolean                           TRUE
dispatchers                          string                            (PROTOCOL=TCP) (SERVICE=orclXD
                                                                       B)
distributed_lock_timeout             integer                           60
dml_locks                            integer                           2076
dnfs_batch_size                      integer                           4096
dst_upgrade_insert_conv              boolean                           TRUE
enable_automatic_maintenance_pdb     boolean                           TRUE
enable_ddl_logging                   boolean                           FALSE
enable_dnfs_dispatcher               boolean                           FALSE
enable_goldengate_replication        boolean                           FALSE
enable_imc_with_mira                 boolean                           FALSE
enable_pluggable_database            boolean                           TRUE
enabled_PDBs_on_standby              string                            *
encrypt_new_tablespaces              string                            CLOUD_ONLY
event                                string
external_keystore_credential_locatio string
n
fal_client                           string
fal_server                           string
fast_start_io_target                 integer                           0
fast_start_mttr_target               integer                           0
fast_start_parallel_rollback         string                            LOW
file_mapping                         boolean                           FALSE
fileio_network_adapters              string
filesystemio_options                 string                            none
fixed_date                           string
forward_listener                     string
gcs_server_processes                 integer                           1
global_names                         boolean                           FALSE
global_txn_processes                 integer                           1
hash_area_size                       integer                           131072
heat_map                             string                            OFF
hi_shared_memory_address             integer                           0
hs_autoregister                      boolean                           TRUE
http_proxy                           string
ifile                                file
inmemory_adg_enabled                 boolean                           TRUE
inmemory_automatic_level             string                            OFF
inmemory_clause_default              string
inmemory_expressions_usage           string                            ENABLE
inmemory_force                       string                            DEFAULT
inmemory_max_populate_servers        integer                           0
inmemory_optimized_arithmetic        string                            DISABLE
inmemory_prefer_xmem_memcompress     string
inmemory_prefer_xmem_priority        string
inmemory_query                       string                            ENABLE
inmemory_size                        big integer                       0
inmemory_trickle_repopulate_servers_ integer                           1
percent
inmemory_virtual_columns             string                            MANUAL
inmemory_xmem_size                   big integer                       0
instance_abort_delay_time            integer                           0
instance_groups                      string
instance_mode                        string                            READ-WRITE
instance_name                        string                            orcl1
instance_number                      integer                           1
instance_type                        string                            RDBMS
instant_restore                      boolean                           FALSE
java_jit_enabled                     boolean                           TRUE
java_max_sessionspace_size           integer                           0
java_pool_size                       big integer                       0
java_restrict                        string                            none
java_soft_sessionspace_limit         integer                           0
job_queue_processes                  integer                           40
large_pool_size                      big integer                       0
ldap_directory_access                string                            NONE
ldap_directory_sysauth               string                            no
license_max_sessions                 integer                           0
license_max_users                    integer                           0

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
license_sessions_warning             integer                           0
listener_networks                    string
lob_signature_enable                 boolean                           FALSE
local_listener                       string                             (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                                       192.168.11.195)(PORT=1521))
lock_name_space                      string
lock_sga                             boolean                           FALSE
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string
log_archive_dest_3                   string
log_archive_dest_30                  string
log_archive_dest_31                  string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string                            enable
log_archive_dest_state_10            string                            enable
log_archive_dest_state_11            string                            enable
log_archive_dest_state_12            string                            enable
log_archive_dest_state_13            string                            enable
log_archive_dest_state_14            string                            enable
log_archive_dest_state_15            string                            enable
log_archive_dest_state_16            string                            enable
log_archive_dest_state_17            string                            enable
log_archive_dest_state_18            string                            enable
log_archive_dest_state_19            string                            enable
log_archive_dest_state_2             string                            enable
log_archive_dest_state_20            string                            enable
log_archive_dest_state_21            string                            enable
log_archive_dest_state_22            string                            enable
log_archive_dest_state_23            string                            enable
log_archive_dest_state_24            string                            enable
log_archive_dest_state_25            string                            enable
log_archive_dest_state_26            string                            enable
log_archive_dest_state_27            string                            enable
log_archive_dest_state_28            string                            enable
log_archive_dest_state_29            string                            enable
log_archive_dest_state_3             string                            enable
log_archive_dest_state_30            string                            enable
log_archive_dest_state_31            string                            enable
log_archive_dest_state_4             string                            enable
log_archive_dest_state_5             string                            enable
log_archive_dest_state_6             string                            enable
log_archive_dest_state_7             string                            enable
log_archive_dest_state_8             string                            enable
log_archive_dest_state_9             string                            enable
log_archive_duplex_dest              string
log_archive_format                   string                            %t_%s_%r.dbf
log_archive_max_processes            integer                           4
log_archive_min_succeed_dest         integer                           1
log_archive_start                    boolean                           FALSE
log_archive_trace                    integer                           0
log_buffer                           big integer                       7136K
log_checkpoint_interval              integer                           0
log_checkpoint_timeout               integer                           1800
log_checkpoints_to_alert             boolean                           FALSE
log_file_name_convert                string
long_module_action                   boolean                           TRUE
max_datapump_jobs_per_pdb            string                            100
max_datapump_parallel_per_job        string                            50
max_dispatchers                      integer
max_dump_file_size                   string                            unlimited
max_idle_blocker_time                integer                           0
max_idle_time                        integer                           0
max_iops                             integer                           0
max_mbps                             integer                           0
max_pdbs                             integer                           254
max_shared_servers                   integer
max_string_size                      string                            STANDARD
memoptimize_pool_size                big integer                       0
memory_max_target                    big integer                       0
memory_target                        big integer                       0
multishard_query_data_consistency    string                            strong
multishard_query_partial_results     string                            not allowed
nls_calendar                         string                            GREGORIAN
nls_comp                             string                            BINARY
nls_currency                         string                            $
nls_date_format                      string                            DD-MON-RR
nls_date_language                    string                            AMERICAN
nls_dual_currency                    string                            $
nls_iso_currency                     string                            AMERICA
nls_language                         string                            AMERICAN
nls_length_semantics                 string                            BYTE
nls_nchar_conv_excp                  string                            FALSE
nls_numeric_characters               string                            .,
nls_sort                             string                            BINARY
nls_territory                        string                            AMERICA
nls_time_format                      string                            HH.MI.SSXFF AM
nls_time_tz_format                   string                            HH.MI.SSXFF AM TZR
nls_timestamp_format                 string                            DD-MON-RR HH.MI.SSXFF AM
nls_timestamp_tz_format              string                            DD-MON-RR HH.MI.SSXFF AM TZR
noncdb_compatible                    boolean                           FALSE
object_cache_max_size_percent        integer                           10
object_cache_optimal_size            integer                           10240000
ofs_threads                          integer                           4
olap_page_pool_size                  big integer                       0
one_step_plugin_for_pdb_with_tde     boolean                           FALSE
open_cursors                         integer                           300
open_links                           integer                           4
open_links_per_instance              integer                           4
optimizer_adaptive_plans             boolean                           TRUE
optimizer_adaptive_reporting_only    boolean                           FALSE
optimizer_adaptive_statistics        boolean                           FALSE
optimizer_capture_sql_plan_baselines boolean                           FALSE
optimizer_dynamic_sampling           integer                           2
optimizer_features_enable            string                            19.1.0
optimizer_ignore_hints               boolean                           FALSE
optimizer_ignore_parallel_hints      boolean                           FALSE
optimizer_index_caching              integer                           0
optimizer_index_cost_adj             integer                           100
optimizer_inmemory_aware             boolean                           TRUE
optimizer_mode                       string                            ALL_ROWS
optimizer_secure_view_merging        boolean                           TRUE
optimizer_use_invisible_indexes      boolean                           FALSE
optimizer_use_pending_statistics     boolean                           FALSE
optimizer_use_sql_plan_baselines     boolean                           TRUE
os_authent_prefix                    string                            ops$
os_roles                             boolean                           FALSE
outbound_dblink_protocols            string                            ALL
parallel_adaptive_multi_user         boolean                           FALSE
parallel_degree_limit                string                            CPU
parallel_degree_policy               string                            MANUAL
parallel_execution_message_size      integer                           16384
parallel_force_local                 boolean                           FALSE
parallel_instance_group              string
parallel_max_servers                 integer                           40
parallel_min_degree                  string                            1
parallel_min_percent                 integer                           0
parallel_min_servers                 integer                           4
parallel_min_time_threshold          string                            AUTO
parallel_servers_target              integer                           40
parallel_threads_per_cpu             integer                           1
pdb_file_name_convert                string
pdb_lockdown                         string
pdb_os_credential                    string
pdb_template                         string
permit_92_wrap_format                boolean                           TRUE
pga_aggregate_limit                  big integer                       2G
pga_aggregate_target                 big integer                       795M
plscope_settings                     string                            IDENTIFIERS:NONE
plsql_ccflags                        string
plsql_code_type                      string                            INTERPRETED
plsql_debug                          boolean                           FALSE
plsql_optimize_level                 integer                           2
plsql_v2_compatibility               boolean                           FALSE
plsql_warnings                       string                            DISABLE:ALL
pre_page_sga                         boolean                           TRUE
private_temp_table_prefix            string                            ORA$PTT_
processes                            integer                           300
processor_group_name                 string
query_rewrite_enabled                string                            TRUE
query_rewrite_integrity              string                            enforced
rdbms_server_dn                      string
read_only_open_delayed               boolean                           FALSE
recovery_parallelism                 integer                           0
recyclebin                           string                            on
redo_transport_user                  string
remote_dependencies_mode             string                            TIMESTAMP
remote_listener                      string                             rac19c-scan:1521
remote_login_passwordfile            string                            EXCLUSIVE
remote_os_authent                    boolean                           FALSE
remote_os_roles                      boolean                           FALSE
remote_recovery_file_dest            string
replication_dependency_tracking      boolean                           TRUE
resource_limit                       boolean                           TRUE
resource_manage_goldengate           boolean                           FALSE
resource_manager_cpu_allocation      integer                           2
resource_manager_plan                string                            DEFAULT_CDB_PLAN
result_cache_max_result              integer                           5
result_cache_max_size                big integer                       12M
result_cache_mode                    string                            MANUAL
result_cache_remote_expiration       integer                           0

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
resumable_timeout                    integer                           0
rollback_segments                    string
scheduler_follow_pdbtz               boolean                           FALSE
sec_case_sensitive_logon             boolean                           TRUE
sec_max_failed_login_attempts        integer                           3
sec_protocol_error_further_action    string                            (DROP,3)
sec_protocol_error_trace_action      string                            TRACE
sec_return_server_release_banner     boolean                           FALSE
serial_reuse                         string                            disable
service_names                        string                            orcl.oracle.com
session_cached_cursors               integer                           50
session_max_open_files               integer                           10
sessions                             integer                           472
sga_max_size                         big integer                       2400M
sga_min_size                         big integer                       0
sga_target                           big integer                       2400M
shadow_core_dump                     string                            partial
shared_memory_address                integer                           0
shared_pool_reserved_size            big integer                       36909875
shared_pool_size                     big integer                       0
shared_server_sessions               integer
shared_servers                       integer                           1
shrd_dupl_table_refresh_rate         integer                           60
skip_unusable_indexes                boolean                           TRUE
smtp_out_server                      string
sort_area_retained_size              integer                           0
sort_area_size                       integer                           65536
spatial_vector_acceleration          boolean                           FALSE
spfile                               string                            +DATA/ORCL/PARAMETERFILE/spfil
                                                                       e.300.1070776865
sql92_security                       boolean                           TRUE
sql_trace                            boolean                           FALSE
sqltune_category                     string                            DEFAULT
ssl_wallet                           string
standby_db_preserve_states           string                            NONE
standby_file_management              string                            MANUAL
standby_pdb_source_file_dblink       string
standby_pdb_source_file_directory    string
star_transformation_enabled          string                            FALSE
statistics_level                     string                            TYPICAL
streams_pool_size                    big integer                       0
tape_asynch_io                       boolean                           TRUE
target_pdbs                          integer                           4
tde_configuration                    string
temp_undo_enabled                    boolean                           FALSE
thread                               integer                           1
threaded_execution                   boolean                           FALSE
timed_os_statistics                  integer                           0
timed_statistics                     boolean                           TRUE
trace_enabled                        boolean                           TRUE
tracefile_identifier                 string
transactions                         integer                           519
transactions_per_rollback_segment    integer                           5
undo_management                      string                            AUTO
undo_retention                       integer                           900
undo_tablespace                      string                            UNDOTBS1
unified_audit_common_systemlog       string
unified_audit_sga_queue_size         integer                           1048576
unified_audit_systemlog              string
uniform_log_timestamp_format         boolean                           TRUE
use_dedicated_broker                 boolean                           FALSE
use_large_pages                      string                            TRUE
user_dump_dest                       string                            /u01/app/oracle/product/19.0.0
                                                                       /dbhome_1/rdbms/log
wallet_root                          string
workarea_size_policy                 string                            AUTO
xml_db_events                        string                            enable
```
#### show parameter（ASM）
```
SQL> show parameter

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
allow_group_access_to_sga            boolean                           FALSE
asm_diskgroups                       string                            DATA, RECO
asm_diskstring                       string                            /dev/oracleasm/disks/*
asm_power_limit                      integer                           1
asm_preferred_read_failure_groups    string
audit_file_dest                      string                            /u01/app/19.0.0/grid/rdbms/aud
                                                                       it
audit_sys_operations                 boolean                           TRUE
audit_syslog_level                   string
audit_trail                          string                            NONE
background_core_dump                 string                            partial
background_dump_dest                 string                            /u01/app/19.0.0/grid/rdbms/log
cdb_cluster                          boolean                           FALSE
cluster_database                     boolean                           TRUE
cluster_database_instances           integer                           2
cluster_interconnects                string
connection_brokers                   string                            ((TYPE=DEDICATED)(BROKERS=1)),
                                                                        ((TYPE=EMON)(BROKERS=1))
core_dump_dest                       string                            /u01/app/grid/diag/asm/+asm/+A
                                                                       SM1/cdump
cpu_count                            integer                           2
db_cache_size                        big integer                       0
db_ultra_safe                        string                            OFF
db_unique_name                       string                            +ASM
diagnostic_dest                      string                            /u01/app/grid
event                                string
file_mapping                         boolean                           FALSE
filesystemio_options                 string                            none
forward_listener                     string
ifile                                file
instance_abort_delay_time            integer                           0
instance_name                        string                            +ASM1
instance_number                      integer                           1
instance_type                        string                            ASM
large_pool_size                      big integer                       12M
ldap_directory_sysauth               string                            no
listener_networks                    string                            ((NAME=ora.ASMNET1LSNR_ASM.lsn
                                                                       r) (LOCAL_LISTENER="(DESCRIPTI
                                                                       ON=(ADDRESS=(PROTOCOL=TCP)(HOS
                                                                       T=192.168.0.11)(PORT=1525)))")
                                                                       ), ((NAME=ora.ASMNET1LSNR_ASM.
                                                                       lsnr)(REMOTE_LISTENER="(DESCRI
                                                                       PTION=(ADDRESS=(PROTOCOL=TCP)(
                                                                       HOST=192.168.0.12)(PORT=1525))
                                                                       )")), ((NAME=ora.ASMNET1LSNR_A
                                                                       SM.lsnr) (REMOTE_LISTENER="(DE
                                                                       SCRIPTION=(ADDRESS=(PROTOCOL=T
                                                                       CP)(HOST=192.168.0.11)(PORT=15
                                                                       25)))"))
local_listener                       string                             (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                                       192.168.11.195)(PORT=1521))
lock_name_space                      string
lock_sga                             boolean                           FALSE
max_dump_file_size                   string                            unlimited
memoptimize_pool_size                big integer                       0
memory_max_target                    big integer                       1076M
memory_target                        big integer                       1076M
nls_calendar                         string                            GREGORIAN
nls_comp                             string                            BINARY
nls_currency                         string                            $
nls_date_format                      string                            DD-MON-RR
nls_date_language                    string
nls_dual_currency                    string                            $
nls_iso_currency                     string                            AMERICA
nls_language                         string                            AMERICAN
nls_length_semantics                 string                            BYTE
nls_nchar_conv_excp                  string                            FALSE
nls_numeric_characters               string                            .,
nls_sort                             string                            BINARY
nls_territory                        string                            AMERICA
nls_time_format                      string                            HH.MI.SSXFF AM
nls_time_tz_format                   string                            HH.MI.SSXFF AM TZR
nls_timestamp_format                 string                            DD-MON-RR HH.MI.SSXFF AM
nls_timestamp_tz_format              string                            DD-MON-RR HH.MI.SSXFF AM TZR
os_authent_prefix                    string                            ops$
os_roles                             boolean                           FALSE
parallel_execution_message_size      integer                           16384
pga_aggregate_target                 big integer                       0
processes                            integer                           600
remote_listener                      string
remote_login_passwordfile            string                            EXCLUSIVE
remote_os_authent                    boolean                           FALSE
remote_os_roles                      boolean                           FALSE
service_names                        string                            +ASM
sessions                             integer                           922
sga_max_size                         big integer                       1088M
sga_target                           big integer                       0
shadow_core_dump                     string                            partial
shared_pool_reserved_size            big integer                       31037849
shared_pool_size                     big integer                       0
sort_area_size                       integer                           65536
spfile                               string                            +CRS/rac19c-cluster/ASMPARAMET
                                                                       ERFILE/registry.253.1070580631
sql_trace                            boolean                           FALSE
statistics_level                     string                            TYPICAL
tde_configuration                    string
timed_os_statistics                  integer                           0
timed_statistics                     boolean                           TRUE
trace_enabled                        boolean                           TRUE
tracefile_identifier                 string
unified_audit_sga_queue_size         integer                           1048576
uniform_log_timestamp_format         boolean                           TRUE
use_dedicated_broker                 boolean                           FALSE
use_large_pages                      string                            FALSE
user_dump_dest                       string                            /u01/app/19.0.0/grid/rdbms/log
workarea_size_policy                 string                            AUTO
```

#### lsnrctl status (node1)
```
[oracle@rac19c-node1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-JUL-2021 00:57:19

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                14-JUL-2021 23:16:19
Uptime                    0 days 1 hr. 41 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac19c-node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.191)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.195)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "c0bdc3ea4a123889e053bf0ba8c00688.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "c0bf543a98bd02e8e053c00ba8c03bd5.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "pdb.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
```
#### lsnrctl status (node2)
```
[oracle@rac19c-node1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-JUL-2021 01:00:44

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                14-JUL-2021 23:16:19
Uptime                    0 days 1 hr. 44 min. 25 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac19c-node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.191)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.195)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_CRS" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "c0bdc3ea4a123889e053bf0ba8c00688.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "c0bf543a98bd02e8e053c00ba8c03bd5.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "pdb.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
```