How To Run Ggsci In “silent” Mode

Question: Like sqlplus -S, how does one suppress the ggsci banner and extraneous output?

Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise. It moves committed transactions from redo logs and maintains transaction integrity with sub-second latency. Its reliability is especially critical for enabling continuous-availability solutions, including high availability, zero downtime for upgrades and migrations, live reporting, operational business intelligence, and transactional data integration.

Running ggsci in silent mode

You can use “ggsci -S” similar to “sqlplus -S” with ‘end of file (EOF)’ marker. For example:

$ code1=`ggsci -S << EOF
> info all
> EOF`

$ echo $code1
GGSCI> Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED 00:00:07 484:17:40 EXTRACT STOPPED 00:00:09 457:10:23 EXTRACT STOPPED

Same can be used in a script.

$ vi myscript.sh
ggsci -S << EOF
info all
EOF

Run the script as any normal script. For example:

$ ./myscript.sh

Running ggsci in silent mode

You May Also Like