pat98's always & forever

1번 노드

[root@rac1 ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.

The execution of the script is complete.

[root@rac1 ~]# /u01/app/19.3.0.0/grid/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/19.3.0.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/base/crsdata/rac1/crsconfig/rootcrs_rac1_2020-10-03_08-53-35PM.log

2020/10/03 20:53:42 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/10/03 20:53:42 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/10/03 20:53:42 CLSRSC-363: User ignored prerequisites during installation

2020/10/03 20:53:42 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/10/03 20:53:45 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/10/03 20:53:46 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/10/03 20:53:46 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/10/03 20:53:47 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/10/03 20:54:32 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/10/03 20:54:32 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/10/03 20:54:37 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/10/03 20:54:49 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/10/03 20:54:49 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/10/03 20:54:53 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/10/03 20:54:53 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2020/10/03 20:55:33 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/10/03 20:55:38 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/10/03 20:56:24 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/10/03 20:56:28 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

ASM has been created and started successfully.

[DBT-30001] Disk groups created successfully. Check /u01/app/base/cfgtoollogs/asmca/asmca-201003PM085700.log for details.

2020/10/03 20:57:56 CLSRSC-482: Running command: '/u01/app/19.3.0.0/grid/bin/ocrconfig -upgrade oracle dba'

CRS-4256: Updating the profile

Successful addition of voting disk 424834c4a1b14f4dbf83d128c0ea63f4.

Successfully replaced voting disk group with +VOTE.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

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

 1. ONLINE   424834c4a1b14f4dbf83d128c0ea63f4 (/dev/nvme0n3p1) [VOTE]

Located 1 voting disk(s).

2020/10/03 20:59:15 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/10/03 21:00:45 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/10/03 21:00:45 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/10/03 21:02:09 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/10/03 21:02:38 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

2번 노드

[root@rac2 ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.

The execution of the script is complete.

[root@rac2 ~]# /u01/app/19.3.0.0/grid/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/19.3.0.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.3.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/base/crsdata/rac2/crsconfig/rootcrs_rac2_2020-10-03_09-07-02PM.log

2020/10/03 21:07:07 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/10/03 21:07:07 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/10/03 21:07:07 CLSRSC-363: User ignored prerequisites during installation

2020/10/03 21:07:07 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/10/03 21:07:09 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/10/03 21:07:09 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/10/03 21:07:09 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/10/03 21:07:11 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/10/03 21:07:14 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/10/03 21:07:14 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/10/03 21:07:25 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/10/03 21:07:25 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/10/03 21:07:27 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/10/03 21:07:28 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2020/10/03 21:07:44 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/10/03 21:08:10 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/10/03 21:08:11 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/10/03 21:08:57 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/10/03 21:08:58 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

2020/10/03 21:09:08 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/10/03 21:10:01 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/10/03 21:10:01 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/10/03 21:10:29 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/10/03 21:10:44 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

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

패치작업 19.8.0.0.200714 (GI PSU 31305339)

OCW Patch Set Update      : 19.8.0.0.200714 (31305087)

ACFS Patch Set Update      : 19.8.0.0.200714 (31304218)

Database Patch Set Update : 19.8.0.0.200714 (31281355)

Tomcat Release Update     :  19.0.0.0.0     (31335188)

Oracle Grid Infrastructure Patch Set Update 19.8.0.0.200714 

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

GRID_HOME, ORACLE_HOME 을 개별로 각각 할때

- grid 유저

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31304218

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31335188

- oracle 유저

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355

(oracle)

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

(root 유저)

export GRID_HOME=/u01/app/19.3.0.0/grid

$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling

(grid 유저)

export GRID_HOME=/u01/grid/19.3.0.0

cd <UNZIPPED_PATCH_LOCATION>

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31305087

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31304218

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31281355

$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31335188

(oracle 유저)

export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0

cd <UNZIPPED_PATCH_LOCATION>

./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31305087

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31281355

./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

(root 유저)

export GRID_HOME=/u01/grid/19.3.0.0

$GRID_HOME/rdbms/install/rootadd_rdbms.sh

$GRID_HOME/crs/install/rootcrs.sh -postpatch

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

GI Home

(root로)

$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback

(grid 유저로)

$GRID_HOME/OPatch/opatch nrollback -local -id 31305087,31304218,31281355,31335188 -oh $GRID_HOME

(oracle 유저로)

cd <UNZIPPED_PATCH_LOCATION>

./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)

$ORACLE_HOME/OPatch/opatch nrollback -local -id  31305087,31281355 -oh /oracle/product/19.3.0.0

./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)

Run post script

(root로)

$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

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

19c 부터 gridSetup.sh 뿐만 아니라 Database runInstaller 에도 -applyRU 옵션으로 엔진설치와 RU(패치)를 동시에 설치할 수 있게 옵션이 생겼다.

옵션은 runInstaller -applyRU [패치화일위치]

우선 홈디렉토리를 만들고 

mkdir -p /oracle/app/oracle/product/19.3.0

Image-based 방식이므로 19.3 설치화일과 최신 OPatch 는 ORACLE_HOME 밑으로 이동시킨다.

mv p31281355_190000_Linux-x86-64 /oracle/app/oracle/product/19.3.0

mv p6880880_190000_Linux-x86-64 /oracle/app/oracle/product/19.3.0

cd /oracle/app/oracle/product/19.3.0

unzip p31281355_190000_Linux-x86-64

unzip p6880880_190000_Linux-x86-64

19.8 패치화일은 별도의 위치에 압축해제한다.

unzip p31281355_190000_Linux-x86-64 /oracle/patch

이제 runInstaller 를 applyRU 옵션을 주고 실행한다.

./runInstaller -applyRU /oracle/patch/31281355

[TEST]oracle@ora19c:/oracle/app/oracle/product/19.3.0# ./runInstaller -applyRU /oracle/patch/31281355

Preparing the home to patch...

Applying the patch /oracle/patch/31281355...

Successfully applied the patch.

The log can be found at: /tmp/InstallActions2020-09-23_09-58-02PM/installerPatchActions_2020-09-23_09-58-02PM.log

Launching Oracle Database Setup Wizard...

여기서 GUI 에서 마우스 클릭이 먹지 않는 황당한 증상이 일어날수 있다. 머하지는 거냐 ㅠ.ㅠ

침착하게 마우스 왼쪽+오른쪽 버튼을 동시에 꾸욱 눌러주자!! 그리고 Step by Step 을 진행하자.

적용 되었는지 확인 작업하고 DBCA 실행!!

[TEST]oracle@ora19c:/home/oracle# opatch lspatches

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

[TEST]oracle@ora19c:/home/oracle# opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.21

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/app/oracle/product/19.3.0

Central Inventory : /oracle/oraInventory

   from           : /oracle/app/oracle/product/19.3.0/oraInst.loc

OPatch version    : 12.2.0.1.21

OUI version       : 12.2.0.7.0

Log file location : /oracle/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-09-23_22-37-04PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/19.3.0/cfgtoollogs/opatch/lsinv/lsinventory2020-09-23_22-37-04PM.txt

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

Local Machine Information::

Hostname: ora19c

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 19c                                                  19.0.0.0.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  31281355     : applied on Wed Sep 23 21:59:25 KST 2020

Unique Patch ID:  23688465

Patch description:  "Database Release Update : 19.8.0.0.200714 (31281355)"

   Created on 6 Jul 2020, 11:18:02 hrs PST8PDT

   Bugs fixed:

     30533132, 30312546, 29924181, 30980733, 31383396, 31094688, 7391838

     8476681, 14735102, 17428816, 19080742, 19697993, 20313356, 21374587

     21965541, 22580355, 22729345, 23296836, 23606241, 23645975, 23763462

     24596874, 24669730, 24687075, 24971456, 25030027, 25092651, 25416731

     25560538, 25756945, 25804387, 25806201, 25883179, 25986062, 25997810

     26001677, 26284288, 26440142, 26476244, 26611353, 26668264, 26739322

     26777814, 26872233, 27036163, 27044169, 27101798, 27126122, 27126938

     27166935, 27195935, 27221350, 27244999, 27254335, 27359766, 27369515

     27378053, 27392968, 27406105, 27411022, 27423500, 27439716, 27453490

     27458357, 27489107, 27582210, 27589260, 27629928, 27666312, 27692173

     27700413, 27710072, 27729678, 27801144, 27828892, 27846298, 27880025

     27929509, 27934711, 27935464, 27941110, 27957203, 27967484, 28064977

     28072567, 28078186, 28092783, 28104176, 28109326, 28125947, 28129791

     28138847, 28144569, 28181021, 28189466, 28204262, 28205555, 28209985

     28210681, 28263142, 28271258, 28271693, 28276054, 28279456, 28294563

     28313275, 28319114, 28322973, 28326928, 28350595, 28371123, 28373960

     28375383, 28379065, 28381939, 28386259, 28390273, 28395302, 28397317

     28402823, 28410431, 28431445, 28435333, 28442896, 28454215, 28463226

     28475242, 28484299, 28489419, 28492006, 28498976, 28502773, 28504631

     28513333, 28521330, 28530171, 28534475, 28535127, 28538439, 28541606

     28542455, 28546290, 28547068, 28547926, 28558645, 28561704, 28564479

     28565296, 28567417, 28567819, 28569897, 28572407, 28572533, 28572544

     28572667, 28572834, 28578945, 28587723, 28589509, 28593682, 28594086

     28597221, 28601957, 28605066, 28606598, 28608211, 28612239, 28618343

     28620697, 28622202, 28625862, 28627033, 28628592, 28632796, 28636532

     28639299, 28642899, 28643654, 28643718, 28644549, 28645570, 28646200

     28646939, 28649388, 28655209, 28663289, 28663782, 28672457, 28673945

     28681153, 28689483, 28692103, 28692275, 28694639, 28694872, 28696373

     28703812, 28705231, 28707931, 28708400, 28709063, 28710385, 28710469

     28710734, 28714461, 28715655, 28715727, 28718469, 28719348, 28720204

     28720418, 28721497, 28722229, 28730079, 28734355, 28740708, 28742555

     28745367, 28749853, 28752923, 28755011, 28758722, 28760206, 28765983

     28767240, 28769456, 28771947, 28772390, 28774416, 28776431, 28776811

     28777214, 28778754, 28781599, 28781754, 28785531, 28789531, 28791852

     28793062, 28795551, 28795734, 28802734, 28804517, 28805242, 28808314

     28808656, 28810381, 28811560, 28813931, 28815123, 28815355, 28817449

     28819640, 28820669, 28821847, 28824482, 28827682, 28831971, 28833912

     28835937, 28836716, 28838385, 28844738, 28845346, 28846759, 28849776

     28850084, 28854004, 28855520, 28855922, 28857552, 28861861, 28862532

     28863263, 28863432, 28863487, 28865569, 28867992, 28872645, 28873575

     28875089, 28876253, 28876639, 28876926, 28878865, 28882784, 28884931

     28887305, 28888327, 28889730, 28892794, 28897512, 28899663, 28900506

     28901126, 28905390, 28905457, 28905615, 28907196, 28910498, 28912691

     28915561, 28917080, 28918429, 28919145, 28922227, 28922532, 28922608

     28925634, 28925880, 28927452, 28932914, 28933158, 28935293, 28936114

     28937717, 28938422, 28938698, 28940179, 28940281, 28941901, 28942455

     28945421, 28945994, 28946233, 28949888, 28950868, 28951533, 28952168

     28954762, 28955606, 28955883, 28956908, 28957292, 28957723, 28958088

     28959493, 28960863, 28962775, 28965084, 28965095, 28965231, 28965376

     28966444, 28974083, 28974999, 28977322, 28981871, 28983095, 28983486

     28985478, 28986207, 28986231, 28986257, 28986326, 28986481, 28988482

     28988864, 28989306, 28993295, 28993353, 28994307, 28994542, 28996376

     29000000, 29001305, 29001888, 29002488, 29002784, 29002927, 29003407

     29003738, 29006318, 29006621, 29007321, 29007353, 29007775, 29008035

     29008669, 29009513, 29010126, 29011936, 29012609, 29013475, 29013832

     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352

     29022986, 29024054, 29024448, 29024552, 29024732, 29026582, 29026606

     29027456, 29027694, 29027940, 29031575, 29031600, 29032234, 29032276

     29032457, 29032607, 29033052, 29033145, 29033200, 29033280, 29034587

     29036278, 29037290, 29038528, 29038728, 29039089, 29039510, 29040739

     29043554, 29043651, 29043725, 29044763, 29044954, 29046482, 29047850

     29048178, 29048289, 29048498, 29048605, 29048728, 29050357, 29050560

     29050765, 29050886, 29051702, 29051953, 29052726, 29053783, 29055644

     29056024, 29056270, 29056560, 29056767, 29056894, 29059011, 29060216

     29061016, 29061959, 29062692, 29062848, 29062860, 29062868, 29110526

     29110783, 29110790, 29110797, 29110802, 29110805, 29111598, 29113282

     29113305, 29115857, 29117526, 29117642, 29118543, 29119077, 29120223

     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125036

     29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450

     29129497, 29129712, 29130219, 29131539, 29132869, 29132938, 29133470

     29134447, 29135383, 29135649, 29136111, 29138641, 29139070, 29139761

     29139956, 29141316, 29141341, 29141685, 29142609, 29142667, 29143516

     29144995, 29145214, 29145730, 29146810, 29149829, 29150338, 29151520

     29152357, 29154725, 29155099, 29157051, 29157389, 29158680, 29158899

     29159909, 29159936, 29160174, 29161597, 29162095, 29163073, 29163156

     29163415, 29163437, 29163524, 29163567, 29164376, 29165682, 29167111

     29167342, 29167374, 29167940, 29168137, 29168219, 29168433, 29169073

     29169215, 29170232, 29171683, 29171942, 29172618, 29172826, 29173140

     29173373, 29173817, 29174004, 29174753, 29176318, 29177466, 29177543

     29177886, 29178385, 29179097, 29180313, 29180455, 29180559, 29180893

     29181078, 29181153, 29181231, 29181620, 29181743, 29181923, 29182019

     29182517, 29182901, 29183912, 29184297, 29184666, 29185193, 29186456

     29186605, 29188255, 29189302, 29189307, 29189889, 29190235, 29190474

     29190663, 29190740, 29191541, 29192419, 29192468, 29192685, 29193207

     29194205, 29194367, 29194493, 29194827, 29194981, 29195279, 29195337

     29195758, 29196725, 29198092, 29198913, 29199635, 29199733, 29200316

     29200700, 29201494, 29201539, 29201787, 29202104, 29202461, 29202850

     29203122, 29203166, 29203227, 29203425, 29203443, 29203604, 29205281

     29205323, 29205419, 29205463, 29205767, 29205918, 29206109, 29206605

     29207073, 29208260, 29208732, 29211457, 29211724, 29212012, 29212433

     29212611, 29213320, 29213351, 29213613, 29213775, 29213850, 29213879

     29214561, 29214960, 29216312, 29216723, 29216746, 29216984, 29217294

     29217472, 29217828, 29217848, 29218570, 29219205, 29219273, 29220079

     29221248, 29221891, 29221942, 29222031, 29222784, 29223833, 29223859

     29223967, 29224065, 29224605, 29225076, 29225168, 29225758, 29227602

     29228869, 29229164, 29229754, 29229844, 29229955, 29230252, 29230565

     29231133, 29232117, 29232154, 29232449, 29233415, 29233810, 29233953

     29234123, 29236573, 29237538, 29237575, 29237744, 29240307, 29240759

     29241345, 29241651, 29242017, 29242884, 29243958, 29245063, 29245137

     29245160, 29246163, 29247415, 29247712, 29247906, 29248495, 29248552

     29248835, 29248858, 29249289, 29249412, 29249991, 29250059, 29250317

     29251259, 29253184, 29253871, 29254031, 29254930, 29255178, 29255273

     29255431, 29255435, 29255718, 29255973, 29256426, 29259119, 29259320

     29260452, 29260956, 29261547, 29261548, 29261906, 29262512, 29262887

     29265448, 29266248, 29266899, 29267292, 29268412, 29269171, 29269228

     29269825, 29270585, 29273539, 29273570, 29273735, 29273812, 29273847

     29274428, 29274564, 29274627, 29275461, 29276272, 29277317, 29278218

     29278684, 29279658, 29279751, 29279854, 29281527, 29281691, 29281796

     29282233, 29282898, 29285197, 29285503, 29285788, 29285956, 29286037

     29286229, 29287130, 29287705, 29290110, 29292837, 29293072, 29293574

     29296257, 29297863, 29297915, 29298220, 29299049, 29299082, 29299844

     29301463, 29301566, 29302963, 29303918, 29304314, 29304781, 29306226

     29306713, 29307638, 29309698, 29311528, 29311588, 29311927, 29312310

     29312672, 29312734, 29312753, 29312889, 29313347, 29313417, 29313525

     29314539, 29314636, 29317756, 29318410, 29319441, 29321489, 29323946

     29324568, 29324735, 29325087, 29325105, 29325257, 29325765, 29325993

     29327044, 29327892, 29329042, 29329087, 29329807, 29330361, 29331066

     29331209, 29331380, 29331493, 29332292, 29332395, 29332763, 29332771

     29333500, 29336843, 29337294, 29337310, 29337742, 29338315, 29338348

     29338453, 29338780, 29338913, 29339101, 29339155, 29341209, 29343086

     29343156, 29343861, 29344541, 29345937, 29346057, 29346211, 29346943

     29347620, 29348176, 29350052, 29350762, 29350868, 29351044, 29351386

     29351662, 29351716, 29351735, 29351749, 29351771, 29352298, 29352724

     29352867, 29352947, 29353271, 29353432, 29353718, 29353821, 29353960

     29355654, 29356547, 29356704, 29356711, 29356752, 29356782, 29358509

     29358828, 29360252, 29360285, 29360672, 29360911, 29360950, 29361319

     29361472, 29361801, 29362596, 29363151, 29364171, 29364177, 29366406

     29366940, 29367019, 29367561, 29368253, 29368310, 29372069, 29372541

     29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346

     29377804, 29377986, 29378029, 29378287, 29378834, 29378913, 29379750

     29379978, 29382641, 29382784, 29382815, 29383695, 29384781, 29384854

     29384864, 29385339, 29385429, 29385652, 29386502, 29386557, 29386635

     29386660, 29387073, 29387274, 29387310, 29387337, 29388020, 29388072

     29388094, 29388524, 29388830, 29389408, 29389889, 29390011, 29390435

     29390785, 29391030, 29391237, 29391438, 29391849, 29391925, 29392554

     29392966, 29393291, 29394014, 29394140, 29394749, 29395657, 29397954

     29397996, 29398488, 29398863, 29399046, 29399100, 29399121, 29399336

     29399938, 29402131, 29404483, 29405012, 29405462, 29405651, 29405996

     29407488, 29407804, 29408853, 29409149, 29409455, 29410311, 29410834

     29411037, 29411469, 29412066, 29412269, 29413382, 29413517, 29413544

     29413634, 29413956, 29416688, 29416700, 29417084, 29417173, 29417719

     29417884, 29418165, 29420254, 29420834, 29421059, 29423003, 29423016

     29423156, 29423826, 29424999, 29426241, 29426320, 29428230, 29429017

     29429087, 29429264, 29429466, 29429566, 29430524, 29430866, 29431192

     29431485, 29432176, 29434301, 29434869, 29435474, 29435652, 29436454

     29436514, 29436522, 29436727, 29437594, 29437712, 29438150, 29438277

     29438736, 29439522, 29441196, 29442936, 29443187, 29443250, 29444072

     29444282, 29444602, 29446669, 29448498, 29449477, 29449845, 29449852

     29450162, 29450193, 29450421, 29450812, 29450936, 29451386, 29452251

     29452576, 29452936, 29452953, 29454978, 29455424, 29455773, 29456538

     29456714, 29457312, 29457370, 29457502, 29457807, 29457978, 29460252

     29461420, 29461791, 29461971, 29462594, 29462767, 29462957, 29463047

     29463528, 29463798, 29464616, 29464779, 29465177, 29466674, 29467622

     29469565, 29470291, 29471832, 29471860, 29472618, 29473708, 29476473

     29481584, 29483452, 29483532, 29483626, 29483672, 29483685, 29483712

     29483723, 29483771, 29485099, 29486181, 29486848, 29487150, 29487189

     29488894, 29489436, 29489546, 29490256, 29492127, 29492939, 29493122

     29494245, 29495057, 29495684, 29497311, 29497588, 29497696, 29498198

     29500257, 29500826, 29500963, 29501218, 29502561, 29503543, 29503631

     29503827, 29504492, 29504682, 29505668, 29506942, 29507270, 29507616

     29508681, 29509777, 29510278, 29511064, 29511611, 29511980, 29512890

     29514479, 29515134, 29515240, 29515476, 29515766, 29515834, 29516300

     29516727, 29516766, 29517168, 29517883, 29519131, 29521187, 29521688

     29521748, 29521862, 29522358, 29522561, 29522662, 29523055, 29523216

     29523511, 29524599, 29524985, 29525366, 29525467, 29525886, 29526966

     29527595, 29527610, 29528368, 29529147, 29530440, 29530515, 29530812

     29530909, 29531654, 29531836, 29532532, 29536342, 29536445, 29537829

     29538631, 29541742, 29541769, 29542084, 29542449, 29542580, 29542643

     29543034, 29543956, 29546817, 29547010, 29547867, 29548413, 29548427

     29548592, 29548687, 29548722, 29549040, 29549071, 29549104, 29549154

     29549730, 29552773, 29553141, 29554092, 29557144, 29557261, 29557336

     29557556, 29558238, 29558452, 29558975, 29559187, 29559395, 29559446

     29559908, 29559981, 29564592, 29564593, 29565611, 29579919, 29580394

     29580983, 29581771, 29584261, 29584693, 29586143, 29587299, 29587765

     29589544, 29591343, 29592011, 29592215, 29597536, 29597754, 29598039

     29598046, 29598226, 29598233, 29599008, 29599300, 29601461, 29602831

     29603460, 29603884, 29604002, 29604257, 29606261, 29607136, 29607797

     29608000, 29608023, 29610506, 29611020, 29611991, 29614206, 29614987

     29615824, 29616244, 29616414, 29618074, 29618190, 29620042, 29622936

     29623323, 29625065, 29625804, 29625876, 29626154, 29626732, 29628200

     29629430, 29629650, 29629681, 29629745, 29631749, 29632095, 29632265

     29632611, 29633697, 29633753, 29633936, 29634643, 29635427, 29635717

     29635990, 29637362, 29637526, 29637560, 29638285, 29641736, 29643721

     29644426, 29644464, 29645167, 29645349, 29647176, 29648928, 29651183

     29651520, 29653132, 29653246, 29655164, 29655668, 29656400, 29656819

     29656843, 29657399, 29657422, 29657744, 29657960, 29658056, 29661028

     29661065, 29661722, 29663191, 29663368, 29663494, 29663601, 29664087

     29664161, 29665940, 29667527, 29667994, 29668005, 29669413, 29670782

     29671363, 29672507, 29675446, 29676089, 29677051, 29677173, 29677733

     29677927, 29679856, 29681987, 29683039, 29683211, 29684518, 29685137

     29685276, 29687214, 29687220, 29687459, 29687718, 29687727, 29687763

     29688867, 29689145, 29689255, 29692694, 29694869, 29695425, 29695821

     29695841, 29696310, 29700125, 29700460, 29700770, 29703932, 29705793

     29707099, 29707493, 29707896, 29708876, 29708915, 29710188, 29710858

     29713810, 29715220, 29715703, 29716194, 29716227, 29716491, 29716602

     29716871, 29717659, 29717901, 29719146, 29720133, 29721418, 29721576

     29722167, 29724658, 29725476, 29725781, 29726695, 29738400, 29739576

     29741319, 29741976, 29742223, 29744225, 29746962, 29747493, 29747648

     29747653, 29748285, 29748336, 29748513, 29749471, 29750673, 29751094

     29753244, 29754196, 29754951, 29755821, 29756274, 29756444, 29757099

     29757264, 29757651, 29757687, 29758203, 29758217, 29758661, 29761678

     29761837, 29761911, 29763158, 29765035, 29765393, 29766207, 29766435

     29766503, 29766679, 29768899, 29770750, 29771032, 29771242, 29773197

     29773842, 29775393, 29779196, 29780140, 29782211, 29782823, 29782866

     29784106, 29785239, 29785311, 29787292, 29787766, 29789911, 29791152

     29791880, 29792213, 29793318, 29794174, 29794462, 29795712, 29795957

     29796378, 29797726, 29802695, 29804875, 29805772, 29806390, 29807964

     29809792, 29809837, 29812084, 29812489, 29813503, 29813650, 29813671

     29815341, 29815713, 29817278, 29817547, 29817784, 29821582, 29822714

     29825525, 29827647, 29827852, 29831196, 29834506, 29836096, 29838485

     29838773, 29839715, 29840619, 29841267, 29841687, 29843277, 29843692

     29843831, 29844226, 29844275, 29845530, 29846126, 29846645, 29846688

     29848084, 29848849, 29849100, 29850930, 29851733, 29853485, 29856859

     29858121, 29858376, 29859068, 29860994, 29861075, 29864203, 29864261

     29865188, 29865590, 29865658, 29869086, 29869404, 29869887, 29869906

     29870065, 29871098, 29871312, 29872401, 29872937, 29872983, 29873665

     29874090, 29874761, 29875459, 29875565, 29876358, 29876989, 29877608

     29878076, 29881050, 29881478, 29881575, 29881643, 29881839, 29882427

     29882454, 29882729, 29884958, 29885890, 29886809, 29887111, 29888621

     29889184, 29889358, 29890740, 29891075, 29891853, 29891916, 29892604

     29893132, 29896510, 29897418, 29897863, 29900203, 29900824, 29901419

     29902299, 29902327, 29902330, 29902659, 29903190, 29903299, 29903357

     29903454, 29904002, 29906678, 29907942, 29908389, 29908777, 29909658

     29910402, 29912286, 29913805, 29913966, 29914449, 29914544, 29915217

     29915848, 29916975, 29919789, 29920025, 29920376, 29920804, 29921318

     29922225, 29923452, 29926466, 29927756, 29928210, 29928427, 29928564

     29930457, 29932202, 29932430, 29932780, 29934052, 29937565, 29937956

     29938225, 29939400, 29939795, 29940373, 29942096, 29942554, 29943670

     29943879, 29944035, 29944660, 29944963, 29945645, 29946388, 29947145

     29950220, 29951620, 29951759, 29956016, 29956222, 29957412, 29957493

     29958925, 29960884, 29961353, 29961609, 29961847, 29962160, 29962248

     29962834, 29962927, 29962939, 29965052, 29965603, 29965888, 29966768

     29967223, 29968085, 29969557, 29970081, 29970298, 29971027, 29971481

     29971888, 29971936, 29971951, 29972176, 29973012, 29989783, 29989845

     29991257, 29993717, 29997326, 29997553, 30000664, 30001331, 30003187

     30006159, 30006985, 30007450, 30007797, 30008125, 30008198, 30008214

     30009710, 30012181, 30015070, 30017836, 30018017, 30018903, 30019864

     30024618, 30025814, 30026016, 30027614, 30028599, 30029519, 30029806

     30031027, 30032376, 30033040, 30033547, 30034456, 30035598, 30038392

     30039800, 30039959, 30040157, 30041501, 30042490, 30043398, 30043610

     30043930, 30044507, 30045389, 30045484, 30046497, 30047531, 30047702

     30047765, 30047931, 30049966, 30051176, 30051783, 30051804, 30052928

     30053036, 30053501, 30053748, 30054980, 30056058, 30057718, 30057799

     30058149, 30058453, 30059106, 30059109, 30060267, 30060330, 30062364

     30062819, 30064268, 30066352, 30067565, 30068871, 30071446, 30072905

     30073314, 30073744, 30074296, 30074349, 30074469, 30074472, 30074820

     30075037, 30076058, 30076197, 30076253, 30078675, 30078934, 30079949

     30080266, 30081546, 30081580, 30082145, 30083100, 30083216, 30083488

     30083807, 30084971, 30085897, 30086596, 30086992, 30090568, 30092280

     30092859, 30095591, 30095952, 30097092, 30097115, 30098251, 30099302

     30099420, 30099454, 30100354, 30101186, 30103551, 30103553, 30104378

     30104555, 30106748, 30109365, 30110224, 30110370, 30110518, 30114477

     30114489, 30114534, 30116085, 30116203, 30116854, 30117209, 30117335

     30117593, 30118261, 30118279, 30120608, 30122583, 30125765, 30126145

     30127522, 30127805, 30127904, 30128047, 30131286, 30131645, 30132708

     30133841, 30135396, 30135731, 30135942, 30136346, 30139392, 30142907

     30143470, 30143593, 30146593, 30146969, 30147473, 30147928, 30149035

     30149658, 30150606, 30153552, 30153885, 30154633, 30155814, 30155837

     30159329, 30159511, 30159536, 30159752, 30159760, 30163243, 30164714

     30165493, 30165503, 30165897, 30169254, 30170104, 30172925, 30173113

     30173556, 30174401, 30175291, 30177597, 30178250, 30178839, 30178990

     30179644, 30180208, 30181756, 30183696, 30183715, 30183920, 30184102

     30185852, 30186319, 30186476, 30186706, 30187866, 30189516, 30190090

     30191274, 30193165, 30193505, 30193736, 30194612, 30194710, 30194972

     30195667, 30195668, 30195684, 30196195, 30196358, 30196629, 30198861

     30198905, 30200034, 30200132, 30200237, 30200680, 30200758, 30202349

     30202388, 30203929, 30204042, 30204542, 30206493, 30206675, 30207473

     30208327, 30208723, 30209736, 30210884, 30213031, 30213540, 30215130

     30215302, 30215351, 30217206, 30217982, 30218044, 30218317, 30219222

     30221237, 30221298, 30222512, 30223712, 30223847, 30224650, 30224868

     30224950, 30225265, 30225443, 30225718, 30225844, 30226244, 30228567

     30229683, 30232638, 30235919, 30235979, 30236554, 30238211, 30238715

     30239480, 30240010, 30240547, 30241567, 30241920, 30242120, 30242724

     30243216, 30244340, 30246053, 30246179, 30247305, 30249432, 30251003

     30252005, 30252098, 30252156, 30252458, 30252977, 30253035, 30253090

     30253608, 30253705, 30253835, 30254206, 30254525, 30254726, 30255143

     30255528, 30256542, 30257412, 30264405, 30265523, 30265608, 30265615

     30265703, 30266791, 30267155, 30269428, 30269748, 30270647, 30270744

     30271114, 30272329, 30274090, 30274188, 30274324, 30275548, 30275569

     30275578, 30276243, 30277120, 30277451, 30277733, 30281428, 30282501

     30282591, 30283296, 30283577, 30283579, 30283581, 30283932, 30284219

     30284369, 30285457, 30285843, 30288343, 30288491, 30289458, 30293345

     30294267, 30294671, 30295110, 30295549, 30295808, 30297905, 30299367

     30299817, 30299934, 30300030, 30300538, 30305264, 30305395, 30305568

     30305880, 30307814, 30307883, 30308368, 30308624, 30308772, 30308947

     30309098, 30309798, 30311826, 30312094, 30313848, 30314079, 30314198

     30314837, 30316667, 30316897, 30317209, 30318638, 30318943, 30319080

     30319099, 30322980, 30323658, 30323849, 30324180, 30325407, 30326882

     30327149, 30328168, 30328690, 30329209, 30330123, 30331759, 30332505

     30334484, 30334563, 30335127, 30335832, 30335987, 30336032, 30336742

     30339103, 30341713, 30342371, 30342878, 30344614, 30345201, 30345432

     30345809, 30346330, 30346867, 30349714, 30352581, 30352623, 30355490

     30357463, 30357897, 30360383, 30362003, 30362850, 30363716, 30364329

     30364613, 30365745, 30367193, 30368048, 30368482, 30368534, 30368668

     30371264, 30371623, 30371909, 30372081, 30373550, 30374345, 30374570

     30374739, 30375109, 30376986, 30377347, 30381207, 30381525, 30382982

     30383286, 30384121, 30384152, 30389229, 30389414, 30389507, 30391272

     30392011, 30393110, 30393653, 30394738, 30394974, 30396946, 30397100

     30398257, 30398422, 30399906, 30402386, 30403763, 30403881, 30403902

     30403989, 30404117, 30408515, 30408808, 30409207, 30409339, 30409590

     30412188, 30412863, 30412885, 30412921, 30413137, 30414679, 30414714

     30416034, 30417648, 30419024, 30421439, 30421476, 30422487, 30423135

     30423218, 30424347, 30430921, 30431274, 30431504, 30431698, 30431703

     30431717, 30433177, 30437149, 30441687, 30441959, 30442749, 30442884

     30443393, 30446583, 30447060, 30447589, 30448182, 30448917, 30449194

     30450787, 30453442, 30454090, 30458568, 30458593, 30460922, 30461458

     30463938, 30464250, 30464655, 30466081, 30469777, 30472891, 30474167

     30474774, 30475115, 30476768, 30477588, 30477685, 30477691, 30477767

     30479715, 30480872, 30483140, 30483521, 30484042, 30484801, 30485255

     30486436, 30487387, 30490014, 30493518, 30495035, 30495133, 30495483

     30496957, 30497057, 30500224, 30500297, 30500344, 30500582, 30501574

     30502415, 30503943, 30505497, 30506794, 30506991, 30507032, 30509277

     30510347, 30510527, 30513285, 30513848, 30515886, 30516868, 30517214

     30519188, 30522285, 30522998, 30523137, 30523538, 30523601, 30523750

     30528547, 30528704, 30529940, 30534351, 30534549, 30534827, 30537405

     30537533, 30539519, 30540109, 30540407, 30544247, 30544595, 30545281

     30545556, 30549637, 30549789, 30549881, 30551000, 30551123, 30556581

     30556807, 30557386, 30560513, 30561590, 30564139, 30564343, 30573703

     30576393, 30577071, 30579051, 30581448, 30582500, 30588738, 30591028

     30592859, 30595114, 30595860, 30596488, 30598682, 30598746, 30598919

     30599405, 30599407, 30600173, 30600184, 30602230, 30605215, 30609799

     30612199, 30613937, 30613971, 30614411, 30619525, 30619787, 30622528

     30623138, 30623142, 30624792, 30624864, 30625121, 30628899, 30629643

     30629799, 30631393, 30633259, 30633938, 30635183, 30635302, 30635326

     30637270, 30637319, 30641755, 30641900, 30644889, 30651231, 30651621

     30651674, 30652515, 30652853, 30654558, 30657365, 30657624, 30657706

     30657875, 30658702, 30661939, 30662651, 30663646, 30668407, 30671813

     30674959, 30676209, 30681462, 30681516, 30686131, 30690686, 30691604

     30691731, 30691857, 30692473, 30698289, 30703610, 30704826, 30708735

     30710807, 30714151, 30714715, 30718862, 30719419, 30720736, 30720844

     30722705, 30724679, 30724881, 30727701, 30729604, 30730026, 30732711

     30734707, 30735736, 30740997, 30741263, 30749722, 30750991, 30751968

     30758943, 30761878, 30763272, 30763305, 30763639, 30765486, 30769312

     30773164, 30776416, 30776929, 30778855, 30781032, 30781041, 30783551

     30785101, 30789904, 30790441, 30801296, 30801510, 30803210, 30808869

     30812574, 30814285, 30815852, 30816938, 30823744, 30825391, 30825419

     30825656, 30826474, 30828350, 30829779, 30833454, 30834110, 30838605

     30847442, 30848773, 30851951, 30857721, 30858919, 30866141, 30866988

     30871716, 30871792, 30880913, 30881407, 30883877, 30886188, 30887501

     30890720, 30890971, 30896620, 30904672, 30906274, 30909918, 30913399

     30914272, 30914674, 30919691, 30922936, 30922996, 30923517, 30923940

     30927821, 30930339, 30936831, 30937410, 30939934, 30940259, 30941056

     30944643, 30945005, 30952104, 30953836, 30957739, 30964194, 30968737

     30970518, 30972841, 30972966, 30973113, 30973137, 30973143, 30980317

     30987088, 30990034, 30992597, 30993198, 30996991, 30998759, 30998847

     31001017, 31001455, 31001859, 31004077, 31004719, 31004844, 31008240

     31010976, 31013127, 31016413, 31019249, 31021157, 31022858, 31029936

     31031955, 31032904, 31039627, 31039928, 31051075, 31062010, 31066265

     31077365, 31084921, 31100172, 31106577, 31113089, 31118809, 31119057

     31134430, 31153120, 31156383, 31172207, 31177193, 31182793, 31193936

     31200845, 31305624, 31338673, 31393600, 31414023, 31414524

Patch  29585399     : applied on Thu Apr 18 16:21:33 KST 2019

Unique Patch ID:  22840393

Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"

   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT

   Bugs fixed:

     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673

     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321

     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040

     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250

     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779

     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876

     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455

     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456

     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631

     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540

     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091

     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624

     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934

     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583

     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090

     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753

     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299

     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381

     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931

     29413360, 29457319, 29465047

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

OPatch succeeded.

Oracle DBCS dataguard 구성후 patch 비교

- Oracle DBCS에서 Console 화면상에서 자동으로 Dataguard 구성후 primary, standby 패치 비교하면 다르다. 

Standby 가 최신 이미지로 Provisioning 되기 때문인데 동일하게 맞추려면 Custom Oracle Image 사용하여 작업가능.

primary : 19.6.0.0

standby : 19.8.0.0

- primary 

[grid@primary OPatch]$ ./opatch lspatches

30788310;ACFS Interim patch for 30788310

30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

[TEST]oracle@primary:/home/oracle# opatch lspatches

30484981;OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)

30423135;REINSTATE IS FAILING POST APPLYING 19C OCT19 PATCHES

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

30413137;ORA-00600  INTERNAL ERROR CODE, ARGUMENTS  [2006]

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

- standby

[grid@standby OPatch]$ ./opatch lspatches

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

[TEST]oracle@standby:/home/oracle# opatch lspatches

29997959;DSTV34 UPDATE - TZDATA2019B - NEED OJVM FIX

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

Oracle DBCS에서 Console 화면상에서 Dataguard 구성후 primary, standby 패치 비교하면 다르다. 

Standby 가 최신 이미지로 Provisioning 되기 때문

primary : 19.6.0.0

standby : 19.8.0.0

- primary 

[grid@primary OPatch]$ ./opatch lspatches

30788310;ACFS Interim patch for 30788310

30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

[TEST]oracle@primary:/home/oracle# opatch lspatches

30484981;OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)

30423135;REINSTATE IS FAILING POST APPLYING 19C OCT19 PATCHES

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

30413137;ORA-00600  INTERNAL ERROR CODE, ARGUMENTS  [2006]

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

- standby

[grid@standby OPatch]$ ./opatch lspatches

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

[TEST]oracle@standby:/home/oracle# opatch lspatches

29997959;DSTV34 UPDATE - TZDATA2019B - NEED OJVM FIX

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump (Doc ID 286496.1) 참조

뭔가 문제가 있어 expdp 또는 impdp 가 잘 수행되지 않을때 Debug 해서 분석하는 방법

1) spfile 에 설정하는 방법

1. 설정 후 재기동

ALTER SYSTEM SET EVENT = '39089 trace name context forever, level 0x300'  SCOPE = spfile; 

shutdown immedite

startup

2. 확인

SHOW PARAMETER event

NAME                                 TYPE        VALUE

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

event                                string      39089 trace name context forever, level 0x300

3. 제거 후 재기동                                                 

 ALTER SYSTEM RESET EVENT SCOPE = spfile SID='*';  

shutdown immedite

startup

2)  system level에서 설정하는 작업

-- Enable event

ALTER SYSTEM SET EVENTS = '39089 trace name context forever, level 0x300' ;

-- Disable event

ALTER SYSTEM SET EVENTS = '39089 trace name context off' ;

3) 생성된 trace 화일 확인

BACKGROUND_DUMP_DEST 또는 USER_DUMP_DEST 아래에 생성됨.

.1 Data Pump Master Control Process (MCP).

Format : <SID>_dm<number>_<process_id>.trc

2. Data Pump Worker Process trace file.

Format : <SID>_dw<number>_<process_id>.trc

3. Data Pump Shadow Process trace file.

Format : <SID>_ora_<process_id>.trc

- Single instance 구성

[TEST1]oracle@rac011:/home/oracle# rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 11 09:57:00 2020

Version 19.7.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST (DBID=2345177335)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TEST_ICN1XM are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; # 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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/TEST_ICN1XM/controlfile/snapcf_test_icn1xm.f';

- dataguard 구성후 primary

standby와 비교하면 archive deletion policy 만 다르고 나머지는 동일하다.

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TEST_PHX1JG are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

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

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

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

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

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

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

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

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G FORMAT   '%d_%I_%U_%T_%t' PARMS  'SBT_LIBRARY=/opt/oracle/dcs/commonstore/pkgrepos/oss/odbcs/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/objectstore/opc_pfile/2347090681/opc_TEST_phx1jg.ora)';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE ON;

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE' APPLIED ON ALL STANDBY;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/TEST_PHX1JG/controlfile/snapcf_test_phx1jg.f';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/test_phx1jg/controlfile/snapcf_test_phx1jg.f';

- dataguard 구성후 standby

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TEST_PHX2MM are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

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

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

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

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

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

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

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

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G FORMAT   '%d_%I_%U_%T_%t' PARMS  'SBT_LIBRARY=/opt/oracle/dcs/commonstore/pkgrepos/oss/odbcs/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/objectstore/opc_pfile/2347090681/opc_TEST_phx1jg.ora)';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE ON;

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/TEST_PHX1JG/controlfile/snapcf_test_phx1jg.f';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/test_phx1jg/controlfile/snapcf_test_phx1jg.f';

약간 다르지만 우리가 흔히 알고 있는 NAS 를 Oracle Cloud 에서는 FSS(File Storage) 라는 이름으로 서비스 하고 있음.

- IaaS 나 dbcs 에 attach 하는 방법

1. File Storage -> Mount Target 에서 file storage 생성

2. 해당 VCN에 아래와 같은 Security list 추가하고 포트 오픈

Stateful ingress to TCP ports 111, 2048, 2049, 2050, and UDP ports 111 and 2048

Stateful egress for TCP source ports 111, 2048, 2049, 2050, and UDP source port 111

2. 대상 DBCS에 tool 설치 및 mount 작업

- opc 유저에서

sudo yum install nfs-utils

sudo mkdir -p /EXPORT

sudo mount 10.0.0.7:/EXPORT /EXPORT

3. df -k 로 mount point 확인

영구적으로 /etc/fstab 반영

10.10.3.6:/u03 /u03 nfs defaults,nofail,nosuid,resvport 0 0

Oracle Cloud DBCS에 대한 최신자료도 거의 없고해서 답답해서 직접 작성했습니다.

2020년 7월 현재 기준 Oracle Cloud 상에서 DBCS 서비스로 DB 생성하는 내용입니다.

Oracle Cloud DBCS생성_20200717.pdf

11.2.0.4 dbca 옵션

dbca -help

dbca  [-silent | -progressOnly | -customCreate] {<command> <options> }  | { [<command> [options] ] -responseFile  <response file > } [-continueOnNonFatalErrors <true | false>]

Please refer to the manual for details.

You can enter one of the following command:

Create a database by specifying the following parameters:

        -createDatabase

                -templateName <name of an existing template in default location or the complete template path>

                [-cloneTemplate]

                -gdbName <global database name>

                [-sid <database system identifier>]

                [-sysPassword <SYS user password>]

                [-systemPassword <SYSTEM user password>]

                [-emConfiguration <CENTRAL|LOCAL|ALL|NONE>

                        -dbsnmpPassword <DBSNMP user password>

                        -sysmanPassword <SYSMAN user password>

                        [-hostUserName <Host user name for EM backup job>

                         -hostUserPassword <Host user password for EM backup job>

                         -backupSchedule <Daily backup schedule in the form of hh:mm>]

                        [-centralAgent <Enterprise Manager central agent home>]]

                [-disableSecurityConfiguration <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                [-datafileDestination <destination directory for all database files> |  -datafileNames <a text file containing database objects such as controlfiles, tablespaces, redo log files and spfile to their corresponding raw device file names mappings in name=value format.>]

                [-redoLogFileSize <size of each redo log file in megabytes>]

                [-recoveryAreaDestination <destination directory for all recovery files>]

                [-datafileJarLocation  <location of the data file jar, used only for clone database creation>]

                [-storageType < FS | ASM > 

                        [-asmsnmpPassword     <ASMSNMP password for ASM monitoring>]

                         -diskGroupName   <database area disk group name>

                         -recoveryGroupName       <recovery area disk group name>

                [-characterSet <character set for the database>]

                [-nationalCharacterSet  <national character set for the database>]

                [-registerWithDirService <true | false> 

                        -dirServiceUserName    <user name for directory service>

                        -dirServicePassword    <password for directory service >

                        -walletPassword    <password for database wallet >]

                [-listeners  <list of listeners to configure the database with>]

                [-variablesFile   <file name for the variable-value pair for variables in the template>]]

                [-variables  <comma separated list of name=value pairs>]

                [-initParams <comma separated list of name=value pairs>]

                [-sampleSchema  <true | false> ]

                [-memoryPercentage <percentage of physical memory for Oracle>]

                [-automaticMemoryManagement ]

                [-totalMemory <memory allocated for Oracle in MB>]

                [-databaseType <MULTIPURPOSE|DATA_WAREHOUSING|OLTP>]]

Configure a database by specifying the following parameters:

        -configureDatabase

                -sourceDB    <source database sid>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

                [-registerWithDirService|-unregisterWithDirService|-regenerateDBPassword <true | false> 

                        -dirServiceUserName    <user name for directory service>

                        -dirServicePassword    <password for directory service >

                        -walletPassword    <password for database wallet >]

                [-disableSecurityConfiguration <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                [-enableSecurityConfiguration <true|false>

                [-emConfiguration <CENTRAL|LOCAL|ALL|NONE>

                        -dbsnmpPassword <DBSNMP user password>

                        -sysmanPassword <SYSMAN user password>

                        [-hostUserName <Host user name for EM backup job>

                         -hostUserPassword <Host user password for EM backup job>

                         -backupSchedule <Daily backup schedule in the form of hh:mm>]

                        [-centralAgent <Enterprise Manager central agent home>]]

Create a template from an existing database by specifying the following parameters:

        -createTemplateFromDB

                -sourceDB    <service in the form of <host>:<port>:<sid>>

                -templateName      <new template name>

                -sysDBAUserName     <user name  with SYSDBA privileges>

                -sysDBAPassword     <password for sysDBAUserName user name>

                [-maintainFileLocations <true | false>]

Create a clone template from an existing database by specifying the following parameters:

        -createCloneTemplate

                -sourceSID    <source database sid>

                -templateName      <new template name>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

                [-maintainFileLocations <true | false>]

                [-datafileJarLocation       <directory to place the datafiles in a compressed format>]

Generate scripts to create database by specifying the following parameters:

        -generateScripts

                -templateName <name of an existing template in default location or the complete template path>

                -gdbName <global database name>

                [-scriptDest       <destination for all the scriptfiles>]

Delete a database by specifying the following parameters:

        -deleteDatabase

                -sourceDB    <source database sid>

                [-sysDBAUserName     <user name  with SYSDBA privileges>

                 -sysDBAPassword     <password for sysDBAUserName user name>]

Query for help by specifying the following options: -h | -help

Oracle OCI VM Image에서 일어나는 현상임. (Custom Image인 경우 나타남)

증상 :

타임존과 시간을  KST +9:00 설정하여 사용중에 타임존은 유지되나 시간이 UTC인 +0:00 으로 Rollback 되는 현상

(windows2012 운영체제, Linux 는 해당 증상 없음)

Action Plan  :

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation/RealTimeIsUniversal 1 로 설정

또는

reg add "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation" /v RealTimeIsUniversal /d 1 /t REG_DWORD /f

- 설정된 값 확인은

reg query "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation" /s

-> 오라클에서 제공되는 Image 에는 RealTimeIsUniversal 값이 이미 포함되어 있으며 Custom Image 에는 포함되어 있지 않다.)

작업후 서버 리부팅.

- 확인할 사항

1. services.msc -> windows time service 가 자동기동이고 정상으로 실행되고 있는지 확인 (w32tm /query /status)

2. 조치후 리부팅 하여 일정시간 경과후 시간이 Rollback 되는지 모니터링

참고 문서 :

https://docs.aws.amazon.com/ko_kr/AWSEC2/latest/WindowsGuide/windows-set-time.html