Hello guys,
I am linux sysadmin&DBadmin.
At work I received SN200 1.6Tb NVME PCI-e SSD disk model:HUSMR7616BHP301 I have to put it in new server for data warehouse with OS:Oracle Linux 7.7 app: Oracle RDBMS 11R2, I have separate SATA SSD on which I installed OL7, format w/xfs no extra parameters no troubles, first week and few days no problems after that Oracle complain:
ORA-48178: error encountered while reading an ADR block file during ADR initializatio
n [/home/oracle/app/diag/rdbms/pobdw/pobdw/metadata/ADR_INTERNAL.mif]
ORA-48101: error encountered when attempting to read a file [block] [/home/oracle/app
/diag/rdbms/pobdw/pobdw/metadata/ADR_INTERNAL.mif] [0]
ORA-27072: File I/O error
Linux-x86_64 Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1
Thu Nov 7 16:26:50 2019
SMART are happy:
nvme smart-log /dev/nvme1n1
Smart Log for NVME device:nvme1n1 namespace-id:ffffffff
critical_warning : 0
temperature : 30 C
available_spare : 100%
available_spare_threshold : 10%
percentage_used : 0%
data_units_read : 45,741,946
data_units_written : 44,779,247
host_read_commands : 744,942,668
host_write_commands : 212,024,079
controller_busy_time : 2,598
power_cycles : 9
power_on_hours : 507
unsafe_shutdowns : 2
media_errors : 0
num_err_log_entries : 0
Warning Temperature Time : 0
Critical Composite Temperature Time : 0
Temperature Sensor 1 : 30 C
Temperature Sensor 2 : 23 C
Temperature Sensor 3 : 28 C
Temperature Sensor 4 : 30 C
Thermal Management T1 Trans Count : 0
Thermal Management T2 Trans Count : 0
Thermal Management T1 Total Time : 0
Thermal Management T2 Total Time : 0
no media error, no bad sectors.
nvme list report:
Node SN Model Namespace Usage Format FW Rev
---------------- -------------------- ---------------------------------------- --------- -------------------------- ---------------- --------
/dev/nvme1n1 SDM000073BEC HUSMR7616BHP301 1 1.60 TB / 1.60 TB 4 KiB + 0 B KNGND110
The last 2 days happened some weird things using dbca (Database Configuration Assistance) utility twice create database (apr. up to 6min) and twice report I/O error!
on same server same NVME disk.
I try to download hdm but no link received by email same as on first page(The download link for the requested software cannot be found. We will update our database soon and let you know when HGST Device Manager is available for download.).
I have hope to update firmware cos I found in HGST.pdf ver3.13 "HDM 3.4 requires that Firmware Version KMGNP110 or later be installed on the SN100 or SN150 Series SSDs; otherwise, the execution of the resize, reset-to-defaults and manage-name spaces commands will return an error."
Even couple of times shutdown/ startup (aka RDBMS start) and error "ORA-48178: error encountered while reading an ADR block file during ADR initialization" pop-up.
I test with 2nd disk same model same size and same problem persist. :-(
I had few other server with Oracle db using Samsung/Intel PCIe SSD and no troubles so far.
Server is new 2x Gold 6138 @ 2.00GHz Supermicro mobo X11DPi-N, BIOS is from 2019.