Showing posts with label Storage Cell. Show all posts
Showing posts with label Storage Cell. Show all posts

Monday, October 1, 2018

cellcli -e list diskmap

The interesting LIST DISKMAP command in the storage cells links all views to hard disks:
PCI bus address as Name 252:5, OS name (/dev/sdh, for example), GridDisk name DATAC1_CD_05_ed01celadm10 ...

Example:

[root@ed01celadm10 ~]# cellcli -e list diskmap
Name       PhysicalSerial       SlotNumber              Status  PhysicalSize CellDisk         DevicePartition GridDisks
252:0      Q4WPNK               0                       normal  9124G        CD_00_ed01celadm10 /dev/sdc        "DATAC6_CD_00_ed01celadm10, RECOC6_CD_00_ed01celadm10"
252:1      Q56YJK               1                       normal  9124G        CD_01_ed01celadm10 /dev/sdd        "DATAC6_CD_01_ed01celadm10, RECOC6_CD_01_ed01celadm10"
252:2      Q599GK               2                       normal  9124G        CD_02_ed01celadm10 /dev/sde        "DATAC6_CD_02_ed01celadm10, RECOC6_CD_02_ed01celadm10"
252:3      Q573LK               3                       normal  9124G        CD_03_ed01celadm10 /dev/sdf        "DATAC6_CD_03_ed01celadm10, RECOC6_CD_03_ed01celadm10"
252:4      Q566UK               4                       normal  9124G        CD_04_ed01celadm10 /dev/sdg        "DATAC6_CD_04_ed01celadm10, RECOC6_CD_04_ed01celadm10"
252:5      Q575PK               5                       normal  9124G        CD_05_ed01celadm10 /dev/sdh        "DATAC6_CD_05_ed01celadm10, RECOC6_CD_05_ed01celadm10"
252:6      Q578AK               6                       normal  9124G        CD_06_ed01celadm10 /dev/sdi        "DATAC6_CD_06_ed01celadm10, RECOC6_CD_06_ed01celadm10"
252:7      Q59BYK               7                       normal  9124G        CD_07_ed01celadm10 /dev/sdj        "DATAC6_CD_07_ed01celadm10, RECOC6_CD_07_ed01celadm10"
252:8      Q551EK               8                       normal  9124G        CD_08_ed01celadm10 /dev/sdk        "DATAC6_CD_08_ed01celadm10, RECOC6_CD_08_ed01celadm10"
252:9      Q57PRK               9                       normal  9124G        CD_09_ed01celadm10 /dev/sdl        "DATAC6_CD_09_ed01celadm10, RECOC6_CD_09_ed01celadm10"
252:10     Q56NSK               10                      normal  9124G        CD_10_ed01celadm10 /dev/sdm        "DATAC6_CD_10_ed01celadm10, RECOC6_CD_10_ed01celadm10"
252:11     Q56J0K               11                      normal  9124G        CD_11_ed01celadm10 /dev/sdn        "DATAC6_CD_11_ed01celadm10, RECOC6_CD_11_ed01celadm10"
FLASH_10_1 PHLE7423009Q6P4BGN-1 "PCI Slot: 10; FDOM: 1" normal  2981G        FD_00_ed01celadm10 /dev/md310      "FLASHCACHE_FD_00_ed01celadm10, FLASHLOG_FD_00_ed01celadm10"
FLASH_10_2 PHLE7423009Q6P4BGN-2 "PCI Slot: 10; FDOM: 2" normal  2981G        FD_00_ed01celadm10 /dev/md310      "FLASHCACHE_FD_00_ed01celadm10, FLASHLOG_FD_00_ed01celadm10"
FLASH_4_1  PHLE742201RY6P4BGN-1 "PCI Slot: 4; FDOM: 1"  normal  2981G        FD_01_ed01celadm10 /dev/md304      "FLASHCACHE_FD_01_ed01celadm10, FLASHLOG_FD_01_ed01celadm10"
FLASH_4_2  PHLE742201RY6P4BGN-2 "PCI Slot: 4; FDOM: 2"  normal  2981G        FD_01_ed01celadm10 /dev/md304      "FLASHCACHE_FD_01_ed01celadm10, FLASHLOG_FD_01_ed01celadm10"
FLASH_5_1  PHLE742200MK6P4BGN-1 "PCI Slot: 5; FDOM: 1"  normal  2981G        FD_02_ed01celadm10 /dev/md305      "FLASHCACHE_FD_02_ed01celadm10, FLASHLOG_FD_02_ed01celadm10"
FLASH_5_2  PHLE742200MK6P4BGN-2 "PCI Slot: 5; FDOM: 2"  normal  2981G        FD_02_ed01celadm10 /dev/md305      "FLASHCACHE_FD_02_ed01celadm10, FLASHLOG_FD_02_ed01celadm10"
FLASH_6_1  PHLE742300C36P4BGN-1 "PCI Slot: 6; FDOM: 1"  normal  2981G        FD_03_ed01celadm10 /dev/md306      "FLASHCACHE_FD_03_ed01celadm10, FLASHLOG_FD_03_ed01celadm10"
FLASH_6_2  PHLE742300C36P4BGN-2 "PCI Slot: 6; FDOM: 2"  normal  2981G        FD_03_ed01celadm10 /dev/md306      "FLASHCACHE_FD_03_ed01celadm10, FLASHLOG_FD_03_ed01celadm10"




Wednesday, August 8, 2018

Is it possible to use '-' sign (dash/hyphen/minus) in the hostname of Exadata ?

 The problem started from error:

CellCLI> list cell
     ed04celadm01     online

CellCLI> alter cell name = ed04-celadm01;
                                ^
CELL-01504: Invalid command syntax.

CellCLI> alter cell name = 'ed04-celadm01';

CELL-00012: Name value is not valid. ASCII characters a-zA-Z_0-9 required.

CellCLI> alter cell name="dc1-exa1celadm01";

CELL-00012: Name value is not valid. ASCII characters a-zA-Z_0-9 required.


So, the query is: is this possible to use '-' (dash/hyphen/minus) in the Exadata hostname or not ?

As shown above, Oracle prohibit to use dash in the name.

But, in other side, one our customer (large bank) has corporate standard, which require prefix in hostname: LOCATION-EXADATA#-HOSTNAME, for example: dc1-exa1-celadm01  (dc is datacenter name). And they used its corporate standard for many years and have no problems with hostname. And they bought the Exadata. And we need to run this machine.

The documentation say nothing about allowed characters in Exadata hostnames.

We checked: OEDA allowed the '-' sign in the prefix.
So me decided to install Exadata with dash in the hostname.
And installation was successful !

What the matter, what is the difference ?
 
The investigation shows that all hostnames have '-' in the name:
10.18.82.11 dc1-exa1-dbadm01 dc1-exa1-dbadm01.corp.icba.biz
10.18.82.12 dc1-exa1-dbadm02 dc1-exa1-dbadm02.corp.icba.biz
10.18.82.13 dc1-exa1-celadm01 dc1-exa1-celadm01.corp.icba.biz
10.18.82.14 dc1-exa1-celadm02 dc1-exa1-celadm02.corp.icba.biz
10.18.82.15 dc1-exa1-celadm03 dc1-exa1-celadm03.corp.icba.biz
10.18.82.21 dc1-exa1-sw-adm01 dc1-exa1-sw-adm01.corp.icba.biz
10.18.82.22 dc1-exa1-sw-iba01 dc1-exa1-sw-iba01.corp.icba.biz
10.18.82.23 dc1-exa1-sw-ibb01 dc1-exa1-sw-ibb01.corp.icba.biz
10.18.82.24 dc1-exa1-sw-pdua01 dc1-exa1-sw-pdua01.corp.icba.biz
10.18.82.25 dc1-exa1-sw-pdub01 dc1-exa1-sw-pdub01.corp.icba.biz


But CELL NAME was different !

CellCLI> list cell
       dc1_exa1_celadm01  online


Look: Oracle internally put the _ instead of -

And all celldisk and griddisk names are of the same style:


CellCLI> LIST CELLDISK
       CD_00_dc1_exa1_celadm01  normal
       CD_01_dc1_exa1_celadm01  normal
...
       FD_00_dc1_exa1_celadm01  normal
       FD_01_dc1_exa1_celadm01  normal
       FD_02_dc1_exa1_celadm01  normal
       FD_03_dc1_exa1_celadm01  normal

CellCLI> LIST GRIDDISK
       DATAC1_CD_00_dc1_exa1_celadm01  active
       DATAC1_CD_01_dc1_exa1_celadm01  active
...
       RECOC1_CD_00_dc1_exa1_celadm01  active
       RECOC1_CD_01_dc1_exa1_celadm01  active

...


Conclusions:
- It is safe to use '-' in the hostname of the Exadata.
- Divide the HOST name and CELL name (name in cellcli)
- The sign '-' take 1 place. As you should know the Grid Disk Name is limited by 23 chars. Additional chars lead to overallocation (exceeding this limit). So, i recommend - avoid '-' in the host names.


Thursday, December 8, 2016

12-ТБ и 14-ТБ hard disks

Western Digital introduced 12T and 14T hard disks.

https://www.wdc.com/about-wd/newsroom/press-room/2016-12-06-western-digital-introduces-advanced-devices-to-manage-evolving-data-center-application-demands.html

Новые технологии в производстве жестких дисков до 2020 года:
http://fcenter.ru/online/hardnews/#material_id=39308

Western Digital: Мы не разрабатываем новые 10K и 15K жёсткие диски:
https://3dnews.ru/945263?from=most-commented-index

Tuesday, April 19, 2016

X6-2 1/8 new features: half disks and half flash removed

As we know in previous editions 1/8 Exadata = 1/4 Exadata by HW.
This means that storage servers had a 12 hard disks and 4 flash cards, but 6 hard disks and 2 flash cards were disabled. But they still were installed in the server.

In the X6-2 we have a new feature from Oracle:  "Eighth Rack HC storage servers have half the cores enabled and half the disks and flash cards removed."

This means that  X6-2 1/8 contain 6 hard disks and 2 flash cards.

The EF edition has the half flash cards disabled, but installed in the storage server.



http://www.oracle.com/technetwork/database/exadata/exadata-x6-2-ds-2968790.pdf

# ocrconfig -add +DATA PROT-30: The Oracle Cluster Registry location to be added is not usable. PROC-50: The Oracle Cluster Registry locatio...