Online DBA

<<Back to Exadata Main Page Listing Exadata storage cells and their configuration info login to your Exadata Cell Server and execute below command # imageinfo Kernel version: 2.6.39-400.284.1.el6uek.x86_64 #1 SMP Mon Sep 12 19:26:25 PDT 20                                                                                                             16 x86_64 Cell version: OSS_12.1.2.3.3_LINUX.X64_161013 Cell rpm version: cell-12.1.2.3.3_LINUX.X64_16...

<<Back to Exadata Main Page How to Power On/off Oracle Exadata Machine Oracle Exadata machines can be powered on/off either by pressing the power button on front of the server or by logging in to the ILOM interface. Powering on servers using  button on front of the server The power on sequence is as follows. 1. Start Rack, including switches  Note:- Ensure the switches have had power applied for a few minutes to complete power on  configuration before starting Exadata Storage Servers 2.Start Exadata Storage Servers  Note:- Ensure all Exadata Storage Servers complete the boot process before starting the   database servers 3. Start Database Servers Powering On Servers Remotely using ILOM The ILOM can be accessed using the Web console, the command-line interface (CLI), IPMI, or SNMP. For example, to apply power to server dm01cel01 using IPMI, where dm01cel01-ilom is the host name of the ILOM for the serve...

<<Back to Exadata Main Page Exadata The disk has been confined and is in an offline state Error Description Data hard disk entered confinement offline status. The LUN 0_7 changed status to warning - confinedOffline. CellDisk changed status to normal - confinedOffline. All subsequent I/Os on this disk are failed immediately. Confinement tests will be run on the disk to determine if the disk should be dropped Checked the AlerHistory from the Cell # cellcli -e list alerthistory          2_1     2018-07-27T01:56:15+02:00       warning         "Data hard disk entered confinement offline status. The LUN 0_7 changed status to warning - confinedOffline. CellDisk changed status to normal - confinedOffline. All subsequent I/Os on this disk are failed immediately. Confinement tests will be run on the disk to determine if the disk should be dropped. St...

<<Back to Exadata Main Page What is IPMI tool ipmitool - utility for controlling IPMI-enabled devices. Its a technology that gives administrators almost total control over remotely deployed servers. IPMI let remote administrators monitor the health of servers, deploy (or remove) software, manage hardware peripherals like the keyboard and mouse, reboot the system and update software on it, independent of the operating system. You can use this utility to perform IPMI functions with a kernel device driver or over a LAN interface. It's a powerful protocol that is supported by many late model server hardware from major manufacturers like Dell, HP, Oracle and Lenovo. Note - Your server includes a number of IPMI-compliant sensors that measure things such as voltages, temperature ranges, and security latches that detect when the enclosure is opened. For a complete list of sensors, see your platform specific guide. How to check if a device is IPMI-enabled you can use dmideco...

<<Back to Exadata Main Page We got email alert from one dom0 machine in X5-2 Eighth Rack HC 8 TB: DiskControllerFirmwareRevision Unknown. Looks like LSI MegaRAID controler info cannot be fetched.  domU machines running under this dom0 are still working properly. # dbmcli -e list physicaldisk 252:0 B7G5GA normal 252:1 B7HPXA failed 252:2 B7J55A failed 252:3 B6RT7A failed # /opt/MegaRAID/MegaCli/MegaCli64 -adpallinfo -a0 | grep -i package   ]# <<<<<<------- BLANK ]# /opt/MegaRAID/MegaCli/MegaCli64 /c0 show termlog  Controller = 0 Status = Failure Description = Controller 0 not found Solution :Oracle engineer replaced this "suspected" RAID controller Further Issue: Even after replacing the RAID controller the Amber LED in the ILOM of on Exadata Compute nodes was not cleared. The solution is documented in  Doc ID 2111921.1 How to clear AMBER LED on Exadata Compute nodes when Compute Node disks report offline but no fault detected by R...

<<Back to Exadata Main Page If you are receiving notification like this, it means there is something wrong and you must take prompt action. Attribute Name DiskControllerModel Required LSI MegaRAID 9361-8i Found Unknown Attribute Name DiskControllerFirmwareRevision Required 24.3.0-0084 Found Unknown Quick Verification # dbmcli -e list physicaldisk 252:0 B7G5GA normal 252:1 B7HPXA failed 252:2 B7J55A failed 252:3 B6RT7A failed # /opt/MegaRAID/MegaCli/MegaCli64 -adpallinfo -a0 | grep -i package  # <<<<<<------- BLANK # /opt/MegaRAID/MegaCli/MegaCli64 /c0 show termlog  Controller = 0 Status = Failure Description = Controller 0 not found. IF ASR is in place manually open service request for oracle to investigate and fix the issue Solution in my case Oracle engineer replaced this "suspected" RAID controller. # dbmcli -e list physicaldisk ...

<<Back to Exadata Main Page What is Oracle Exadata The Oracle Exadata Database Machine is a combined compute and storage system marketed for running Oracle Database software. It primarily consists Storage Grid (Storage Machines) Compute Grid (Database Machines) Network Grid (Network Components) An oracle Exadata machine comes as Full Rack, Half Rack, Quarter Rack and Eighth Rack. An overview of hardware configuration and differences among them are presented in the below table Hardware Components of Oracle Exadata Database Machine Edition Oracle Exadata Database Machine Full Rack Oracle Exadata Database Machine Half Rack Oracle Exadata Database Machine Quarter Rack Oracle Exadata Database Machine Eighth Rack Oracle Exadata Database Machine X7-2 8 database servers 4 database servers 2 database servers 2 database servers. Each server has 1x 24-core processor with all 24-cores enabled 14 Exadata Storage Ser...