Not getting your point… If it is on how to create a response file the Oracle suggestion is to do a graphical installation and Save Response File on summary screen…
Matt says:
GG Microservices is the epitome of over-engineering. A group of tech-bros got together and asked how can we take a simple one installation tool and make it more complex but also make it useless at the same time. And 23ai is now the height of that stupidity. They’re like the guys on 30 Rock that was tasked with enhancing a microwave and ended up turning it into the Pontiac Aztek.
Service Manger has links back to itself on the same main page. Some links that just open up the same page, but in a new tab. They took simple one line commands like “add credentialstore” that you could put into an obey file and turned them into https curl nightmares that they claim is “simplified”.
I can build out a 19c classic deployment that includes the adapter with a kafka handler sending data to Azure EventHub in the same time it takes someone just trying to wade through the mess that is the oggca response file.
It’s a shame too, because the classic architecture is some really good replication software.
Raymond Munene says:
Update:
Executed the PL/SQL without the container=’ALL’ option and it completed. Not sure what the effects of omitting that option are but I guess I will find out once I set up extract & replikat
Default option is container=’CURRENT’ so yes you might end up with an issue…
From the official documentation: “To specify ALL, the procedure must be invoked in the root by a common user.”.
Have you executed this from the root container ?
Raymond Munene says:
Hi Yannick,
Facing this issue when granting dbms_goldengate_auth.grant_admin_privilege but it keeps failing. Logged the issue with support but no solution given yet.
*
ERROR at line 1:
ORA-44001: invalid schema
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3652
ORA-06512: at “SYS.DBMS_ASSERT”, line 410
ORA-06512: at “SYS.DBMS_XSTREAM_ADM_INTERNAL”, line 50
ORA-06512: at “SYS.DBMS_XSTREAM_ADM_INTERNAL”, line 3137
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3632
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3812
ORA-06512: at “SYS.DBMS_GOLDENGATE_AUTH”, line 63
ORA-06512: at line 1
subrahmanyam says:
can Please guide me ./runinstaller slient mode
Yannick Jaquier says:
Not getting your point… If it is on how to create a response file the Oracle suggestion is to do a graphical installation and Save Response File on summary screen…
Matt says:
GG Microservices is the epitome of over-engineering. A group of tech-bros got together and asked how can we take a simple one installation tool and make it more complex but also make it useless at the same time. And 23ai is now the height of that stupidity. They’re like the guys on 30 Rock that was tasked with enhancing a microwave and ended up turning it into the Pontiac Aztek.
Service Manger has links back to itself on the same main page. Some links that just open up the same page, but in a new tab. They took simple one line commands like “add credentialstore” that you could put into an obey file and turned them into https curl nightmares that they claim is “simplified”.
I can build out a 19c classic deployment that includes the adapter with a kafka handler sending data to Azure EventHub in the same time it takes someone just trying to wade through the mess that is the oggca response file.
It’s a shame too, because the classic architecture is some really good replication software.
Raymond Munene says:
Update:
Executed the PL/SQL without the container=’ALL’ option and it completed. Not sure what the effects of omitting that option are but I guess I will find out once I set up extract & replikat
Yannick Jaquier says:
Hi Raymond,
Default option is container=’CURRENT’ so yes you might end up with an issue…
From the official documentation: “To specify ALL, the procedure must be invoked in the root by a common user.”.
Have you executed this from the root container ?
Raymond Munene says:
Hi Yannick,
Facing this issue when granting dbms_goldengate_auth.grant_admin_privilege but it keeps failing. Logged the issue with support but no solution given yet.
SQL> EXEC dbms_goldengate_auth.grant_admin_privilege(grantee => ‘C##GGADMIN’, privilege_type => ‘CAPTURE’, container => ‘ALL’);
*
ERROR at line 1:
ORA-44001: invalid schema
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3652
ORA-06512: at “SYS.DBMS_ASSERT”, line 410
ORA-06512: at “SYS.DBMS_XSTREAM_ADM_INTERNAL”, line 50
ORA-06512: at “SYS.DBMS_XSTREAM_ADM_INTERNAL”, line 3137
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3632
ORA-06512: at line 1
ORA-06512: at “SYS.DBMS_XSTREAM_AUTH_IVK”, line 3812
ORA-06512: at “SYS.DBMS_GOLDENGATE_AUTH”, line 63
ORA-06512: at line 1
Raymond Munene says:
Thank you for this tutorial.
Have you attempted replicating Oracle EBS data?
Yannick Jaquier says:
Thanks for your comment !
And no, not tested with Oracle EBS data.