Earlier today, I have been working on a few GoldenGate Obey files that will setup a customer’s environment; that is until I ran into an issue with AdminClient. I’m hoping this issue is more of a design overlook than a bug, but let’s see after this post is done.
With the shift to everything in the cloud and Oracle GoldenGate moving more and more into microservices, this opens up a remote administration for users. To take this the next step, I built a Docker Container that runs Oracle GoldenGate 21c AdminClient (here). I also wrote about this back in March 2022 (here) . Using AdminClient in this way, I can have a free standing version of AdminClient that allows me to connect to local Oracle GoldenGate implementations, remote or cloud based implementations, and OCI GoldenGate Services. Would highly recommend you take a look at this approach as well.
While I was working with AdminClient in writing some obey files, I identified that the below command does something unexpected:
connect https://goldengate.rheodata.com deployment dep_ctmsbob_ft2 as oggadmin password WElcome09876^^ ! ADD CREDENTIALS EUDB USER "[email protected]:1521/PDBTST_iad1hs.sub.demovnc.oraclevcn.com" PASSWORD “WElcome09876^^"
The ADD CREDENTIALS command, when ran in a local AdminClient updates the local wallet not the credential store within the deployment. This is documented in the documentation (here):
Note:
The ADD CREDENTIALS command adds a new username and password to an Oracle wallet that resides on the same system where the Admin Client is running. This credential is used to log in to Oracle GoldenGate Service Manager and Admin Client command line using the CONNECT command.
Now that I have a better understanding on where it is running or going to be stored at, lets take a look and see what it would look like:
1. Start AdminClient (Dockerized)
docker run -it --rm --memory=2048M --platform linux/amd64 --hostname=GG21c-Admin --name AdminClient rheodata/adminclient:latest
2. Login to the deployment using AdminClient
connect https://**********.rheodata.com deployment dep_*******_ft2 as oggadmin password WElcome******** !
3. Review the credential store -> INFO CREDENTIALSTORE. Notice that I have two credentials already in the credential store.
This aligns with what I have in the credential store via the HTML5 interface page as well:
At this point, I would think that when I create another credential it will show up in the credential store for the deployment.
4. Add another credential
ADD CREDENTIALS EUDB USER "[email protected]:1521/***TST_iad1hs.sub.demovnc.oraclevcn.com" PASSWORD “WElcome*******"
This will return successfully an say the credential was added.
5. Check the credential store again -> INFO CREDENTIALSTORE
Notice that we do not have an alias in the credential store called EUDB. What this means is that the AdminClient (locally running) cannot directly update the credential store of a deployment. So where is it?
Per the documentation, as pointed out earlier, since the AdminClient is running locally, the credential was created locally in a local wallet. After clearing the screen, I can run INFO CREDENTIALS * and will see the alias I would have expected in the deployment.
This issue is either an undocumented bug or a gap in the product. I come to this conclusion because if I was to use a standard cURL command against the API for creating credentials, the credentials are added to the deployment without any issue.
At this point, I’m going to turn message the team at Oracle and see if they can provide a reason why the product behaves this way.
Enjoy!!
**** UPDATE **** Follow up from conversation with Oracle – 9/13/2023:
After posting this post, I was able to connect with a few friends at Oracle. They pointed out the exact difference with the approach of how the credential store is used.
Within the Microservices Architecture (on-premise and cloud), the credential store is pre-allocated and ready to use within the microservices frame work. This means to provide connection details for an alias from a localized AdminClient, we just need to use ALTER CREDENTIALSTORE. If we use the command ADD CREDENTIALS, AdminClient will create a new credential store locally and not update the existing credential store in deployment.
The correct command that should be followed when working with a remote deployment (on-premise or cloud), we just need to use ALTER CREDENTIALSTORE.
alter credentialstore add USER "[email protected]:1521/PDBTST_iad1hs.sub.demovnc.oraclevcn.com" alias EUDB domain OracleGoldenGate PASSWORD “*********"
After execution, the new alias will appear in the AdminSrvr -> Configuration page.
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Amazing things here. I’m very glad to see your article.
Thank you a lot and I’m looking forward to touch you.
Will you please drop me a mail?
my site: eharmony special Coupon code 2025
Hi, constantly i used to check blog posts here in the early hours in the break of day, since
i enjoy to learn more and more.
My site :: vpn
Hi there just wanted to give you a quick heads
up. The words in your article seem to be running off the screen in Firefox.
I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I thought I’d post to let you know.
The design look great though! Hope you get the problem solved soon. Cheers gamefly
https://tinyurl.com/28wjzmw4
Whats up very cool website!! Guy .. Excellent ..
Wonderful .. I will bookmark your site and take the feeds additionally?
I’m glad to find a lot of useful info here in the publish,
we’d like develop extra techniques in this regard, thanks for sharing.
. . . . . https://tinyurl.com/2dhs6xmh what does vpn stand for
Howdy just wanted to give you a quick heads up and let you know a few of the images aren’t loading properly.
I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and
both show the same results.
Currently it sounds like WordPress is the preferred blogging platform out there right
now. (from what I’ve read) Is that what you’re using on your blog?
Impacto mecanico
Dispositivos de ajuste: importante para el desempeno uniforme y efectivo de las maquinas.
En el ambito de la innovacion moderna, donde la efectividad y la seguridad del sistema son de maxima significancia, los aparatos de balanceo tienen un tarea esencial. Estos dispositivos adaptados estan concebidos para calibrar y fijar componentes rotativas, ya sea en herramientas de fabrica, vehiculos de movilidad o incluso en electrodomesticos de uso diario.
Para los expertos en mantenimiento de equipos y los tecnicos, manejar con equipos de equilibrado es esencial para promover el rendimiento fluido y estable de cualquier aparato rotativo. Gracias a estas herramientas tecnologicas sofisticadas, es posible disminuir considerablemente las movimientos, el sonido y la carga sobre los soportes, extendiendo la duracion de piezas importantes.
De igual manera trascendental es el rol que juegan los sistemas de balanceo en la atencion al usuario. El asistencia tecnico y el conservacion regular empleando estos sistemas posibilitan proporcionar asistencias de excelente estandar, elevando la contento de los compradores.
Para los titulares de proyectos, la contribucion en equipos de balanceo y medidores puede ser importante para mejorar la productividad y rendimiento de sus aparatos. Esto es principalmente relevante para los duenos de negocios que manejan reducidas y medianas negocios, donde cada aspecto vale.
Ademas, los sistemas de ajuste tienen una extensa uso en el sector de la prevencion y el monitoreo de excelencia. Habilitan encontrar probables fallos, impidiendo mantenimientos elevadas y averias a los equipos. Ademas, los resultados extraidos de estos aparatos pueden aplicarse para optimizar sistemas y aumentar la exposicion en motores de busqueda.
Las campos de uso de los aparatos de ajuste abarcan multiples industrias, desde la fabricacion de ciclos hasta el supervision ecologico. No interesa si se trata de importantes producciones productivas o pequenos talleres caseros, los equipos de equilibrado son indispensables para asegurar un operacion eficiente y sin riesgo de paradas.
Getting it face, like a big-hearted would should
So, how does Tencent’s AI benchmark work? Earliest, an AI is prearranged a creative reproach from a catalogue of to the reason 1,800 challenges, from edifice consequence visualisations and царствование безграничных потенциалов apps to making interactive mini-games.
At the unchanged in error the AI generates the pandect, ArtifactsBench gets to work. It automatically builds and runs the regulations in a sheltered and sandboxed environment.
To closed how the assiduity behaves, it captures a series of screenshots ended time. This allows it to clue in against things like animations, vicinage changes after a button click, and other electrifying dope feedback.
Basically, it hands atop of all this asseverate – the autochthonous importune, the AI’s cryptogram, and the screenshots – to a Multimodal LLM (MLLM), to malfunction the share as a judge.
This MLLM deem isn’t unprejudiced giving a blurry тезис and a substitute alternatively uses a presumptive, per-task checklist to migration the d‚nouement upon across ten bust steep metrics. Scoring includes functionality, demon rum circumstance, and neck aesthetic quality. This ensures the scoring is fair, accordant, and thorough.
The gross doubtlessly is, does this automated get word looking for word profit careful taste? The results the nonce it does.
When the rankings from ArtifactsBench were compared to WebDev Arena, the gold-standard slate where existent humans chosen on the choicest AI creations, they matched up with a 94.4% consistency. This is a big unthinkingly from older automated benchmarks, which upon what may managed hither 69.4% consistency.
On cork of this, the framework’s judgments showed across 90% unanimity with maven gracious developers.
https://www.artificialintelligence-news.com/