Install SQL Server tools on Red Hat Enterprise Linux Step by Step tutorial

Install SQL Server tools on Red Hat Enterprise Linux

• Enter superuser mode.

sudo su

• Download the Microsoft Red Hat repository configuration file.

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

• Exit superuser mode.

exit

• Run the following commands to install 'mssql-tools' with the unixODBC developer package.

sudo yum update

sudo yum install mssql-tools unixODBC-utf16-devel

Uninstall SQL Server on Red Hat Enterprise Linux Step by Step Tutorial

Uninstall SQL Server on Red Hat Enterprise Linux Step by Step Tutorial

• In order to remove the mssql-server package, follow these steps:

• Run the remove command. This will delete the package and remove the files under /opt/mssql/. However, this command will not affect user-generated and system database files, which are located under /var/opt/mssql.

sudo yum remove mssql-server

• Removing the package will not delete the generated database files. If you want to delete the database files use the following command:

sudo rm -rf /var/opt/mssql/

Upgrade SQL Server on Red Hat Enterprise Linux Step by Step Totorial

Upgrade SQL Server on Red Hat Enterprise Linux Step by Step Totorial

• In order to upgrade the mssql-server package, execute the following command:

sudo yum update mssql-server

• These commands will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation.

Install SQL Server on Red Hat Enterprise Linux 7.3 Step by Step Tutorial

Install SQL Server on Red Hat Enterprise Linux 7.3 Step by Step Tutorial

Video:

• You need at least 3.25GB of memory to run SQL Server on Linux. 

• To install the mssql-server package on RHEL, follow these steps:

• Enter superuser mode.

sudo su

• Download the Microsoft SQL Server Red Hat repository configuration file:

curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo

• Exit superuser mode.

exit

• Run the following commands to install SQL Server:

sudo yum install -y mssql-server

• After the package installation finishes, run the configuration script and follow the prompts. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

sudo /opt/mssql/bin/sqlservr-setup

• Once the configuration is done, verify that the service is running:

systemctl status mssql-server

Step by step Document for integrating Oracle Enterprise Manager with SCOM

Step by step Document for integrating Oracle Enterprise Manager with SCOM

• You can now receive the Oracle Enterprise Manager alerts in SCOM.
• Please find the detail document on how to intergrate Oracle Enterprise Manager with SCOM
• Click here -->https://docs.oracle.com/cd/E11857_01/install.111/e14736/toc.htm

Oracle MP for SCOM 2012 R2

Oracle MP for SCOM 2012 R2:

• Oracle is one of the Widely used databases in the world. They are proven for there robustness in transaction databases and can easily scale through Peta bytes of data for Datawharehousing.
• SCOM is the enterprise monitoring tool used to monitor the Infrastructure and leads the Gartner Monitoring Quadrant for many years.
• Oracle has released a free Connector which you can download and install and intergrate with SCOM.
• Features Include: 
   

  -	Bi-directional exchange of alerts between Microsoft SCOM and Enterprise Manager
  -	Automatic synchronization of alert state in Microsoft SCOM with the state of alert in Oracle Enterprise Manager (and vice-versa)
  -	Webservices based communication
  -	Out-of-box mapping of Oracle Enterprise Manger alert severity to SCOM alert severity
  -	Ability to customize severity mapping between Enterprise Manager alert and SCOM event

• You can see live demo on how it works by clicking here --> click here
• You can download the connector here --> Click here