Applicable Delphix Versions
After addition/conversion of a dSource to an Oracle LiveSource, the user interface may indicate the LiveSource in a "Waiting" state. In this instance, SnapSyncs complete without issue, but expected changes are not propagated live.
The Delphix Engine determines source status from managed recovery by issuing a specific JDBC query :
select STATUS, THREAD#, SEQUENCE# from V$MANAGED_STANDBY where process='MRP0'
If the Delphix DB user is unable to complete this query remotely, the Engine will not be able to automatically ingest database changes as expected.
The query can be exercised remotely using SQL*Plus using the following command, where delphix_db_user, delphix_db_password, ip_address, listener_port, and service_name are populated as appropriate for your environment/configuration:
$ echo "select STATUS, THREAD#, SEQUENCE# from V$MANAGED_STANDBY where process='MRP0';" | sqlplus 'delphix_db_user/delphix_db_password@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=host_address)(PORT=listener_port))(CONNECT_DATA=(UR=A)(SERVICE_NAME=service_name))))'
If the following error is returned
ORA-00942: table or view does not exist
This will confirm a configuration issue in the source database.
At the time of this writing (August 2017, Delphix 18.104.22.168), the required Delphix database user grants are not complete in the recommended createDelphixDBUser.sh script to support LiveSource configuration. The missing grants required for LiveSource to function are:
grant select on v_$managed_standby to <delphix_db_user> create synonym <delphix_db_user>.v$managed_standby for v_$managed_standby
Once this change is completed, the aforementioned remote JDBC test should now return expected details from MRP, and the LiveSource status will be corrected:
Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> STATUS THREAD# SEQUENCE# ------------ ---------- ---------- APPLYING_LOG 2 441