What is the GoldenGate version you are using? Please recheck whether you have given the privileges properly for the user myGGUserName.
Execute it as the below as 'SYS' user and retry to register the Extract again.,
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE ('myGGUserName');
Thank you for the reply Veera!
I tried the GRANT again with no joy, same error message. I believe I have the latest version here is the output of my 'versions' command.
Version 6.2 (Build 9,200: )
Oracle Database 11g Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for Linux: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
I found this query last week that looks like it might be relevant.
select * from sys.goldengate$_privileges;
the (non-NULL) results are:
CREATE_TIME: 6/20/2014 -- this is how long we've been trying to get this working
Any other logs to check? Nothing for this is coming up in \ggserr.log.
1. I had asked for GoldenGate software version you are using and not the Oracle Version? Please provide me the GoldenGate Version you are using.
2. You have mentioned that, you have given full admin rights to the myGGUserName. What privileges have u given to the user? Is that a DBA Privilege? If no, please try granting DBA privileges to the user myGGUserName.
Whether the privileges were granted before creating the Extract or After Creating the extract? If it is After Creating the Extract, then please drop or delete the extract. Logout from the GGSCI prompt and execute the below statement,
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE( -
grantee => 'myGGUserName', -
privilege_type => 'capture', grant_select_privileges=> true, do_grants => TRUE);
After this, login to the GG prompt and create the Extract and try to Register it.
GGSCI> DBLOGIN USERID myGGUserName, PASSWORD <password>
GGSCI> REGISTER EXTRACT IDEXT2 DATABASE
3. Since you are using the Oracle Database 188.8.131.52.0, We have unique parameter for GoldenGate in introduced in this version. Please make sure that you have edited this parameter,
I was working with my OGG trainer on this as well. We tried many different things, poured over the documentation to make sure we didn't miss something and still came up empty. For now, I've opened up an SR now. When I get it working, I'll update this thread for anyone else looking for a solution.
We checked permissions and roles and anything else he could think of.
Thanks for your help Veera!