'오라클/오라클 클라우드' 카테고리의 글 목록 (2 Page)

2019. 12. 12. 12:10 오라클/오라클 클라우드

Oracle Cloud DBCS dbcli 명령어

[root@db1 ~]# dbcli -h

usage: dbcli [-h/--help]

<category> [-h/--help]

<operation> [-h/--help]

<command> [-h/--help]

<command> [<args>]

Commands list (use -h/--help option for help on any command):

agent:

ping-agent

agentConfigParameter:

list-agentConfigParameters

update-agentConfigParameters

autoLogCleanPolicy:

create-autoLogCleanPolicy

list-autoLogCleanPolicy

backup:

create-backup

getstatus-backup

schedule-backup

backupconfig:

create-backupconfig

delete-backupconfig

describe-backupconfig

list-backupconfigs

update-backupconfig

bmccredential:

create-bmccredential

delete-bmccredential

describe-bmccredential

list-bmccredentials

update-bmccredential

component:

describe-component

database:

describe-database

list-databases

modify-database

recover-database

update-database

upgrade-database

dataguardstatu:

describe-dataguardstatus

list-dataguardstatus

dbhome:

describe-dbhome

list-dbhomes

update-dbhome

dbstorage:

describe-dbstorage

list-dbstorages

dbsystem:

describe-dbsystem

dgconfig:

list-dgconfigs

dgstorage:

describe-dgstorage

list-dgstorages

diagnostic:

collect-diagnostics

featuretracking:

list-featuretracking

job:

describe-job

list-jobs

latestpatch:

describe-latestpatch

logCleanJob:

create-logCleanJob

describe-logCleanJob

list-logCleanJobs

logSpaceUsage:

list-logSpaceUsage

netsecurity:

describe-netsecurity

update-netsecurity

node:

list-nodes

objectstoreswift:

create-objectstoreswift

delete-objectstoreswift

describe-objectstoreswift

list-objectstoreswifts

update-objectstoreswift

pendingjob:

list-pendingjobs

rmanbackupreport:

create-rmanbackupreport

delete-rmanbackupreport

describe-rmanbackupreport

list-rmanbackupreports

schedule:

describe-schedule

list-schedules

update-schedule

scheduledExecution:

list-scheduledExecutions

server:

update-server

system:

describe-system

tdebackupreport:

list-tdebackupreports

tdekey:

update-tdekey

tdewallet:

recover-tdewallet

Operations list (use -h/--help option for help on any command):

collect:

collect-diagnostics

create:

create-autoLogCleanPolicy

create-backup

create-backupconfig

create-bmccredential

create-logCleanJob

create-objectstoreswift

create-rmanbackupreport

delete:

delete-backupconfig

delete-bmccredential

delete-objectstoreswift

delete-rmanbackupreport

describe:

describe-backupconfig

describe-bmccredential

describe-component

describe-database

describe-dataguardstatus

describe-dbhome

describe-dbstorage

describe-dbsystem

describe-dgstorage

describe-job

describe-latestpatch

describe-logCleanJob

describe-netsecurity

describe-objectstoreswift

describe-rmanbackupreport

describe-schedule

describe-system

getstatus:

getstatus-backup

list:

list-agentConfigParameters

list-autoLogCleanPolicy

list-backupconfigs

list-bmccredentials

list-databases

list-dataguardstatus

list-dbhomes

list-dbstorages

list-dgconfigs

list-dgstorages

list-featuretracking

list-jobs

list-logCleanJobs

list-logSpaceUsage

list-nodes

list-objectstoreswifts

list-pendingjobs

list-rmanbackupreports

list-scheduledExecutions

list-schedules

list-tdebackupreports

modify:

modify-database

ping:

ping-agent

recover:

recover-database

recover-tdewallet

schedule:

schedule-backup

update:

update-agentConfigParameters

update-backupconfig

update-bmccredential

update-database

update-dbhome

update-netsecurity

update-objectstoreswift

update-schedule

update-server

update-tdekey

upgrade:

upgrade-database

저작자표시 비영리 변경금지

Posted by pat98

2019. 12. 10. 17:18 오라클/오라클 클라우드

Oracle cloud DBCS timezone 변경

Oracle cloud DBCS에서 Timezone 변경

- DBCS 생성시 Timezone이 기본 UTC 로 한국시간보다 9시간 느리기 때문에 한국사용자의 편의에 맞게 바꿔 타임존을 바꿔 주도록 하자.

- Cloud 상의 DBCS 는 Single instance 이어도 grid 환경 내에 생성되므로 기존 on-premise 와 같이 RAC 환경처럼 timezone 관련한 화일을 수정해 주어야 함. (fast provisioning 이 아닌 grid infrsstructure 로 선택한 경우)

1. 우선 OS Timezone 먼저 변경 후 리부팅

-- linux 7 계열

timedatectl

timedatectl set-timezone Asia/Seoul

ll /etc/localtime

-- linux 6 계열

cp /etc/localtime /etc/localtime_bak

ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime

또는

vi /etc/sysconfig/clock

ZONE=""Asia/Seoul"

UTC=true

ARC=false

Note : /etc/sysconfig/clock 내의 Zone 필드는 /usr/share/zoneinfo 의 내용과 다를수 있음.

2. Grid 환경 Timezone 변경

Grid 환경의 경우 해당화일도 변경해 주어야 함.

1) crs 중지

2) OS 의 timezone 변경

3) $GRID_HOME/crs/install/s_crsconfig_<nodename>_env.txt 의 TZ 변경

TZ=Asia/Seoul

4) crs 재개

s_crsconfig_<nodename>_env.txt 화일은 /usr/share/zoneinfo 화일의 내용을 참조함.

저작자표시 비영리 변경금지

Posted by pat98

2019. 11. 26. 10:35 오라클/오라클 클라우드

Oracle Cloud 에서 Instance 관리 자동화

상단의 그림과 같이 일반적으로 클라우드에서 얘기하는 임계치를 주고 Autoscale 설정과는 다른 방향이지만

Python 스크립트와 Tag 를 이용하여 지정된 시간에 Instance 를 Up, down 하거나 CPU Core 를 up,down 하는 방법을

외국 블로거가 포스팅 해서 테스트 해 봤습니다.

내년 상반기 정도에 Oracle Cloud 에서 DBCS 도 온라인 Core 조정이 가능할것 같다는 얘기가 있으니 기대해 볼만 하겠습니다.

아직까진 기능적으로 구현되진 않아서 아래과 같은 방법으로 적용 가능합니다.

스크립트에서 구현된 세부설정 방법은 첨부화일을 보시면 됩니다.

Autoscaling 자동화.pptx

지정된 시간에 Instance Stop, Start /Scale up, down 구현가능하며 현재까지는 OCI bare Metal 및 Autonomous ADW/ATP 만 가능합니다.

원본의 출처는 아래와 같습니다.

https://www.oc-blog.com/oci-autoscale/

저작자표시 비영리 변경금지

Posted by pat98

2019. 10. 17. 13:25 오라클/오라클 클라우드

New Oracle Cloud Free Tier

오라클 클라우드의 새로운 정책인 Free Tier 내역입니다.

저작자표시 비영리 변경금지

Posted by pat98

2019. 10. 14. 10:48 오라클/오라클 클라우드

Cloudberry 를 이용한 오라클 Object Storage 이용방법

Cloudberry 를 이용한 오라클 Object Storage 이용방법이 있어서 정리해 보았습니다.

원본 출처는 아래와 같습니다.

https://waslleysouza.com.br/2019/01/using-cloudberry-to-access-oci-object-storage/

cloudberry를 이용한 Object Storage 사용법.pptx

저작자표시 비영리 변경금지

Posted by pat98

2019. 9. 2. 14:29 오라클/오라클 클라우드

Oracle ATP(Autonomous Transaction Processing) 18.0 파라미터 확인

Oracle Cloud의 ATP(Autonomous Transaction Processing)에서 거의 대부분의 parameter 를 바꾸는것이 허용되지 않고 있다.

아래의 parameter 값만 바꿀수 있음.

APPROX_FOR_AGGREGATION

APPROX_FOR_COUNT_DISTINCT

APPROX_FOR_PERCENTILE

AWR_PDB_AUTOFLUSH_ENABLED

FIXED_DATE

MAX_IDLE_TIME

NLS_CALENDAR

NLS_COMP

NLS_CURRENCY

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

NLS_LANGUAGE

NLS_LENGTH_SEMANTICS

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

NLS_SORT

NLS_TERRITORY

NLS_TIMESTAMP_FORMAT

NLS_TIMESTAMP_TZ_FORMAT

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES (Allowed only with ALTER SESSION)

OPTIMIZER_IGNORE_HINTS

OPTIMIZER_IGNORE_PARALLEL_HINTS

PLSCOPE_SETTINGS

PLSQL_CCFLAGS

PLSQL_DEBUG

PLSQL_OPTIMIZE_LEVEL

PLSQL_WARNINGS

STATISTICS_LEVEL (Allowed only with ALTER SESSION)

TIME_ZONE: (Allowed only with ALTER SESSION)

SQL> show parameter

NAME TYPE VALUE

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

DBFIPS_140 boolean FALSE

O7_DICTIONARY_ACCESSIBILITY boolean FALSE

active_instance_count integer

adg_account_info_tracking string LOCAL

allow_global_dblinks boolean FALSE

allow_group_access_to_sga boolean FALSE

approx_for_aggregation boolean FALSE

approx_for_count_distinct boolean FALSE

approx_for_percentile string none

aq_tm_processes integer 40

archive_lag_target integer 0

asm_diskstring string

asm_preferred_read_failure_groups string

audit_file_dest string /u02/app/oracle/admin/eon1pod/adump

audit_sys_operations boolean TRUE

audit_syslog_level string

audit_trail string DB

autotask_max_active_pdbs integer 10

awr_pdb_autoflush_enabled boolean TRUE

awr_pdb_max_parallel_slaves integer 10

awr_snapshot_time_offset integer 0

background_core_dump string partial

background_dump_dest string /u02/app/oracle/product/18.1.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

clonedb boolean FALSE

clonedb_dir string

cluster_database boolean TRUE

cluster_database_instances integer 8

cluster_interconnects string

commit_logging string

commit_point_strength integer 1

commit_wait string

commit_write string

common_user_prefix string

compatible string 18.0.0

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))

containers_parallel_degree integer 65535

control_file_record_keep_time integer 7

control_files string +DATA/EON1POD/CONTROLFILE/current.273.1006903229, +RECO/EON1POD/CONTROLFILE/current.256.1006903229

control_management_pack_access string DIAGNOSTIC+TUNING

core_dump_dest string /u02/app/oracle/diag/rdbms/eon1pod/eon1pod1/cdump

cpu_count integer 2

cpu_min integer 0

cpu_target integer 0

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_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 MEDIUM

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

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 25

db_flash_cache_file string

db_flash_cache_size big integer 0

db_flashback_retention_target integer 480

db_index_compression_inheritance string NONE

db_keep_cache_size big integer 0

db_lost_write_protect string TYPICAL

db_name string eon1pod

db_performance_profile string

db_recovery_file_dest string +RECO

db_recovery_file_dest_size big integer 133543968M

db_recycle_cache_size big integer 0

db_securefile string ALWAYS

db_ultra_safe string OFF

db_unique_name string eon1pod

db_unrecoverable_scn_tracking boolean TRUE

db_writer_processes integer 10

dbwr_io_slaves integer 0

ddl_lock_timeout integer 0

default_sharing string METADATA

deferred_segment_creation boolean TRUE

dg_broker_config_file1 string /u02/app/oracle/product/18.1.0.0/dbhome_1/dbs/dr1eon1pod.dat

dg_broker_config_file2 string /u02/app/oracle/product/18.1.0.0/dbhome_1/dbs/dr2eon1pod.dat

dg_broker_start boolean FALSE

diagnostic_dest string /u02/app/oracle

disable_pdb_feature big integer 0

disk_asynch_io boolean TRUE

dispatchers string (PROTOCOL=TCP) (SERVICE=eon1podXDB)

distributed_lock_timeout integer 360

dml_locks integer 66384

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 TRUE

enable_pluggable_database boolean TRUE

enabled_PDBs_on_standby string *

encrypt_new_tablespaces string CLOUD_ONLY

event string

exafusion_enabled integer 1

external_keystore_credential_location string +DATA/encrypt_wallet/tde_seps

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

gcs_server_processes integer 8

global_names boolean FALSE

global_txn_processes integer 2

hash_area_size integer 131072

heat_map string OFF

hi_shared_memory_address integer 0

hs_autoregister boolean TRUE

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_percent integer 1

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 eon1pod1

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 4000

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

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 184M

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 integer 100

max_dispatchers integer

max_dump_file_size string 1G

max_idle_blocker_time integer 5

max_idle_time integer 0

max_iops integer 0

max_mbps integer 0

max_pdbs integer 4098

max_shared_servers integer

max_string_size string EXTENDED

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

nls_comp string BINARY

nls_currency string

nls_date_format string RR/MM/DD HH24:MI:SS

nls_date_language string

nls_dual_currency string

nls_iso_currency string

nls_language string AMERICAN

nls_length_semantics string BYTE

nls_nchar_conv_excp string FALSE

nls_numeric_characters string

nls_sort string

nls_territory string AMERICA

nls_time_format string

nls_time_tz_format string

nls_timestamp_format string

nls_timestamp_tz_format string

noncdb_compatible boolean FALSE

object_cache_max_size_percent integer 10

object_cache_optimal_size integer 10240000

ofs_threads integer 40

olap_page_pool_size big integer 0

one_step_plugin_for_pdb_with_tde boolean FALSE

open_cursors integer 1000

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 18.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 32768

parallel_force_local boolean FALSE

parallel_instance_group string

parallel_max_servers integer 12

parallel_min_degree string 1

parallel_min_percent integer 0

parallel_min_servers integer 704

parallel_min_time_threshold string AUTO

parallel_servers_target integer 12

parallel_threads_per_cpu integer 1

pdb_file_name_convert string

pdb_lockdown string OLTP

pdb_os_credential string

pdb_template string

permit_92_wrap_format boolean TRUE

pga_aggregate_limit big integer 6000M

pga_aggregate_target big integer 3000M

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 10000

processor_group_name string

query_rewrite_enabled string TRUE

query_rewrite_integrity string TRUSTED

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_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 92

resource_manager_plan string FORCE:OLTP_PLAN

result_cache_max_result integer 5

result_cache_max_size big integer 10M

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 ALERT

sec_return_server_release_banner boolean FALSE

serial_reuse string disable

service_names string eon1pod

session_cached_cursors integer 50

session_max_open_files integer 10

sessions integer 100

sga_max_size big integer 301G

sga_min_size big integer 0

sga_target big integer 8000M

shadow_core_dump string partial

shared_memory_address integer 0

shared_pool_reserved_size big integer 2688M

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/EON1POD/PARAMETERFILE/spfile.303.1006903717

sql92_security boolean TRUE

sql_trace boolean FALSE

sqltune_category string DEFAULT

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 601

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 16596

transactions_per_rollback_segment integer 5

undo_management string AUTO

undo_retention integer 1800

undo_tablespace string UNDO_8

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 /u02/app/oracle/product/18.1.0.0/dbhome_1/rdbms/log

wallet_root string

workarea_size_policy string AUTO

xml_db_events string enable

저작자표시 비영리 변경금지

Posted by pat98

2019. 6. 19. 11:15 오라클/오라클 클라우드

Oracle Cloud 서울 리전 서비스 목록

오라클 홈페이지에 서울 Region 에서 가능한 서비스 리스트가 업데이트 되었습니다.

몇몇 아직 안되는 서비스도 있지만 웬만한 서비스는 다 제공을 하고 있네요.

https://www.oracle.com/cloud/data-regions.html#apac

Oracle Cloud Service Data Regions

Find your cloud service regional data center and country guidelines

www.oracle.com

저작자표시 비영리 변경금지

Posted by pat98

2019. 5. 21. 15:11 오라클/오라클 클라우드

Oracle Cloud DBCS listener port 확인

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
--------------------------------------------------------------------------------

저작자표시 비영리 변경금지

Posted by pat98

2019. 5. 15. 15:50 오라클/오라클 클라우드

Azure Datacenter liquid cooling

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

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

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

저작자표시 비영리 변경금지

Posted by pat98

2019. 5. 8. 10:39 오라클/오라클 클라우드

Oracle Cloud 도쿄 리전 오픈

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

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

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

Region Name	Region Location	Region Key	Availability Domain
ap-tokyo-1	Tokyo, Japan	NRT	1
ca-toronto-1	Toronto, Canada	YYZ	1
en-frankfurt-1	Frankfurt, Germany	FRA	3
uk-london-1	London, United Kingdom	LHR	3
us-ahburn-1	Ashburn, VA	IAD	3
us-phoenix-1	Phoenix, AZ	PHX	3

저작자표시 비영리 변경금지

Posted by pat98

pat98's always & forever

'오라클/오라클 클라우드'에 해당되는 글 26건

Oracle Cloud DBCS dbcli 명령어

Oracle cloud DBCS timezone 변경

Oracle Cloud 에서 Instance 관리 자동화

New Oracle Cloud Free Tier

Cloudberry 를 이용한 오라클 Object Storage 이용방법

Oracle ATP(Autonomous Transaction Processing) 18.0 파라미터 확인

Oracle Cloud 서울 리전 서비스 목록

Oracle Cloud DBCS listener port 확인

Azure Datacenter liquid cooling

Oracle Cloud 도쿄 리전 오픈

카테고리

태그목록

글 보관함

최근에 올라온 글

달력

링크

최근에 달린 댓글

티스토리툴바

« | » 2024.5
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31