pat98's always & forever

DBCS provisioning 후 listener port 확인

기본은 1521이며 다른 포트로 변경하는것은 권장하지 않고 있다.

[oracle@gtplus102 ~]$ ps -ef |grep tns
root        22     2  0 05:55 ?        00:00:00 [netns]
grid      9983     1  0 05:57 ?        00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid      9993     1  0 05:57 ?        00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle   47177 36087  0 06:07 pts/0    00:00:00 grep tns

SYS@GTPLUS 06:07:45> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
forward_listener                     string
listener_networks                    string      (( NAME=net1)(LOCAL_LISTENER=(
                                                 ADDRESS=(PROTOCOL=TCP)(HOST=10
                                                 .0.0.3)(PORT=1521))))
local_listener                       string      LISTENER_GTPLUS
remote_listener                      string

[oracle@gtplus102 ~]$ srvctl config listener -a
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: 
  /u01/app/18.0.0.0/grid on node(s) gtplus102
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes: 
Listener is individually disabled on nodes: 

[oracle@gtplus102 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
Registration invited nodes: 
Registration invited subnets: 
SCAN Listener is disabled.
SCAN Listener is individually enabled on nodes: 
SCAN Listener is individually disabled on nodes: 

[oracle@gtplus102 ~]$ srvctl config listener -l ASMNET1LSNR_ASM
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 192.168.16.0
Home: 
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes: 
Listener is individually disabled on nodes: 


[oracle@gtplus102 ~]$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 21-MAY-2019 06:09:08

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                21-MAY-2019 05:57:37
Uptime                    0 days 0 hr. 11 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/18.0.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/gtplus102/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.3)(PORT=1521)))
Services Summary...
Service "+APX" has 1 instance(s).
  Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" 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 "894ba6bc89eb7f72e0530300000ac70b.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "GTPLUSXDB.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 1 handler(s) for this service...
Service "GTPLUS_icn1t9.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "pdb1.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
  Instance "GTPLUS", status READY, has 2 handler(s) for this service...
The command completed successfully


[oracle@gtplus102 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       gtplus102                STABLE
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       gtplus102                STABLE
ora.DATA.dg
               ONLINE  ONLINE       gtplus102                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       gtplus102                STABLE
ora.RECO.dg
               ONLINE  ONLINE       gtplus102                STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       gtplus102                mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       gtplus102                STABLE
ora.ons
               ONLINE  ONLINE       gtplus102                STABLE
ora.proxy_advm
               ONLINE  ONLINE       gtplus102                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.asm
      1        ONLINE  ONLINE       gtplus102                Started,STABLE
ora.cvu
      1        ONLINE  ONLINE       gtplus102                STABLE
ora.gtplus102.vip
      1        ONLINE  ONLINE       gtplus102                STABLE
ora.gtplus_icn1t9.db
      1        ONLINE  ONLINE       gtplus102                Open,HOME=/u01/app/o
                                                             racle/product/18.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------

Azure Datacenter 에서 연구중인 프로젝트라고 하는데 우리가 아는 수냉시스템하고는 차원이 다른듯..

향후 몇년후 Azure Database센터내의 olympus 서버에 적용하기 위해 노력중이라고 한다.

공기보다 효율적이라고 한다. (보드에 물이 흐르고 있어..)

=====================================================

2019.5.7일 작성

패치작업 11.2.0.4.190416 (GI PSU 29255947)

Database Patch Set Update : 11.2.0.4.190416 (29141056)
OCW Patch Set Update      : 11.2.0.4.190416 (29141201)
ACFS PATCH SET UPDATE     : 11.2.0.4.190115 (28729245)


Oracle Grid Infrastructure Patch Set Update 11.2.0.4.190416 (Includes Database PSU 11.2.0.4.190416) 
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

(root 유저)
$GRID_HOME/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)

(grid 유저)

export GRID_HOME=/oragrid/product/11.2.0.4
cd 

$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/29141201
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/28729245
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local  ./29255947/29141056

(oracle 유저)

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
cd 

./29255947/23054319/custom/server/23054319/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/23054319/custom/server/23054319/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)


(root 유저)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)



### [롤백하는 경우] ###########
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.pl -unlock

(grid 유저로)

$GRID_HOME/OPatch/opatch rollback -local -id 29141201 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 28729245 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 29141056 -oh $GRID_HOME

(oracle 유저로)

cd 
./29255947/29141201/custom/server/29141201/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/29141201/custom/server/29141201/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)

Run post script
(root로)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch

====================================================================
2019.5월 7일 작성

패치작업 12.2.0.1.190416 (GI PSU 29301687 )


DB RU    : 12.2.0.1.190416 (29314339)
OCW RU   : 12.2.0.1.190416 (29314424)
ACFS RU  : 12.2.0.1.190416 (29301676)
DBWLM    : 12.2.0.1.170913 (26839277)
TOMCAT   : 12.2.0.1.0      (28566910)


Oracle Grid Infrastructure Patch Set Update 12.2.0.1.190416 (Includes Database PSU 12.2.0.1.190416) 
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29301676
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/28566910

- oracle 
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424

- oracle 
$/bin/srvctl stop home -o  -s  -n 

(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch 

$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling (롤링으로 하고자 할때)

(grid)
export OPATCH_DEBUG=true

export GRID_HOME=/u01/app/12.2.0.1/grid
cd /home/oracle


$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314424 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29301676 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/26839277 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314339 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/28566910 -silent  


(oracle)
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd 

./29301687/29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314424 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314339 -silent
./29301687/29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 


(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch 

$GRID_HOME/crs/install/rootcrs.sh -postpatch -nonrolling (롤링으로 하고자 할때)

(oracle)
$ /bin/srvctl start home -o  -s  -n 

- Loading Modified SQL Files into the Database

sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

-----------------------------

### [롤백하는 경우] ###########

(oracle)
$ /bin/srvctl stop home -o  -s  -n 

(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback

(grid)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/OPatch/opatch nrollback -local -id 29314424,29301676,29314339,26839277,28566910 -oh $GRID_HOME


(oracle)
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd 
./29301687 /29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 
$ORACLE_HOME/OPatch/opatch nrollback -local -id  29314424,29314339 -oh /oracle/product/12.2.0.1/dbhome_1
./29301687 /29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

Run post script
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch -rollback

(oracle)
$ /bin/srvctl start home -o  -s  -n 

sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

[oracle:/home/oracle]#ss
SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 10 15:19:33 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

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

SQL> select status from v$instance;

STATUS
------------------------
OPEN

SQL> show parameter

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
DBFIPS_140                             boolean                FALSE
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                 /oracle/app/admin/ORA19/adump
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                 /oracle/app/product/19.3.0/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                FALSE
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                7
control_files                          string                 /oradata/ORA19/control01.ctl,/oradata/ORA19/control02.ctl
control_management_pack_access         string                 DIAGNOSTIC+TUNING
core_dump_dest                         string                 /oracle/app/diag/rdbms/ora19/ORA19/cdump
cpu_count                              integer                1
cpu_min_count                          string                 1
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
db_create_online_log_dest_1            string
db_create_online_log_dest_2            string
db_create_online_log_dest_3            string
db_create_online_log_dest_4            string
db_create_online_log_dest_5            string
db_domain                              string
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                 ORA19
db_performance_profile                 string
db_recovery_file_dest                  string
db_recovery_file_dest_size             big integer            0
db_recycle_cache_size                  big integer            0
db_securefile                          string                 PREFERRED
db_ultra_safe                          string                 OFF
db_unique_name                         string                 ORA19
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                 /oracle/app/product/19.3.0/dbs/dr1ORA19.dat
dg_broker_config_file2                 string                 /oracle/app/product/19.3.0/dbs/dr2ORA19.dat
dg_broker_start                        boolean                FALSE
diagnostic_dest                        string                 /oracle/app
disable_pdb_feature                    big integer            0
disk_asynch_io                         boolean                TRUE
dispatchers                            string                 (PROTOCOL=TCP) (SERVICE=ORA19XDB)
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_location  string
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                0
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                 ORA19
instance_number                        integer                0
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                20
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
license_sessions_warning               integer                0
listener_networks                      string
lob_signature_enable                   boolean                FALSE
local_listener                         string                 LISTENER_ORA19
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                20
parallel_min_degree                    string                 1
parallel_min_percent                   integer                0
parallel_min_servers                   integer                2
parallel_min_time_threshold            string                 AUTO
parallel_servers_target                integer                20
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            788M
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
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                1
resource_manager_plan                  string
result_cache_max_result                integer                5
result_cache_max_size                  big integer            12128K
result_cache_mode                      string                 MANUAL
result_cache_remote_expiration         integer                0
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                 ORA19
session_cached_cursors                 integer                50
session_max_open_files                 integer                10
sessions                               integer                472
sga_max_size                           big integer            2368M
sga_min_size                           big integer            0
sga_target                             big integer            2368M
shadow_core_dump                       string                 partial
shared_memory_address                  integer                0
shared_pool_reserved_size              big integer            26004684
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                 /oracle/app/product/19.3.0/dbs/spfileORA19.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                0
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                 /oracle/app/product/19.3.0/rdbms/log
wallet_root                            string
workarea_size_policy                   string                 AUTO
xml_db_events                          string                 enable

2019/4/30일 부로 tokyo 리전이 오픈되었습니다. 리전 이름은 ap-tokyo-1 입니다.

향후 확장되기는 하겠지만 현재 AD는 1개이네요..

한국 리전도 빨리 오픈되기를 응원해 봅니다.

Exadata X8-2 가 나오면서 OECA 도 v.2.04 로 홈페이지에 업데이트 되었음.

https://www.oracle.com/technetwork/database/exadata/oeca-download-2817713.html

하지만 최신 버전은 이전 버전 X2, X3, X4 가 리스트에 없으므로 옛날 버전도 같이 올려 놓음.

최신거 v.204 : 

Excel 로 된 옛날꺼 v117.5 :

제품 Support 소식입니다.

Oracle 19c RAC 에는 더이상 SE2 를 지원하지 않는다고 합니다. 

오라클 메뉴얼과 오라클 RAC Product Manager 인 Markus Michalewicz 의 발표 자료에서 퍼 왔습니다.

앞으로 SE2 RAC 사용 고객들은

1. RAC -> Single 로 변경

2. Eneterprise 로 업그레이드

3. SE2 ->클라우드로 이전 

위의 3가지 사항들에 대해 고민거리가 생길 듯 합니다.

간만에 본 오라클 자격증 시험..

합격은 했지만

나이가 드니 잘 안 외워지는건 사실이네..

12.2 RMAN에서 백업시 Trace 화일이 많이 생기는 이슈관련 확인중.

12c DB RMAN Backup Generate Large Trace File even though PATCH 27674384 has been installed (문서 ID 2428828.1)

해결책 : 

SQL> Alter system set events 'trace[krb.*] disk disable, memory disable';

내용확인시 krb 라는 것이 있어서 추가확인..

Oracle library 중의 하나인듯..

SQL> ORADEBUG DOC COMPONENT KRB

  KRB                          Kernel Backup Restore (krb)
    KRB_THREAD                 KRBBPC Thread Switches ((null))
    KRB_IO                     KRB I/O ((null))
    KRB_INCR                   KRB Incremental Restore ((null))
    KRB_PERF                   KRB Performance Tracing ((null))
    KRB_BPOUTPUT               Detailed Backup Piece Output ((null))
    KRB_BPVAL                  Detailed Block List During Restore Validate ((null))
    KRB_FLWRES                 Details on Restore Flow ((null))
    KRB_FLWCPY                 Details on krbydd Flow ((null))
    KRB_FLWBCK                 Details on Backup Flow ((null))
    KRB_FLWUSAGE               RMAN Feature Usage ((null))
    KRB_OPTIM                  Unused Space Compression ((null))

ORADEBUG 에 대한 참고 URL

http://tech.e2sn.com/oracle/troubleshooting/oradebug-doc