Shulou(Shulou.com)06/01 Report--

Ddl_setup executes failure handling

Environmental Information:

ORACLE 11.2.0.4 RAC x64

OGG 11.2.1.0.1

Error message:

SQL > @ ddl_setup.sql

The prompt table does not exist and ends with the following prompt:

STATUS OF DDL REPLICATION

-

ERRORS detected in installation of DDL Replication software components (6)

Script complete.

Resolution process:

SQL > @ ddl_disable

SQL > create pfile='/orasoft/pfile906.ora' from spfile

SQL > alter system set enable_goldengate_replication=true sid='*'

SQL > GRANT CREATE TABLE,CREATE SEQUENCE TO ggadmin

SQL > role_setup.sql

SQL > GRANT GGS_GGSUSER_ROLE TO ggadmin

SQL > ddl_pin ggadmin

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.