'오라클' 카테고리의 글 목록 (22 Page)

2018. 10. 17. 16:28 오라클

패치작업 12.2.0.1.181016 (GI PSU 28714316 )

DB RU : 12.2.0.1.181016 (28662603)

OCW RU : 12.2.0.1.181016 (28662626)

ACFS RU : 12.2.0.1.181016 (28662640)

DBWLM : 12.2.0.1.170913 (26839277)

TOMCAT : 12.2.0.1.0 (28566910)

Oracle Grid Infrastructure Patch Set Update 12.2.0.1.181016 (Includes Database PSU 12.2.0.1.181016)

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662603

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662626

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662640

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/26839277

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28566910

- oracle

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662603

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28714316/28662626

- oracle

$<ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(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 ./28714316/28662626 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28662640 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/26839277 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28662603 -silent

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28714316/28566910 -silent

(oracle)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28714316/28662626/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28714316/28662626

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28714316/28662603

./28714316/28662626/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)

$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

- Loading Modified SQL Files into the Database

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

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

(oracle)

$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(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 28662626,28662640,28662603,26839277,28566910 -oh $GRID_HOME

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28714316 /28662626/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch nrollback -local -id 28662626,28662603 -oh /oracle/product/12.2.0.1/dbhome_1

./28714316 /28662626/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)

$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

Posted by pat98

2018. 8. 3. 14:24 오라클

12c MGMT 관련 자료

직접 작성한 자료 공유합니다.

12c MGMT DB 관련 PPT 자료

GIMR_가이드(MGMTDB)_v1.0.pdf

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

Posted by pat98

2018. 8. 3. 10:45 오라클

controlfile 크기 확인

Dictionary view 를 통해서 controlfile 의 크기를 확인.

sys@ORA12> select name, block_size, file_size_blks, (block_size*file_size_blks) + block_size as "SIZE" from v$controlfile;

NAME BLOCK_SIZE FILE_SIZE_BLKS SIZE

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

/oradata/ORA12/control01.ctl 16384 646 10600448

/oradata/ORA12/control02.ctl 16384 646 10600448

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

Posted by pat98

2018. 7. 25. 10:31 오라클

oracle 18.3 이 릴리즈 되었다.

오라클 18.3 버전이 Release 되었다.

이전까지는 Cloud 버전만 있었고 on-premise 버전으로는 처음 Release 된듯..현재는 Linux 버전만 있다.

18.1 을 이전 12.2.0.2 버전이라고 생각하면 되니까 해당버전의 PSU 버전이라고 생각하면 되겠다.

아래 그림을 보면 이해가 쉽게 갈 것이다.

1. 설치시 바뀐점은 Single 도 Oracle engine 설치시 이전 12c RAC 처럼 Image-base 방식으로 바뀌어 반드시 $ORACLE_HOME 내에 압축을 먼저 풀고 runInstaller 를 실행해야 한다.

2. 설치후 버전 확인

sys@ORA18> select * from v$version;

BANNER

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

BANNER_FULL

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

BANNER_LEGACY

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

CON_ID

----------

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

0

3. 패치확인

Updata 버전이여서 인지 설치시 별도 패치작업 없이 RU가 바로 적용된다.

[oracle:/home/oracle]#opatch lsinv

Oracle Interim Patch Installer version 12.2.0.1.14

Oracle Home : /oracle/product/18.3.0

Central Inventory : /oracle/oraInventory

from : /oracle/product/18.3.0/oraInst.loc

OPatch version : 12.2.0.1.14

OUI version : 12.2.0.4.0

Log file location : /oracle/product/18.3.0/cfgtoollogs/opatch/opatch2018-07-25_10-14-29AM_1.log

Lsinventory Output file location : /oracle/product/18.3.0/cfgtoollogs/opatch/lsinv/lsinventory2018-07-25_10-14-29AM.txt

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

Local Machine Information::

Hostname: 18c

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 18c 18.0.0.0.0

There are 1 products installed in this Oracle Home.

Interim patches (4) :

Patch 27908644 : applied on Thu Jul 19 02:44:11 KST 2018

Unique Patch ID: 22153180

Patch description: "UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171"

Created on 4 May 2018, 01:21:02 hrs PST8PDT

Bugs fixed:

27908644

Patch 27923415 : applied on Thu Jul 19 02:41:38 KST 2018

Unique Patch ID: 22239273

Patch description: "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"

Created on 15 Jul 2018, 10:33:22 hrs PST8PDT

Bugs fixed:

27304131, 27539876, 27952586, 27642235, 27636900, 27461740

Patch 28090553 : applied on Thu Jul 19 02:40:01 KST 2018

Unique Patch ID: 22256940

Patch description: "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"

Created on 11 Jul 2018, 19:20:31 hrs PST8PDT

Bugs fixed:

12816839, 18701017, 22734786, 23698980, 23840305, 25709124, 25724089

26299684, 26313403, 26433972, 26527054, 26586174, 26587652, 26647619

26827699, 26860285, 26882126, 26882316, 26943660, 26996813, 27012915

27018734, 27032726, 27034318, 27040560, 27080748, 27086406, 27092991

27098733, 27106915, 27114112, 27121566, 27133637, 27144533, 27153755

27166715, 27174938, 27174948, 27177551, 27177852, 27182006, 27182064

27184253, 27204476, 27212837, 27213140, 27220610, 27222423, 27222938

27238077, 27238258, 27249544, 27252023, 27257509, 27263677, 27265816

27267992, 27271876, 27274143, 27285557, 27299455, 27300007, 27302415

27309182, 27314512, 27315159, 27320985, 27334353, 27338838, 27346984

27358232, 27362190, 27370933, 27377219, 27378959, 27379846, 27379956

27393421, 27398223, 27399499, 27399762, 27399985, 27401618, 27403244

27404599, 27426277, 27428790, 27430219, 27430254, 27433163, 27452897

27458829, 27465480, 27475272, 27481406, 27481765, 27492916, 27496806

27503318, 27503413, 27508936, 27508984, 27513114, 27519708, 27526362

27528204, 27532009, 27534289, 27560562, 27560735, 27573154, 27573408

27574335, 27577122, 27579969, 27581484, 27593587, 27595801, 27600706

27609819, 27625010, 27625050, 27627992, 27654039, 27657467, 27657920

27668379, 27682288, 27691717, 27702244, 27703242, 27708711, 27714373

27725967, 27731346, 27734470, 27735534, 27739957, 27740854, 27747407

27748321, 27757979, 27766679, 27768034, 27778433, 27782464, 27783059

27786669, 27786699, 27801774, 27811439, 27839732, 27850736, 27862636

27864737, 27865439, 27889841, 27896388, 27897639, 27906509, 27931506

27935826, 27941514, 27957892, 27978668, 27984314, 27993298, 28023410

28025398, 28032758, 28039471, 28039953, 28045209, 28099592, 28109698

28174926, 28182503, 28204423, 28240153

Patch 28090523 : applied on Thu Jul 19 02:39:24 KST 2018

Unique Patch ID: 22329768

Patch description: "Database Release Update : 18.3.0.0.180717 (28090523)"

Created on 14 Jul 2018, 00:03:50 hrs PST8PDT

Bugs fixed:

9062315, 13554903, 21547051, 21766220, 21806121, 23003564, 23310101

24489904, 24689376, 24737581, 24925863, 25035594, 25035599, 25287072

25348956, 25634405, 25726981, 25743479, 25824236, 25943740, 26226953

26336101, 26423085, 26427905, 26450454, 26476244, 26598422, 26615291

26646549, 26654411, 26731697, 26785169, 26792891, 26818960, 26822620

26843558, 26843664, 26846077, 26894737, 26898279, 26928317, 26933599

26956033, 26961415, 26966120, 26986173, 26992964, 27005278, 27026401

27028251, 27030974, 27036408, 27038986, 27041253, 27044575, 27047831

27053044, 27058530, 27060167, 27060859, 27061736, 27066451, 27066519

27073066, 27086821, 27090765, 27101527, 27101652, 27110878, 27112686

27119621, 27126666, 27128580, 27135647, 27143756, 27143882, 27147979

27153641, 27155549, 27156355, 27163928, 27169796, 27181521, 27181537

27189611, 27190851, 27193810, 27199245, 27208953, 27210038, 27210872

27214085, 27215007, 27216224, 27221900, 27222121, 27222626, 27224987

27226913, 27232983, 27233563, 27236052, 27236110, 27240246, 27240570

27241221, 27241247, 27244337, 27244785, 27249215, 27250547, 27254851

27258578, 27259386, 27259983, 27262650, 27262945, 27263276, 27263996

27270197, 27274456, 27274536, 27275136, 27275776, 27282707, 27283029

27283960, 27284499, 27285244, 27288230, 27292213, 27294480, 27301308

27301568, 27302594, 27302681, 27302695, 27302711, 27302730, 27302777

27302800, 27302960, 27304410, 27304936, 27305318, 27307868, 27310092

27313687, 27314206, 27314390, 27318869, 27321179, 27321834, 27326204

27329812, 27330158, 27330161, 27333658, 27333664, 27333693, 27334316

27334648, 27335682, 27338912, 27338946, 27339115, 27339396, 27339483

27339495, 27341036, 27345190, 27345231, 27345450, 27345498, 27346329

27346644, 27346709, 27346949, 27347126, 27348081, 27348707, 27349393

27352600, 27354783, 27356373, 27357773, 27358241, 27359178, 27359368

27360126, 27364891, 27364916, 27364947, 27365139, 27365702, 27365993

27367194, 27368850, 27372756, 27375260, 27375542, 27376871, 27378103

27379233, 27381383, 27381656, 27384222, 27389352, 27392187, 27395404

27395416, 27395794, 27396357, 27396365, 27396377, 27396624, 27396666

27396672, 27396813, 27398080, 27398660, 27401637, 27405242, 27405696

27410300, 27410595, 27412805, 27417186, 27420715, 27421101, 27422874

27423251, 27425507, 27425622, 27426363, 27427805, 27430802, 27432338

27432355, 27433870, 27434050, 27434193, 27434486, 27434974, 27435537

27439835, 27441326, 27442041, 27444727, 27445330, 27445462, 27447452

27447687, 27448162, 27450355, 27450400, 27450783, 27451049, 27451182

27451187, 27451531, 27452760, 27453225, 27457666, 27457891, 27458164

27459909, 27460675, 27467543, 27469329, 27471876, 27472969, 27473800

27479358, 27483974, 27484556, 27486253, 27487795, 27489719, 27496224

27496308, 27497950, 27498477, 27501327, 27501413, 27501465, 27502420

27504190, 27505603, 27506774, 27508985, 27511196, 27512439, 27517818

27518227, 27518310, 27520070, 27520900, 27522245, 27523368, 27523800

27525909, 27532375, 27533819, 27534509, 27537472, 27544030, 27545630

27547732, 27550341, 27551855, 27558557, 27558559, 27558861, 27560702

27563629, 27563767, 27570318, 27577758, 27579353, 27580996, 27585755

27585800, 27586810, 27586895, 27587672, 27591842, 27592466, 27593389

27595973, 27599689, 27602091, 27602488, 27603841, 27604293, 27607805

27608669, 27610269, 27613080, 27613247, 27615608, 27616657, 27617522

27625274, 27625620, 27631506, 27634676, 27635508, 27644757, 27649707

27652302, 27663370, 27664702, 27679488, 27679664, 27679806, 27679961

27680162, 27680509, 27682151, 27688099, 27688692, 27690578, 27691809

27692215, 27693713, 27697092, 27701795, 27705761, 27707544, 27709046

27718914, 27719187, 27723002, 27726269, 27726780, 27732323, 27739006

27740844, 27744211, 27745220, 27747869, 27748954, 27751006, 27753336

27757567, 27772815, 27773602, 27774320, 27774539, 27779886, 27780562

27782339, 27783289, 27786772, 27791223, 27797290, 27803665, 27807441

27812560, 27812593, 27813267, 27815347, 27818871, 27832643, 27833369

27834984, 27840386, 27847259, 27851757, 27861909, 27869339, 27873643

27882176, 27892488, 27924147, 27926113, 27930478, 27934468, 27941896

27945870, 27950708, 27952762, 27961746, 27964051, 27970265, 27971575

27984028, 27989849, 27993289, 27994333, 27997875, 27999597, 28021205

28022847, 28033429, 28057267, 28059199, 28072130, 28098865, 28106402

28132287, 28169711, 28174827, 28184554, 28188330, 25929650, 28264172

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

3. Parameter 들도 추가 수정된게 보인다. (optimizer_ignore_hints 가 정식 파라미터가 되었다)

설치과정은 Simple 하다.

일단 oracle.com 에서 LINUX.X64_180000_db_home.zip 화일 다운로드

압축풀고 runInstaller 실행하면..

root.sh 실행후 되었으면...

dbca 실행

초기 설치 후 Default parameter 값 확인

sys@ORA18> 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 1

archive_lag_target integer 0

asm_diskstring string

asm_preferred_read_failure_groups string

audit_file_dest string /oracle/admin/ORA18/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/product/18.3.0/rdbms/l

og

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

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 /oracle/oradata/ORA18/control0

1.ctl, /oracle/oradata/ORA18/c

ontrol02.ctl

control_management_pack_access string DIAGNOSTIC+TUNING

core_dump_dest string /oracle/diag/rdbms/ora18/ORA18

/cdump

cpu_count integer 3

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

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 ORA18

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/product/18.3.0/dbs/dr1

ORA18.dat

dg_broker_config_file2 string /oracle/product/18.3.0/dbs/dr2

ORA18.dat

dg_broker_start boolean FALSE

diagnostic_dest string /oracle

disable_pdb_feature big integer 0

disk_asynch_io boolean TRUE

dispatchers string (PROTOCOL=TCP) (SERVICE=ORA18X

DB)

distributed_lock_timeout integer 60

dml_locks integer 2084

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 FALSE

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

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 ORA18

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

local_listener string LISTENER_ORA18

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

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 254

max_shared_servers integer

max_string_size string STANDARD

memoptimize_pool_size big integer 0

memory_max_target big integer 1536M

memory_target big integer 1536M

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

parallel_min_degree string 1

parallel_min_percent integer 0

parallel_min_servers integer 6

parallel_min_time_threshold string AUTO

parallel_servers_target integer 24

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 0

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 3

resource_manager_plan string

result_cache_max_result integer 5

result_cache_max_size big integer 3936K

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 ORA18

session_cached_cursors integer 50

session_max_open_files integer 10

sessions integer 474

sga_max_size big integer 1536M

sga_min_size big integer 0

sga_target big integer 0

shadow_core_dump string partial

shared_memory_address integer 0

shared_pool_reserved_size big integer 10905190

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/product/18.3.0/dbs/spf

ileORA18.ora

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 0

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 521

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 TRUE

user_dump_dest string /oracle/product/18.3.0/rdbms/l

og

wallet_root string

workarea_size_policy string AUTO

xml_db_events string enable

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

Posted by pat98

2018. 7. 19. 17:39 오라클

패치작업 12.2.0.1.180717 (GI PSU 28183653)

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

패치작업 12.2.0.1.180717 (GI PSU 28183653)

DB RU : 12.2.0.1.180717 (28163133)

OCW RU : 12.2.0.1.180717 (28163190)

ACFS RU : 12.2.0.1.180717 (28163235)

DBWLM : 12.2.0.1.170913 (26839277)

TOMCAT : 12.2.0.1.170723 (27144050)

Oracle Grid Infrastructure Patch Set Update 12.2.0.1.180417 (Includes Database PSU 12.2.0.1.180417)

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163133

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163190

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163235

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/26839277

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/27144050

- oracle

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163133

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/28183653/28163190

- oracle

$<ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(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 GRID_HOME=/u01/app/12.2.0.1/grid

cd /u01/install

export OPATCH_DEBUG=true

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163190

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163235

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/26839277

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/28163133

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./28183653/27144050

(oracle)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28183653/28163190/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28183653/28163190

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./28183653/28163133 (오래걸림)

./28183653/28163190/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)

$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

- Loading Modified SQL Files into the Database

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

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

(oracle)

$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>

(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 28163190,28163235,28163133,26839277,27144050 -oh $GRID_HOME

(oracle)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./28183653/28163190/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch nrollback -local -id 28163190,28163133 -oh /oracle/product/12.2.0.1

./28183653/28163190/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)

$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

Posted by pat98

2018. 7. 6. 14:26 오라클

rman set newnname 생성 PL/SQL

- rman set newnname 생성 PL/SQL

set serveroutput on;

declare

cursor df is select file#, name from v$datafile;

begin

dbms_output.put_line('run');

dbms_output.put_line('{');

for dfrec in df loop

dbms_output.put_line('set newname for datafile ' ||

dfrec.file# || ' to ''' || dfrec.name ||''' ;');

end loop;

dbms_output.put_line('restore database;');

dbms_output.put_line('switch all;');

dbms_output.put_line('}');

end;

/

run

{

set newname for datafile 1 to '/oradata/TEST/system01.dbf' ;

set newname for datafile 2 to '/oradata/TEST/sysaux01.dbf' ;

set newname for datafile 3 to '/oradata/TEST/undotbs01.dbf' ;

set newname for datafile 4 to '/oradata/TEST/users01.dbf' ;

set newname for datafile 5 to '/oradata/TEST/test01.dbf' ;

restore database;

switch all;

}

PL/SQL procedure successfully completed.

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

Posted by pat98

2018. 6. 15. 10:30 오라클

rman configuration clear

- rman configuration clear

설정값 확인

rman> show all;

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/11.2.0.4/dbs/snapcf_TEST.f'; # default

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

- default 로 되돌리기

CONFIGURE RETENTION POLICY CLEAR;

CONFIGURE BACKUP OPTIMIZATION CLEAR;

CONFIGURE DEFAULT DEVICE TYPE CLEAR;

CONFIGURE CONTROLFILE AUTOBACKUP CLEAR;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT CLEAR;

CONFIGURE DEVICE TYPE DISK CLEAR;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT CLEAR;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK CLEAR;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT CLEAR;

CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

CONFIGURE CHANNEL DEVICE TYPE SBT CLEAR;

CONFIGURE MAXSETSIZE CLEAR;

CONFIGURE ENCRYPTION FOR DATABASE CLEAR;

CONFIGURE ENCRYPTION ALGORITHM CLEAR;

CONFIGURE COMPRESSION ALGORITHM CLEAR;

CONFIGURE ARCHIVELOG DELETION POLICY CLEAR;

CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

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

Posted by pat98

2018. 5. 18. 15:19 오라클

패치작업 12.2.0.1.180417 (GI PSU 27468969)

DB RU : 12.2.0.1.180116 (27674384)

OCW RU : 12.2.0.1.180116 (27464465)

ACFS RU : 12.2.0.1.171115 (27458609)

DBWLM : 12.2.0.1.170913 (26839277)

TOMCAT : 12.2.0.1.170723 (27144050)

Oracle Grid Infrastructure Patch Set Update 12.2.0.1.180417 (Includes Database PSU 12.2.0.1.180417)

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 유저

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27674384

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27464465

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27458609

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/26839277

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27144050

- oracle 유저

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27674384

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/27468969/27464465

(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 (2노드 동시에 하고자할 때)

(grid 유저)

export GRID_HOME=/u01/app/12.2.0.1/grid

cd /u01/install

export OPATCH_DEBUG=true

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27464465

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27458609

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/26839277

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27674384

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./27468969/27144050

(oracle 유저)

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27468969/27464465/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27468969/27464465

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./27468969/27674384 (오래걸림)

./27468969/27464465/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 (2노드 동시에 하고자 할때)

- Loading Modified SQL Files into the Database

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

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

GI Home

(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 27464465,27458609,27674384,26839277,27144050 -oh $GRID_HOME

(oracle 유저로)

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1

cd <UNZIPPED_PATCH_LOCATION>

./27468969/27464465/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch nrollback -local -id 27464465,27674384 -oh /oracle/product/12.2.0.1

./27468969/27464465/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

sqlplus /nolog

SQL> conect / as sysdba

SQL> startup

SQL> quit

cd $ORACLE_HOME/OPatch

./datapatch -verbose

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

Posted by pat98

2018. 5. 18. 15:16 오라클

ASMNET1LSNR_ASM 의 포트관련

ASM LOCAL_LISTENER using incorrect port after GIPSU was installed (문서 ID 2201573.1)

12.2: Rootupgrade.sh Fails With ORA-27300: OS system dependent operation:sslssunreghdlr failed with status: 0 (문서 ID 2327353.1)

- local listener port 가 1526 으로 잘못 지정되는 경우가 있음.

SYS@+ASM2> show parameter local_li

NAME TYPE VALUE

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

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1526))

12.2.에서 ASMNET1LSNR_ASM 의 default port 는 1525 임

[RAC1]oracle@rac1:/home/oracle# srvctl config listener -l ASMNET1LSNR_ASM

Name: ASMNET1LSNR_ASM

Type: ASM Listener

Owner: oracle

Subnet: 10.10.10.0

Home: <CRS home>

End points: TCP:1526

Listener is enabled.

Listener is individually enabled on nodes:

Listener is individually disabled on nodes:

- 수정

$ srvctl modify listener -l ASMNET1LSNR_ASM -endpoints 1521

$ srvctl modify listener -l ASMNET2LSNR_ASM -endpoints 1521

$ srvctl modify listener -l ASMNET3LSNR_ASM -endpoints 1521

$ srvctl modify listener -l ASMNET4LSNR_ASM -endpoints 1521

- 확인

SYS@+ASM2> show parameter local_li

NAME TYPE VALUE

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

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1521))

ps : 문서에는 SMNET1LSNR_ASM 포트가 1526 으로 나와 있으나 내 경우에는 설치 후 확인해 보면 1525 였음.

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

Posted by pat98

2018. 3. 28. 18:04 오라클

12c log 화일위치 한방에 정리

출처 : 12cR1 RAC : Oracle Clusterware のログ格納場所について(R12.1.0.2 〜)(KROWN:168363) (문서 ID 1770194.1)

[12.1 이상]

<Gird_Home>은 Oracle Grid Infrastructure를 설치 한 디렉토리를 가리 킵니다.

<Grid_Base>은 Oracle Grid Infrastructure를 설치 한 사용자의 ORACLE_BASE를 말합니다.

<Oracle_Base>은 Oracle Database를 설치 한 사용자의 ORACLE_BASE를 말합니다.

================================+==========================================================================

로그 | Oracle12c Release1 (12.1.0.2) 이상

================================+==========================================================================

Oracle Clusterware | <Grid_Base> / diag / crs / <호스트 이름> /crs/trace/alert.log

--------------------------------+--------------------------------------------------------------------------

OHAS | <Grid_Base>/diag/crs/<hostname>/crs/trace/ohasd.trc

--------------------------------+--------------------------------------------------------------------------

CRS | <Grid_Base>/diag/crs/<hostname>/crs/trace/crsd.trc

--------------------------------+--------------------------------------------------------------------------

CSS | <Grid_Base>/diag/crs/<hostname>/crs/trace/ocssd.trc

--------------------------------+--------------------------------------------------------------------------

EVM | <Grid_Base>/diag/crs/ <호스트 이름> /crs/trace/evmd.trc

| <Grid_Base> / diag / crs / <호스트 이름> /crs/trace/evmlogger.trc

| <Grid_Base> / crsdata / <호스트 이름> / evm /

--------------------------------+--------------------------------------------------------------------------

CTSS | <Grid_Base>/diag/crs/<hostname>/crs/trace/octssd.trc

--------------------------------+--------------------------------------------------------------------------

OHAS 요원 | <Grid_Base>/diag/crs/<hostname>/crs/trace/ohasd_oraagent_grid.trc

| <Grid_Base>/diag/crs/<hostname>/crs/trace/ohasd_cssdmonitor_root.trc

| <Grid_Base>/diag/crs/<hostname>/crs/trace/ohasd_cssdagent_root.trc

| <Grid_Base>/diag/crs/<hostname>/crs/trace/ohasd_orarootagent_root.trc

--------------------------------+--------------------------------------------------------------------------

CRS 에이전트 | <Grid_Base>/diag/crs/<hostname> /crs/trace/crsd_orarootagent_root.trc

| <Grid_Base>/diag/crs/<호스트 이름>/crs/trace/crsd_oraagent_oracle.trc

| <Grid_Base>/diag/crs/<호스트 이름>/crs/trace/crsd_oraagent_grid.trc

--------------------------------+--------------------------------------------------------------------------

GPNP | <Grid_Base>/diag/crs/<호스트 이름>/crs/trace/gpnpd.trc

--------------------------------+--------------------------------------------------------------------------

GIPC | <Grid_Base>/diag/crs/<hostname>/crs/trace/gipcd.trc

--------------------------------+--------------------------------------------------------------------------

mDNS | <Grid_Base>/diag/crs/<호스트 이름>/crs/trace/mdnsd.trc

--------------------------------+--------------------------------------------------------------------------

DISKMON | <Grid_Base>/diag/crs/<호스트 이름>/crs/trace/diskmon.trc

--------------------------------+--------------------------------------------------------------------------

OCR 도구 | <Grid_Base>/diag/crs/<호스트 이름>/crs/trace /

(ocrdump, ocrcheck, ocrconfig) |

(*1) |

--------------------------------+--------------------------------------------------------------------------

구성 도구 | <Oracle_Base> / cfgtoollogs /

(*2) |

--------------------------------+--------------------------------------------------------------------------

root.sh | <Grid_Home>/ cfgtoollogs/crsconfig/rootcrs_<hostname>.log

(그리드 인프라 환경) |

--------------------------------+--------------------------------------------------------------------------

기본 리스너 / 사용자 리스너 | <Grid_Base>/diag/tnslsnr/<hostname>/<lsnrname> /

--------------------------------+--------------------------------------------------------------------------

스캔 목록 | <Grid_Base>/diag/tnslsnr/<hostname>/<scan lsnrname>

--------------------------------+--------------------------------------------------------------------------

ASM | <Grid_Base>/diag/asm /

--------------------------------+--------------------------------------------------------------------------

CHM (클러스터 건강 Monito) | <Grid_Base>/diag/crs/<hostname>/crs/trace/ologgerd.trc

| <Grid_Base>/diag/crs/ <hostname>/crs/trace/osysmond.trc

--------------------------------+--------------------------------------------------------------------------

ACFS 이진 로그 | <Grid_Base>/crsdata/<hostname>/acfs

--------------------------------+--------------------------------------------------------------------------

ACFS 복제 / 보안 | <Grid_Home>/log/<hostname>/acfs

--------------------------------+--------------------------------------------------------------------------

CVU | <Grid_Base>/crsdata/ <호스트 이름>/cvu/

--------------------------------+--------------------------------------------------------------------------

클러스터 유틸리티 | <Grid_Base>/crsdata/ <호스트 이름>/crsconfig/

--------------------------------+--------------------------------------------------------------------------

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

Posted by pat98

pat98's always & forever

'오라클'에 해당되는 글 497건

패치작업 12.2.0.1.181016 (GI PSU 28714316 )

12c MGMT 관련 자료

controlfile 크기 확인

oracle 18.3 이 릴리즈 되었다.

패치작업 12.2.0.1.180717 (GI PSU 28183653)

rman set newnname 생성 PL/SQL

rman configuration clear

패치작업 12.2.0.1.180417 (GI PSU 27468969)

ASMNET1LSNR_ASM 의 포트관련

12c log 화일위치 한방에 정리

카테고리

태그목록

글 보관함

최근에 올라온 글

달력

링크

최근에 달린 댓글

티스토리툴바

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