LoginSignup
1
0

検証用RAC環境(3node)

Last updated at Posted at 2024-03-12

DB環境・構成

OS :Oracle Linux 7.9
DB :Oracle Database 19c
node:3node 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
               ONLINE  ONLINE       rac19c-node3             STABLE
ora.chad
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
               ONLINE  ONLINE       rac19c-node3             STABLE
ora.net1.network
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
               ONLINE  ONLINE       rac19c-node3             STABLE
ora.net3.network
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
               ONLINE  ONLINE       rac19c-node3             STABLE
ora.ons
               ONLINE  ONLINE       rac19c-node1             STABLE
               ONLINE  ONLINE       rac19c-node2             STABLE
               ONLINE  ONLINE       rac19c-node3             STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        ONLINE  ONLINE       rac19c-node3             STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        ONLINE  ONLINE       rac19c-node3             STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        ONLINE  ONLINE       rac19c-node3             STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac19c-node2             STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac19c-node3             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        ONLINE  ONLINE       rac19c-node3             STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             Started,STABLE
      2        ONLINE  ONLINE       rac19c-node2             Started,STABLE
      3        ONLINE  ONLINE       rac19c-node3             Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac19c-node1             STABLE
      2        ONLINE  ONLINE       rac19c-node2             STABLE
      3        ONLINE  ONLINE       rac19c-node3             STABLE
ora.cvu
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.orcl.aaa.svc
      2        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
      3        ONLINE  ONLINE       rac19c-node3             Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             /dbhome_1,STABLE
ora.orcl.orcl_cdb.svc
      1        ONLINE  ONLINE       rac19c-node1             STABLE
ora.orcl.orcl_pdb.svc
      2        ONLINE  ONLINE       rac19c-node1             STABLE
      3        ONLINE  ONLINE       rac19c-node3             STABLE
      4        ONLINE  ONLINE       rac19c-node2             STABLE
ora.orcl.test_pdb.svc
      2        ONLINE  ONLINE       rac19c-node1             STABLE
      3        ONLINE  ONLINE       rac19c-node2             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.rac19c-node3.vip
      1        ONLINE  ONLINE       rac19c-node3             STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac19c-node2             STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rac19c-node3             STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rac19c-node1             STABLE
--------------------------------------------------------------------------------

srvctl config database -d <db_name>

[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.ora
Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1102242983
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: aaa,orcl_cdb,orcl_pdb,test_pdb
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2,orcl3
Configured nodes: rac19c-node1,rac19c-node2,rac19c-node3
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 <db_name>

[oracle@rac19c-node1 ~]$ srvctl config service -d orcl
Service name: aaa
Server pool:
Cardinality: 1
Service role: PRIMARY
Management policy: MANUAL
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1
Available instances: orcl2,orcl3
CSS critical: no
Service uses Java: false

Service name: orcl_cdb
Server pool:
Cardinality: 1
Service role: PRIMARY
Management policy: MANUAL
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name:
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1
Available instances: orcl2,orcl3
CSS critical: no
Service uses Java: false

Service name: orcl_pdb
Server pool:
Cardinality: 3
Service role: PRIMARY
Management policy: MANUAL
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Failback :  true
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1,orcl2,orcl3
Available instances:
CSS critical: no
Service uses Java: false

Service name: test_pdb
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: MANUAL
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1,orcl2
Available instances: orcl3
CSS critical: no
Service uses Java: false

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

[oracle@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.187
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.168.11.188
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.168.11.189
SCAN VIP is enabled.

srvctl config vip -n <node_name>

[oracle@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.184
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[oracle@rac19c-node1 ~]$
[oracle@rac19c-node1 ~]$ srvctl config vip -n rac19c-node2
VIP exists: network number 1, hosting node rac19c-node2
VIP IPv4 Address: 192.168.11.185
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[oracle@rac19c-node1 ~]$
[oracle@rac19c-node1 ~]$ srvctl config vip -n rac19c-node3
VIP exists: network number 1, hosting node rac19c-node3
VIP IPv4 Address: 192.168.11.186
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

srvctl config all

[oracle@rac19c-node1 ~]$ srvctl config all

Oracle Clusterware configuration details
========================================

Oracle Clusterware basic information
------------------------------------
  Operating system        Linux
  Name                    rac19c-cluster
  Class                   STANDALONE
  Cluster nodes           rac19c-node3, rac19c-node2, rac19c-node1
  Version                 19.0.0.0.0
  Groups                  SYSOPER:asmoper SYSASM:asmadmin SYSRAC:asmadmin
                          SYSDBA:asmdba
  OCR locations           +CRS
  Voting disk             CRS
  locations
  Voting disk file        /dev/oracleasm/disks/CRS
  paths

Cluster network configuration details
-------------------------------------
  Interface name  Type  Subnet           Classification
  ens192          IPV4  192.168.11.0/24  PUBLIC
  ens224          IPV4  192.168.0.0/24   PRIVATE, ASM

SCAN configuration details
--------------------------

SCAN "rac19c-scan" details
++++++++++++++++++++++++++
  Name                rac19c-scan
  IPv4 subnet         192.168.11.0/24
  DHCP server type    static
  End points          TCP:1521

  SCAN listeners
  --------------
  Name              VIP address
  LISTENER_SCAN1    192.168.11.187
  LISTENER_SCAN2    192.168.11.188
  LISTENER_SCAN3    192.168.11.189


ASM configuration details
-------------------------
  Mode             unknown
  Password file    unknown
  SPFILE           unknown
The following errors occurred while retrieving the Oracle Clusterware
configuration details.

ASM configuration details
PRCT-1011 : Failed to run "asmcmd". Detailed error:
Connected to an idle instance.|ASMCMD-8102: no connection to Oracle ASM;
command requires Oracle ASM to run

Database configuration details
==============================

Database "ora.orcl.db" details
------------------------------
  Name             ora.orcl.db
  Type             RAC
  Version          19.0.0.0.0
  Role             PRIMARY
  Management       AUTOMATIC
  policy
  SPFILE           +data
  Password file    +DATA
  Groups           OSDBA:dba OSOPER:oper OSBACKUP:backupdba OSDG:dgdba OSKM:kmdba
                   OSRAC:racdba
  Oracle home      /u01/app/oracle/product/19.0.0/dbhome_1

lsdg

[grid@rac19c-node1 ~]$ 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     10236     9824                0            9824              0             Y  CRS/
MOUNTED  EXTERN  N         512             512   4096  4194304    102396    93776                0           93776              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     51196    27640                0           27640              0             N  RECO``````

show parameter (db)

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                           1
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                           1
control_files                        string                            +DATA/ORCL/CONTROLFILE/current
                                                                       .257.1102242999, +RECO/ORCL/CO
                                                                       NTROLFILE/current.256.11022430
                                                                       01
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                       19671M
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.184)(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
result_cache_max_result              integer                           5
result_cache_max_size                big integer                       12224K
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                       2384M
sga_min_size                         big integer                       0
sga_target                           big integer                       2384M
shadow_core_dump                     string                            partial
shared_memory_address                integer                           0
shared_pool_reserved_size            big integer                       32715571
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.ora
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                           1
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.11)(PORT=1525))
                                                                       )")), ((NAME=ora.ASMNET1LSNR_A
                                                                       SM.lsnr) (REMOTE_LISTENER="(DE
                                                                       SCRIPTION=(ADDRESS=(PROTOCOL=T
                                                                       CP)(HOST=192.168.0.12)(PORT=15
                                                                       25)))")), ((NAME=ora.ASMNET1LS
                                                                       NR_ASM.lsnr) (REMOTE_LISTENER=
                                                                       "(DESCRIPTION=(ADDRESS=(PROTOC
                                                                       OL=TCP)(HOST=192.168.0.13)(POR
                                                                       T=1525)))"))
local_listener                       string                             (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                                       192.168.11.184)(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                           840
remote_listener                      string
remote_login_passwordfile            string                            EXCLUSIVE
remote_os_authent                    boolean                           FALSE
remote_os_roles                      boolean                           FALSE
service_names                        string                            +ASM
sessions                             integer                           1282
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.1102238071
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(全ノード共通)

[oracle@rac19c-node1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-MAR-2024 20:32:34

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                05-MAR-2024 20:21:03
Uptime                    7 days 0 hr. 11 min. 30 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.181)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.11.184)(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 "aaa.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "dcd0acb55b6b6f3ee053b50ba8c0f458.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "dcd1758283791fcae053b50ba8c0a312.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 "orcl_cdb.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl_pdb.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...
Service "test_pdb.oracle.com" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

/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
1
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
0