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

2019. 4. 11. 11:06 오라클/오라클 클라우드

1Z0-932 시험

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

합격은 했지만

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

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

Posted by pat98

2019. 2. 28. 13:21 오라클/오라클 클라우드

Oracle Cloud Database toad 로 접속

Oracle Cloud 인 Oracle Cloud Infrastructure Database 서비스에서 toad 이용하여 접속하기.

우선 cloud 상에서 접속할 Database의 connection strings 를 확인해 놓는다.

DatabaseDB > Systems DB > System Details

1. 기본적으로 tnsnames.ora 화일의 SERVICE_NAME 부분만 정확하게 기술해 주면 된다.

나의 oracle client 가 깔린 PC에서 tnsnames.ora 화일 아래와 같이 지정

gtplus101_dbcs =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 132.xx.xx.xx)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DBCSTEST_iad1gw.sub02260904100.vcn0226090410.oraclevcn.com)

)

여기서 사용되는 Database 이름은 DBCSTEST_iad1gw 와 같이 unique name 이 사용된다.

gtplus101.sub02260904100.vcn0226090410.oraclevcn.com:1521/DBCSTEST_iad1gw.sub02260904100.vcn0226090410.oraclevcn.com

2. toad 에서 TNS 접속으로 해도 되지만 여기선 Direct로 해 보았다. 아래 설정으로 지정후 접속

3. Database가 12c 이고 내 pc의 client 가 10g 버전이기 때문에, 접속시 ORA-28040 에러가 날 것이다.

참고.) Single 인스턴스인 경우에도 기본적으로 Grid 가 12c 로 설치가 된다.

DBCS 에 ssh 로 접속해서

sudo su - oracle

cd /u01/app/oracle/product/11.2.0.4/dbhome_1

vi sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

4. 다시 접속하면 정상.

유저상태를 잠깐 살펴보면 sys,system 을 제외하고는 보안상 이유인듯 모두 lock 되어 있음을 확인할수 있다.

- User

USERNAME DEF_TBS TEMP_TBS PROFILE CREATED ACCOUNT_STATUS

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

ANONYMOUS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

APPQOSSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

AUDSYS USERS TEMP DEFAULT 2018.08.06 LOCKED

CTXSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

DBSFWUSER SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

DBSNMP SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

DIP USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

DVF SYSAUX TEMP DEFAULT 2018.08.06 LOCKED

DVSYS SYSAUX TEMP DEFAULT 2018.08.06 LOCKED

GGSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

GSMADMIN_INTERNAL SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

GSMCATUSER USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

GSMUSER USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

LBACSYS SYSTEM TEMP DEFAULT 2018.08.06 LOCKED

MDDATA USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

MDSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

OJVMSYS USERS TEMP DEFAULT 2018.08.06 LOCKED

OLAPSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

ORACLE_OCM USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

ORDDATA SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

ORDPLUGINS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

ORDSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

OUTLN SYSTEM TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

REMOTE_SCHEDULER_AGENT USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SI_INFORMTN_SCHEMA SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYS SYSTEM TEMP DEFAULT 2018.08.06 OPEN

SYS$UMF USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYSBACKUP USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYSDG USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYSKM USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYSRAC USERS TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

SYSTEM SYSTEM TEMP DEFAULT 2018.08.06 OPEN

WMSYS SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

XDB SYSAUX TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

XS$NULL SYSTEM TEMP DEFAULT 2018.08.06 EXPIRED & LOCKED

35 rows selected.

기본 Database 구성은 대략 아래와 같다.

- Tablespace

Tablespace Name EXT_MGT Total MBytes Used Mbytes Free Mbytes % Free % Used

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

SYSAUX LOCAL 640 609 31 4.84 95.16

SYSTEM LOCAL 860 853 7 .81 99.19

UNDOTBS1 LOCAL 75 28 47 62.67 37.33

USERS LOCAL 5 1 4 80.00 20.00

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

TOTAL 1,580 1,491 89

- Datafiles

TABLESPACE_NAME FILE_NAME TOT_KB FREE_KB USAGE_P

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

SYSAUX +DATA/DBCSTEST_IAD1GW/DATAFILE/sysaux.262.100 655,360 31,872 95.1

1239181

SYSTEM +DATA/DBCSTEST_IAD1GW/DATAFILE/system.261.100 880,640 7,296 99.2

1239145

UNDOTBS1 +DATA/DBCSTEST_IAD1GW/DATAFILE/undotbs1.263.1 76,800 47,872 37.7

001239197

USERS +DATA/DBCSTEST_IAD1GW/DATAFILE/users.274.1001 5,120 4,096 20.0

240047

- parameter

SQL> show parameter

NAME TYPE VALUE

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

DBFIPS_140 boolean FALSE

O7_DICTIONARY_ACCESSIBILITY boolean FALSE

_datafile_write_errors_crash_instanc boolean FALSE

e

_db_writer_coalesce_area_size big integer 16M

_disable_interface_checking boolean TRUE

_enable_NUMA_support boolean FALSE

_file_size_increase_increment big integer 2044M

_fix_control string 18960760:on

_gc_policy_time integer 20

_gc_undo_affinity boolean TRUE

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

archive_lag_target integer 0

asm_diskstring string

asm_preferred_read_failure_groups string

audit_file_dest string /u01/app/oracle/admin/DBCSTEST

_iad1gw/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 /u01/app/oracle/product/18.0.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 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 18.0.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 +RECO/DBCSTEST_IAD1GW/CONTROLF

ILE/current.256.1001239253

control_management_pack_access string DIAGNOSTIC+TUNING

core_dump_dest string /u01/app/oracle/diag/rdbms/dbc

stest_iad1gw/DBCSTEST/cdump

cpu_count integer 4

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 FULL

db_block_checksum string FULL

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

db_create_online_log_dest_2 string

db_create_online_log_dest_3 string

db_create_online_log_dest_4 string

NAME TYPE VALUE

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

db_create_online_log_dest_5 string

db_domain string sub02260904100.vcn0226090410.o

raclevcn.com

db_file_multiblock_read_count integer 128

db_file_name_convert string

db_files integer 1024

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 TYPICAL

db_name string DBCSTEST

db_performance_profile string

db_recovery_file_dest string +RECO

db_recovery_file_dest_size big integer 255G

db_recycle_cache_size big integer 0

db_securefile string PREFERRED

db_ultra_safe string OFF

db_unique_name string DBCSTEST_iad1gw

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

.0/dbhome_1/dbs/dr1DBCSTEST_ia

d1gw.dat

dg_broker_config_file2 string /u01/app/oracle/product/18.0.0

.0/dbhome_1/dbs/dr2DBCSTEST_ia

d1gw.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=DBCSTE

STXDB)

distributed_lock_timeout integer 60

dml_locks integer 2744

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_pluggable_database boolean TRUE

enabled_PDBs_on_standby string *

encrypt_new_tablespaces string CLOUD_ONLY

event string

exafusion_enabled integer 1

external_keystore_credential_locatio string

n

fal_client string

fal_server string

fast_start_io_target integer 0

fast_start_mttr_target integer 300

fast_start_parallel_rollback string LOW

file_mapping boolean FALSE

fileio_network_adapters string

filesystemio_options string setall

fixed_date string

forward_listener string

gcs_server_processes integer 0

global_names boolean TRUE

global_txn_processes integer 1

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

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

NAME TYPE VALUE

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

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

listener_networks string (( NAME=net1)(LOCAL_LISTENER=(

ADDRESS=(PROTOCOL=TCP)(HOST=10

.0.0.2)(PORT=1521))))

local_listener string LISTENER_DBCSTEST

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

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 unlimited

max_idle_time integer 0

max_iops integer 0

max_mbps integer 0

max_pdbs integer 4098

NAME TYPE VALUE

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

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

nls_comp string BINARY

nls_currency string

nls_date_format string

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 4

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 16384

parallel_force_local boolean FALSE

parallel_instance_group string

parallel_max_servers integer 160

parallel_min_degree string 1

parallel_min_percent integer 0

parallel_min_servers integer 16

parallel_min_time_threshold string AUTO

parallel_servers_target integer 160

parallel_threads_per_cpu integer 2

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

pga_aggregate_target big integer 7680M

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 400

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

NAME TYPE VALUE

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

resource_limit boolean TRUE

resource_manage_goldengate boolean FALSE

resource_manager_cpu_allocation integer 4

resource_manager_plan string

result_cache_max_result integer 5

result_cache_max_size big integer 78656K

result_cache_mode string MANUAL

result_cache_remote_expiration integer 0

resumable_timeout integer 0

rollback_segments string

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 DBCSTEST_iad1gw.sub02260904100

.vcn0226090410.oraclevcn.com

session_cached_cursors integer 100

session_max_open_files integer 10

sessions integer 624

sga_max_size big integer 15G

sga_min_size big integer 0

sga_target big integer 15G

shadow_core_dump string partial

shared_memory_address integer 0

shared_pool_reserved_size big integer 96M

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/DBCSTEST_IAD1GW/PARAMETE

RFILE/spfile.269.1001239605

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 30

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 686

transactions_per_rollback_segment integer 5

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBS1

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 only

user_dump_dest string /u01/app/oracle/product/18.0.0

.0/dbhome_1/rdbms/log

wallet_root string

workarea_size_policy string AUTO

xml_db_events string enable

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

Posted by pat98

2019. 2. 26. 17:38 오라클/오라클 클라우드

Oracle Cloud 에서 DB System 생성시 Shape 종류

Oracle cloud 에서 DB System 생성시 화면상에 상세한 설명이 나오지 않아서 정리해 보았다.

1. 지원하는 DB edition & Version

- 1 노드 시스템은 아래와 같은 edition 을 지원함.

Standard Edition
Enterprise Edition
Enterprise Edition - High Performance
Enterprise Edition - Extreme Performance

2 노드 RAC 시스템은 Oracle Enterprise Edition - Extreme Performance 을 선택하여야 구성가능함.

- 지원하는 DB 버전

Oracle Database 18c
Oracle Database 12c Release 2 (12.2)
Oracle Database 12c Release 1 (12.1)
Oracle Database 11g Release 2 (11.2)

2. Bare-Metal DB Systems

- 베어메탈은 아래와 같은 2가지 사양을 선택할수 있다.

- 스토리지 옵션은 아래과 같이 선택할 수 있다.

Normal 또는 High 선택에 따라 아래와 같이 구성할수 있다.

3. Virtual machine DB Systems

- 지원되는 Shape 종류

1) 시스템이 X7에서 기동되는 Shape 의 종류

2) 시스템이 X5에서 기동되는 Shape 의 종류

3) 스토리지 옵션

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

Posted by pat98

2019. 2. 22. 10:46 오라클/오라클 클라우드

클라우드 벤더별 Cloud Data Warehouse 서비스 비교 그림

각 벤더마다 제공하는 서비스이 이름이 각각 다른데 개념은 거의 비슷하다.

클라우드 벤더별 Cloud Data Warehouse 서비스 비교 그림

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

Posted by pat98

2019. 2. 12. 09:55 오라클/오라클 클라우드

Oracle ADW 생성후 Schema, Object 살짝 맛보기

Oracle ADW 생성시 default user list (sqldeveloper 로 접속하여 확인)

on-premise 와 달리 클라우드 용도의 유저가 몇개 보임

. 용도에 대해서는 차차 확인해 봐야 할듯.

Tablespace 리스트

DB명은 임의로 생성되는 듯. 샘플데이터가 200G (?)

샘플데이터의 내용은 아래과 같은 객체로 생성되어 있다.

Database 기본 속성

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

Posted by pat98

2019. 1. 23. 16:33 오라클/오라클 클라우드

oci cli 설치하기

window7 에서 oci cli 설치

보통 windows 10 에서는 별 문제없이 설치되는 모양이다.

아직 windows7를 사용하는 관계로 windows 7에서는 에러가 발생하여 아래와 같이 진행함.

1. python 설치안되어 있다면,우선 pc에 phthon 3.6 을 www.python.org 로 가서 download 받는다.

-> 원래 phthon 이 설치되어 있지 않으면 설치과정에서 최신버전을 알아서 설치한다고 하는데 실제 해보면 잘 안됨.

-> 굳이 최신버전인 3.7.2 을 설치할 필요없음.

-> 3.7.2 를 설치후 진행하면 cryptography 관련에러로 설치가 정상적으로 되지 않음.(아직 지원 안하는 듯)

초기 설치화면에서 PATH 추가 부분 체크해주고 NEXT, NEXT 로 설치완료

2. 설치과정 중 visual studio 관련 에러 날시에는... (잘되면 굳이 설치할 필요없다..설치했다가 용량이 커서 다시 지웠음.)

https://visualstudio.microsoft.com/ko 으로 가서

Visual Studio IDE 메뉴에서 community 버전 설치받아서 설치한다. 설치화일 조금 큼..완료되면..

3. cmd 창 실행한다.

아래와 같은 순서로 command 실행.

1. powershell

2. Set-ExecutionPolicy RemoteSigned

3. powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.ps1'))"

과정중 물어보면 그냥 ENTER, ENTER 진행.

완료됨.

참고 : linux 인 경우는

bash -c "$(curl -L https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.sh)"

오라클 사이트 메뉴얼 문서 :

https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliinstall.htm

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

정상설치시 아래와 같은 로그가 기록된다.

C:\Users\jongin>powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://raw.githubuserc

ontent.com/oracle/oci-cli/master/scripts/install/install.ps1'))"

-- Verifying Python version.

-- Python version 3.6.8 okay.

===> In what directory would you like to place the install? (leave blank to use 'C:\Users\jongin\lib\oracle-cli'):

-- Install directory 'C:\Users\jongin\lib\oracle-cli' is not empty and may contain a previous installation.

===> Remove this directory? (y/N): y

-- Deleted 'C:\Users\jongin\lib\oracle-cli'.

-- Creating directory 'C:\Users\jongin\lib\oracle-cli'.

-- We will install at 'C:\Users\jongin\lib\oracle-cli'.

===> In what directory would you like to place the 'oci.exe' executable? (leave blank to use 'C:\Users\jongin\bin'):

-- The executable will be in 'C:\Users\jongin\bin'.

===> In what directory would you like to place the OCI scripts? (leave blank to use 'C:\Users\jongin\bin\oci-cli-scripts'):

-- The scripts will be in 'C:\Users\jongin\bin\oci-cli-scripts'.

-- Downloading virtualenv package from https://github.com/pypa/virtualenv/archive/15.0.0.tar.gz.

-- Downloaded virtualenv package to C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\15.0.0.tar.gz.

-- Checksum of C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\15.0.0.tar.gz OK.

-- Extracting 'C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\15.0.0.tar.gz' to 'C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2'.

-- Copying DLLs into virtualenv.

-- Copying C:\Users\jongin\AppData\Local\Programs\Python\Python36\python3.dll to C:\Users\jongin\lib\oracle-cli\Scripts

-- Copying C:\Users\jongin\AppData\Local\Programs\Python\Python36\python36.dll to C:\Users\jongin\lib\oracle-cli\Scripts

-- Copying C:\Users\jongin\AppData\Local\Programs\Python\Python36\vcruntime140.dll to C:\Users\jongin\lib\oracle-cli\Scripts

-- Executing: ['C:\\Users\\jongin\\AppData\\Local\\Programs\\Python\\Python36\\python.exe', 'virtualenv.py', '--python', 'C:\\Users\\jongin\\AppData\\

Local\\Programs\\Python\\Python36\\python.exe', 'C:\\Users\\jongin\\lib\\oracle-cli']

Already using interpreter C:\Users\jongin\AppData\Local\Programs\Python\Python36\python.exe

Using base prefix 'C:\\Users\\jongin\\AppData\\Local\\Programs\\Python\\Python36'

New python executable in C:\Users\jongin\lib\oracle-cli\Scripts\python.exe

Installing setuptools, pip, wheel...done.

-- Executing: ['C:\\Users\\jongin\\lib\\oracle-cli\\Scripts\\pip', 'install', '--cache-dir', 'C:\\Users\\jongin\\AppData\\Local\\Temp\\tmpcdwmtrn2', '

oci_cli', '--upgrade']

Collecting oci_cli

Downloading https://files.pythonhosted.org/packages/17/2b/b8f6e1ff421c7dff30349483c665874b91700825dc14c3ccabeeed2b43fd/oci_cli-2.4.41-py2.py3-none-a

ny.whl (2.4MB)

100% |????????????????????????????????| 2.4MB 4.3MB/s

Collecting retrying==1.3.3 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/44/ef/beae4b4ef80902f22e3af073397f079c96969c69b2c7d52a57ea9ae61c9d/retrying-1.3.3.tar.gz

Collecting python-dateutil==2.7.3 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/cf/f5/af2b09c957ace60dcfac112b669c45c8c97e32f94aa8b56da4c6d1682825/python_dateutil-2.7.3-py2.py3

-none-any.whl (211kB)

100% |????????????????????????????????| 215kB 6.4MB/s

Collecting cryptography==2.1.4 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/83/5d/87826c818f2a00e1c36e2bb4680bac68198501ba88d6fe56650aac4b314c/cryptography-2.1.4-cp36-cp36m

-win_amd64.whl (1.3MB)

100% |????????????????????????????????| 1.3MB 4.1MB/s

Collecting six==1.11.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/67/4b/141a581104b1f6397bfa78ac9d43d8ad29a7ca43ea90a2d863fe3056e86a/six-1.11.0-py2.py3-none-any.w

hl

Collecting idna<2.7,>=2.5 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/27/cc/6dd9a3869f15c2edfab863b992838277279ce92663d334df9ecf5106f5c6/idna-2.6-py2.py3-none-any.whl

(56kB)

100% |????????????????????????????????| 61kB 3.8MB/s

Collecting pyOpenSSL==17.5.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/79/db/7c0cfe4aa8341a5fab4638952520d8db6ab85ff84505e12c00ea311c3516/pyOpenSSL-17.5.0-py2.py3-none

-any.whl (53kB)

100% |????????????????????????????????| 61kB 1.6MB/s

Collecting certifi (from oci_cli)

Downloading https://files.pythonhosted.org/packages/9f/e0/accfc1b56b57e9750eba272e24c4dddeac86852c2bebd1236674d7887e8a/certifi-2018.11.29-py2.py3-no

ne-any.whl (154kB)

100% |????????????????????????????????| 163kB 2.7MB/s

Collecting configparser==3.5.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/7c/69/c2ce7e91c89dc073eb1aa74c0621c3eefbffe8216b3f9af9d3885265c01c/configparser-3.5.0.tar.gz

Collecting arrow==0.10.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/54/db/76459c4dd3561bbe682619a5c576ff30c42e37c2e01900ed30a501957150/arrow-0.10.0.tar.gz (86kB)

100% |????????????????????????????????| 92kB 4.9MB/s

Collecting cx-Oracle==6.2.1 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/0a/1f/f741fa005aec72b8278975a7d47c2ba9f305b5202fec5d15406da82f5d65/cx_Oracle-6.2.1-cp36-cp36m-wi

n_amd64.whl (159kB)

100% |????????????????????????????????| 163kB 6.0MB/s

Collecting jmespath==0.9.3 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/b7/31/05c8d001f7f87f0f07289a5fc0fc3832e9a57f2dbd4d3b0fee70e0d51365/jmespath-0.9.3-py2.py3-none-a

ny.whl

Collecting terminaltables==3.1.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/9b/c4/4a21174f32f8a7e1104798c445dacdc1d4df86f2f26722767034e4de4bff/terminaltables-3.1.0.tar.gz

Collecting oci==2.1.4 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/4c/d6/93a8fc52e4d29488fbf8094fc4b3d7e5d390d4f15fdc1977c323aa3eefcb/oci-2.1.4-py2.py3-none-any.wh

l (1.5MB)

100% |????????????????????????????????| 1.5MB 4.1MB/s

Collecting click==6.7 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.wh

l (71kB)

100% |????????????????????????????????| 71kB 4.5MB/s

Collecting httpsig-cffi==15.0.0 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/93/f5/c9a213c0f906654c933f1192148d8aded2022678ad6bce8803d3300501c6/httpsig_cffi-15.0.0-py2.py3-n

one-any.whl

Collecting pytz==2016.10 (from oci_cli)

Downloading https://files.pythonhosted.org/packages/f5/fa/4a9aefc206aa49a4b5e0a72f013df1f471b4714cdbe6d78f0134feeeecdb/pytz-2016.10-py2.py3-none-any

.whl (483kB)

100% |????????????????????????????????| 491kB 4.7MB/s

Collecting asn1crypto>=0.21.0 (from cryptography==2.1.4->oci_cli)

Downloading https://files.pythonhosted.org/packages/ea/cd/35485615f45f30a510576f1a56d1e0a7ad7bd8ab5ed7cdc600ef7cd06222/asn1crypto-0.24.0-py2.py3-non

e-any.whl (101kB)

100% |????????????????????????????????| 102kB 5.1MB/s

Collecting cffi>=1.7; platform_python_implementation != "PyPy" (from cryptography==2.1.4->oci_cli)

Downloading https://files.pythonhosted.org/packages/2f/85/a9184548ad4261916d08a50d9e272bf6f93c54f3735878fbfc9335efd94b/cffi-1.11.5-cp36-cp36m-win_am

d64.whl (166kB)

100% |????????????????????????????????| 174kB 3.3MB/s

Collecting pycparser (from cffi>=1.7; platform_python_implementation != "PyPy"->cryptography==2.1.4->oci_cli)

Downloading https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz (158kB)

100% |????????????????????????????????| 163kB 6.4MB/s

Building wheels for collected packages: retrying, configparser, arrow, terminaltables, pycparser

Building wheel for retrying (setup.py) ... done

Stored in directory: C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\wheels\d7\a9\33\acc7b709e2a35caa7d4cae442f6fe6fbf2c43f80823d46460c

Building wheel for configparser (setup.py) ... done

Stored in directory: C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\wheels\a3\61\79\424ef897a2f3b14684a7de5d89e8600b460b89663e6ce9d17c

Building wheel for arrow (setup.py) ... done

Stored in directory: C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\wheels\ce\4f\95\64541c7466fd88ffe72fda5164f8323c91d695c9a77072c574

Building wheel for terminaltables (setup.py) ... done

Stored in directory: C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\wheels\30\6b\50\6c75775b681fb36cdfac7f19799888ef9d8813aff9e379663e

Building wheel for pycparser (setup.py) ... done

Stored in directory: C:\Users\jongin\AppData\Local\Temp\tmpcdwmtrn2\wheels\f2\9a\90\de94f8556265ddc9d9c8b271b0f63e57b26fb1d67a45564511

Successfully built retrying configparser arrow terminaltables pycparser

Installing collected packages: six, retrying, python-dateutil, idna, asn1crypto, pycparser, cffi, cryptography, pyOpenSSL, certifi, configparser, arro

w, cx-Oracle, jmespath, terminaltables, pytz, oci, click, httpsig-cffi, oci-cli

Successfully installed arrow-0.10.0 asn1crypto-0.24.0 certifi-2018.11.29 cffi-1.11.5 click-6.7 configparser-3.5.0 cryptography-2.1.4 cx-Oracle-6.2.1 h

ttpsig-cffi-15.0.0 idna-2.6 jmespath-0.9.3 oci-2.1.4 oci-cli-2.4.41 pyOpenSSL-17.5.0 pycparser-2.19 python-dateutil-2.7.3 pytz-2016.10 retrying-1.3.3

six-1.11.0 terminaltables-3.1.0

===> Modify PATH to include the CLI and enable tab completion in PowerShell now? (Y/n):

--

-- ** Close and re-open PowerShell to reload changes to your PATH **

-- In order to run the autocomplete script, you may also need to set your PowerShell execution policy to allow for running local scripts (as an Admini

strator run Set-ExecutionPolicy RemoteSigned in a PowerShell prompt)

--

-- Installation successful.

-- Run the CLI with C:\Users\jongin\bin\oci.exe --help

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

Posted by pat98

pat98's always & forever

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

1Z0-932 시험

Oracle Cloud Database toad 로 접속

Oracle Cloud 에서 DB System 생성시 Shape 종류

클라우드 벤더별 Cloud Data Warehouse 서비스 비교 그림

Oracle ADW 생성후 Schema, Object 살짝 맛보기

oci cli 설치하기

카테고리

태그목록

글 보관함

최근에 올라온 글

달력

링크

최근에 달린 댓글

티스토리툴바

« | » 2025.1
일	월	화	수	목	금	토
			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