1.
Make
sure to have a Non-Default tablespace for GoldenGate User (not users
tablespace)
SQL> select username, default_tablespace from dba_users where
username='GGS_DR_OWNER';
USERNAME DEFAULT_TABLESPACE
------------------------------
------------------------------
GGS_DR_OWNER GGS_DATA
2.
Turn
off Recycle bin for the Source database.
SQL> alter session set recyclebin=OFF scope=BOTH;
Session
altered.
3.
You
will find the below execution scripts under GoldenGate Software Home Directory.
SQL> @marker_setup
Marker
setup 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_DR_OWNER
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_DR_OWNER
MARKER
TABLE
-------------------------------
OK
MARKER
SEQUENCE
-------------------------------
OK
Script
complete.
SQL> @ddl_setup
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 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
GoldenGate schema name:GGS_DR_OWNER
You
will be prompted for the mode of installation.
To
install or reinstall DDL replication, enter INITIALSETUP
To
upgrade DDL replication, enter NORMAL
Enter
mode of installation:INITIALSETUP
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_DR_OWNER as a GoldenGate schema name, INITIALSETUP as a mode of
installation.
Working,
please wait ...
RECYCLEBIN
must be empty.
This
installation will purge RECYCLEBIN for all users.
To
proceed, enter yes. To stop installation, enter no.
Enter
yes or no:yes
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_DR_OWNER
DDLORA_GETTABLESPACESIZE
STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
CLEAR_TRACE
STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
CREATE_TRACE
STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
TRACE_PUT_LINE
STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
INITIAL_SETUP
STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
DDLVERSIONSPECIFIC
PACKAGE STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
DDLREPLICATION
PACKAGE STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
DDLREPLICATION
PACKAGE BODY STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
DDL
HISTORY TABLE
-----------------------------------
OK
DDL
HISTORY TABLE(1)
-----------------------------------
OK
DDL
DUMP TABLES
-----------------------------------
OK
DDL
DUMP COLUMNS
-----------------------------------
OK
DDL
DUMP LOG GROUPS
-----------------------------------
OK
DDL
DUMP PARTITIONS
-----------------------------------
OK
DDL
DUMP PRIMARY KEYS
-----------------------------------
OK
DDL
SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL
TRIGGER CODE STATUS:
Line/pos Error
----------
-----------------------------------------------------------------
No
errors No errors
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
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/admin/TXNQA/udump/ggs_ddl_trace.log
Analyzing
installation status...
STATUS
OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL
installation of DDL Replication software components
Script
complete.
SQL> @role_setup
GGS
Role setup script
This
script will drop and recreate the role GGS_GGSUSER_ROLE
To
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_DR_OWNER
Wrote
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 <loggedUser>
where
<loggedUser> is the user assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO GGS_DR_OWNER;
Grant
succeeded.
SQL> @ddl_enable
Trigger
altered.
SQL> @ddl_pin GGS_DR_OWNER
PL/SQL
procedure successfully completed.
PL/SQL
procedure successfully completed.
PL/SQL
procedure successfully completed.
GGSCI 1> DBLOGIN USERID GGS_DR_OWNER, PASSWORD GGS_DR_OWNER
GGSCI 2> ADD TRANDATA SUKUMAR.emp
EXTRACT
ddlext
SETENV
(NLS_LANG=AMERICAN_AMERICA.UTF8)
SETENV
ORACLE_SID=sukumar
USERID
GGS_DR_OWNER@DB_TNS, PASSWORD GGS_DR_OWNER
RMTHOST
OGG01.sukumar.com, MGRPORT 7809
RMTTRAIL
/u01/GG/source/dirdat/dd
TRANLOGOPTIONS
ASMUSER sys@ASM_TNS, ASMPASSWORD asm123
DDL INCLUDE MAPPED -----------------
Mandatory
Parameter for DDL replication
TABLE
SUKUMAR.emp;
After
completion of DDL Setup, If you don’t want to replicat the DDL’s, we have an
option to disable it.
SQL> @ddl_disable
Trigger
altered.
No comments:
Post a Comment