반응형

기존 상태 확인

[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   17M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/mapper/vg00-var_log_audit  1.9G   13M  1.8G   1% /var/log/audit
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdh                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
/dev/asm/commonstore-62          10G  329M  9.7G   4% /opt/oracle/dcs/commonstore
/dev/asm/volume1-62              10G  329M  9.7G   4% /u02
tmpfs                           6.3G     0  6.3G   0% /run/user/0
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.DATA.VOLUME1.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       one19c                   STABLE
ora.chad
               ONLINE  ONLINE       one19c                   STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       one19c                   mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.data.volume1.acfs
               ONLINE  ONLINE       one19c                   mounted on /u02,STAB
                                                             LE
ora.net1.network
               ONLINE  ONLINE       one19c                   STABLE
ora.ons
               ONLINE  ONLINE       one19c                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       one19c                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.cvu
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c.vip
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c_icn153.db
      1        ONLINE  ONLINE       one19c                   Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       one19c                   STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/u02
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Tue Sep 27 14:39:52 2022
    mount time:      Wed Sep 28 08:59:50 2022
    mount sequence number: 0
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   10737418240  (  10.00 GB )
    total free:   10392436736  (   9.68 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/volume1-62
        label:
        state:                 Available
        major, minor:          251, 31746
        logical sector size:   512
        size:                  10737418240  (  10.00 GB )
        free:                  10392436736  (   9.68 GB )
        metadata read I/O count:         2090
        metadata write I/O count:        10
        total metadata bytes read:       8560640  (   8.16 MB )
        total metadata bytes written:    40960  (  40.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED

/opt/oracle/dcs/commonstore
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Mon Sep 26 09:59:48 2022
    mount time:      Wed Sep 28 08:59:50 2022
    mount sequence number: 1
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   10737418240  (  10.00 GB )
    total free:   10392502272  (   9.68 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/commonstore-62
        label:
        state:                 Available
        major, minor:          251, 31745
        logical sector size:   512
        size:                  10737418240  (  10.00 GB )
        free:                  10392502272  (   9.68 GB )
        metadata read I/O count:         2111
        metadata write I/O count:        10
        total metadata bytes read:       8646656  (   8.25 MB )
        total metadata bytes written:    40960  (  40.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   236248                0          236248              0             Y  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   257020                0          257020              0             N  RECO/
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
               ONLINE  ONLINE       one19c                   mounted on /u02,STAB
                                                             LE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 28 09:24:08 2022 Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> col volume_name for a20
SQL> col volume_device for a50
SQL> set linesize 150
SQL> SELECT volume_name, volume_device FROM V$ASM_VOLUME;
VOLUME_NAME          VOLUME_DEVICE
-------------------- --------------------------------------------------
COMMONSTORE          /dev/asm/commonstore-62
VOLUME1              /dev/asm/volume1-62
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0
[grid@one19c ~]$
[grid@one19c ~]$

ACFS 삭제 

--ACFS FIlesystem Resources 중지
[grid@one19c ~]$ srvctl stop filesystem -volume VOLUME1 -diskgroup DATA
--ACFS Filesystem Resources 삭제
[root@one19c bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]#
[root@one19c bin]#
[root@one19c bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]# pwd
/u01/app/19.0.0.0/grid/bin
[root@one19c bin]# ./srvctl remove filesystem  -volume VOLUME1 -diskgroup DATA
[root@one19c bin]# ./crsctl status res ora.data.volume1.acfs -t
CRS-2613: Could not find resource 'ora.data.volume1.acfs'.
[root@one19c bin]# ./crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.DATA.VOLUME1.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       one19c                   STABLE
ora.chad
               ONLINE  ONLINE       one19c                   STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       one19c                   mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       one19c                   STABLE
ora.ons
               ONLINE  ONLINE       one19c                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       one19c                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.cvu
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c.vip
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c_icn153.db
      1        ONLINE  ONLINE       one19c                   Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       one19c                   STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------
[root@one19c bin]#
[root@one19c bin]#
[root@one19c bin]# ./asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   236248                0          236248              0             Y  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   257020                0          257020              0             N  RECO/
[root@one19c bin]#
--ACFS Volume 삭제
[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd volinfo --all
Diskgroup Name: DATA
         Volume Name: COMMONSTORE
         Volume Device: /dev/asm/commonstore-62
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /opt/oracle/dcs/commonstore

         Volume Name: VOLUME1
         Volume Device: /dev/asm/volume1-62
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /u02
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd voldelete -G DATA VOLUME1
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd volinfo --all
Diskgroup Name: DATA

         Volume Name: COMMONSTORE
         Volume Device: /dev/asm/commonstore-62
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /opt/oracle/dcs/commonstore

[grid@one19c ~]$
[grid@one19c ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   246492                0          246492              0             Y  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304    262144   257020                0          257020              0             N  RECO/
[grid@one19c ~]$
[grid@one19c ~]$ exit
logout
[root@one19c /]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c /]# rm -rf /u02
[root@one19c /]#

 

반응형
반응형

Patch전 사전 확인

[root@one19c ~]# cliadm update-dbcli
Job details
----------------------------------------------------------------
                     ID:  fe8c68e7-4f63-41af-bebb-23b0901ffccb
            Description:  DcsCli patching
                 Status:  Created
                Created:  September 26, 2022 11:17:59 AM KST
                Message:  Dcs cli will be updated
Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------

[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.3.2.1.0
Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
GI                                        19.15.0.0.0           19.16.0.0
DB                                        19.15.0.0.0           19.16.0.0
[root@one19c ~]#
[root@one19c ~]# dbcli describe-latestpatch
componentType   availableVersion
--------------- --------------------
gi              12.2.0.1.220719
gi              12.1.0.2.220719
gi              18.16.0.0.0
gi              19.16.0.0.0
gi              21.7.0.0.0
db              11.2.0.4.220719
db              12.2.0.1.220719
db              12.1.0.2.220719
db              18.16.0.0.0
db              19.16.0.0.0
db              21.7.0.0.0
[root@one19c ~]#
[root@one19c ~]# su - grid
Last login: Mon Sep 26 11:17:11 KST 2022
[grid@one19c ~]$ cd $ORACLE_HOME/OPatch
[grid@one19c OPatch]$ pwd
/u01/app/19.0.0.0/grid/OPatch
[grid@one19c OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.32
OPatch succeeded.
[grid@one19c OPatch]$ ./opatch lspatches -oh /u01/app/19.0.0.0/grid
33610957;OCW Interim patch for 33610957
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
33810130;JDK BUNDLE PATCH 19.0.0.0.220419
33911149;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33911149)
33815607;ACFS RELEASE UPDATE 19.15.0.0.0 (33815607)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@one19c OPatch]$ exit
[root@one19c ~]#
[root@one19c ~]# su - oracle
Last login: Mon Sep 26 11:20:21 KST 2022 on pts/0
[oracle@one19c ~]$ cd $ORACLE_HOME/OPatch
[oracle@one19c OPatch]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch
[oracle@one19c OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.30
OPatch succeeded.
[oracle@one19c OPatch]$ ./opatch lspatches -oh /u01/app/oracle/product/19.0.0.0/dbhome_1
34096213;Fix for Bug 34096213
33810360;CVE-2021-45943 REPORTED IN (OPEN SOURCE GEOSPATIAL FOUNDATION/GEOSPATIAL DATA ABSTRACTION LIBRARY/OPENGIS SIMPLE FEATURES REFERENCE IMPLEMENTATION (GDAL/OGR)/3.3.0)
34088989;ONE-OFF REQUEST FOR DELETE DIR FOR SUPTOOLS/TFA + SUPTOOLS/ORACHK + SUPTOOLS/ORACHK.ZIP FROM DB PSU/BP/RU/RUR
33809062;TRACKING BUG FOR REGRESSION RTI 24544369 CAUSED BY PKNAGGS_BUG-32472737 APPROVED/INCLUDED IN 21.0.0.0 ADBSBP
33613829;RDBMS - DSTV37 UPDATE - TZDATA2021E
32327201;RDBMS - DSTV36 UPDATE - TZDATA2020E
31335037;RDBMS - DSTV35 UPDATE - TZDATA2020A
30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937
33808367;OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)
31732095;UPDATE PERL IN 19C DATABASE ORACLE HOME TO V5.32
33810130;JDK BUNDLE PATCH 19.0.0.0.220419
33815596;OCW RELEASE UPDATE 19.15.0.0.0 (33815596)
33806152;Database Release Update : 19.15.0.0.220419 (33806152)
OPatch succeeded.
[oracle@one19c OPatch]$ exit
logout
[root@one19c ~]#

Oracle GRID Patch

[root@one19c ~]# dbcli update-server -h
Usage: update-server [options]
  Options:
    --component, -c
      Component to update
    --help, -h
      get help
    --json, -j
      json output
    --local, -l
      Update Server Components Locally
    --node, -n
      Node to be updated
    --precheck, -p
      Only Analyze the patch
    --version, -v
      Version to be updated
[root@one19c ~]#
[root@one19c ~]# dbcli update-server -p
{
  "jobId" : "88bb70c4-c738-43f2-875d-c643213ebc36",
  "status" : "Created",
  "message" : null,
  "errorCode" : "",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 11:24:33 AM KST",
  "resourceList" : [ ],
  "description" : "Server Patching Prechecks",
  "updatedTime" : "September 26, 2022 11:24:33 AM KST",
  "percentageProgress" : "0%",
  "cause" : null,
  "action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli update-server
{
  "jobId" : "2fd66f64-23ae-4db4-999d-2467d1c35981",
  "status" : "Created",
  "message" : null,
  "errorCode" : "",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 11:25:26 AM KST",
  "resourceList" : [ ],
  "description" : "Server Patching",
  "updatedTime" : "September 26, 2022 11:25:26 AM KST",
  "percentageProgress" : "0%",
  "cause" : null,
  "action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 2fd66f64-23ae-4db4-999d-2467d1c35981
Job details
----------------------------------------------------------------
                     ID:  2fd66f64-23ae-4db4-999d-2467d1c35981
            Description:  Server Patching
                 Status:  Waiting
                Created:  September 26, 2022 11:25:26 AM KST
               Progress:  0%
                Message:
             Error Code:

Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 2fd66f64-23ae-4db4-999d-2467d1c35981
Job details
----------------------------------------------------------------
                     ID:  2fd66f64-23ae-4db4-999d-2467d1c35981
            Description:  Server Patching
                 Status:  Success
                Created:  September 26, 2022 11:25:26 AM KST
               Progress:  100%
                Message:
             Error Code:

Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching                                       September 26, 2022 11:29:14 AM KST  September 26, 2022 11:30:31 AM KST  Success
Server Patching                                                          September 26, 2022 11:30:31 AM KST  September 26, 2022 11:49:45 AM KST  Success
[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
GI                                        19.16.0.0.0           up-to-date
DB                                        19.15.0.0.0           19.16.0.0
[root@one19c ~]#

Oracle Database Patch

[root@one19c ~]# dbcli list-dbhomes
ID                                       Name                 DB Version                               Home Location                                 Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612     OraDB19000_home1     19.15.0.0.0                              /u01/app/oracle/product/19.0.0.0/dbhome_1     Configured
[root@one19c ~]#
[root@one19c ~]# dbcli update-dbhome -h
Usage: update-dbhome [options]
  Options:
    --cloneOcid, -o
      clone OCID
    --cloneType, -cc
      Clone type
    --cloneVersion, -cv
      cloneVersion
  * --dbhomeid, -i
      Db home to be updated
    --help, -h
      get help
    --json, -j
      json output
    --local, -l
      Update Db home Locally
    --node, -n
      Node to be updated
    --parUrl, -pu
      par Url
    --precheck, -p
      Only Analyze the patch
    --sha256sum, -ss
      sha256sum
    --version, -v
      Patch version to be updated
[root@one19c ~]#
[root@one19c ~]# dbcli update-dbhome -i 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612
{
  "jobId" : "9ab958f6-93bb-4238-b996-5b97f039ab1f",
  "status" : "Created",
  "message" : null,
  "errorCode" : "",
  "reports" : [ ],
  "createTimestamp" : "September 26, 2022 12:28:26 PM KST",
  "resourceList" : [ ],
  "description" : "Database inplace image patching with dbhomeId : 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612",
  "updatedTime" : "September 26, 2022 12:28:27 PM KST",
  "percentageProgress" : "0%",
  "cause" : null,
  "action" : null
}
[root@one19c ~]#
[root@one19c ~]# dbcli describe-job -i 9ab958f6-93bb-4238-b996-5b97f039ab1f

Job details
----------------------------------------------------------------
                     ID:  9ab958f6-93bb-4238-b996-5b97f039ab1f
            Description:  Database inplace image patching with dbhomeId : 5d519ce8-5ae6-4f4f-a4a6-bd0dd63a1612
                 Status:  Success
                Created:  September 26, 2022 12:28:26 PM KST
               Progress:  100%
                Message:
             Error Code:

Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Precheck DBHome patching tasks                                           September 26, 2022 12:28:27 PM KST  September 26, 2022 12:31:53 PM KST  Success
DBHome patching                                                          September 26, 2022 12:31:53 PM KST  September 26, 2022 12:44:18 PM KST  Success
Post DBHome patching tasks                                               September 26, 2022 12:44:18 PM KST  September 26, 2022 12:49:31 PM KST  Success

[root@one19c ~]#
[root@one19c ~]#
[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
GI                                        19.16.0.0.0           up-to-date
DB                                        19.16.0.0.0           up-to-date
[root@one19c ~]#

Patch결과 확인

[root@one19c ~]# dbcli describe-component
System Version
---------------
22.2.3.1.0
Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
GI                                        19.16.0.0.0           up-to-date
DB                                        19.16.0.0.0           up-to-date

[root@one19c ~]#
[root@one19c ~]# su - grid
Last login: Mon Sep 26 13:02:52 KST 2022 on pts/0
[grid@one19c ~]$ cd $ORACLE_HOME/OPatch
[grid@one19c OPatch]$ pwd
/u01/app/19.0.0.0/grid/OPatch
[grid@one19c OPatch]$ ./opatch lspatches -oh /u01/app/19.0.0.0/grid
34122773;OCW Interim patch for 34122773
34113634;JDK BUNDLE PATCH 19.0.0.0.220719
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
34318175;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34318175)
34139601;ACFS RELEASE UPDATE 19.16.0.0.0 (34139601)
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
[grid@one19c OPatch]$
[grid@one19c OPatch]$ exit
logout
[root@one19c ~]# su - oracle
Last login: Mon Sep 26 13:03:09 KST 2022
[oracle@one19c ~]$ cd $ORACLE_HOME/OPatch
[oracle@one19c OPatch]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch
[oracle@one19c OPatch]$ ./opatch lspatches -oh /u01/app/oracle/product/19.0.0.0/dbhome_1
33303486;UNPLUG/PLUG A PLUGGABLE DATABASE MOVE DO A COPY AND NEED DOUBLE SPACE IN ASM.
29780459;INCREASE _LM_RES_HASH_BUCKET AND BACK OUT CHANGES FROM THE BUG 29416368 FIX
34006650;DSTV38 UPDATE - TZDATA2022A - NEED OJVM FIX
34006614;RDBMS - DSTV38 UPDATE - TZDATA2022A
33613829;RDBMS - DSTV37 UPDATE - TZDATA2021E
34113634;JDK BUNDLE PATCH 19.0.0.0.220719
32327201;RDBMS - DSTV36 UPDATE - TZDATA2020E
31335037;RDBMS - DSTV35 UPDATE - TZDATA2020A
30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937
33912872;DATABASE PERL UPDATE IN 19C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
34086870;OJVM RELEASE UPDATE: 19.16.0.0.220719 (34086870)
34160635;OCW RELEASE UPDATE 19.16.0.0.0 (34160635)
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
OPatch succeeded.
[oracle@one19c OPatch]$
[oracle@one19c OPatch]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 26 13:05:59 2022 Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> SET LINESIZE 400
SQL> COLUMN ACTION_TIME FORMAT A20
SQL> COLUMN ACTION FORMAT A10
SQL> COLUMN STATUS FORMAT A10
SQL> COLUMN DESCRIPTION FORMAT A60
SQL> COLUMN VERSION FORMAT A10
SQL> SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
  2  ,ACTION ,STATUS ,DESCRIPTION ,SOURCE_VERSION ,TARGET_VERSION ,PATCH_ID
  3  FROM DBA_REGISTRY_SQLPATCH
  4  ORDER BY ACTION_TIME;
ACTION_TIME          ACTION     STATUS     DESCRIPTION                                                  SOURCE_VERSION  TARGET_VERSION    PATCH_ID
-------------------- ---------- ---------- ------------------------------------------------------------ --------------- --------------- ----------
20220501 20:01:24    APPLY      SUCCESS    OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)             19.1.0.0.0      19.1.0.0.0        33808367
20220501 20:01:24    APPLY      SUCCESS    Database Release Update : 19.15.0.0.220419 (33806152)        19.1.0.0.0      19.15.0.0.0       33806152
20220926 12:48:24    ROLLBACK   SUCCESS    OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)             19.16.0.0.0     19.16.0.0.0       33808367
20220926 12:48:26    APPLY      SUCCESS    OJVM RELEASE UPDATE: 19.16.0.0.220719 (34086870)             19.15.0.0.0     19.15.0.0.0       34086870
20220926 12:48:26    APPLY      SUCCESS    Database Release Update : 19.16.0.0.220719 (34133642)        19.15.0.0.0     19.16.0.0.0       34133642
SQL> exit
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@one19c OPatch]$
반응형
반응형

기존 상태 확인

[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62         5.0G  319M  4.7G   7% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       one19c                   STABLE
ora.chad
               ONLINE  ONLINE       one19c                   STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       one19c                   mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       one19c                   STABLE
ora.ons
               ONLINE  ONLINE       one19c                   STABLE
ora.proxy_advm
               ONLINE  ONLINE       one19c                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                               STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       one19c                   STABLE
ora.cvu
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c.vip
      1        ONLINE  ONLINE       one19c                   STABLE
ora.one19c_icn153.db
      1        ONLINE  ONLINE       one19c                   Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       one19c                   STABLE
ora.scan1.vip
      1        OFFLINE OFFLINE                               STABLE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/opt/oracle/dcs/commonstore
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Mon Sep 26 09:59:48 2022
    mount time:      Tue Sep 27 08:48:23 2022
    mount sequence number: 0
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   5368709120  (   5.00 GB )
    total free:   5034442752  (   4.69 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/commonstore-62
        label:
        state:                 Available
        major, minor:          251, 31745
        logical sector size:   512
        size:                  5368709120  (   5.00 GB )
        free:                  5034442752  (   4.69 GB )
        metadata read I/O count:         2140
        metadata write I/O count:        10
        total metadata bytes read:       8765440  (   8.36 MB )
        total metadata bytes written:    40960  (  40.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED
[grid@one19c ~]$

기존 ACFS Resize

[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62         5.0G  319M  4.7G   7% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil size 10G /opt/oracle/dcs/commonstore
acfsutil size: new file system size: 10737418240 (10240MB)
[grid@one19c ~]$
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   19M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  256K   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62          10G  329M  9.7G   4% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/opt/oracle/dcs/commonstore
    ACFS Version: 19.0.0.0.0
    on-disk version:       49.0
    compatible.advm:       19.0.0.0.0
    ACFS compatibility:    19.0.0.0.0
    flags:        MountPoint,Available,KiloSnap
    creation time:   Mon Sep 26 09:59:48 2022
    mount time:      Tue Sep 27 08:48:23 2022
    mount sequence number: 0
    number of nodes:       1
    allocation unit:       4096
    metadata block size:   4096
    volumes:      1
    total size:   10737418240  (  10.00 GB )
    total free:   10392502272  (   9.68 GB )
    file entry table allocation: 262144
    primary volume: /dev/asm/commonstore-62
        label:
        state:                 Available
        major, minor:          251, 31745
        logical sector size:   512
        size:                  10737418240  (  10.00 GB )
        free:                  10392502272  (   9.68 GB )
        metadata read I/O count:         4278
        metadata write I/O count:        45
        total metadata bytes read:       17575936  (  16.76 MB )
        total metadata bytes written:    393216  ( 384.00 KB )
        ADVM diskgroup:        DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       unprotected
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED
    compression status: DISABLED
[grid@one19c ~]$

신규 ACFS 생성

[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd -p
ASMCMD [+] > volcreate -G DATA -s 10G VOLUME1
ASMCMD [+] >
ASMCMD [+] > volinfo -G DATA VOLUME1
Diskgroup Name: DATA

         Volume Name: VOLUME1
         Volume Device: /dev/asm/volume1-62
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage:
         Mountpath:

ASMCMD [+] > exit
[grid@one19c ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 27 14:34:20 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> col volume_name for a20
SQL> col volume_device for a50
SQL> set linesize 150
SQL> SELECT volume_name, volume_device FROM V$ASM_VOLUME;
VOLUME_NAME          VOLUME_DEVICE
-------------------- --------------------------------------------------
COMMONSTORE          /dev/asm/commonstore-62
VOLUME1              /dev/asm/volume1-62
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[grid@one19c ~]$
[grid@one19c ~]$ which mkfs
/usr/sbin/mkfs
[grid@one19c ~]$ ls -al /usr/sbin/mkfs
-rwxr-xr-x 1 root root 11520 Dec 10  2021 /usr/sbin/mkfs
[grid@one19c ~]$
[grid@one19c ~]$
[grid@one19c ~]$ mkfs -t acfs /dev/asm/volume1-62
mkfs.acfs: version                   = 19.0.0.0.0
mkfs.acfs: on-disk version           = 46.0
mkfs.acfs: volume                    = /dev/asm/volume1-62
mkfs.acfs: volume size               = 10737418240  (  10.00 GB )
mkfs.acfs: Format complete.
[grid@one19c ~]$ exit
[root@one19c /]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]#
[root@one19c /]# mkdir /u02
[root@one19c /]# chown oracle:oinstall /u02
[root@one19c /]# cd /u01/app/19.0.0.0/grid/bin
[root@one19c bin]# pwd
/u01/app/19.0.0.0/grid/bin
[root@one19c bin]#
[root@one19c bin]# ./srvctl add filesystem -device /dev/asm/volume1-62 -path /u02
[root@one19c bin]# ./crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
               OFFLINE OFFLINE      one19c                   STABLE
--------------------------------------------------------------------------------
[root@one19c bin]# su - grid
[grid@one19c ~]$ srvctl start filesystem -d /dev/asm/volume1-62
[grid@one19c ~]$ crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
               ONLINE  ONLINE       one19c                   mounted on /u02,STAB
                                                             LE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         32G     0   32G   0% /dev
tmpfs                            32G  845M   31G   3% /dev/shm
tmpfs                            32G   25M   32G   1% /run
tmpfs                            32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/vg00-root           9.6G  2.9G  6.2G  32% /
/dev/sda2                       488M  237M  216M  53% /boot
/dev/mapper/vg00-home           960M  2.7M  891M   1% /home
/dev/mapper/vg00-var            5.7G  156M  5.3G   3% /var
/dev/mapper/vg00-opt             39G  1.9G   36G   6% /opt
/dev/sda1                       128M  7.5M  121M   6% /boot/efi
/dev/mapper/vg00-var_log        3.8G   20M  3.6G   1% /var/log
/dev/mapper/vg00-var_log_audit  1.9G   12M  1.8G   1% /var/log/audit
tmpfs                            32G  4.0K   32G   1% /var/tmp
tmpfs                            32G  136M   32G   1% /tmp
/dev/sdi                        196G   33G  154G  18% /u01
tmpfs                           6.3G     0  6.3G   0% /run/user/102
/dev/asm/commonstore-62          10G  329M  9.7G   4% /opt/oracle/dcs/commonstore
tmpfs                           6.3G     0  6.3G   0% /run/user/1000
/dev/asm/volume1-62              10G  329M  9.7G   4% /u02
[grid@one19c ~]$
반응형

+ Recent posts

티스토리툴바