I upgraded the oracle golden gate to 12.2 version and during database initial load I faced the following error.
2017-07-30 21:53:51 ERROR OGG-01201 Error reported by MGR : Access denied.
This error occured when we try to do the direct initial load operation for small tables via SOURCEISTABLE. With this method, extract parameter file connects directly from the source to the target. The exact is added with parameter SOURCEISTABLE and replicate created on target side as shown below.
Source: REGISTER EXTRACT IL_Ext DATABASE CONTAINER (PDB1) ADD EXTRACT IL_Ext, SOURCEISTABLE EDIT PARAMS IL_Ext ------------- EXTRACT IL_Ext SETENV (ORACLE_SID=CDB) SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8") UserIdAlias GG_CDB RMTHOST gg01.it, MGRPORT 7809 RMTTASK REPLICAT, GROUP IL_Rep SOURCECATALOG PDB1 TABLE Test.T1; Target: ADD REPLICAT IL_Rep, SPECIALRUN EDIT PARAMS IL_Rep ------------------- REPLICAT IL_Rep SETENV (ORACLE_SID=CDB) SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8") ASSUMETARGETDEFS HANDLECOLLISIONS SOURCECATALOG PDB1 UserIdAlias GG_PDB1 MAP Test.T1, TARGET Test2.T1;
The extact start and stop and following errors will be reported in report file of the process. This is due to new security feature in GG 12.2 which allow access a remote system via “ACCESSRULE ” rule. This new rule will allow source server to make connection and start the replicat process remotely.
2017-07-30 21:53:51 ERROR OGG-01201 Error reported by MGR : Access denied. 2017-07-30 21:53:51 ERROR OGG-01668 PROCESS ABENDING.
Syntax is below and after adding this in mgr parameter file the inital load will complete as expected.
ACCESSRULE, PROG *, IPADDR 10.1.0.10, ALLOW