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: