Oracle - SQL - MySQL DBA - Life Long Learning Experience

Today Morning I thought i should do something different than usual :) . Few Basic Steps required to install and configure MySQL . Please follow the steps as outlined. 1)  Install RPM's [root@kphqdbrm02ord bundle]# rpm -Uvh mysql-community-common-5.7.19-1.el7.x86_64.rpm mysql-community-server-5.7.19-1.el7.x86_64.rpm warning: mysql-community-common-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:mysql-community-common-5.7.19-1.e################################# [ 25%]    2:mysql-community-server-5.7.19-1.e################################# [ 50%] Cleaning up / removing...    3:mysql-community-server-5.7.16-1.e################################# [ 75%]    4:mysql-community-...

Today Morning one of my Test database (VM) was playing up . This came to light when the esxi Host was down due to power issue bringing all the guest down .  After the Host Server  was sorted and we started bringing individual  guest servers up but one of Test VM was struggling . On diagnosing it appeared that the  flash recovery area was filled 99.99% and there was no room for online log to archive . Error Encountered during the start of the instance : SQL> startup ORACLE instance started. Total System Global Area 1837244416 bytes Fixed Size                  2851720 bytes Variable Size             553651320 bytes Database Buffers         1275068416 bytes Redo Buffers                5672960 bytes D...

Very Useful information about SQL Server Builds .  It is nicely presented in the blog . Please see  below for our reference . Microsoft SQL Server Version List What version of SQL Server do I have? This unofficial build chart lists all of the known Service Packs ( SP ), Cumulative Updates ( CU ), patches, hotfixes and other builds of MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released. Useful articles: How to identify your SQL Server version and edition SQL Server Internal Database Versions Microsoft SQL Server Support Lifecycle Microsoft SQL Server Home Microsoft SQL Server Developer Center Microsoft TechNet: Microsoft SQL Server Microsoft Knowledge Base Sqlservr.exe versions   Quick summary:   RTM (no SP ) SP1 SP2 SP3 SP4   SQL Server 2017      codename vNext 14.0.1000.169 *new           SQL Server 2016 13...