In order to use agctl commands, we need to know goldengate instance_name.
Unfortunately, agctl does not work the same way as srvctl where it’s possible to determine what is configured.
ggsuser@hawk1 ~ $ $ORACLE_HOME/bin/srvctl config database DBFS ggsuser@hawk1 ~ $ $GRID_HOME/bin/agctl config goldengate XAG-212: Instance '' is not yet registered. ggsuser@hawk1 ~ $
How do we find out what the goldengate instance name is? IFF XAG is configured, then grep for it.
ggsuser@hawk1 ~ $ $GRID_HOME/bin/crsctl stat res -t|grep -A2 xag xag.gg_xx-vip.vip 1 ONLINE ONLINE hawk1 STABLE xag.gg_xx.goldengate 1 ONLINE ONLINE hawk1 STABLE -------------------------------------------------------------------------------- ggsuser@hawk1 ~ $ $GRID_HOME/bin/agctl status goldengate gg_xx Goldengate instance 'gg_xx' is running on hawk1 ggsuser@hawk1 ~ $
Some other useful commands to gather configurations info.
ggsuser@hawk1 ~ $ $GRID_HOME/bin/crsctl stat res|grep xag NAME=xag.gg_xx-vip.vip NAME=xag.gg_xx.goldengate TYPE=xag.goldengate.type ggsuser@hawk1 ~ $ ggsuser@hawk1 ~ $ $GRID_HOME/bin/crsctl stat res|grep -i type|sort -u TYPE=app.appvipx.type TYPE=local_resource TYPE=ora.asm.type TYPE=ora.cluster_vip_net1.type TYPE=ora.cvu.type TYPE=ora.database.type TYPE=ora.diskgroup.type TYPE=ora.listener.type TYPE=ora.mgmtdb.type TYPE=ora.mgmtlsnr.type TYPE=ora.network.type TYPE=ora.oc4j.type TYPE=ora.ons.type TYPE=ora.scan_listener.type TYPE=ora.scan_vip.type TYPE=xag.goldengate.type ggsuser@hawk1 ~ $ $GRID_HOME/bin/crsctl stat res -w "TYPE = xag.goldengate.type" -p NAME=xag.gg_xx.goldengate TYPE=xag.goldengate.type ACL=owner:ggsuser:rwx,pgrp:dba:r-x,other::r-- ACTIONS= ACTION_SCRIPT=%CRS_HOME%/bin/aggoldengateas ACTION_TIMEOUT=60 ACTIVE_PLACEMENT=0 AGENT_FILENAME=%CRS_HOME%/bin/scriptagent AUTO_START=restore CARDINALITY=1 CHECK_INTERVAL=30 CHECK_TIMEOUT=0 CLEAN_TIMEOUT=60 CRITICAL_EXTRACTS= CRITICAL_REPLICATS= CRS_ATTRIBUTES= DATABASES= (No DB dependencies - User Exits) DATAGUARD_AUTOSTART=no DB_SERVICES= DEGREE=1 DELETE_TIMEOUT=60 DESCRIPTION="Oracle GoldenGate Clusterware Resource" ENABLED=1 ENVIRONMENT_VARS= FAILOVER_DELAY=0 FAILURE_INTERVAL=600 FAILURE_THRESHOLD=5 FILESYSTEMS=dbfs_mount GG_HOME=/u03/gg/12.2.0 GG_INSTANCE_TYPE=target HOSTING_MEMBERS=hawk1 hawk2 INSTANCE_FAILOVER=1 INTERMEDIATE_TIMEOUT=0 JAGENT_AUTOSTART=no LOAD=1 LOGGING_LEVEL=1 MODIFY_TIMEOUT=60 MONITOR_EXTRACTS= MONITOR_REPLICATS= OFFLINE_CHECK_INTERVAL=0 ORACLE_CLIENT_HOME= ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 PLACEMENT=restricted RELOCATE_BY_DEPENDENCY=1 RESTART_ATTEMPTS=5 SCRIPT_TIMEOUT=60 SERVER_CATEGORY= SERVER_POOLS= START_CONCURRENCY=0 START_DEPENDENCIES=hard(xag.gg_xx-vip.vip,dbfs_mount) pullup(xag.gg_xx-vip.vip,dbfs_mount) START_TIMEOUT=300 STOP_CONCURRENCY=0 STOP_DEPENDENCIES=hard(xag.gg_xx-vip.vip,intermediate:dbfs_mount) STOP_TIMEOUT=300 UPTIME_THRESHOLD=10m USER_WORKLOAD=no USE_STICKINESS=0 VERSION=2 VIP_CREATED=1 VIP_NAME=xag.gg_xx-vip.vip ggsuser@hawk1 ~ $
You might be thinking, if there are no dependencies for database, then why is it referencing Database Home?
ggsuser@hawk1 ::/u03/gg/12.2.0 $ ldd ggsci linux-vdso.so.1 => (0x00007ffcaa8ff000) librt.so.1 => /lib64/librt.so.1 (0x00007f6a02c5b000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f6a02a56000) libgglog.so => /u03/gg/12.2.0/./libgglog.so (0x00007f6a02630000) libggrepo.so => /u03/gg/12.2.0/./libggrepo.so (0x00007f6a023ba000) libdb-6.1.so => /u03/gg/12.2.0/./libdb-6.1.so (0x00007f6a01fd5000) libggperf.so => /u03/gg/12.2.0/./libggperf.so (0x00007f6a01da5000) libggparam.so => /u03/gg/12.2.0/./libggparam.so (0x00007f6a00c8d000) libicui18n.so.48 => /u03/gg/12.2.0/./libicui18n.so.48 (0x00007f6a0089d000) libicuuc.so.48 => /u03/gg/12.2.0/./libicuuc.so.48 (0x00007f6a0051c000) libicudata.so.48 => /u03/gg/12.2.0/./libicudata.so.48 (0x00007f69fed57000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f69feb3a000) libxerces-c.so.28 => /u03/gg/12.2.0/./libxerces-c.so.28 (0x00007f69fe574000) libantlr3c.so => /u03/gg/12.2.0/./libantlr3c.so (0x00007f69fe35b000) libnnz12.so => /u01/app/oracle/product/12.1.0/db_1/lib/libnnz12.so (0x00007f69fdc36000) libclntsh.so.12.1 => /u01/app/oracle/product/12.1.0/db_1/lib/libclntsh.so.12.1 (0x00007f69fabbf000) libons.so => /u01/app/oracle/product/12.1.0/db_1/lib/libons.so (0x00007f69fa97a000) libclntshcore.so.12.1 => /u01/app/oracle/product/12.1.0/db_1/lib/libclntshcore.so.12.1 (0x00007f69fa406000) libggnnzitp.so => /u03/gg/12.2.0/./libggnnzitp.so (0x00007f69f9922000) libm.so.6 => /lib64/libm.so.6 (0x00007f69f9620000) libc.so.6 => /lib64/libc.so.6 (0x00007f69f925e000) /lib64/ld-linux-x86-64.so.2 (0x00005624a8090000) libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f69f8f56000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f69f8d3f000) libmql1.so => /u01/app/oracle/product/12.1.0/db_1/lib/libmql1.so (0x00007f69f8ac8000) libipc1.so => /u01/app/oracle/product/12.1.0/db_1/lib/libipc1.so (0x00007f69f8750000) libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f69f8537000) libaio.so.1 => /lib64/libaio.so.1 (0x00007f69f8335000)
Would’t be much better if Goldengate installation is self contained without having to download and install 2 components!
[…] DBFS and XAG […]
Pingback by DBFS and XAG | IT Remote — September 18, 2019 @ 4:01 pm |