In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.