Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Auto start of Golden Gate after DB server reboots


One can use BOOTDELAYMINUTES parameter in manager parameter file,

BOOTDELAYMINUTES parameter on a Windows system is to delay the activities that Manager performs when it starts, such as executing parameters or autostart of extract and replicat processes.

For example, BOOTDELAYMINUTES can be used to delay AUTOSTART parameters until database services are started.

Specify BOOTDELAYMINUTES before other parameter entries. This parameter only supports Windows.

Example:

GGSCI (rssb) 3> view params mgr

PORT 7808

BOOTDELAYMINUTES 3

USERID gg,PASSWORD gg

AUTOSTART EXTRACT EXTLINUX

PURGEOLDEXTRACTS D:\lok\Stud_Mat\Golden_Gate\gg_sw\Source\dirdat\ex, USECHECKPOI NTS

 

 

 

 

 

Advertisements

April 2, 2013 Posted by | Golden Gate | Leave a comment

WARNING OGG-01194 EXTRACT task LOAD2 abended : There is no trail to reposition to when doing direct load task


This problem arises because golden gate user doesn’t have proper privileges.

Problem can be solved by granting insert anytable privilege to the user i.e. grant insert any table to ggs_user.

August 8, 2012 Posted by | Golden Gate | Leave a comment