Shulou(Shulou.com)05/31 Report--

This article mainly introduces what problems you will encounter when using ogg to synchronize mysql from oracle. It has a certain reference value, and interested friends can refer to it. I hope you will gain a lot after reading this article.

ORACLE Sync mysql encountered a problem:

2018-08-27 10:59:54 WARNING OGG-01004 Aborted grouped transaction on DESIGNXXxx, Database error 1105 ([SQL error 1105] Parameter of prepared statement which is set through mysql_send

_ long_data () is longer than 'max_allowed_packet' bytes

You can modify the configuration parameter of the mysql server (my.ini or my.cnf file): max_allowed_packet = 500m. The drawback is that this method requires a restart of the mysql server.

2018-08-27 18:16:03 WARNING OGG-01154 SQL error 1364 mapping RAPANORAMAGEOM to PMC.RAPANORAMAGEOM [SQL error 1364] Field 'Geomtrycolor' doesn't have a default value.

Set the default value for the error field in the database. Integer: 0, string: set to NULL

Find the corresponding table-- > Design Table-> default selection box (set default)

-- Key column Sex (20) is missing from update on table GUEST'

Alter table GUEST add primary key (Guestid)

2018-08-28 09:53:45 ERROR OGG-00768 DYNSQL: Preparing SQL statement (ID = 0) failed. SQL error (1064). You have an error in your SQL syntax; check the manual that corresponds to your MySQ

L server version for the right syntax to use near'% T SET% S WHERE% W'at line 1.

Solution:

Check whether the table fields of both databases are consistent. It may be missing fields.

Mask reserved word list

Xxx.DBA_TABLES_TMP

2018-09-14 16:46:37 WARNING OGG-01154 SQL error 1364 mapping USERLIMITIxxxxx to SMS.USERLIMITINFODETAIL [SQL error 1364] Field 'Userlimitid' doesn't have a default value.

Removal of STRICT_TRANS_TABLES from sql_mode

Thank you for reading this article carefully. I hope the article "what are the problems in synchronizing mysql from oracle using ogg" shared by the editor will be helpful to you. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.