How to configure yum repository server on OEL 6.5

Configure Linux yum server step by step

 What is YUM command?

YUM stands for Yellow dog Updater, Modified because it is based on YUP, the Yellow dog Updater. Yellow Dog is a version of Linux for the Power Architecture hardware. YUP, and later YUM, were written by the Linux community as a way to maintain an RPM-based system.

Uses of YUM Command?

Automatic resolution of software dependencies. If a package installation or upgrade request is made and requires the installation or upgrade of additional packages, YUM can list these dependencies and prompt the user to install or upgrade them.
Command-line and graphical versions. The command-line version can be run on a system with a minimal number of software packages. The graphical versions offer ease-of-use and a user-friendly graphical interface to software management.
Multiple software locations at one time. YUM can be configured to look for software packages in more than one location at a time.
Ability to specify particular software versions or architectures. Software locations accessible by YUM can contain multiple versions of the same RPM package and different builds for different architectures such as one for i686 and one for x86_64. yum can easily check the appropriate version and download it.
While it's unlikely that you'll have an Internet connection during the exam, you could have a network connection to a local repository. So you should be ready to use the yum command during the Red Hat exam.


YUM Server step by step configurations


STEP:-1

 Insert OEL 6.5 installation media in your computer and mount it into your PC.

to mount OEL 6.5 DVD into your PC, execute the following command

[root@test ~]#  mount /dev/cdrom /media

STEP:-2

 Go to "/media/Server/Packages/" directory and installed the required packages for YUM Server.

following packages are required for YUM Server :

vsftpd-2.2.2-6.el6.x86_64.rpm
deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
createrepo-0.9.8-4.el6.noarch.rpm

to go to "/media/Server/Packages/", use the following command

[root@test ~]#  cd /media/Server/Packages/

to install the above packages, execute the following command

# rpm -ivh vsftpd-2.2.2-6.el6.x86_64.rpm
# rpm -ivh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
# rpm -ivh python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
# rpm -ivh createrepo-0.9.8-4.el6.noarch.rpm 


[root@test Packages]# rpm -ivh vsftpd-2.2.2-11.el6_4.1.x86_64.rpm
warning: vsftpd-2.2.2-11.el6_4.1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
      package vsftpd-2.2.2-11.el6_4.1.x86_64 is already installed
[root@test Packages]# rpm -ivh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
warning: deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:deltarpm               ########################################### [100%]

[root@test Packages]# rpm -ivh python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
warning: python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:python-deltarpm        ########################################### [100%]
[root@test Packages]# rpm -ivh createrepo-0.9.9-18.0.1.el6.noarch.rpm
warning: createrepo-0.9.9-18.0.1.el6.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:createrepo             ########################################### [100%]

STEP:-3

 In the next step start the FTP Service.

to check the status of FTP Service execute the following command

[root@test ~]#  service vsftpd status

to start the FTP Service execute the following command

[root@test ~]#  service vsftpd start

to permanently start FTP Service execute the following command

[root@test ~]#  chkconfig vsftpd on

STEP:-4

 Now go to "/var/ftp/pub/" directory and then create a directory in it named "IT".

to go to "/var/ftp/pub/", execute the following command

[root@test ~]#  cd /var/ftp/pub/

to create a directory named IT, execute the following command

[root@test ~]#  mkdir IT

STEP:-5

 Copy the entire OEL 6 DVD in the "/var/ftp/pub/IT/" directory.

to copy the entire OEL 6.5 DVD in the "/var/ftp/pub/IT/", use the following command

[root@test ~]#  cp -rf  /media/*  /var/ftp/pub/IT/

STEP:-6 

Create the reposatory of  RPM Packages of  "/var/ftp/pub/IT/" directory.

to create the reposatory of RPM Packages, use the following command

[root@test ~]# createrepo -v /var/ftp/pub/IT/


Workers Finished
Gathering worker results

Saving Primary metadata
Saving file lists metadata
Saving other metadata
Generating sqlite DBs
Starting other db creation: Wed Jun 17 14:11:26 2015
Ending other db creation: Wed Jun 17 14:11:33 2015
Starting filelists db creation: Wed Jun 17 14:11:36 2015
Ending filelists db creation: Wed Jun 17 14:12:01 2015
Starting primary db creation: Wed Jun 17 14:12:02 2015
Ending primary db creation: Wed Jun 17 14:12:20 2015
Sqlite DBs complete

STEP:-7

 In the next step create the configuration file of YUM Server in "/etc/yum.repos.d/" directory and add the following line in it.

[server]
name=YUM-Server
baseurl=ftp://192.168.1.101/pub/IT
enabled=1
gpgcheck=0

Note :- where 192.168.1.101 is the IP address of your PC on which you configure YUM-Server.

to create the configuration file of YUM Server in "/etc/yum.repos.d/", use the following command

[root@test ~]# vi /etc/yum.repos.d/server.repo


[root@test yum.repos.d]# cat server.repo
[server]
name=YUM-Server
baseurl=ftp://192.168.1.115/pub/IT
enabled=1
gpgcheck=0
[root@test yum.repos.d]#

STEP:-8

 Now install any  packages using YUM-Server.

 to install any packages using YUM-Server, execute the following command

[root@test ~]# yum install <package-name>

[root@test ~]# yum install oracle-rdbms-server-12cR1-preinstall

*******************************************************************************************************

[root@sujeet ~]# yum install oracle-ebs-server-R12-preinstall

[root@sujeet yum.repos.d]# vi public-yum-ol6.repo

[ol6_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


[ol6_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1



memory for crash kernel 0x0 to 0x0 notwithin permissible range

Symptom
When the user finishes the RHEL5.7 operating system installation and enters into the operating system, a “Memory for crash kernel (0x0 to 0x0) notwithin permissible range” error message may appear as shown below:



Affected configurations
The above symptom is associated with, but not limited to, the following systems:
  • All ThinkServer systems
Applies to:
  • Red Hat Enterprise Linux 5
  • Red Hat Enterprise Linux 5 x64
Additional Information:

This is an informative message only. This message is displayed any time memory is not being reserved for use by the kdump kernel such as the crash kernel parameter is not being passed on the kernel command line.
Solution
If you are not happy with ignoring that message I am going to post here how to remove it. This is one way that it can be done, if you know some other way you are more than welcome to post it here.
My solution is simple, as root you just need to edit your grub configuration and remove the quite option from the kernel line as follows:
 cd /boot/grub/
vi grub.conf
before:
title CentOS (2.6.18-194.el5)
root (hd0,0)
kernel /vmlinuz-2.6.18-194.el5 ro root=/dev/VolGroup00/LogVol00 rhgb quiet
initrd /initrd-2.6.18-194.el5.img
after:
title CentOS (2.6.18-194.el5)
root (hd0,0)
kernel /vmlinuz-2.6.18-194.el5 ro root=/dev/VolGroup00/LogVol00 rhgb
initrd /initrd-2.6.18-194.el5.img
 That’s it, save, exit and reboot to check it:
# init 6

Running Virtualbox In A Xen Environment Is Not Supported


Kernel driver not installed (rc=-1908)” on Linux

I recently installed the latest version of Oracle Virtual-box (4.3.26) on Linux5.8

The installation goes fine, but when trying to run Virtualbox, it reports the following error.




Solution:-

How to install Oracle VirtualBox:
  a) Make sure that your system is up-to-date
  b) Install the packages needed to compile external modules
     # zypper in gcc make kernel-devel
     - Note: In my case, 'make' was already installed
  c) # zypper ar http://download.virtualbox.org/virtualbox/rpm/opensuse/11.4/ virtualbox
     # zypper ref -r virtualbox
     # zypper in VirtualBox-4.1
     - Note: Additional package to install: libpng12-0
  d) YaST > User and Group Management > Users > Edit > Details > Additional Groups > check "vboxusers" > OK > OK
  e) Install VirtualBox ExtensionPack (necessary for USB support)
     $ cd Downloads
     $ wget http://download.virtualbox.org/virtualbox/4.1.12/Oracle_VM_VirtualBox_Extension_Pack-4.1.12-77245.vbox-extpack
     # VBoxManage extpack install Oracle_VM_VirtualBox_Extension_Pack-4.1.12-77245.vbox-extpack
  f) Reboot (necessary because of step d)
  g) VirtualBox is now ready to use. After any kernel upgrade, you need to recompile the VBox kernel modules
     # /etc/init.d/vboxdrv setup




Check Database growth

To calculate the Data-file Growth on a yearly basis:
SQL> select to_char(CREATION_TIME,'RRRR') year,to_char(CREATION_TIME,'MM') month,round(sum(bytes)/1024/1024/1024) gb from v$datafile group by to_char(CREATION_TIME,'RRRR'),to_char(CREATION_TIME,'MM') order by 1,2;

YEAR MO         GB
---- -- ----------
2000 05          5
2000 12          1
2002 03          0
2002 05          1
2002 10          3
2003 01          2
2003 06          1
2003 11         19
2004 02          0
2004 03          0
2005 12          1

YEAR MO         GB
---- -- ----------
2007 01          5
2014 01         82

13 rows selected.
Take the sum of this two values which will be your total database size. Record this value daily/weekly/monthly basis and compare the difference.

SQL> select round((sum(bytes)/1048576/1024),2)
from V$tempfile;  2

ROUND((SUM(BYTES)/1048576/1024),2)
----------------------------------
                             46.07

SQL> select round((sum(bytes)/1048576/1024),2) from V$datafile;

ROUND((SUM(BYTES)/1048576/1024),2)
----------------------------------
                            119.66


column “Percent of Total Disk Usage” justify right format 999.99
column “Space Used (MB)” justify right format 9,999,999.99
column “Total Object Size (MB)” justify right format 9,999,999.99
set linesize 150
set pages 80
set feedback off
select * from (select to_char(end_interval_time, ‘MM/DD/YY’) mydate, sum(space_used_delta) / 1024 / 1024 “Space used (MB)”, avg(c.bytes) / 1024 / 1024 “Total Object Size (MB)”,
round(sum(space_used_delta) / sum(c.bytes) * 100, 2) “Percent of Total Disk Usage”
from
dba_hist_snapshot sn,
dba_hist_seg_stat a,
dba_objects b,
dba_segments c
where begin_interval_time > trunc(sysdate) – &days_back
and sn.snap_id = a.snap_id
and b.object_id = a.obj#
and b.owner = c.owner
and b.object_name = c.segment_name
and c.segment_name = ‘&segment_name’
group by to_char(end_interval_time, ‘MM/DD/YY’))
order by to_date(mydate, ‘MM/DD/YY’);



Weekly growth of database
set feedback off
set pages 80
set linesize 150
spool /tmp/weekly_growth.txt
ttitle “Total Disk Used”
select sum(space_used_delta) / 1024 / 1024 “Space used (M)”, sum(c.bytes) / 1024 / 1024 “Total Schema Size (M)”,
round(sum(space_used_delta) / sum(c.bytes) * 100, 2) || ‘%’ “Percent of Total Disk Usage”
from
dba_hist_snapshot sn,
dba_hist_seg_stat a,
dba_objects b,
dba_segments c
see code depot for full script
where end_interval_time > trunc(sysdate) – &days_back
and sn.snap_id = a.snap_id
and b.object_id = a.obj#
and b.owner = c.owner
and b.object_name = c.segment_name
and c.owner = ‘&schema_name’
and space_used_delta > 0;
title “Total Disk Used by Object Type”
select c.segment_type, sum(space_used_delta) / 1024 / 1024 “Space used (M)”, sum(c.bytes) / 1024 / 1024 “Total Space (M)”,
round(sum(space_used_delta) / sum(c.bytes) * 100, 2) || ‘%’ “Percent of Total Disk Usage”
from
dba_hist_snapshot sn,
dba_hist_seg_stat a,
dba_objects b,
dba_segments c
see code depot for full script
where end_interval_time > trunc(sysdate) – &days_back
and sn.snap_id = a.snap_id
and b.object_id = a.obj#
and b.owner = c.owner
and b.object_name = c.segment_name
and space_used_delta > 0
and c.owner = ‘&schema_name’
group by rollup(segment_type);
spool off

Through  OEM


Here are the steps to know Database growth pattern for last one month/year using OEM


1) Login to OEM and Click on the Reports Tab
2) Navigate to Reports–>Storage–>Oracle Database Space Usage path and Click on Oracle Database Space Usage link.
3) Select the Target database and here we are getting Oracle Database space usage for last one Month.
4) Also we can get one year Database growth by setting Set Time Period Button.
5) Also we can find Oracle Database Table-space Monthly Space Usage by Navigating Reports–>Storage–>Oracle Database Space Usage path and click on Oracle Database Table-space Monthly Space Usage link.
select sum(a.bytes+b.bytes)/1024/1024 "Total Size(MB)",sum(c.bytes)/1024/1024 "Used Space(MB)",sum(d.bytes)/1024/1024 "Free Space(MB)" from dba_data_files a,dba_temp_files b,dba_segments c,dba_free_space d;
Total Size(MB)                   Used Space(MB)              Free Space(MB)
--------------                   --------------              --------------
    1060137494                     528906                      28491086.3
 
 
The Total Size includes the size of Temporary tablespaces also, which is excluded in the rest two figures.

Scripts: Database,Table,Tablespace Growth Report using AWR

Hello
The following code snippets are collected from various sources and updating here, (not sure even about copy write of those, if any found so, I am happy to remove from here), until then we will try to use them.
Some background,  Oracle AWR by default collects the information about the segment growth periodically. This information can be queried using views DBA_HIST_SEG_STAT.
Script #1 : script to display table size changes between two periods. 
column "Percent of Total Disk Usage" justify right format 999.99 
column "Space Used (MB)" justify right format 9,999,999.99 
column "Total Object Size (MB)" justify right format 9,999,999.99 
set linesize 150 
set pages 80 
set feedback off 
select * from (select to_char(end_interval_time, ‘MM/DD/YY’) mydate, sum(space_used_delta) / 1024 / 1024 "Space used (MB)", avg(c.bytes) / 1024 / 1024 "Total Object Size (MB)", 
round(sum(space_used_delta) / sum(c.bytes) * 100, 2) "Percent of Total Disk Usage" 
from 
   dba_hist_snapshot sn, 
   dba_hist_seg_stat a, 
   dba_objects b, 
   dba_segments c 
where begin_interval_time > trunc(sysdate) – &days_back 
and sn.snap_id = a.snap_id 
and b.object_id = a.obj# 
and b.owner = c.owner 
and b.object_name = c.segment_name 
and c.segment_name = ‘&segment_name’ 
group by to_char(end_interval_time, ‘MM/DD/YY’)) 
order by to_date(mydate, ‘MM/DD/YY’);

Script #2:-  Database Growth in 1 hour intervals
Declare 
    v_BaselineSize    number(20); 
    v_CurrentSize    number(20); 
    v_TotalGrowth    number(20); 
    v_Space        number(20); 
    cursor usageHist is 
            select a.snap_id, 
            SNAP_TIME, 
            sum(TOTAL_SPACE_ALLOCATED_DELTA) over ( order by a.SNAP_ID) ProgSum 
        from 
            (select SNAP_ID, 
                sum(SPACE_ALLOCATED_DELTA) TOTAL_SPACE_ALLOCATED_DELTA 
            from DBA_HIST_SEG_STAT 
            group by SNAP_ID 
            having sum(SPACE_ALLOCATED_TOTAL) <> 0 
            order by 1 ) a, 
            (select distinct SNAP_ID, 
                to_char(END_INTERVAL_TIME,’DD-Mon-YYYY HH24:Mi’) SNAP_TIME 
            from DBA_HIST_SNAPSHOT) b 
        where a.snap_id=b.snap_id; 
Begin 
    select sum(SPACE_ALLOCATED_DELTA) into v_TotalGrowth from DBA_HIST_SEG_STAT; 
    select sum(bytes) into v_CurrentSize from dba_segments; 
    v_BaselineSize := v_CurrentSize – v_TotalGrowth ;
    dbms_output.put_line(‘SNAP_TIME           Database Size(MB)’);
    for row in usageHist loop 
            v_Space := (v_BaselineSize + row.ProgSum)/(1024*1024); 
        dbms_output.put_line(row.SNAP_TIME || ‘           ‘ || to_char(v_Space) ); 
    end loop; 
end;

Script #3: Top 50 Query which can be used to query segments with highest growth. This will also report the present size of the segment which is very useful in identifying the growth percentage.
SELECT o.OWNER , o.OBJECT_NAME , o.SUBOBJECT_NAME , o.OBJECT_TYPE , 
    t.NAME "Tablespace Name", s.growth/(1024*1024) "Growth in MB", 
    (SELECT sum(bytes)/(1024*1024) 
    FROM dba_segments 
    WHERE segment_name=o.object_name) "Total Size(MB)" 
FROM DBA_OBJECTS o, 
    ( SELECT TS#,OBJ#, 
        SUM(SPACE_USED_DELTA) growth 
    FROM DBA_HIST_SEG_STAT 
    GROUP BY TS#,OBJ# 
    HAVING SUM(SPACE_USED_DELTA) > 0 
    ORDER BY 2 DESC ) s, 
    v$tablespace t 
WHERE s.OBJ# = o.OBJECT_ID 
AND s.TS#=t.TS# 
AND rownum < 51 
ORDER BY 6 DESC 
/

Script #4: List object growth over last N days, sorted by growth desc 
set feedback on 
select * from (select c.TABLESPACE_NAME,c.segment_name “Object Name”,b.object_type, 
sum(space_used_delta) / 1024 / 1024 “Growth (MB)” 
from dba_hist_snapshot sn, 
dba_hist_seg_stat a, 
dba_objects b, 
dba_segments c 
where begin_interval_time > trunc(sysdate) – &days_back 
and sn.snap_id = a.snap_id 
and b.object_id = a.obj# 
and b.owner = c.owner 
and b.object_name = c.segment_name 
and c.owner =’SIEBEL’ 
group by c.TABLESPACE_NAME,c.segment_name,b.object_type) 
order by 3 asc;

Script #5: generates tablespace usage trend/growth.
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF; 
set linesize 125 
set numwidth 20 
set pagesize 50 
COL NAME FOR A30 
col SNAP_ID for 9999999 
set serveroutput off; 
SPOOL TBS_TREND.xls; 
set verify off; 
set echo off;
SELECT 
distinct DHSS.SNAP_ID,VTS.NAME, 
TO_CHAR(DHSS.END_INTERVAL_TIME, ‘DD-MM HH:MI’) AS SNAP_Time, 
ROUND((DHTS.TABLESPACE_USEDSIZE*8192)/1024/1024)/&&max_instance_num AS USED_MB, 
ROUND((DHTS.TABLESPACE_SIZE*8192)/1024/1024)/&&max_instance_num AS SIZE_MB 
FROM DBA_HIST_TBSPC_SPACE_USAGE DHTS,V$TABLESPACE VTS,DBA_HIST_SNAPSHOT DHSS 
WHERE VTS.TS#=DHTS.TABLESPACE_ID 
AND DHTS.SNAP_ID=DHSS.SNAP_ID 
AND DHSS.INSTANCE_NUMBER=1 
AND TABLESPACE_ID=&id 
ORDER BY 1; 
SPOOL OFF;



DELL PowerEdge R620 rack server

INTRODUCTION

Designed for extraordinary performance on a wide range of applications, the Dell™ PowerEdge™ R620 rack server is an impressive general-purpose platform that is perfect for data centers with space constraints. With its hyper-dense memory—up to 768GB in a 1U form factor—and powered by the Intel® Xeon® processor E5 product family, the R620 shines when handling visualization, high-performance computing (HPC), and work-group collaboration applications.

Accomplish More:

 Pack more computing power into a space-challenged data center with the PowerEdge R620, which offers an exceptionally large memory footprint along with balanced, Scrabble I/O capabilities, including integrated PCI Express® (PCIe) 3.0 capable expansion slots. With reliability, availability, and serviceability (RAS) features like hot-pluggable fans, disks, power supply units (PSUs), and even redundant failsafe hypervisors, the R620 keeps your data center running with rock-steady reliability.

Dense Design for demanding workload

Visualization environments demand high memory capacity to maximize the number of virtual machines per server, and the PowerEdge R620 was designed specifically with these environments in mind. The R620 also offers outstanding computational density for HPC application clusters by providing powerful processing capabilities in a compact form factor.

Tailor your network fabric

 The R620’s network features allow you to tailor your network throughput to match your application needs, enabling added I/O performance. Dell Select Network Adapters, our flexible NIC technology, let you choose the right network fabric without using up a valuable PCI slot. You can pick speed, technology, vendor, plus other options such as switch independent NIC partitioning, which lets you share and manage bandwidth on 10GbE connections.

Dell Open-Manage Systems Management

The Dell Open-Manage™ systems management portfolio includes the Integrated Dell Remote Access Controller (iDRAC) with Life cycle Controller. Innovative embedded management features help IT administrators manage Dell servers in physical, virtual, local and remote environments, operating in-band or out-of-band, with or without a systems management software agent. Open-Manage integrates and connects to third-party systems management solutions so you can maintain your single point of control and capitalize on your existing investment. Open-Manage simplifies the life-cycle of deploying, updating, monitoring, and maintaining your Dell PowerEdge servers.


Processor

  • Intel® Xeon® processor E5-2600 or E5-2600 v2 product family

    Processor Socket:2

    Internal Interconnect:
    2 x Intel QuickPath Interconnect (QPI); 6.4 GT/s; 7.2 GT/s; 8.0 GT/s

    Cache:2.5MB per core; core options: 4, 6, 8, 10, 12

Operating System

  • Microsoft® Windows Server® 2012
    Microsoft Windows Server 2008 R2 SP1, x64 (includes Hyper-V®)
    Novell® SUSE® Linux Enterprise Server
    Red Hat® Enterprise Linux®

  • Virtualization options:

  • Citrix® XenServer®
    VMware® vSphere® ESXi ™
    Red Hat Enterprise Virtualization®

Chipset

  • Intel C602

Memory

  • Up to 1.5TB (24 DIMM slots) 2GB/4GB/8GB/16GB/32GB/64GB DDR3 up to 1866MT/s

Storage

  • Maximum internal storage:
    Up to 10TB

    Hot-plug hard drive options:2.5” PCIe SSD, SAS SSD, SATA SSD, SAS (15K, 10K), nearline SAS (7.2K), SATA (7.2K), SAS 512n (15K)
    Self-Encrypting Drives available

Drive Bays

  • Up to ten 2.5" hot-plug SAS, SATA, or SSD or up to four hot-plug 2.5" SAS, SATA, or SSD + two PCIe SSD

Slots

  • 3 PCIe slots:Two x16 slots with x16 bandwidth, half-height, half-length
    One x16 slot with x8 bandwidth, half-height, half-length
    (ten-drive-bay configuration is available only with 3 PCIe slot option)

    or

    2 PCIe slots:One x16 slot with x16 bandwidth, full-height, 3/4 length
    One x16 slot with x16 bandwidth (or x8 with one processor only), half-height, half-length

RAID Controllers

  • Internal controllers:

  • PERC S110 (SW RAID)
    PERC H310
    PERC H710
    PERC H710P

  • External HBAs (RAID):

  • PERC H810

  • External HBAs (non-RAID):
  • 6Gbps SAS HBA

Communications

  • Broadcom® 5720 quad-port 1GbE Base-T (no TOE or iSCSI offload) 
    Intel I350 quad-port 1GbE Base-T (no TOE or iSCSI offload) 
    Intel X540 dual-port 10GbE Base-T with 2 x 1GbE (FCoE capability enabled on the 10GbE ports)
    Broadcom 57800S dual-port 10GbE Base-T with 2 x 1GbE (TOE and iSCSI offload available on 10GbE ports) Broadcom 57800S dual-port 10GbE SFP+ with 2 x 1GbE (TOE and iSCSI offload available on 10GbE ports)Broadcom 57840S quad-port 10GbE SFP+ Rack NDC (NPAR1.0, SRIOV, DCB, iSCSI and FCoE offloads and CEM)

Power

  • Titanium efficiency, hot-plug redundant 750W power supply
    Platinum efficiency, hot-plug redundant 495W, 750W or 1100W power supplies
    Auto-ranging power supplies

Availability

  • High-efficiency, hot-plug, redundant power supplies; DC power supplies; hot-plug hard drives; TPM; dual internal SD support; hot-plug redundant fans; optional bezel; luggage-tag; ECC memory; interactive LCD screen; extended thermal support; ENERGY STAR® compliant; extended power range; Switch Agnostic Partitioning (SWAP)

Management

  • Remote Management iDRAC7 with Lifecycle Controller
    iDRAC7 Express (default), iDRAC7 Enterprise (upgrade option),
    8GB vFlash media (upgrade option), 16GB vFlash media (upgrade option)

    Systems Management 

  • IPMI 2.0 compliant
    Dell OpenManage™ Essentials 
    Dell OpenManage Power Center
    Dell OpenManage Connections:
    • Dell OpenManage Integration Suite for Microsoft® System Center
    • Dell plug-in for VMware® vCenter™
    HP Operations Manager, IBM Tivoli® Netcool® , and CA Network and Systems Management

    ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

     This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...