我想通过AWS SCT将Oralce DB迁移到Amazon Redshift [英] I would like migrate Oralce DB to Amazon Redshift with AWS SCT

问题描述

我参考本教程在 step5 中，Amazon SCT将Oracle架构转换为Amazon Redshift.但是，我必须更改Amazon SCT的配置，因为该教程文档是旧编写于2017年.更改配置之一，我尝试禁用使用AWS Glue .我打开项目设置以取消选中使用AWS Glue"复选框.不久之后， AWS SCT冻结.

In step5, I use Amazon SCT to convert the Oracle Schema to Amazon Redshift. But, I have to change config for Amazon SCT because the tutorial document is old written in 2017. One of the change config, I try to disable to use AWS Glue. I open Project settings to uncheck the checkbox "Use AWS Glue". And soon after, AWS SCT froze.

我的PC有8GB的内存，我尝试有16GB的商务PC.仍然没用.

My PC has 8GB memory, and I try business PC which has 16GB memory. Still it is useless.

根据此博客，我需要增加JVM的大小.因此，我编辑了SCT的配置文件.

According to this blog,I need to increase JVM size. So, I edit the configuration files for SCT.

[Application]
app.name=AWS Schema Conversion Tool
app.version=1.0.645
app.runtime=$ROOTDIR\runtime
app.identifier=com.amazon.sct
app.classpath=$ROOTDIR\app\AWSSchemaConversionTool.jar;$ROOTDIR\app\AWSSchemaConversionToolBatch.jar
app.mainjar=$ROOTDIR\app\AWSSchemaConversionTool.jar
app.mainclass=com.amazon.sct.App

[JavaOptions]
-Xss128M
-Dfile.encoding=UTF-8
-XX:+UseParallelGC
--add-opens=java.base/jdk.internal.loader=ALL-UNNAMED
--add-exports=java.base/jdk.internal.loader=ALL-UNNAMED
--add-exports=java.base/jdk.internal.misc=ALL-UNNAMED

[JVMUserOptions] #add
–Xmx4096m        #add 
–Xms2048m        #add

[ArgOptions]

我完成了文件的编辑并重新启动AWS SCT，但是 JVM内存不会增加.

I finish editing the files and restart AWS SCT, but JVM memory does not increase.

我不知道如何解决麻烦.接下来我该怎么办?请帮助我.

I have no idea about sovling the trouble. What should I do next? Please help me.

推荐答案

解决方案

一次，我卸载了AWS SCT，然后重新安装了旧版本一.然后，我可以打开项目设置窗口，然后取消选中[Use AWS Glue]项目设置

这篇关于我想通过AWS SCT将Oralce DB迁移到Amazon Redshift的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！