Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50560. Please use mysql_upgrade to fix this error.

This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded MySQL Server (51. to 5.6  in my case) . After upgrading your MySQL you have to run  mysql_upgrade to fix any incompatibilities in System tables. If it finds any errors it automatically repairs it and … Continue reading Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50560. Please use mysql_upgrade to fix this error.

Documentation#1193 – Unknown system variable ‘lc_messages’

This error you would usually see when you login to phpMyAdmin after an upgrade. This is related to your MySQL version, in my case I had upgraded my phpMyAdmin but the MySQL version was still on 5.1, after upgrading to MySQL 5.6 it solved the issue You can upgrade MySQL to the latest version by … Continue reading Documentation#1193 – Unknown system variable ‘lc_messages’

Upgrade Oracle Apex from 5.1.x to 18.1

Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from version 5.1.4 to 18.1 . The new version of Apex has many exciting new features, you can read about them all here Setup : Apex Version : Oracle Apex 5.1.4 Webserver : ORDS Running on … Continue reading Upgrade Oracle Apex from 5.1.x to 18.1

Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to Oracle 12.2.0.1 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 11.2.0.4 first and you can upgrade to 12cR2 In our Scenario We will … Continue reading Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

Upgrade and Migrate to 12c – Oracle Official Presentation

A 600 slide presentation by Oracle DB Product Manager Mike Dietrich, to upgrade and migrate to Oracle 12c. Upgrade_and_Migrate_12c

UPGRADE ORACLE 10.2.0.1 TO 10.2.0.4 WINDOWS SERVER 2003 32-BIT

UPGRADE ORACLE 10.2.0.1 TO 10.2.0.4  WINDOWS SERVER 2003 32-BIT --------------------------------------------------------------- 1. CHECK FOR TIMZEZONE INFORMATION USING FOLLOWING SQL QUERY SELECT version FROM v$timezone_file; * If this query reports version 4, no action is required; in this case, continue with next steps. * If this reports a version lower or higher then 4, proceed to step … Continue reading UPGRADE ORACLE 10.2.0.1 TO 10.2.0.4 WINDOWS SERVER 2003 32-BIT