Install MySQL Enterprise Monitor step by step with screenshots

In this post will cover the step by step screenshots to install MySQL Enterprise Monitor (MEM) version 8.0.3, which will help us for troubleshooting and notifying any critical issues related to MySQL databases.

Download the latest software related to MySQL Enterprise Monitor (MEM) version 8.0.3 from Oracle Support site. You can install  MySQL Enterprise Monitor (MEM) using three ways:

1. Graphical User Interface (GUI)
2. Text-based
3. Unattended 

MySQL Enterprise Monitor 8.0.3 now supports MySQL 8, MySQL  Enterprise Monitor Agent, Data collection model, Graphs, Advisors and Query Analyzer have been updated, which will help to triage any MySQL issues more easily. Before the installation starts, have proper ports and firewalls ready for Tomcat server port, Tomcat SSL port and MySQL Database Port.

I have chosen the Graphical User Interface (GUI) and below are the step by step screenshots for the installation process.

At this stage, we are done with the installation of the MySQL Enterprise Monitor. Happy Monitoring!!!

Step by Step Oracle 18c Database Installation on Linux with Screenshots

Create a staging directory on your server and download the files from OTN. Make sure to set the profiles perfectly for the database and you do have all the directories set with right permissions. Check the RPM’s based on your operating system stipulations. In this scenario, we will see how to install 18.0.0.0.0 on OEL 7. Lets get started.


[Sajid@SajidServer~]$ cd /usr/stage
[Sajid@SajidServer stage]$ ls -ltr
-rwxrwxr-x  1 oracle oinstall 4564649047 Jan 23 16:16 LINUX.X64_180000_db_home.zip

[Sajid@SajidServer stage]$ unzip LINUX.X64_180000_db_home.zip

Make sure you have your VNC or XMING set up properly and now invoke the runInstaller

[Sajid@SajidServer database]$ ./runInstaller

At this stage, we have successfully completed the 18c database install on OEL7. Thanks for Visiting!!!

Apply the latest PSU 12.1.0.2.190115 (Jan 2019) for Oracle RAC Database

       In this article, I will be sharing my knowledge on applying the latest Oracle patch set update 12.1.0.2.190115 (released in January 2019) on RAC cluster. Do refer to readme file before executing the PSU.

If you need further step by step approach for applying the patch in detail, do refer to Apply the latest PSU5 for 12.1.0.2 RAC Database (here) (Scroll down) in my blog.

########
Error 1:
########

OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.

########
Error 2:
########

OPATCHAUTO-72088: OPatch version check failed.
OPATCHAUTO-72088: OPatch software version in homes selected for patching are different.
OPATCHAUTO-72088: Please install same OPatch software in all homes.
OPatchAuto failed.

opatchauto failed with error code 42

##########
Solution:
##########

Patch 27547329, Patch 28259833 and Patch 28729169 requires minimum OPatch version 12.2.0.1.13. Make sure to download  p6880880_180000_Linux-x86-64.zip in both Grid and Oracle homes. So that, you are on the latest opatch version and move forward with patching.

After that applied the patch and it was successful.

[root@sajidserver01 OPatch]# ./opatchauto apply /usr/staging/28813884

OPatchauto session is initiated at Mon Jan  21 13:52:25 2019

System initialization log file is /usr/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-01-21_01-52-26PM.log.

Session log file is /usr/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2019-01-21_01-52-30PM.log
The id for this session is ZRI4

Executing OPatch prereq operations to verify patch applicability on home /usr/oracle/product/12.1.0
Patch applicability verified successfully on home /usr/oracle/product/12.1.0


Verifying SQL patch applicability on home /usr/oracle/product/12.1.0
SQL patch applicability verified successfully on home /usr/oracle/product/12.1.0


Executing OPatch prereq operations to verify patch applicability on home /usr/12.1.0/grid
Patch applicability verified successfully on home /usr/12.1.0/grid


Preparing to bring down database service on home /usr/oracle/product/12.1.0
Successfully prepared home /usr/oracle/product/12.1.0 to bring down database service


Bringing down database service on home /usr/oracle/product/12.1.0
Following database has been stopped and will be restarted later during the session: sajiddb
Database service successfully brought down on home /usr/oracle/product/12.1.0


Bringing down CRS service on home /usr/12.1.0/grid
Prepatch operation log file location: /usr/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2019-01-21_01-55-08PM.log
CRS service brought down successfully on home /usr/12.1.0/grid


Start applying binary patch on home /usr/oracle/product/12.1.0
Binary patch applied successfully on home /usr/oracle/product/12.1.0


Start applying binary patch on home /usr/12.1.0/grid
Binary patch applied successfully on home /usr/12.1.0/grid


Starting CRS service on home /usr/12.1.0/grid
Postpatch operation log file location: /usr/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2019-01-21_01-59-21PM.log
CRS service started successfully on home /usr/12.1.0/grid


Starting database service on home /usr/oracle/product/12.1.0
Database service successfully started on home /usr/oracle/product/12.1.0


Preparing home /usr/oracle/product/12.1.0 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /usr/oracle/product/12.1.0
SQL patch applied successfully on home /usr/oracle/product/12.1.0

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:sajidserver01
SIDB Home:/usr/oracle/product/12.1.0
Version:12.1.0.2.0
Summary:

==Following patches were SKIPPED:

Patch: /usr/staging/28813884/26983807
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /usr/staging/28813884/28729220
Reason: This patch is not applicable to this specified target type - "oracle_database"


==Following patches were SUCCESSFULLY applied:

Patch: /usr/staging/28813884/28729169
Log: /usr/oracle/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-55-30PM_1.log

Patch: /usr/staging/28813884/28729213
Log: /usr/oracle/product/12.1.0/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-55-30PM_1.log


Host:sajidserver01
SIHA Home:/usr/12.1.0/grid
Version:12.1.0.2.0
Summary:

==Following patches were SKIPPED:

Patch: /usr/staging/28813884/26983807
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY applied:

Patch: /usr/staging/28813884/28729169
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log

Patch: /usr/staging/28813884/28729213
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log

Patch: /usr/staging/28813884/28729220
Log: /usr/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-21_01-56-18PM_1.log



OPatchauto session completed at Mon Jan  21 14:01:18 2019
Time taken to complete the session 8 minutes, 54 seconds

Happy Patching and Learning.

Install MySQL on Linux

                    Will be discussing on installing latest MySQL open source relational database system version 8.0 on OEL7. You can download the MySQL software from https://dev.mysql.com/downloads/repo/yum/ or Oracle Metalink website. Let's get started, we can split this installation into three parts as below:

1. Download MySQL software

2. Secure MySQL Installation

3. Create the Database

[root@sajidserver~]#yum install mysql-community-server

Look for the temporary password, which you need it for secure installation.

[root@sajidserver~]#grep 'temporary password' /var/log/mysqld.log

2019-01-05T00:02:55.258804Z 5 [Note] [MY-010454] [Server] A temporary 

password is generated for root@localhost: zytrk7-j<

Now let's connect to MySQL and create the database.

Installation of GoldenGate Monitoring Agent 12.2

      Oracle GoldenGate Monitor is used to monitor the status of the Goldengate targets like Manager, Extract and Replicat from Oracle Enterprise Manager. Download Oracle GoldenGate Monitor 12.2.1.2.0 from OTN site, you even need minimum java version 8 (1.8) to have Oracle GoldenGate Monitor installed using Oracle Universal Install. For installing Oracle Golden gate 12c (http://sajidkhadarabad.blogspot.com/2016/03/install-oracle-golden-gate-12c.html) 

You can install Oracle GoldenGate Monitor by Oracle Universal Install or through a silent install. I chose Oracle Universal Install and below are the steps for the install.

Sajidserver01:oracle$ ls -ltr

-r-xr-xr-x 1 oracle oinstall 430387063 Oct 14 04:33 fmw_12.2.1.2.0_ogg.jar

-rwxr-xr-x 1 oracle oinstall 430166267 Mar 17 15:30 fmw_12.2.1.2.0_ogg_Disk1_1of1.zip

Sajidserver01:oracle$ java -jar -Xmx1024m /usr/oracle/gg12c/stage/fmw_12.2.1.2.0_ogg.jar

Launcher log file is /tmp/OraInstall2018-11-16_12-43-53PM/launcher2018-11-16_12-43-53PM.log.

Extracting files.....

Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2400.000 MHz    Passed

Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed

Checking swap space: must be greater than 512 MB.   Actual 16383 MB    Passed

Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)

Checking temp space: must be greater than 300 MB.   Actual 65485 MB    Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2018-11-16_12-43-53PM

Log: /tmp/OraInstall2018-11-16_12-43-53PM/install2018-11-16_12-43-53PM.log

Logs are located here: /tmp/OraInstall2018-11-16_12-43-53PM.

Feed in the location where you want to have monitoring agent installed and make sure to create the directory earlier.

Oracle GoldenGate Monitor is successfully installed!!!

TFA-00104 TFA-00002 Oracle Trace File Analyzer (TFA) is not running

                   Oracle Trace File Analyzer (TFA) is a one-stop tool to diagnose all of your system. You can download latest TFA from (Doc ID 1513912.1). I was working on upgrading TFA from 18.1.1 to 18.3.3. Before upgrade TFA was up and running in a healthy state, once I have invoked upgrade happen to run into issues TFA-00104 and TFA-00002, below is the fix for it.

Everytime it will be different error across each server, even though the file exists on the server with right permissions.

ERROR: /usr/tfa/sajidserver02/tfa_home/internal/.pidfile does not exists

ERROR: /usr/tfa/sajidserver02/tfa_home/internal/cached_kv.out does not exists

TFA-00104 Cannot establish connection with TFA Server. Please check TFA Certificates

TFA-00002 Oracle Trace File Analyzer (TFA) is not running

TFA-00002 Oracle Trace File Analyzer (TFA) is not running

Take it easy as its just a tool, we can directly opt for the new install. Below are the steps which I have performed on the server.

Successfully done with TFA install."Happy Analysing".

Note:

You can check version with using below command:

[root@sajidserver01 bin]# ./tfactl print status

.--------------------------------------------------------------------------------------------------.

| Host     | Status of TFA | PID   | Port | Version    | Build ID             | Inventory Status   |

+----------+---------------+-------+------+------------+----------------------+--------------------+

|sajidsrv01| RUNNING       | 27385 | 5000 | 18.3.3.0.0 | 18330020181005054218 | COMPLETE           |

'----------+---------------+-------+------+------------+----------------------+--------------------'