Oracle LiveSource stays in "Waiting" state (KBA1686)

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Applicable Delphix Versions

Issue

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.

Troubleshooting

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.

Resolution

At the time of this writing (August 2017, Delphix 5.1.8.0), 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 11.2.0.4.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> 
STATUS THREAD# SEQUENCE# 
------------ ---------- ---------- 
APPLYING_LOG 2 441