最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE

来源:动视网 责编:小采 时间:2020-11-09 14:09:13
文档

运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE

运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE: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
推荐度:
导读运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE: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 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."

文档

运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE

运行GoldenGateddl_setup.sql脚本时报错***PleasemoveGOLDENGATE: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
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top