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.
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’
Setup for the Environment ------------------- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 184.108.40.206 DB Home Version : 220.127.116.11 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)
Oracle Version Affected : 18.104.22.168 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], , , , …
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