Easy way to connect to GoldenGate adminclient Oracle GoldenGate command line interface is launched by adminclient or if the path is not in $PATH: /u01/app/oracle/goldengate/bin/adminclient or wherever you install it. Then at the ">" prompt, you type connect http://: as , password dblogin useridalias It takes time to type and you probably have to find the user ID alias first because that's not easy to remember. But you can save this hassel with a shell script, say also called adminclient, in your shop's custom executable directory, say /home/oracle/bin, which is in $PATH. And this /home/oracle/bin/adminclient contains these lines: #!/bin/bash echo "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!" echo "Please type 'obey adminclient.ob' at the > prompt to connect" echo "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!" echo "" cd /home/oracle/bin OGG_VAR_HOME=/tmp /u01/app/oracle/goldengate/bin/adminclient (Change the full path to the actual adminclient binary on the last line to your setup. Change OGG_VAR_HOME if you want to save the log files to a different directory; they're useless in normal operation.) Then create an obey file /home/oracle/bin/adminclient.ob, which is like a .sql file for sqlplus. This file contains these lines: connect http://: as , password dblogin useridalias (Change the strings in angle brackets to your setup.) Now, all you need to do is to type "adminclient" (regardless directory since /home/oracle/bin is in $PATH), and type "obey adminclient.ob" at the ">" prompt: myhost ~ $ adminclient !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Please type 'obey adminclient.ob' at the > prompt to connect !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Oracle GoldenGate Administration Client for Oracle Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054 Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved. Linux, x64, 64bit (optimized) on Oct 17 2019 12:35:55 Operating system character set identified as UTF-8. OGG (not connected) 1> obey adminclient.ob OGG (not connected) 2> connect http://myhost:9100 as oggadmin, password xxxxxx Using default deployment 'ogg_ma_test' OGG (http://myhost:9100 ogg_ma_test) 3> dblogin useridalias test_ogg Successfully logged into database. OGG (http://myhost:9100 ogg_ma_test as test_ogg@EXATEST) 4> Since adminclient.ob contains the password, please chmod 600 so it's a little more secure. In case of Oracle RAC where GoldenGate uses this cluster setup, should be the IP or DNS name for the cluster, so you can scp the two files to any node without editing. Obviously you can add more adminclient commands to the obey file. You can also create other obey files to be called later after login. But you must put them in /home/oracle/bin or wherever the "cd" line in your adminclient script says. GG adminclient is not smart enough to have something like $SQLPATH for sqlplus. ---------------------------------------------------------------------------------------------------- If you prefer to use adminclient from your Windows laptop or desktop to connect to the database (which may run on other OS'es), download GG for Windows. Unlike Oracle database, Oracle GoldenGate does not have a separate software package to install client only. But you can install it and *use* it as a client only. For example, download "Oracle GoldenGate 19.1.0.0.4 Microservices for Oracle on Windows (64 bit)" at https://www.oracle.com/middleware/technologies/goldengate-downloads.html, and install it on Windows (you can choose 19c as the target database but keep in mind some adminclient commands may not work against a pre-19c database). Say you install it at c:\oracle\goldengate. Then at cmd prompt: set path=%path%;C:\oracle\goldengate\bin;C:\oracle\goldengate\lib adminclient connect http://: as , password dblogin useridalias You can create adminclient.cmd or adminclient.bat (equivalent to /home/oracle/bin/adminclient shown earlier) in any folder that is in your %path% (mine is c:\systools), and also create adminclient.ob as shown earlier. An example adminclient.cmd is: setlocal cd C:\systools set path=%path%;C:\oracle\goldengate\bin;C:\oracle\goldengate\lib C:\oracle\goldengate\bin\adminclient endlocal where "setlocal" makes sure after you finish running this cmd file, your console window doesn't have the two goldengate paths in %path%. The only problem with the Windows adminclient is that on some but not all installations (I haven't found the pattern), it changes the cmd background color to gray, and there's no way to stop that. (Adminclient command "set color off" is not supported, and "set adminclient_color=OFF" at cmd prompt has no effect.)