运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE
程序员文章站
2022-04-19 10:14:13
...
SQL @ddl_setup Oracle GoldenGate DDL Replication setup script Verifying that current user has privileges to install DDL Replication... You will be prompted for the name of a schema for the Oracle GoldenGate database objects. NOTE: For an O
SQL> @ddl_setup Oracle GoldenGate DDL Replication setup script Verifying that current user has privileges to install DDL Replication... You will be prompted for the name of a schema for the Oracle GoldenGate database objects. NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled. NOTE: The schema must be created prior to running this script. NOTE: Stop all DDL replication before starting this installation. Enter Oracle GoldenGate schema name:goldengate Working, please wait ... Spooling to file ddl_setup_spool.txt Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ... Check complete. declare * ERROR at line 1: ORA-20783: ORA-20783: Oracle GoldenGate DDL Replication setup: *** Please move GOLDENGATE to its own tablespace ORA-06512: at line 34 I've read the script, it seems that the problem can be fixed like this: $export ALLOW_SHARED_TABLESPACE='TRUE'
其实export ALLOW_SHARED_TABLESPACE='TRUE' 这个方法不是好方法。
GoldenGate 对DDL的配置要求如下:
As explained in install doc, http://docs.oracle.com/cd/E35209_01/doc.1121/e35957.pdf "Create a default tablespace for the Oracle GoldenGate DDL schema. This tablespace must be dedicated to the DDL schema; do not allow any other schema to share it. AUTOEXTEND must be set to ON for this tablespace, and the tablespace must be sized to accommodate the growth of the GGS_DDL_HIST and GGS_MARKER tables. The GGS_DDL_HIST table, in particular, will grow in proportion to overall DDL activity."
推荐阅读
-
pycharm运行脚本时控制台不输出print中的日志
-
解决pycharm终端/cmd运行python脚本报错“ImportError/ModuleNotFoundError:No Module named ...”
-
运行ASP时脚本超时问题最终解决办法
-
运行.vbs脚本时,无法找到名为wscript.shell的automation类
-
Python.Scrapy爬虫运行(scrapy.cfg和路径皆正确时)报错的解决方案
-
解决连接oracle报错 尝试加载Oracle客户端库时引发BadImageFomatException。如果在安装64位Oracle客户端组件的情况下以32位模式运行,将出现此问题的报错。
-
运行vbs脚本报错无效字符、中文乱码的解决方法(编码问题)
-
VSCode报错:无法加载文件XXX,因为在此系统上禁止运行脚本。
-
解决windows下npm安装的模块执行报错:无法将“cnpm”项识别为 cmdlet、函数、脚本文件或可运行程序的名称。
-
pycharm运行脚本时控制台不输出print中的日志