Soumya's Database Blog : November 2022

Various odacli commands for ODA

[root@oda02 ~]# odaadmcli show env_hw

BM ODA X7-2 Medium

[root@hkoda02 ~]# fwupdate list disk

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

CONTROLLER

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

ID Type Manufacturer Model Product Name FW Version BIOS Version EFI Version FCODE Version Package Version NVDATA Version XML Support

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

c0 HDC Intel 0xa182 0x4866 - - - - - - N/A

DISKS

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

ID Manufacturer Model ATA Model Chassis Slot Type Media Size(GiB) FW Version ATA FW Ver XML Support

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

c0d0 INTEL SSDSGFTG480G7 INTEL_SSDSCKJB874G7 - 1 sata SSD 447 0121 N2010121 N/A

c0d1 INTEL SSDSGFTG480G7 INTEL_SSDSCKJB874G7 - - sata SSD 447 0121 N2010121 N/A

[root@oda02 ~]# odaadmcli show server

Power State : On

Open Problems : 0

Model : ODA X7-2M

Type : Rack Mount

Part Number : ODA X7-2M

Serial Number : 19355THJ026

Primary OS : Not Available

ILOM Address : 172.10.38.191

ILOM MAC Address : 00:B0:E0:F9:12:F6

Description : Oracle Database Appliance X7-2 Medium 19355THJ026

Locator Light : Off

Actual Power Consumption : 256 watts

Ambient Temperature : 23.250 degree C

Open Problems Report : System is healthy

[root@hkoda02 ~]# odacli describe-component

System Version

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

19.15.0.0.0

System node Name

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

oda02

Local System Version

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

19.15.0.0.0

Component Installed Version Available Version

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

OAK

19.15.0.0.0 up-to-date

19.15.0.0.220419 up-to-date

DB {

[OraDB12102_home1]

12.1.0.2.190716 12.1.0.2.220419

[OraDB12102_home2]

12.1.0.2.220419 up-to-date

[OraDB19000_home1]

19.15.0.0.220419 up-to-date

}

DCSCONTROLLER

19.15.0.0.0 up-to-date

DCSCLI

19.15.0.0.0 up-to-date

DCSAGENT

19.15.0.0.0 up-to-date

DCSADMIN

19.15.0.0.0 up-to-date

7.9 up-to-date

ILOM

5.0.2.24.r141466 up-to-date

BIOS

41100500 up-to-date

LOCAL CONTROLLER FIRMWARE {

[c6]

80000690 80000681

[c7]

214.2.271.9 up-to-date

}

SHARED CONTROLLER FIRMWARE {

[c1,c2]

QDV1RF32 up-to-date

[c3,c4,c5]

VDV1RL04 up-to-date

}

LOCAL DISK FIRMWARE

0121 up-to-date

SHARED DISK FIRMWARE

0121 up-to-date

HMP

2.4.8.0.601 up-to-date

[root@oda02 ~]# odacli describe-dbsystem-image

DB System Image details

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

Component Name Supported Versions Available Versions

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

DBVM 19.15.0.0.0 not-available

GI 19.15.0.0.220419 19.15.0.0.220419

19.14.0.0.220118 not-available

19.13.0.0.211019 not-available

19.12.0.0.210720 not-available

19.11.0.0.210420 not-available

21.6.0.0.220419 not-available

21.5.0.0.220118 not-available

21.4.0.0.211019 not-available

21.3.0.0.210720 not-available

DB 19.15.0.0.220419 19.15.0.0.220419

19.14.0.0.220118 not-available

19.13.0.0.211019 not-available

19.12.0.0.210720 not-available

19.11.0.0.210420 not-available

21.6.0.0.220419 not-available

21.5.0.0.220118 not-available

21.4.0.0.211019 not-available

21.3.0.0.210720 not-available

[root@oda02 ~]# odaadmcli show fs

Type Total Space Free Space Total DG Space Free DG Space Diskgroup Mount Point

acfs 5120M 4801M 24419840M 9252364M DATA /opt/oracle/dcs/commonstore

acfs 153600M 118108M 24419840M 9252364M DATA /opt/oracle/oak/pkgrepos/orapkgs/clones

acfs 10240M 8409M 24419840M 9252364M DATA /u01/app/odaorabase0

acfs 81920M 30011M 24419840M 9252364M DATA /u01/app/odaorahome

[root@oda02 ~]# odacli list-jobs

ID Description Created Status

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

7d552349-af92-4bb0-833e-f19168bef783 Repository Update July 27, 2022 5:59:25 AM HKT Success

9e4d4405-805a-4449-973a-ded6983a060a Repository Update July 27, 2022 6:58:53 AM HKT Success

5441d731-b434-4158-bc04-e16ae988b134 Repository Update July 27, 2022 7:16:46 AM HKT Success

fee90149-bd73-49a6-bb06-62a34534cb25 User creation(oda-admin) July 27, 2022 7:24:22 AM HKT Success

4675f8d7-6a4e-48d7-9434-ba0701600499 Restore node service - GI July 27, 2022 7:24:24 AM HKT Success

f6da68f6-cff2-4b67-b1f2-d835f304c35c Configure database home storage July 27, 2022 4:48:29 PM HKT Success

f1e7229c-1286-418a-8657-66b049dfbb13 Restore node service - Database July 27, 2022 4:52:40 PM HKT Created

27ccad9f-df93-4ac3-8e2d-3430c132ee2e Repository Update July 27, 2022 7:17:01 PM HKT Success

6b5f2338-cf2d-40cb-8991-7accd3733aec Restore node service - Database July 27, 2022 7:21:53 PM HKT Success

348df102-50c8-4e12-b8b0-c997a2af065f Database Home OraDB12102_home2 creation with version :12.1.0.2.220419 August 2, 2022 3:03:33 PM HKT Success

e9972ef8-86d1-4459-addc-2d46ff4352f3 Repository Update November 7, 2022 4:34:43 PM HKT Created

abf6f3b0-3470-4490-95c6-66190ae32628 Repository Update November 7, 2022 5:15:10 PM HKT Success

dd5beffe-388b-4d8c-bc3b-18370c9c8293 Database Home OraDB19000_home1 creation with version :19.15.0.0.220419 November 7, 2022 5:42:05 PM HKT Success

[root@oda02 ~]# odacli list-availablepatches

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

ODA Release Version Supported DB Versions Available DB Versions Supported Platforms

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

19.15.0.0.0 21.6.0.0.220419 Clone not available DB System

19.15.0.0.220419 19.15.0.0.220419 Bare Metal, DB System

12.1.0.2.220419 12.1.0.2.220419 Bare Metal

[root@oda02 ~]# odacli list-dbhome-storages

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

ID Node Description Disk Group Volume Size(GB) Status

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

040561b1-40c4-4fb1-8cb2-409e2898279e 0 ORACLE_HOME DATA orahome_sh 80 CONFIGURED

cb698aed-544e-407d-b5e2-a4e12a72ad71 0 ORACLE_BASE DATA odabase_n0 10 CONFIGURED

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

[root@oda02 ~]# odacli list-dbhomes

ID Name DB Version Home Location Status

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

a051cc7b-e678-44bc-be26-b03bda48c413 OraDB12102_home1 12.1.0.2.190716 /u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_1 CONFIGURED

f12ae9fd-165d-4550-bb0f-ef8f89a828b9 OraDB12102_home2 12.1.0.2.220419 /u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_2 CONFIGURED

e91973c3-b7b2-41df-a2b5-a80e8fca408c OraDB19000_home1 19.15.0.0.220419 /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED

[root@oda02 ~]# odaadmcli show disk

NAME PATH TYPE STATE STATE_DETAILS

pd_00 /dev/nvme0n1 NVD ONLINE Good

pd_01 /dev/nvme1n1 NVD ONLINE Good

pd_02 /dev/nvme4n1 NVD ONLINE Good

pd_03 /dev/nvme3n1 NVD ONLINE Good

pd_04 /dev/nvme2n1 NVD ONLINE Good

[root@oda02 ~]# odacli list-dgstorages

DiskGroup Redundancy Physical Total Space Physical Reserved Space Physical Free Space Logical Free Space

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

DATA NORMAL 23.28 TB 3.49 TB 8.82 TB 4.41 TB

RECO NORMAL 5.82 TB 894.0 GB 4.29 TB 2.14 TB

[root@oda02 ~]# odacli list-dbhome-storages

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

ID Node Description Disk Group Volume Size(GB) Status

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

040561b1-40c4-4fb1-8cb2-409e2898279e 0 ORACLE_HOME DATA orahome_sh 80 CONFIGURED

cb698aed-544e-407d-b5e2-a4e12a72ad71 0 ORACLE_BASE DATA odabase_n0 10 CONFIGURED

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

[root@oda02 ~]# odacli describe-cpucore

Node Cores Modified Job Status

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

0 10 July 27, 2022 7:46:41 AM HKT CONFIGURED

[root@hkoda02 ~]# odacli describe-system -b

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Env:-

DB : 12.1.0.2

GI: 19.0.0(Oracle restart)

OS: OEL 7

DB Type: Standalone Database

During execution of rman duplicate database following error is observed.

RMAN> run{

allocate auxiliary channel C1 DEVICE TYPE DISK;

allocate auxiliary channel C2 DEVICE TYPE DISK;

allocate auxiliary channel C3 DEVICE TYPE DISK;

allocate auxiliary channel C4 DEVICE TYPE DISK;

duplicate database to 'E1THS' backup location '/u01/rman18062021/databkp' nofilenamecheck;

}

Error details:-

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of sql command on clone_default channel at 11/07/2022 02:29:26

RMAN-20000: abnormal termination of job step

RMAN-11003: failure during parse/execution of SQL statement: alter system reset db_unique_name scope=spfile

RMAN-11001: Oracle Error:

ORA-32010: cannot find entry to delete in SPFILE

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of sql command on clone_default channel at 11/07/2022 02:29:06

RMAN-20000: abnormal termination of job step

RMAN-11003: failure during parse/execution of SQL statement: alter system set db_unique_name = 'E1THS' comment= 'Modified by RMAN duplicate' scope=spfile

RMAN-11001: Oracle Error:

ORA-32017: failure in updating SPFILE

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 11/07/2022 02:29:26

RMAN-05501: aborting duplication of target database

Rationale:-

This issue is reported as Bug 20977794 in MOS for Oracle 12.1.0.2 version.The error is observed during execution of rman duplicate database where any attempt to change DB_UNIQUE_NAME for database when a CRS resource for it exists. As RMAN tries to make a change to db_unique_name, this error is observed.

Solution :-

Remove the existing entry to database which is going to be cloned from CRS registry

[oracle@server004 dbs]$ srvctl config database

E1KRS

E1THS

[oracle@server004 dbs]$ srvctl remove database -db E1THS

Remove the database E1THS? (y/[n]) y

Now rerun the Rman duplicate command , it should work fine.

CRS-4013: This command is not supported in a single-node configuration.

Issue:-

[grid@hkgdbs004 bin]$ ./crsctl stop crs

CRS-4013: This command is not supported in a single-node configuration.

CRS-4000: Command Stop failed, or completed with errors.

Solution:-

There is no crs in standalone grid installation. Hence try shutting down Has Component

[grid@hkgdbs004 bin]$ ./crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'hkgdbs004'

CRS-2673: Attempting to stop 'ora.DATAC1.dg' on 'hkgdbs004'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'hkgdbs004'

CRS-2677: Stop of 'ora.DATAC1.dg' on 'hkgdbs004' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'hkgdbs004'

CRS-2673: Attempting to stop 'ora.RECOC1.dg' on 'hkgdbs004'

CRS-2677: Stop of 'ora.RECOC1.dg' on 'hkgdbs004' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'hkgdbs004'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'hkgdbs004' succeeded

CRS-2677: Stop of 'ora.evmd' on 'hkgdbs004' succeeded

CRS-2677: Stop of 'ora.asm' on 'hkgdbs004' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'hkgdbs004'

CRS-2677: Stop of 'ora.cssd' on 'hkgdbs004' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'hkgdbs004' has completed

CRS-4133: Oracle High Availability Services has been stopped.

ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution in this home.

So while applying patch on grid home(19c) we faced the above error

$ ./gridSetup.sh ApplyRU /u01/app/33803476

ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution in this home. Use a different home to proceed.

Solution:- In our last attempt to patch grid home , the opatch failed . So while retrying to after fixing the issue when retrying to apply the patch its throwing above error.

The only way to resolve this issue is to clean the contents of GRID HOME (e.g. rm -Rf <NEW_GRID_HOME>), then re-unzip the Grid Infrastructure binary on local node into the NEW_GRID_HOME path as GRID_HOME user.

$ rm -rf $GRID_HOME

$ unzip LINUX.X64_193000_grid_home.zip

And then retry to apply the patch again. It should work .