Skip to main content

OCI VMDB System : Apply GI PSU using dbcli

Environment : OCI VMDB System
OS : Oracle Linux 7

=> dbcli commands should be run as root user.

=> Update dcs client and agent 

[root@sitdb ~]# cliadm update-dbcli
Job details
----------------------------------------------------------------
                     ID:  1ac41360-f581-4ce8-b631-2b91e9ba1d64
            Description:  DcsCli patching
                 Status:  Created
                Created:  September 6, 2022 10:03:16 AM GST
                Message:  Dcs cli will be updated
Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------

[root@sitdb ~]# dbcli describe-job -i 1ac41360-f581-4ce8-b631-2b91e9ba1d64

Job details
----------------------------------------------------------------
                     ID:  1ac41360-f581-4ce8-b631-2b91e9ba1d64
            Description:  DcsCli patching
                 Status:  Success
                Created:  September 6, 2022 10:03:16 AM GST
               Progress:  100%
                Message:
             Error Code:
Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
[root@sitdb ~]# rpm -qa |grep dcs-cli
dcs-cli-22.3.1.0.0_220727.0606-1.x86_64
[root@sitdb ~]# rpm -qa |grep dcs-agent
dcs-agent-22.3.1.0.0_220727.0606-12.x86_64
[root@sitdb ~]#


=> Verify the latest version of GI available. In this case installed version is 19.15 and available version is 19.16


[root@sitdb ~]# 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@sitdb ~]# dbcli describe-component

System Version
---------------
22.3.1.0.0
Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
GI                                        19.15.0.0.0           19.16.0.0
DB                                        12.1.0.2.220419       12.1.0.2.220719
[root@sitdb ~]#


=> Run Pre Check 

[root@sitdb ~]# dbcli update-server --precheck

{
  "jobId" : "62323bb3-012a-41f6-8971-d95ff68e29e2",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "August 24, 2022 11:33:10 AM GST",
  "resourceList" : [ ],
  "description" : "Server Patching Prechecks",
  "updatedTime" : "August 24, 2022 11:33:10 AM GST",
  "percentageProgress" : "0%",
  "cause" : null,
  "action" : null
}
[root@sitdb ~]#

[root@sitdb ~]# dbcli describe-job -i 62323bb3-012a-41f6-8971-d95ff68e29e2

Job details
----------------------------------------------------------------
                     ID:  62323bb3-012a-41f6-8971-d95ff68e29e2
            Description:  Server Patching Prechecks
                 Status:  Success
                Created:  August 24, 2022 11:33:10 AM GST
               Progress:  100%
                Message:
Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching                                       August 24, 2022 11:33:10 AM GST     August 24, 2022 11:35:38 AM GST     Success
Server Patching                                                          August 24, 2022 11:35:38 AM GST     August 24, 2022 11:38:19 AM GST     Success
[root@sitdb ~]#

=> Apply Latest PSU to GI (Downtime Activity)

[root@sitdb ~]# dbcli update-server

{
  "jobId" : "ed3c3491-cafd-47e9-9eb9-642d78035cea",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "August 24, 2022 11:46:37 AM GST",
  "resourceList" : [ ],
  "description" : "Server Patching",
  "updatedTime" : "August 24, 2022 11:46:37 AM GST",
  "percentageProgress" : "0%",
  "cause" : null,
  "action" : null
}
[root@sitdb ~]#

[root@sitdb ~]# dbcli describe-job -i ed3c3491-cafd-47e9-9eb9-642d78035cea

Job details
----------------------------------------------------------------
                     ID:  ed3c3491-cafd-47e9-9eb9-642d78035cea
            Description:  Server Patching
                 Status:  Success
                Created:  August 24, 2022 11:46:37 AM GST
               Progress:  100%
                Message:
Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching                                       August 24, 2022 11:46:38 AM GST     August 24, 2022 11:48:24 AM GST     Success
Server Patching                                                          August 24, 2022 11:48:24 AM GST     August 24, 2022 12:14:00 PM GST     Success
[root@sitdb ~]#

[root@sitdb ~]# 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                                        12.1.0.2.220419       12.1.0.2.220719
[root@sitdb ~]#


Labels:

Comments

Post a Comment

Popular posts from this blog

Data Safe - Introduction

Oracle Data Safe - Practical Guide Oracle Data Safe learner guide Oracle Data Safe Assess risk, discover sensitive data, audit activity, and mask safely It focuses on what Data Safe helps you do operationally: review security posture, find risky identities, centralize auditing, locate sensitive data, and produce safer non-production copies. Contents 01 Why Data Safe matters 02 Where it fits 03 Capability map 04 Assessments 05 Activity Auditing 06 Discovery and Masking 07 Operating model 08 First 30 days 09 Knowledge check Section 01 Why Data Safe matters Database security work is often fragmented. One process checks configuration drift, another stores audit logs, another team scans for PII, and another team writes masking logic for test refreshes. Data Safe is useful because it turns those separate jobs into one security workflow. Key idea The best way to think about Data Safe is as a control plane for database security posture: assess the target, identify risky accounts, d...
Post a Comment
Read more

Testing Different Access Paths : Concatenated Index

Oracle Concatenated Indexes - Practical Deep Dive Oracle concatenated index deep dive Concatenated Indexes How composite indexes really work, why column order matters, and when skip scan changes the story Concatenated indexes, also called composite indexes, are easy to explain badly and surprisingly rich to explain well. The usual summary is “Oracle can use the index only when the leading column is present,” but that is only the starting point. To design them properly, you need to think about leading portions, equality versus range predicates, ordering requirements, skip scan eligibility, covering behavior, and whether one composite index can replace several single-column indexes in a given workload. Contents 01 What concatenated indexes are 02 Leading edge and leading portion 03 Why column order matters 04 Skip scan and when it helps 05 Access patterns and plan reading 06 Covering and sort elimination 07 Design rules that actually hold 08 Common mistakes 09 End-to-end demo 1...
Post a Comment
Read more

Database Replay - Real Application Testing (RAT)

Oracle Database Replay and RAT - Practical Deep Dive Oracle Database Replay deep dive Database Replay and Real Application Testing How to validate upgrades, patches, migrations, and risky changes with real workload behavior Database Replay is one of the most practical risk-reduction tools in the Oracle DBA toolbox. Instead of trusting synthetic benchmarks, isolated SQL tests, or intuition, you capture a real production workload, restore a test system to the same logical starting point, replay that workload, and analyze whether performance, errors, timing, and transactional behavior still look safe. Contents 01 What RAT actually is 02 Why Database Replay matters 03 End-to-end workflow 04 Capture design and prerequisites 05 Preprocess, calibrate, replay 06 Reading the results well 07 Pitfalls and unreplayable work 08 Database Replay vs SPA 09 Practical playbooks 10 Knowledge check Section 01 What Real Application Testing actually is Real Application Testing, usually shortened...
Post a Comment
Read more