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.

ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home Version : 12.1.0.2 Primary, 2 Node RAC, db_unique_name = primeprd Instance 2 : primeprd1 Instance 2 : primeprd2 TNS entry: PRIMEPRD, but below entry in tnsnames.ora files on both node with DB Home user, most … Continue reading Oracle 12c Dataguard RAC Primary to RAC Standby with Dataguard Broker (on Exadata)

ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [32], [1], [], …

Oracle Version Affected : 12.1.0.2 OS : OEL 6 Update 7, x64 This error is related to Parallel Query and we encountered it many times, once on test and once on production. The solution is to apply below patch Patch 19201867: SR12.2PX_HYBRID_LOAD - TRC - ORA-600 [KXSPOAC : EXL 1] It is due to a … Continue reading ORA-12801: error signaled in parallel query server P001 ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [32], [1], [], …

PRVG-1561 : Setting ORA_CRS_HOME variable is not supported

While installing Oracle 12c on Linux you can get this error. The solution is very easy just unset the ORA_CRS_HOME environment variable and run the runInstaller again $ unset ORA_CRS_HOME