Using the Admin Client
Admin Client is a command line utility for controlling and configuring tasks in Oracle GoldenGate and OCI GoldenGate.
Access Admin Client
Use Admin Client to connect to OCI GoldenGate to configure tasks and view process information and log messages. You can launch Admin Client one of two ways:
- Click Launch Admin Client on the deployment details page.
- Launch Cloud Shell, and then run Admin Client.
Note:
If you have an Oracle GoldenGate Marketplace version running on a Compute instance, you can access its AdminClient to connect to your OCI GoldenGate deployment.Connect to Admin Client through Cloud Shell
adminclient
connect <deployment-public-url-or-ip> as <goldengate-user> password <goldengate-password> !
Note:
- You can find the deployment's url and public IP address on its deployment details page.
- If you encounter the error,
bash: adminclient: command not found
, then use the following steps to change Cloud Shell's architecture:- From the Cloud Shell's Actions menu, select Architecture.
- In the Architecture dialog, select X86_64 for preferred architecture, and then click Confirm.
However, if the deployment has a private endpoint, then you must create a bastion, bastion session, and SSH tunnel.
To connect to a private OCI GoldenGate deployment in Admin Client:
- In the Oracle Cloud console global navigation bar, click Cloud Shell. If this is your first time connecting to Cloud Shell, it will take a few moments to connect.
- You can run the following command to generate SSH keys, or skip this
step and generate the keys when you create the
bastion:
ssh-keygen -t rsa
Keep the default filename and don't enter a passphrase when prompted. The private key is located at
~/ssh/id_rsa
and the public key is located at~/ssh/id_rsa.pub
. - On the deployment details page, take note of the deployment's Private IP and Subnet information.
- Create a Bastion.
- From the Oracle Cloud console menu, select Identity & Security, and then select Bastion.
- Click Create Bastion.
- In the Create Bastion panel, enter a name, and then select the same subnet where the deployment resides.
- For CIDR block allowlist, enter
0.0.0.0/0
. - Click Create bastion.
- Create a session.
- After the bastion is in an Active state, on the bastion details page, click Create Session.
- For Session type, select SSH Port forwarding session.
- Enter a name for the session.
- For Connect to target using, select IP Address, and then enter the deployment's private IP.
- For Port, enter 443.
- For Add SSH Key, copy and paste the contents of the public key (~/ssh/id_rsa.pub) from Cloud Shell.
- Click Create Session.
- After the bastion session state is active, select View SSH command from its Action menu (ellipsis icon).
- In the View SSH command dialog, enter the path to the private key
(
~/ssh/id_rsa
) in place of<private-key>
and replace<localport>
with the port in Cloud Shell that will forward the connection to the bastion.Note:
Cloud Shell doesn't allow port forwarding on a privileged port with sudo access, so you must use a non-privileged port like 7443. After the command runs once in the foreground to add the Bastion host toknown_hosts
, you can append an amperstand (&) to the end of the command so that it can run in the background next time. - Copy the command and then run it in Cloud Shell. You can ignore
bind: Cannot assign requested address
messages. - Start the admin
client.
adminclient
- Connect to the OCI GoldenGate
deployment.
connect 127.0.0.1:7443 as <goldengate-user> password <goldengate-password> !
Note:
The exclamation point (!) at the end of the command is very important. Without it, the command fails and returns an error.
Use Admin Client
After connecting successfully, you can run any of the following commands:
- Display the status of OCI GoldenGate
processes:
info all
- View statistics for your
Extract:
view stats
- View the content of the ggserror log
file:
view messages
- Purge trail files that are no longer used by
Extracts:
purge exttrail <trail-file-name>
See AdminClient Command Line Interface Commands for the full list of commands.
Known issues
AdminClient: Unable to negotiate with <ip-address> port 22: no matching hote key type found.
FIPS mode initialized.
Unable to negotiate with <ip-address> port 22: no matching host key type found. Their offer: ssh-ed25519
Action completed. Waiting until the work request has entered state: ('SUCCEEDED',)
FIPS mode initialized.
Unable to negotiate with <ip-address> port 22: no matching host key type found. Their offer: ssh-ed25519
Cannot create ssh tunnelnel
Workaround: Complete the following steps:
- Open a new Cloud Shell session.
- Create a file using the following
command:
cat .ssh/config
- Enter the following into the
.ssh/config
file, and then save it:HostkeyAlgorithms ssh-rsa,ssh-ed25519 PubkeyAcceptedKeyTypes ssh-ed25519,ssh-rsa
- If there's an existing
.ssh/known_hosts
file, delete it. - Close the Cloud Shell session.
- Click Launch Admin Client on your deployment details page.
Using the Admin Client
Copyright © 2022, Oracle and/or its affiliates.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.