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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s