Goldengate - Classic Extract To Integrated Extract

To run integrated extract  in  11.2.1 Goldengate , the following requirements should be met

 1.Oracle RDBMS must be 11.2.0.3 or higher

 and

 2.You must apply the RDBMS(Database) patches as suggested in the below MOS document
  NOTE:1411356.1 - 11.2.0.3 Database specific bundle patch for Integrated Extract 11.2.x

Once the above conditions are met, you may follow the below steps to upgrade to integrated extract

Connect to the Extract database, and grant the following priviege to GG Admin user

SQL>exec dbms_goldengate_auth.grant_admin_privilege('')


Login into GGSCI
•Check to see if upgrade possible
         GGSCI> INFO UPGRADE
Upgrade may fail, in case of existing open transactions 


GGSCI>stop extract 

GGSCI>dblogin userid ,password 

--Register the extract in the databse if not done already

GGSCI>register extract database

GGSCI>alter extract ,upgrade integrated tranlog

GGSCI>start extract 

Doc ID 1484313.1