data_all_oracle

All Details are here:==========================================================================C:\GG>ggsci.exe

Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230Windows x64 (optimized), Oracle 11g on Apr 23 2012 04:55:02

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (GOLDENGATE1) 1>

SQL> spool ALL_LOGS_DETAILS.txtSQL> @marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.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:ggs_data

Marker setup table script complete, running verification script...Please enter the name of a schema for the GoldenGate database objects:Setting schema name to GGS_DATA

MARKER TABLE-------------------------------OK

MARKER SEQUENCE-------------------------------OK

Script complete.SQL> @ddl_setup.sql

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:ggs_data

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.

Using GGS_DATA as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...Please enter the name of a schema for the GoldenGate database objects:Setting schema name to GGS_DATA

CLEAR_TRACE STATUS:

Line/pos Error---------------------------------------- -----------------------------------------------------------------No errors No errors

CREATE_TRACE STATUS:


TRACE_PUT_LINE STATUS:


INITIAL_SETUP STATUS:


DDLVERSIONSPECIFIC PACKAGE STATUS:


DDLREPLICATION PACKAGE STATUS:


DDLREPLICATION PACKAGE BODY STATUS:

Line/pos Error---------------------------------------- -----------------------------------------------------------------1859/17 PL/SQL: SQL Statement ignored1859/43 PL/SQL: ORA-00942: table or view does not exist2810/25 PL/SQL: SQL Statement ignored2810/51 PL/SQL: ORA-00942: table or view does not exist2849/29 PL/SQL: SQL Statement ignored2849/55 PL/SQL: ORA-00942: table or view does not exist3008/17 PL/SQL: SQL Statement ignored3008/43 PL/SQL: ORA-00942: table or view does not exist3039/29 PL/SQL: SQL Statement ignored3039/55 PL/SQL: ORA-00942: table or view does not exist3257/33 PL/SQL: SQL Statement ignored

Line/pos Error---------------------------------------- -----------------------------------------------------------------3257/59 PL/SQL: ORA-00942: table or view does not exist

DDL IGNORE TABLE-----------------------------------OK

DDL IGNORE LOG TABLE-----------------------------------OK

DDLAUX PACKAGE STATUS:


DDLAUX PACKAGE BODY STATUS:


SYS.DDLCTXINFO PACKAGE STATUS:


SYS.DDLCTXINFO PACKAGE BODY STATUS:


DDL HISTORY TABLE-----------------------------------FAILED: Table does not exist

DDL HISTORY TABLE(1)-----------------------------------FAILED: Table does not exist

DDL DUMP TABLES-----------------------------------FAILED: Table does not exist

DDL DUMP COLUMNS-----------------------------------FAILED: Table does not exist

DDL DUMP LOG GROUPS-----------------------------------FAILED: Table does not exist

DDL DUMP PARTITIONS-----------------------------------FAILED: Table does not exist

DDL DUMP PRIMARY KEYS-----------------------------------FAILED: Table does not exist

DDL SEQUENCE-----------------------------------FAILED: Sequence does not exist

GGS_TEMP_COLS-----------------------------------OK

GGS_TEMP_UK-----------------------------------OK

DDL TRIGGER CODE STATUS:

Line/pos Error---------------------------------------- -----------------------------------------------------------------133/26 PL/SQL: ORA-02289: sequence does not exist133/5 PL/SQL: SQL Statement ignored919/30 PL/SQL: ORA-00942: table or view does not exist919/4 PL/SQL: SQL Statement ignored

DDL TRIGGER INSTALL STATUS-----------------------------------OK

DDL TRIGGER RUNNING STATUS------------------------------------------------------------------------------------------------------------------------ENABLED

STAYMETADATA IN TRIGGER------------------------------------------------------------------------------------------------------------------------OFF

DDL TRIGGER SQL TRACING------------------------------------------------------------------------------------------------------------------------0

DDL TRIGGER TRACE LEVEL------------------------------------------------------------------------------------------------------------------------0

LOCATION OF DDL TRACE FILE------------------------------------------------------------------------------------------------------------------------C:\OracleDatabase\diag\rdbms\test\test\trace/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION------------------------------------------------------------------------------------------------------------------------ERRORS detected in installation of DDL Replication software components (6)

Script complete.SQL> @role_setup.sql

GGS Role setup script

This script will drop and recreate the role GGS_GGSUSER_ROLETo use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

You will be prompted for the name of a schema for the GoldenGate database objects.NOTE: The schema must be created prior to running this script.NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:ggs_dataWrote file role_setup_set.txt

PL/SQL procedure successfully completed.

Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO

where is the user assigned to the GoldenGate processes.SQL> grant ggs_ggsuser_role to ggs_data;grant ggs_ggsuser_role to ggs_data*ERROR at line 1:ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

SQL> @ddl_enable

Trigger altered.

SQL> @ddl_pin ggateBEGIN dbms_shared_pool.keep('ggate .DDLReplication', 'P'); END;

*ERROR at line 1:ORA-06564: object ggate .DDLReplication does not existORA-06512: at "SYS.DBMS_UTILITY", line 156ORA-06512: at "SYS.DBMS_SHARED_POOL", line 72ORA-06512: at "SYS.DBMS_SHARED_POOL", line 84ORA-06512: at line 1

BEGIN dbms_shared_pool.keep('ggate .trace_put_line', 'P'); END;

*ERROR at line 1:ORA-06564: object ggate .trace_put_line does not existORA-06512: at "SYS.DBMS_UTILITY", line 156ORA-06512: at "SYS.DBMS_SHARED_POOL", line 72ORA-06512: at "SYS.DBMS_SHARED_POOL", line 84ORA-06512: at line 1

PL/SQL procedure successfully completed.

SQL> spool offnot spooling currentlySQL>

data_all_oracle

Data & Analytics